DBA Data[Home] [Help]

APPS.CSI_INTERFACE_PKG dependencies on HZ_CUST_ACCT_SITES_ALL

Line 2886: hz_cust_acct_sites_all hcas

2882: THEN
2883: SELECT hcas.party_site_id
2884: INTO x_source_line_rec.ship_to_party_site_id
2885: FROM hz_cust_site_uses_all hcsu,
2886: hz_cust_acct_sites_all hcas
2887: WHERE hcsu.site_use_id = x_source_line_rec.ib_current_loc_id -- ship_to_address_id
2888: AND hcas.cust_acct_site_id = hcsu.cust_acct_site_id;
2889: END IF;
2890:

Line 2899: hz_cust_acct_sites_all hcas

2895: THEN
2896: SELECT hcas.party_site_id
2897: INTO x_source_line_rec.install_to_party_site_id
2898: FROM hz_cust_site_uses_all hcsu,
2899: hz_cust_acct_sites_all hcas
2900: WHERE hcsu.site_use_id = x_source_line_rec.ib_install_loc_id
2901: AND hcas.cust_acct_site_id = hcsu.cust_acct_site_id;
2902: END IF;
2903:

Line 3014: hz_cust_acct_sites_all hcas

3010: IF x_source_line_rec.ship_to_address_id is not null THEN
3011: SELECT hcas.party_site_id
3012: INTO x_source_line_rec.ship_to_party_site_id
3013: FROM hz_cust_site_uses_all hcsu,
3014: hz_cust_acct_sites_all hcas
3015: WHERE hcsu.site_use_id = x_source_line_rec.ship_to_address_id
3016: AND hcas.cust_acct_site_id = hcsu.cust_acct_site_id;
3017: END IF;
3018: