select
  INST_ID,                                 -- INST_ID NUMBER
  RMRNO,                                   -- CONF# NUMBER
  RMNAM,                                   -- NAME VARCHAR2(65)
  RMVAL                                    -- VALUE VARCHAR2(1025)
from
  X$KCCRM
where
  RMNAM is not null