MSC_CUSTOMERS_TCA_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 HP.PARTY_NAME PARTNER_NAME, HP.PARTY_NUMBER PARTNER_NUMBER, DECODE (HP.STATUS,'A', 1,'I', 2, NULL) STATUS, 2 PARTNER_TYPE, HP.PARTY_ID TP_ID,HP.LAST_UPDATE_DATE,NVL(HP.CATEGORY_CODE,-1) CUSTOMER_CLASS_NAME FROM HZ_PARTIES HP WHERE EXISTS (SELECT 1 FROM HZ_CUST_ACCOUNTS HCA WHERE HCA.PARTY_ID = HP.PARTY_ID)