select
  i.inst_id,                               -- INST_ID NUMBER
  kqfvinam,                                -- VIEW_NAME VARCHAR2(30)
  kqftpsel                                 -- VIEW_DEFINITION VARCHAR2(4000)
from
  x$kqfvi i,
  x$kqfvt t
where
  i.indx = t.indx