333: rt.quantity,
334: rt.transaction_id,
335: rt.unit_of_measure
336: FROM rcv_transactions rt,
337: rcv_shipment_lines rsl
338: WHERE transaction_id = v_parent_trx_id
339: AND rt.shipment_line_id = rsl.shipment_line_id
340: -- bug 8640033
341: AND NOT EXISTS(SELECT 'purchase order shipment cancelled or fc'