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 1034: FROM po_line_locations_all poll

1030: d_progress := 20;
1031:
1032: SELECT count(*)
1033: INTO l_line_finally_closed
1034: FROM po_line_locations_all poll
1035: , po_lines_all pol
1036: , po_releases_all por
1037: , po_line_locations_all ppo_ll
1038: WHERE poll.line_location_id = p_shipment_id

Line 1037: , po_line_locations_all ppo_ll

1033: INTO l_line_finally_closed
1034: FROM po_line_locations_all poll
1035: , po_lines_all pol
1036: , po_releases_all por
1037: , po_line_locations_all ppo_ll
1038: WHERE poll.line_location_id = p_shipment_id
1039: AND pol.po_line_id = poll.po_line_id
1040: AND por.po_release_id(+) = poll.po_release_id
1041: AND ppo_ll.line_location_id(+) = poll.source_shipment_id

Line 3027: -- use po_line_locations instead of po_line_locations all

3023: d_progress := 210;
3024:
3025: --
3026: -- update the shipment closure dates
3027: -- use po_line_locations instead of po_line_locations all
3028: -- this is to leverage l_id_tbl from above
3029:
3030: FORALL i IN 1..l_id_tbl.COUNT
3031: UPDATE po_line_locations poll