APPS.OE_ACKNOWLEDGMENT_PVT dependencies on HZ_CUST_SITE_USES_ALL

Line 919: FROM hz_cust_acct_sites_all a, hz_cust_site_uses_all b

915: BEGIN
916: -- Fix for the bug2722519
917: SELECT b.cust_acct_site_id, a.ece_tp_location_code,b.location
918: INTO l_ship_to_addr_id, l_ship_to_location_code,l_ship_to_addr_code
919: FROM hz_cust_acct_sites_all a, hz_cust_site_uses_all b
920: WHERE a.cust_acct_site_id = b.cust_acct_site_id
921: AND b.site_use_id = l_line_tbl(I).ship_to_org_id
922: AND b.site_use_code='SHIP_TO';
923: -- removed unnecessary validation of customer account, bug 3656640

Line 1402: FROM hz_cust_acct_sites_all a, hz_cust_site_uses_all b

1398: BEGIN
1399: -- Fix for the bug 2722519
1400: SELECT b.cust_acct_site_id, a.ece_tp_location_code,b.location
1401: INTO l_bill_to_addr_id, l_bill_to_location_code,l_bill_to_addr_code
1402: FROM hz_cust_acct_sites_all a, hz_cust_site_uses_all b
1403: WHERE a.cust_acct_site_id = b.cust_acct_site_id
1404: AND b.site_use_id = l_header_rec.invoice_to_org_id
1405: AND b.site_use_code='BILL_TO';
1406: -- removed unnecessary validation of customer account, bug 3656640

Line 1423: FROM hz_cust_acct_sites_all a, hz_cust_site_uses_all b

1419: BEGIN
1420: -- Fix for the bug 2722519
1421: SELECT b.cust_acct_site_id, a.ece_tp_location_code,b.location
1422: INTO l_ship_to_addr_id, l_ship_to_location_code,l_ship_to_addr_code
1423: FROM hz_cust_acct_sites_all a, hz_cust_site_uses_all b
1424: WHERE a.cust_acct_site_id = b.cust_acct_site_id
1425: AND b.site_use_id = l_header_rec.ship_to_org_id
1426: AND b.site_use_code='SHIP_TO';
1427: -- removed unnecessary validation of customer account, bug 3656640

Line 1443: FROM hz_cust_acct_sites_all a, hz_cust_site_uses_all b

1439:
1440: BEGIN
1441: SELECT b.cust_acct_site_id, a.ece_tp_location_code,b.location
1442: INTO l_sold_to_addr_id, l_sold_to_location_code,l_sold_to_addr_code
1443: FROM hz_cust_acct_sites_all a, hz_cust_site_uses_all b
1444: WHERE a.cust_acct_site_id = b.cust_acct_site_id
1445: AND b.site_use_id = l_header_rec.sold_to_org_id
1446: AND b.site_use_code='SOLD_TO'
1447: AND a.cust_account_id = l_header_rec.sold_to_org_id;