[Home] [Help]
View: 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
Name |
PARTY_SITE_ID |
PARTY_SITE_CODE |
ORG_ID |
PARTY_ID |