DBA Data[Home] [Help]

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