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