select
x.ksppinm name,
y.kspftctxvl value,
y.kspftctxdf isdefault,
decode(bitand(y.kspftctxvf,7),1,'MODIFIED',4,'SYSTEM_MOD','FALSE') ismod,
decode(bitand(y.kspftctxvf,2),2,'TRUE','FALSE') isadj
from
sys.x$ksppi x,
sys.x$ksppcv2 y
where
x.inst_id = userenv('Instance') and
y.inst_id = userenv('Instance') and
x.indx+1 = y.kspftctxpn
order by
translate(x.ksppinm, ' _', ' ')
