MSC_DIM_CSTMHYR_CUS_SITE_V

Details

• Schema: FUSION

• Object owner: MSC

• Object type: VIEW

Columns

Name
ID NAME PARENT_ID CUSTOMER_NUMBER DESCRIPTION KEY_CUSTOMER_TYPE

Query

SQL_Statement

SELECT SHTL.ID ID, SHTL.NAME NAME, LLMD.ID PARENT_ID, LLMD.NAME CUSTOMER_NUMBER, SHTL.ID ||'-'|| SHTL.NAME DESCRIPTION, NVL(KC.KEY_CUSTOMER,decode(SHTL.ID, -5 ,3, decode(LLMD.ID, -5 ,2, 0 ) ) ) KEY_CUSTOMER_TYPE FROM MSC_DIM_CSTMHRCHY_LLMD LLMD, MSC_DIM_CSTMHRCHY_SHTL SHTL, MSC_KEY_CUSTOMER KC where LLMD.hierarchy_id = SHTL.hierarchy_id and SHTL.level_id = 43 and LLMD.LEVEL_ID = SHTL.PARENT_LEVEL_ID and LLMD.ID = SHTL.PARENT_ID AND KC.CUSTOMER_ID (+) = LLMD.ID