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 1036: , po_releases_all por

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

Line 2496: FROM po_releases_all

2492: IF (p_document_type = 'RELEASE') THEN
2493:
2494: SELECT NVL(authorization_status, 'INCOMPLETE')
2495: INTO l_authorization_status
2496: FROM po_releases_all
2497: WHERE po_release_id = p_document_id;
2498:
2499: ELSE
2500:

Line 3434: UPDATE po_releases por

3430: IF (PO_LOG.d_stmt) THEN
3431: PO_LOG.stmt(d_module, d_progress, 'l_rollup_code', l_rollup_code);
3432: END IF;
3433:
3434: UPDATE po_releases por
3435: SET por.closed_code = l_rollup_code
3436: , por.last_update_date = SYSDATE
3437: , por.last_updated_by = p_user_id
3438: , por.last_update_login = p_login_id