DBA Data[Home] [Help]

APPS.PO_RCO_VALIDATION_PVT dependencies on RCV_SHIPMENT_LINES

Line 2980: FROM rcv_shipment_lines

2976: -- Check for ASN not being fully received
2977: BEGIN
2978: SELECT 1
2979: INTO l_asn_exist
2980: FROM rcv_shipment_lines
2981: WHERE
2982: po_line_location_id = l_po_line_loc_id AND
2983: nvl(quantity_shipped, 0) > nvl(quantity_received, 0) AND
2984: nvl(asn_line_flag, 'N') = 'Y' AND