DBA Data[Home] [Help]

APPS.PO_DOCUMENT_ACTION_CLOSE dependencies on PO_RELEASES_ALL

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: