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_RELEASES

Line 959: , po_releases_all por

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
962: AND pol.po_line_id = poll.po_line_id
963: AND por.po_release_id(+) = poll.po_release_id

Line 3141: UPDATE po_releases por

3137: IF (PO_LOG.d_stmt) THEN
3138: PO_LOG.stmt(d_module, d_progress, 'l_rollup_code', l_rollup_code);
3139: END IF;
3140:
3141: UPDATE po_releases por
3142: SET por.closed_code = l_rollup_code
3143: , por.last_update_date = SYSDATE
3144: , por.last_updated_by = p_user_id
3145: , por.last_update_login = p_login_id