1. Tables and Views for SCM
  2. MSC_AP_CUSTOMERS_V

MSC_AP_CUSTOMERS_V

Details

  • Schema: FUSION

  • Object owner: MSC

  • Object type: VIEW

Columns

Name

SR_TP_ID

PARTNER_NAME

PARTNER_NUMBER

STATUS

PARTNER_TYPE

CUSTOMER_CLASS_CODE

LAST_UPDATE_DATE

Query

SQL_Statement

SELECT

HP.PARTY_ID SR_TP_ID,

HP.PARTY_NAME PARTNER_NAME ,

HP.PARTY_NUMBER PARTNER_NUMBER ,

DECODE (HP.STATUS,'A',1,'I',2) STATUS,

2 PARTNER_TYPE,

(SELECT MAX(CUSTOMER_CLASS_CODE) FROM HZ_CUST_ACCOUNTS HCA WHERE HCA.PARTY_ID = HP.PARTY_ID) CUSTOMER_CLASS_CODE,

HP.LAST_UPDATE_DATE

FROM HZ_PARTIES HP

WHERE EXISTS (SELECT 1 FROM HZ_CUST_ACCOUNTS HCA WHERE HCA.PARTY_ID = HP.PARTY_ID)