MSC_DIM_CSTMHYR_SUP_SITE_V

Details

• Schema: FUSION

• Object owner: MSC

• Object type: VIEW

Columns

Name
ID NAME DESCRIPTION PARENT_ID REFRESH_NUMBER

Query

SQL_Statement
SELECT SHTL.ID ID, SHTL.NAME NAME, SHTL.ID ||'-'|| SHTL.NAME DESCRIPTION, LLMD.ID PARENT_ID, -1 REFRESH_NUMBER FROM MSC_DIM_CSTMHRCHY_LLMD LLMD, MSC_DIM_CSTMHRCHY_SHTL SHTL where LLMD.hierarchy_id = SHTL.hierarchy_id and SHTL.level_id = 46 and LLMD.LEVEL_ID = SHTL.PARENT_LEVEL_ID and LLMD.ID = SHTL.PARENT_ID