110: ,loc.task_id task_id
111: ,NULL locator_inventory_item_id
112: ,NULL empty_flag
113: ,NULL location_current_units
114: from mtl_serial_numbers msn
115: ,mtl_secondary_inventories sub
116: ,mtl_item_locations loc
117: ,mtl_lot_numbers lot
118: where msn.current_status = 3
203: ,loc.task_id task_id
204: ,NULL locator_inventory_item_id
205: ,NULL empty_flag
206: ,NULL location_current_units
207: from mtl_serial_numbers msn
208: ,mtl_secondary_inventories sub
209: ,mtl_item_locations loc
210: ,mtl_lot_numbers lot
211: where msn.current_status = 3
312: ,loc.task_id task_id
313: ,NULL locator_inventory_item_id
314: ,NULL empty_flag
315: ,NULL location_current_units
316: from mtl_serial_numbers msn
317: ,mtl_secondary_inventories sub
318: ,mtl_item_locations loc
319: ,mtl_lot_numbers lot
320: where msn.current_status = 3