MSC_CUSTOMERS_MSC_V

Details

• Schema: FUSION

• Object owner: MSC

• Object type: VIEW

Columns

Name
PARTNER_NAME PARTNER_NUMBER STATUS PARTNER_TYPE TP_ID LAST_UPDATE_DATE CUSTOMER_CLASS_NAME

Query

SQL_Statement
SELECT TP.PARTNER_NAME, TP.PARTNER_NUMBER, TP.STATUS, 2 PARTNER_TYPE, TP.TP_ID, TP.LAST_UPDATE_DATE, NVL(CUSTOMER_CLASS_CODE,-1) CUSTOMER_CLASS_NAME FROM MSC_CUSTOMERS TP WHERE TP. PARTNER_TYPE = 2