MSC_DIM_CUST_V

Details

• Schema: FUSION

• Object owner: MSC

• Object type: VIEW

Columns

Name
ID NAME CUSTOMER_NUMBER PARENT_ID DESCRIPTION KEY_CUSTOMER_TYPE

Query

SQL_Statement

SELECT CUS.TP_ID ID, CUS.PARTNER_NAME NAME, CUS.PARTNER_NUMBER CUSTOMER_NUMBER, DECODE(CUS.CUSTOMER_CLASS_NAME, '-1' , -1, MSC_COLL_UTILS.GETFIXEDID('CUSTOMER_CLASS_ID',NVL(CUS.CUSTOMER_CLASS_NAME,-1),NULL)) PARENT_ID, TP_ID||'-'|| PARTNER_NUMBER DESCRIPTION, CASE CUS.TP_ID WHEN -5 THEN 2 ELSE NVL(KC.KEY_CUSTOMER,0) END AS KEY_CUSTOMER_TYPE FROM MSC_CUSTOMERS_V CUS, MSC_KEY_CUSTOMER KC WHERE CUS. PARTNER_TYPE = 2 AND KC.CUSTOMER_ID(+) =CUS.TP_ID