select
  inst_id,                                 -- INST_ID NUMBER
  fid,                                     -- ADVISE_ID NUMBER
  rank,                                    -- RANK NUMBER
  decode(                                  -- REQUIRED VARCHAR2(3)
    bitand(flags,65536), 0, 'NO', 'YES'),
  reco_msg                                 -- MESSAGE VARCHAR2(1024)
from
  x$dbkreco
where
  type = 0