select
  x.inst_id,                               -- INST_ID NUMBER
  x.indx+1,                                -- NUM NUMBER
  ksppinm,                                 -- NAME VARCHAR2(80)
  ksppity,                                 -- TYPE NUMBER
  ksppstvl,                                -- VALUE VARCHAR2(4000)
  ksppstdvl,                               -- DISPLAY_VALUE VARCHAR2(4000)
  ksppstdf,                                -- ISDEFAULT VARCHAR2(9)
  decode(                                  -- ISSES_MODIFIABLE VARCHAR2(5)
    bitand(ksppiflg/256,1),1,'TRUE','FALSE'),
  decode(                                  -- ISSYS_MODIFIABLE VARCHAR2(9)
    bitand(ksppiflg/65536,3),1,'IMMEDIATE',2,'DEFERRED', 3,'IMMEDIATE','FALSE'),
  decode(                                  -- ISINSTANCE_MODIFIABLE VARCHAR2(5)
    bitand(ksppiflg,4),4,'FALSE', decode(bitand(ksppiflg/65536,3), 0, 'FALSE', 'TRUE')),
  decode(                                  -- ISMODIFIED VARCHAR2(10)
    bitand(ksppstvf,7),1,'MODIFIED',4,'SYSTEM_MOD','FALSE'),
  decode(                                  -- ISADJUSTED VARCHAR2(5)
    bitand(ksppstvf,2),2,'TRUE','FALSE'),
  decode(                                  -- ISDEPRECATED VARCHAR2(5)
    bitand(ksppilrmflg/64, 1), 1, 'TRUE', 'FALSE'),
  decode(                                  -- ISBASIC VARCHAR2(5)
    bitand(ksppilrmflg/268435456, 1), 1, 'TRUE', 'FALSE'),
  ksppdesc,                                -- DESCRIPTION VARCHAR2(255)
  ksppstcmnt,                              -- UPDATE_COMMENT VARCHAR2(255)
  ksppihash                                -- HASH NUMBER
from
  x$ksppi x,
  x$ksppcv y
where
  (x.indx = y.indx) and bitand(ksppiflg,268435456) = 0 and ((translate(ksppinm,'_','#') not like '##%') and ((translate(ksppinm,'_','#') not like '#%') or (ksppstdf = 'FALSE') or (bitand(ksppstvf,5) > 0)))