VIEW: APPS.JAI_CMN_CUSTOMER_SITES_V

Source

View Text - Preformatted

SELECT HZCSU.site_use_id PARTY_SITE_ID , HZCSU.location PARTY_SITE_CODE , hzcas.org_id , hzca.cust_account_id PARTY_ID FROM hz_parties HZP , hz_party_sites HZPS , hz_cust_accounts HZCA , hz_cust_acct_sites_all HZCAS, hz_cust_site_uses_all HZCSU WHERE HZP.party_id = hzca.party_id AND HZPS.party_id = hzp.party_id AND hzp.party_id = hzca.party_id AND hzcas.cust_acct_site_id = hzcsu.cust_acct_site_id AND hzps.party_site_id = hzcas.party_site_id /* Bug#3360432 */ AND hzca.cust_account_id = hzcas.cust_account_id AND EXISTS ( SELECT 1 FROM JAI_CMN_CUS_ADDRESSES WHERE customer_id = hzca.cust_account_id AND address_id = hzcsu.cust_acct_site_id )

View Text - HTML Formatted

SELECT HZCSU.SITE_USE_ID PARTY_SITE_ID
, HZCSU.LOCATION PARTY_SITE_CODE
, HZCAS.ORG_ID
, HZCA.CUST_ACCOUNT_ID PARTY_ID
FROM HZ_PARTIES HZP
, HZ_PARTY_SITES HZPS
, HZ_CUST_ACCOUNTS HZCA
, HZ_CUST_ACCT_SITES_ALL HZCAS
, HZ_CUST_SITE_USES_ALL HZCSU
WHERE HZP.PARTY_ID = HZCA.PARTY_ID
AND HZPS.PARTY_ID = HZP.PARTY_ID
AND HZP.PARTY_ID = HZCA.PARTY_ID
AND HZCAS.CUST_ACCT_SITE_ID = HZCSU.CUST_ACCT_SITE_ID
AND HZPS.PARTY_SITE_ID = HZCAS.PARTY_SITE_ID /* BUG#3360432 */
AND HZCA.CUST_ACCOUNT_ID = HZCAS.CUST_ACCOUNT_ID
AND EXISTS ( SELECT 1
FROM JAI_CMN_CUS_ADDRESSES
WHERE CUSTOMER_ID = HZCA.CUST_ACCOUNT_ID
AND ADDRESS_ID = HZCSU.CUST_ACCT_SITE_ID )