View: JAI_CMN_CUSTOMER_SITES_V

Product:	JA - Asia/Pacific Localizations
Description:
Implementation/DBA Data:	APPS.JAI_CMN_CUSTOMER_SITES_V

View Text

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 )

Columns