View: XLA_THIRD_PARTY_SITES_V

Product:	XLA - Subledger Accounting
Description:	third party site information
Implementation/DBA Data:	APPS.XLA_THIRD_PARTY_SITES_V

View Text

SELECT VS.VENDOR_SITE_ID THIRD_PARTY_SITE_ID
, V.VENDOR_ID THIRD_PARTY_ID
, 'S' THIRD_PARTY_TYPE
, VS.VENDOR_SITE_CODE THIRD_PARTY_SITE_CODE
, VS.ADDRESS_LINE1 LOCATION
FROM AP_SUPPLIERS V
, AP_SUPPLIER_SITES_ALL VS
WHERE V.VENDOR_ID = VS.VENDOR_ID UNION ALL SELECT HCSU.SITE_USE_ID THIRD_PARTY_SITE_ID
, HCA.CUST_ACCOUNT_ID THIRD_PARTY_ID
, 'C' THIRD_PARTY_TYPE
, HCSU.SITE_USE_CODE THIRD_PARTY_SITE_CODE
, HCSU.LOCATION LOCATION
FROM HZ_CUST_ACCOUNTS HCA
, HZ_CUST_ACCT_SITES_ALL HCAS
, HZ_CUST_SITE_USES_ALL HCSU
WHERE HCA.CUST_ACCOUNT_ID = HCAS.CUST_ACCOUNT_ID
AND HCAS.CUST_ACCT_SITE_ID = HCSU.CUST_ACCT_SITE_ID

Columns