233: rt.vendor_lot_num --Bug#6145310
234: FROM rcv_transactions rt,
235: mtl_system_items_kfv im,
236: mtl_parameters so,
237: rcv_shipment_lines sl,
238: po_headers_all po ,
239: rcv_shipment_headers sh,
240: hr_operating_units hou --RLNAGARA B5018797
241: WHERE rt.TRANSACTION_ID = l_event_key
292: rt.vendor_lot_num --Bug#6145310
293: FROM rcv_transactions rt,
294: mtl_system_items_b_kfv im,
295: mtl_parameters so,
296: rcv_shipment_lines sl,
297: po_headers_all po ,
298: rcv_shipment_headers sh ,
299: rcv_lot_transactions tran ,
300: mtl_lot_numbers lot,