DBA Data[Home] [Help]

APPS.WSH_MAPPING_DATA dependencies on HZ_CUST_ACCT_RELATE_ALL

Line 158: HZ_CUST_ACCT_RELATE_ALL HCAR

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'

Line 905: HZ_CUST_ACCT_RELATE_ALL HCAR

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'

Line 1423: hz_cust_acct_relate_all hcar

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'