APPS.PO_RCO_VALIDATION_PVT dependencies on RCV_SHIPMENT_LINES
Line 3044: FROM rcv_shipment_lines
3040: -- Check for ASN not being fully received
3041: BEGIN
3042: SELECT 1
3043: INTO l_asn_exist 3044: FROM rcv_shipment_lines 3045: WHERE
3046: po_line_location_id = l_po_line_loc_id AND
3047: nvl(quantity_shipped, 0) > nvl(quantity_received, 0) AND
3048: nvl(asn_line_flag, 'N') = 'Y' AND