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_AUTOCREATE_PVT dependencies on PO_LINE_LOCATIONS_DRAFT_ALL

Line 1384: FROM po_line_locations_draft_all

1380:
1381: --Fetch All PAR related Shipments
1382: CURSOR fetch_line_location_ids(p_line_id NUMBER, p_par_draft_id NUMBER , p_change_status VARCHAR2 ) IS
1383: SELECT line_location_id
1384: FROM po_line_locations_draft_all
1385: WHERE po_line_id = p_line_id
1386: AND draft_id = p_par_draft_id
1387: AND change_status = p_change_status ;
1388:

Line 1585: FROM po_line_locations_draft_all

1581: BEGIN
1582: --fetch the lineLocation id of the Modification
1583: SELECT line_location_id
1584: INTO l_mod_line_location_id
1585: FROM po_line_locations_draft_all
1586: WHERE draft_id = p_mod_draft_id
1587: AND po_line_id =Nvl((SELECT mod_line_id
1588: FROM po_lines_draft_all
1589: WHERE po_line_id = p_par_line_id_tbl(i)

Line 1592: FROM po_line_locations_draft_all

1588: FROM po_lines_draft_all
1589: WHERE po_line_id = p_par_line_id_tbl(i)
1590: AND draft_id =p_par_draft_id_tbl(i)), p_par_line_id_tbl(i) )
1591: AND shipment_num = (SELECT shipment_num
1592: FROM po_line_locations_draft_all
1593: WHERE line_location_id = shipments_rec.line_location_id) ;
1594: EXCEPTION
1595: WHEN No_Data_Found
1596: THEN NULL;