APPS.PO_CHG_REQUEST_PVT dependencies on RCV_SHIPMENT_LINES

Line 3212: FROM RCV_SHIPMENT_LINES RSL

3208: END IF;
3209:
3210: SELECT count(*)
3211: into l_count_asn
3212: FROM RCV_SHIPMENT_LINES RSL
3213: WHERE RSL.po_header_id = p_po_header_id
3214: AND (RSL.po_line_location_id = l_po_change_requests(j).document_line_location_id OR l_po_change_requests(j).document_line_location_id is null)
3215: AND NVL(RSL.quantity_shipped,0) > NVL(RSL.quantity_received,0)
3216: AND NVL(RSL.ASN_LINE_FLAG,'N') = 'Y'