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
242: AND rt.shipment_header_id = sl.shipment_header_id
243: AND rt.shipment_line_id = sl.shipment_line_id
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,
301: hr_operating_units hou
302: WHERE rt.TRANSACTION_ID = p_trans_id