DBA Data[Home] [Help]

APPS.RCV_AVAILABILITY dependencies on PO_HEADERS_ALL

Line 958: po_headers_all poh

954: SELECT 'Y'
955: INTO x_valid_status
956: FROM po_line_locations_all pll,
957: po_lines_all pol,
958: po_headers_all poh
959: WHERE pol.po_header_id = poh.po_header_id
960: AND pll.po_line_id = pol.po_line_id
961: AND NVL(pll.approved_flag, 'N') = 'Y'
962: AND NVL(pol.closed_code, 'OPEN') <> 'FINALLY CLOSED'