select
  inst_id,                                 -- INST_ID NUMBER
  name_kfals,                              -- NAME VARCHAR2(70)
  group_kfals,                             -- GROUP_NUMBER NUMBER
  number_kfals,                            -- FILE_NUMBER NUMBER
  incarn_kfals,                            -- FILE_INCARNATION NUMBER
  entnum_kfals,                            -- ALIAS_INDEX NUMBER
  entinc_kfals,                            -- ALIAS_INCARNATION NUMBER
  parent_kfals,                            -- PARENT_INDEX NUMBER
  refer_kfals,                             -- REFERENCE_INDEX NUMBER
  decode(                                  -- ALIAS_DIRECTORY VARCHAR2(1)
    bitand(entflg_kfals, 12), 4, 'Y', 8, 'Y', 'N'),
  decode(                                  -- SYSTEM_CREATED VARCHAR2(1)
    bitand(entflg_kfals, 15), 1, 'N', 2, 'Y', 4, 'Y', 8, 'N') 
from
  x$kfals
where
  decode(bitand(entflg_kfals, 12), 4, 'Y', 8, 'Y', 'N') = 'Y' OR decode(bitand(entflg_kfals, 16), 16, 'Y', 'N') = 'Y'