APPS.RCV_AVAILABILITY dependencies on PO_REQUISITION_HEADERS_ALL

Line 901: po_requisition_headers_all rh

897: */
898: SELECT 'Y'
899: INTO x_valid_status
900: FROM po_requisition_lines_all rl,
901: po_requisition_headers_all rh
902: WHERE rh.requisition_header_id = rl.requisition_header_id
903: AND type_lookup_code = l_lookup_code
904: AND authorization_status = 'APPROVED'
905: AND NVL(rl.cancel_flag, 'N') = 'N'