DBA Data[Home] [Help]

VIEW: APPS.XLA_THIRD_PARTIES_V

Source

View Text - Preformatted

SELECT v.VENDOR_ID, 'S', v.SEGMENT1 FROM AP_SUPPLIERS v UNION ALL SELECT hca.CUST_ACCOUNT_ID, 'C', hca.ACCOUNT_NUMBER FROM HZ_CUST_ACCOUNTS hca
View Text - HTML Formatted

SELECT V.VENDOR_ID
, 'S'
, V.SEGMENT1
FROM AP_SUPPLIERS V UNION ALL SELECT HCA.CUST_ACCOUNT_ID
, 'C'
, HCA.ACCOUNT_NUMBER
FROM HZ_CUST_ACCOUNTS HCA