MSC_DIM_ZONE_V

Details

• Schema: FUSION

• Object owner: MSC

• Object type: VIEW

Columns

Name
ID NAME PARENT_ID DESCRIPTION

Query

SQL_Statement

SELECT DISTINCT A.ID, A.NAME, NVL(B.PARENT_ID, A.PARENT_ID) PARENT_ID, A.DESCRIPTION DESCRIPTION FROM (SELECT MZ.ZONE_ID ID , MZ.ZONE_NAME NAME , -1 PARENT_ID, MZ.ZONE_ID||'-'||MZ.ZONE_NAME||'-'||MZ.ZONE_TYPE DESCRIPTION FROM MSC_ZONES_V MZ WHERE MZ.ZONE_ID IS NOT NULL) A, (SELECT SHTL.ID ID,SHTL.NAME NAME, LLMD.ID PARENT_ID FROM MSC_DIM_CSTMHRCHY_LLMD LLMD, MSC_DIM_CSTMHRCHY_SHTL SHTL where 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 (+)