DBA Data[Home] [Help]

APPS.RCV_AVAILABILITY dependencies on PO_HEADERS_ALL

Line 1071: po_headers_all poh

1067: SELECT 'Y'
1068: INTO x_valid_status
1069: FROM po_line_locations_all pll,
1070: po_lines_all pol,
1071: po_headers_all poh
1072: WHERE pol.po_header_id = poh.po_header_id
1073: AND pll.po_line_id = pol.po_line_id
1074: AND NVL(pll.approved_flag, 'N') = 'Y'
1075: AND NVL(pol.closed_code, 'OPEN') <> 'FINALLY CLOSED'