FND Design Data [Home] [Help]

View: AR_CUSTOMER_VENDOR_V

Product: AR - Receivables
Description: Customer and Vendor Names
Implementation/DBA Data: ViewAPPS.AR_CUSTOMER_VENDOR_V
View Text

SELECT SUBSTRB(PARTY.PARTY_NAME
, 1
, 50) NAME
FROM HZ_CUST_ACCOUNTS CUST_ACCT
, HZ_PARTIES PARTY
WHERE CUST_ACCT.PARTY_ID = PARTY.PARTY_ID UNION SELECT VENDOR_NAME NAME
FROM PO_VENDORS

Columns

Name
NAME