Skip to content
September 24, 2013 / doganay

HIDDEN PARAMETER LIST

SELECT x.indx + 1 NUM,
ksppinm NAME,
ksppity TYPE,
ksppstvl DISPLAY_VALUE,
ksppstdf ISDEFAULT,
DECODE (BITAND (ksppiflg / 256, 1), 1, 'TRUE', 'FALSE') ISSES_MODIFIABLE,
DECODE (BITAND (ksppiflg / 65536, 3),
1, 'IMMEDIATE',
2, 'DEFERRED',
3, 'IMMEDIATE',
'FALSE') ISSYS_MODIFIABLE,
DECODE (BITAND (ksppstvf, 7),
1, 'MODIFIED',
4, 'SYSTEM_MOD',
'FALSE') ISMODIFIED,
DECODE (BITAND (ksppstvf, 2), 2, 'TRUE', 'FALSE') ISADJUSTED,
ksppdesc DESCRIPTION,
ksppstcmnt UPDATE_COMMENT
FROM x$ksppi x, x$ksppcv y
WHERE (x.indx = y.indx);
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: