SELECT PARENT_GROUP_ID SGB_PARENT_GROUP_ID, GROUP_ID SGB_GROUP_ID, GROUP_LEVEL1 SGB_GROUP_LEVEL1, GROUP_LEVEL2 SGB_GROUP_LEVEL2, GROUP_LEVEL3 SGB_GROUP_LEVEL3, GROUP_LEVEL4 SGB_GROUP_LEVEL4, DECODE(DENORM_LEVEL,5,'Y','N') ROLLUP_FLG_LVLB, DENORM_LEVEL FROM BIL_OBI_RS_GROUPS_DENORM WHERE DENORM_LEVEL <= 5 WITH READ ONLY
SELECT PARENT_GROUP_ID SGB_PARENT_GROUP_ID
, GROUP_ID SGB_GROUP_ID
, GROUP_LEVEL1 SGB_GROUP_LEVEL1
, GROUP_LEVEL2 SGB_GROUP_LEVEL2
, GROUP_LEVEL3 SGB_GROUP_LEVEL3
, GROUP_LEVEL4 SGB_GROUP_LEVEL4
, DECODE(DENORM_LEVEL
, 5
, 'Y'
, 'N') ROLLUP_FLG_LVLB
, DENORM_LEVEL
FROM BIL_OBI_RS_GROUPS_DENORM
WHERE DENORM_LEVEL <= 5 WITH READ ONLY
|
|
|