MSC_DIM_CUST_SITE_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_SITE.PARTNER_SITE_ID ID , DECODE(CUS_SITE.PARTNER_ID ,-5,NVL(CUS_SITE.PARTNER_ADDRESS, CUS_SITE.TP_SITE_CODE) ,CUS_SITE.TP_SITE_CODE ) NAME , CUS.PARTNER_NUMBER CUSTOMER_NUMBER , CUS_SITE.PARTNER_ID PARENT_ID , CUS_SITE.PARTNER_SITE_ID ||'-' ||CUS_SITE.TP_SITE_CODE DESCRIPTION , NVL(KC.KEY_CUSTOMER,DECODE(CUS_SITE.PARTNER_SITE_ID, -5 ,3, DECODE(CUS_SITE.PARTNER_ID, -5 ,2, 0 ) ) ) KEY_CUSTOMER_TYPE FROM MSC_CUSTOMERS_V CUS , MSC_CUSTOMER_SITES CUS_SITE , MSC_KEY_CUSTOMER KC WHERE CUS_SITE.PARTNER_TYPE = 2 AND CUS_SITE.PARTNER_TYPE = CUS.PARTNER_TYPE AND CUS.TP_ID = CUS_SITE.PARTNER_ID AND KC.CUSTOMER_ID (+) = CUS.TP_ID