VIEW: APPS.XLA_THIRD_PARTY_SITES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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