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 6101: FROM hz_locations hz,

6097: -- SQL What: Return 1 if the given is a valid customer ship-to
6098: -- location, 0 otherwise.
6099: /* SELECT count(*)
6100: INTO l_ship_to_loc_valid
6101: FROM hz_locations hz,
6102: hz_party_sites ps,
6103: hz_cust_site_uses_all su,
6104: hz_cust_acct_sites_all asa,
6105: hz_cust_accounts cu,

Line 6125: hz_locations loc,

6121: SELECT count(*)
6122: into l_ship_to_loc_valid
6123: FROM hz_cust_site_uses_all site,
6124: hz_party_sites party_site,
6125: hz_locations loc,
6126: hz_cust_acct_sites_all acct_site ,
6127: oe_order_lines_all oel,
6128: oe_drop_ship_sources oedp
6129: WHERE oedp.line_location_id = l_line_location_id

Line 6148: hz_locations loc,

6144: SELECT Count(*)
6145: INTO l_ship_to_loc_valid
6146: FROM hz_cust_site_uses_all site,
6147: hz_party_sites party_site,
6148: hz_locations loc,
6149: hz_cust_acct_sites_all acct_site ,
6150: oe_order_lines_all oel,
6151: oe_drop_ship_sources oedp,
6152: hz_cust_acct_relate_all rel