SELECT PARENT_GROUP_ID SG2_PARENT_GROUP_ID, GROUP_ID SG2_GROUP_ID, GROUP_LEVEL1 SG2_GROUP_LEVEL1, GROUP_LEVEL2 SG2_GROUP_LEVEL2, DECODE(DENORM_LEVEL,2,'Y','N') ROLLUP_FLG_LVL2, DENORM_LEVEL FROM BIL_OBI_RS_GROUPS_DENORM WHERE DENORM_LEVEL <= 2 WITH READ ONLY
SELECT PARENT_GROUP_ID SG2_PARENT_GROUP_ID
, GROUP_ID SG2_GROUP_ID
, GROUP_LEVEL1 SG2_GROUP_LEVEL1
, GROUP_LEVEL2 SG2_GROUP_LEVEL2
, DECODE(DENORM_LEVEL
, 2
, 'Y'
, 'N') ROLLUP_FLG_LVL2
, DENORM_LEVEL
FROM BIL_OBI_RS_GROUPS_DENORM
WHERE DENORM_LEVEL <= 2 WITH READ ONLY
|
|
|