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