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_ACTION_CLOSE dependencies on PO_LINE_LOCATIONS_ALL

Line 957: FROM po_line_locations_all poll

953: d_progress := 20;
954:
955: SELECT count(*)
956: INTO l_line_finally_closed
957: FROM po_line_locations_all poll
958: , po_lines_all pol
959: , po_releases_all por
960: , po_line_locations_all ppo_ll
961: WHERE poll.line_location_id = p_shipment_id

Line 960: , po_line_locations_all ppo_ll

956: INTO l_line_finally_closed
957: FROM po_line_locations_all poll
958: , po_lines_all pol
959: , po_releases_all por
960: , po_line_locations_all ppo_ll
961: WHERE poll.line_location_id = p_shipment_id
962: AND pol.po_line_id = poll.po_line_id
963: AND por.po_release_id(+) = poll.po_release_id
964: AND ppo_ll.line_location_id(+) = poll.source_shipment_id

Line 2736: -- use po_line_locations instead of po_line_locations all

2732: d_progress := 210;
2733:
2734: --
2735: -- update the shipment closure dates
2736: -- use po_line_locations instead of po_line_locations all
2737: -- this is to leverage l_id_tbl from above
2738:
2739: FORALL i IN 1..l_id_tbl.COUNT
2740: UPDATE po_line_locations poll