VIEW: APPS.BIL_OBI_RS_GROUP0_DENORM_V

Source

View Text - Preformatted

SELECT PARENT_GROUP_ID SG0_PARENT_GROUP_ID, GROUP_ID SG0_GROUP_ID, DECODE(DENORM_LEVEL,0,'Y','N') ROLLUP_FLG_LVL0, DENORM_LEVEL FROM BIL_OBI_RS_GROUPS_DENORM WHERE DENORM_LEVEL = 0 WITH READ ONLY

View Text - HTML Formatted

SELECT PARENT_GROUP_ID SG0_PARENT_GROUP_ID
, GROUP_ID SG0_GROUP_ID
, DECODE(DENORM_LEVEL
, 0
, 'Y'
, 'N') ROLLUP_FLG_LVL0
, DENORM_LEVEL
FROM BIL_OBI_RS_GROUPS_DENORM
WHERE DENORM_LEVEL = 0 WITH READ ONLY