APPS.PO_CONTROL_ACTION_VALIDATIONS dependencies on RCV_SHIPMENT_LINES

Line 2538: FROM RCV_SHIPMENT_LINES RSL

2534: AND gt.char2 <> po_document_cancel_pvt.c_doc_subtype_PLANNED
2535: AND POLL.payment_type IS NULL
2536: AND EXISTS
2537: (SELECT 'ASN outstanding'
2538: FROM RCV_SHIPMENT_LINES RSL
2539: WHERE RSL.po_line_location_id = poll.line_location_id
2540: AND NVL(RSL.quantity_shipped,0) > NVL(RSL.quantity_received,0)
2541: AND NVL(RSL.ASN_LINE_FLAG,'N') = 'Y'
2542: AND NVL(RSL.SHIPMENT_LINE_STATUS_CODE,'EXPECTED') <> 'CANCELLED'));