MSC_DIM_RES_ORG_V

Details

• Schema: FUSION

• Object owner: MSC

• Object type: VIEW

Columns

Name
ID CODE NAME PARENT_ID DESCRIPTION REFRESH_NUMBER

Query

SQL_Statement

SELECT A.ID, A.CODE, A.NAME, NVL(B.PARENT_ID, A.PARENT_ID) PARENT_ID, A.DESCRIPTION DESCRIPTION, A.REFRESH_NUMBER REFRESH_NUMBER FROM (SELECT DISTINCT MR.ORGANIZATION_ID ID , MP.ORGANIZATION_CODE CODE, MP.ORGANIZATION_NAME NAME, -1 PARENT_ID, MR.ORGANIZATION_ID||'-'||MP.ORGANIZATION_NAME DESCRIPTION, MP.REFRESH_NUMBER REFRESH_NUMBER FROM MSC_DEPARTMENT_RESOURCES MR, MSC_PARAMETERS MP WHERE MR.ORGANIZATION_ID = MP.ORGANIZATION_ID AND MR.PLAN_ID = -1 ) A, (SELECT SHTL.ID ID, SHTL.NAME CODE, SHTL.NAME NAME, LLMD.ID PARENT_ID FROM MSC_DIM_CSTMHRCHY_LLMD LLMD, MSC_DIM_CSTMHRCHY_SHTL SHTL WHERE LLMD.DIMENSION_ID = SHTL.DIMENSION_ID AND LLMD.DIMENSION_ID = 15 AND LLMD.HIERARCHY_ID = SHTL.HIERARCHY_ID AND LLMD.LEVEL_ID = SHTL.PARENT_LEVEL_ID AND LLMD.ID = SHTL.PARENT_ID ) B WHERE A.ID = B.ID (+) AND A.NAME = B.NAME (+)