eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_ACKNOWLEDGMENT_PVT dependencies on HZ_CUST_ACCT_SITES_ALL

Line 629: FROM hz_cust_site_uses b, hz_cust_acct_sites_all a

625:
626:
627: SELECT /*MOAC_SQL_CHANGES*/ b.site_use_id, a.cust_acct_site_id
628: INTO l_site_use_id, l_address_id
629: FROM hz_cust_site_uses b, hz_cust_acct_sites_all a
630: WHERE a.cust_acct_site_id = b.cust_acct_site_id
631: AND a.cust_account_id = l_header_rec.sold_to_org_id
632: AND b.site_use_code = 'SOLD_TO'
633: AND b.primary_flag = 'Y'

Line 920: FROM hz_cust_acct_sites_all a, hz_cust_site_uses_all b

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

Line 1429: FROM hz_cust_acct_sites_all a, hz_cust_site_uses_all b

1425: BEGIN
1426: -- Fix for the bug 2722519
1427: SELECT b.cust_acct_site_id, a.ece_tp_location_code,b.location
1428: INTO l_bill_to_addr_id, l_bill_to_location_code,l_bill_to_addr_code
1429: FROM hz_cust_acct_sites_all a, hz_cust_site_uses_all b
1430: WHERE a.cust_acct_site_id = b.cust_acct_site_id
1431: AND b.site_use_id = l_header_rec.invoice_to_org_id
1432: AND b.site_use_code='BILL_TO';
1433: -- removed unnecessary validation of customer account, bug 3656640

Line 1450: FROM hz_cust_acct_sites_all a, hz_cust_site_uses_all b

1446: BEGIN
1447: -- Fix for the bug 2722519
1448: SELECT b.cust_acct_site_id, a.ece_tp_location_code,b.location
1449: INTO l_ship_to_addr_id, l_ship_to_location_code,l_ship_to_addr_code
1450: FROM hz_cust_acct_sites_all a, hz_cust_site_uses_all b
1451: WHERE a.cust_acct_site_id = b.cust_acct_site_id
1452: AND b.site_use_id = l_header_rec.ship_to_org_id
1453: AND b.site_use_code='SHIP_TO';
1454: -- removed unnecessary validation of customer account, bug 3656640

Line 1470: FROM hz_cust_acct_sites_all a, hz_cust_site_uses_all b

1466:
1467: BEGIN
1468: SELECT b.cust_acct_site_id, a.ece_tp_location_code,b.location
1469: INTO l_sold_to_addr_id, l_sold_to_location_code,l_sold_to_addr_code
1470: FROM hz_cust_acct_sites_all a, hz_cust_site_uses_all b
1471: WHERE a.cust_acct_site_id = b.cust_acct_site_id
1472: AND b.site_use_id = l_header_rec.sold_to_org_id
1473: AND b.site_use_code='SOLD_TO'
1474: AND a.cust_account_id = l_header_rec.sold_to_org_id;

Line 2189: From hz_cust_site_uses b, hz_cust_acct_sites_all a

2185: Begin
2186: Oe_Debug_Pub.Add('before select of sold to org id');
2187: Select /*MOAC_SQL_CHANGES*/ b.site_use_id, a.cust_acct_site_id
2188: Into l_site_use_id, l_address_id
2189: From hz_cust_site_uses b, hz_cust_acct_sites_all a
2190: Where a.cust_acct_site_id = b.cust_acct_site_id
2191: And a.cust_account_id = l_header_rec.sold_to_org_id
2192: And b.site_use_code = 'SOLD_TO'
2193: And b.primary_flag = 'Y'