select
  inst_id,                                 -- INST_ID NUMBER
  kqftanam,                                -- NAME VARCHAR2(30)
  kqftaobj,                                -- OBJECT_ID NUMBER
  'TABLE',                                 -- TYPE VARCHAR2(5)
  indx                                     -- TABLE_NUM NUMBER
from
  x$kqfta
union all
select
  inst_id,                                 -- INST_ID NUMBER
  kqfvinam,                                -- NAME VARCHAR2(30)
  kqfviobj,                                -- OBJECT_ID NUMBER
  'VIEW',                                  -- TYPE VARCHAR2(5)
  65537                                    -- TABLE_NUM NUMBER
from
  x$kqfvi
union all
select
  inst_id,                                 -- INST_ID NUMBER
  kqfdtnam,                                -- NAME VARCHAR2(30)
  kqfdtobj,                                -- OBJECT_ID NUMBER
  'TABLE',                                 -- TYPE VARCHAR2(5)
  65537                                    -- TABLE_NUM NUMBER
from
  x$kqfdt