DBA Data[Home] [Help]

APPS.RCV_AVAILABILITY dependencies on PO_REQUISITION_HEADERS_ALL

Line 995: po_requisition_headers_all rh

991: */
992: SELECT 'Y'
993: INTO x_valid_status
994: FROM po_requisition_lines_all rl,
995: po_requisition_headers_all rh
996: WHERE rh.requisition_header_id = rl.requisition_header_id
997: AND type_lookup_code = l_lookup_code
998: AND authorization_status = 'APPROVED'
999: AND NVL(rl.cancel_flag, 'N') = 'N'