DBA Data[Home] [Help]

VIEW: APPS.AR_CUSTOMER_VENDOR_V

Source

View Text - Preformatted

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
View Text - HTML Formatted

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