[Home] [Help]
View: WSH_CONSIGNEES_V
View Text
SELECT CUST_ACCT.CUST_ACCOUNT_ID CUSTOMER_ID
, SUBSTRB (PARTY.PARTY_NAME
, 1
, 50) PARTY_NAME
, CUST_ACCT.ACCOUNT_NUMBER CUSTOMER_NUMBER
, 'C' TYPE_FLAG
, 'CUSTOMER' TYPE
, 'C' ||'-' ||CUST_ACCT.CUST_ACCOUNT_ID CONSIGNEE_ID
FROM HZ_PARTIES PARTY
, HZ_CUST_ACCOUNTS CUST_ACCT
WHERE CUST_ACCT.PARTY_ID = PARTY.PARTY_ID UNION SELECT PV.VENDOR_ID CUSTOMER_ID
, SUBSTRB (PARTY.PARTY_NAME
, 1
, 50) PARTY_NAME
, PV.SEGMENT1 CUSTOMER_NUMBER
, 'V' TYPE_FLAG
, 'SUPPLIER' TYPE
, 'V' ||'-' ||PV.VENDOR_ID CONSIGNEE_ID
FROM HZ_PARTIES PARTY
, PO_VENDORS PV
WHERE PV.PARTY_ID = PARTY.PARTY_ID
Columns
Name |
CUSTOMER_ID |
PARTY_NAME |
CUSTOMER_NUMBER |
TYPE_FLAG |
TYPE |
CONSIGNEE_ID |