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.PO_DOCUMENT_UPDATE_PVT dependencies on HZ_LOCATIONS

Line 6051: FROM hz_locations hz,

6047: -- SQL What: Return 1 if the given is a valid customer ship-to
6048: -- location, 0 otherwise.
6049: /* SELECT count(*)
6050: INTO l_ship_to_loc_valid
6051: FROM hz_locations hz,
6052: hz_party_sites ps,
6053: hz_cust_site_uses_all su,
6054: hz_cust_acct_sites_all asa,
6055: hz_cust_accounts cu,

Line 6075: hz_locations loc,

6071: SELECT count(*)
6072: into l_ship_to_loc_valid
6073: FROM hz_cust_site_uses_all site,
6074: hz_party_sites party_site,
6075: hz_locations loc,
6076: hz_cust_acct_sites_all acct_site ,
6077: oe_order_lines_all oel,
6078: oe_drop_ship_sources oedp
6079: WHERE oedp.line_location_id = l_line_location_id

Line 6098: hz_locations loc,

6094: SELECT Count(*)
6095: INTO l_ship_to_loc_valid
6096: FROM hz_cust_site_uses_all site,
6097: hz_party_sites party_site,
6098: hz_locations loc,
6099: hz_cust_acct_sites_all acct_site ,
6100: oe_order_lines_all oel,
6101: oe_drop_ship_sources oedp,
6102: hz_cust_acct_relate_all rel