154: FROM HZ_CUST_SITE_USES_ALL HCSU,
155: HZ_CUST_ACCT_SITES_ALL HCAS,
156: HZ_PARTY_SITES HPS,
157: HZ_CUST_ACCOUNTS HCA,
158: HZ_CUST_ACCT_RELATE_ALL HCAR
159: WHERE HCSU.CUST_ACCT_SITE_ID = HCAS.CUST_ACCT_SITE_ID
160: AND HCAS.PARTY_SITE_ID = HPS.PARTY_SITE_ID
161: AND HCAS.CUST_ACCOUNT_ID = HCA.CUST_ACCOUNT_ID
162: AND HCSU.SITE_USE_CODE = 'SHIP_TO'
901: FROM HZ_CUST_SITE_USES_ALL HCSU,
902: HZ_CUST_ACCT_SITES_ALL HCAS,
903: HZ_PARTY_SITES HPS,
904: HZ_CUST_ACCOUNTS HCA,
905: HZ_CUST_ACCT_RELATE_ALL HCAR
906: WHERE HCSU.CUST_ACCT_SITE_ID = HCAS.CUST_ACCT_SITE_ID
907: AND HCAS.PARTY_SITE_ID = HPS.PARTY_SITE_ID
908: AND HCAS.CUST_ACCOUNT_ID = HCA.CUST_ACCOUNT_ID
909: AND HCSU.SITE_USE_CODE = 'SHIP_TO'
1419: FROM hz_cust_site_uses_all hcsu,
1420: hz_cust_acct_sites_all hcas,
1421: hz_party_sites hps,
1422: hz_cust_accounts hca,
1423: hz_cust_acct_relate_all hcar
1424: WHERE hcsu.cust_acct_site_id = hcas.cust_acct_site_id
1425: AND hcas.party_site_id = hps.party_site_id
1426: AND hcas.cust_account_id = hca.cust_account_id
1427: AND hcsu.site_use_code = 'SHIP_TO'