DBA Data[Home] [Help]

APPS.PO_DOCUMENT_CHECKS_PVT dependencies on RCV_SHIPMENT_LINES

Line 15979: FROM rcv_shipment_lines rsl

15975: AND NVL(poll.closed_code, 'OPEN') <> 'FINALLY CLOSED'
15976: AND EXISTS
15977: (
15978: SELECT 'ASN outstanding'
15979: FROM rcv_shipment_lines rsl
15980: WHERE rsl.po_line_location_id = poll.line_location_id
15981: AND NVL(rsl.quantity_shipped, 0) > NVL(rsl.quantity_received, 0)
15982: AND NVL(rsl.asn_line_flag, 'N') = 'Y'
15983: AND NVL(rsl.shipment_line_status_code, 'EXPECTED') <> 'CANCELLED'