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.PON_OPEN_INTERFACE_PVT dependencies on PO_SHIP_TO_LOC_ORG_V

Line 2825: FROM po_ship_to_loc_org_v po_v

2821:
2822: UPDATE pon_auc_price_breaks_interface pb_int
2823: SET ship_to_location_id =
2824: (SELECT MAX(location_id)
2825: FROM po_ship_to_loc_org_v po_v
2826: WHERE po_v.location_code = pb_int.ship_to_location
2827: )
2828: WHERE batch_id = p_batch_id
2829: AND ship_to_location IS NOT null;

Line 5524: AND NOT EXISTS(SELECT 1 FROM po_ship_to_loc_org_v WHERE location_id = neg_header_record_data.ship_to_location_id))

5520: SYSDATE,
5521: l_cp_login_id
5522: )
5523: WHEN ( neg_header_record_data.ship_to_location_id IS NOT NULL AND neg_header_record_data.ship_to_location_id <> -1
5524: AND NOT EXISTS(SELECT 1 FROM po_ship_to_loc_org_v WHERE location_id = neg_header_record_data.ship_to_location_id))
5525: THEN INTO PON_INTERFACE_ERRORS
5526: (
5527: INTERFACE_TYPE ,
5528: ERROR_MESSAGE_NAME,

Line 6702: from po_ship_to_loc_org_v po_v

6698:
6699: BEGIN
6700: select (nvl(max(location_id), -1))
6701: INTO neg_header_record_data.ship_to_location_id
6702: from po_ship_to_loc_org_v po_v
6703: where po_v.location_code = neg_header_record_data.ship_to_location_code
6704: AND neg_header_record_data.ship_to_location_code IS NOT NULL;
6705: EXCEPTION
6706: WHEN No_Data_Found THEN