select
  rest.inst_id,                            -- INST_ID NUMBER
  rest.resname,                            -- TYPE VARCHAR2(64)
  rest.name,                               -- NAME VARCHAR2(64)
  rest.id1,                                -- ID1_TAG VARCHAR2(64)
  rest.id2,                                -- ID2_TAG VARCHAR2(64)
  decode(                                  -- IS_USER VARCHAR2(3)
    bitand(eqt.flags, 1), 1, 'YES', 'NO'),
  rest.expl                                -- DESCRIPTION VARCHAR2(4000)
from
  X$KSIRESTYP rest,
  X$KSQEQTYP eqt
where
  (rest.inst_id = eqt.inst_id) and (rest.indx = eqt.indx) and (rest.indx > 0)