View: XLA_THIRD_PARTIES_V

Product:	XLA - Subledger Accounting
Description:	Third party id, third party type and third party number information
Implementation/DBA Data:	APPS.XLA_THIRD_PARTIES_V

View Text

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

Columns