XLA_THIRD_PARTY_SITES_V

Details

• Schema: FUSION

• Object owner: XLA

• Object type: VIEW

Columns

Name
THIRD_PARTY_SITE_ID THIRD_PARTY_ID THIRD_PARTY_TYPE THIRD_PARTY_SITE_CODE

Query

SQL_Statement

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 FROM poz_SUPPLIERS v, POZ_SUPPLIER_SITES_ALL_M 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.location THIRD_PARTY_SITE_CODE 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