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
197: ,loc.task_id task_id
198: ,NULL locator_inventory_item_id
199: ,NULL empty_flag
200: ,NULL location_current_units
201: from mtl_serial_numbers msn
202: ,mtl_secondary_inventories sub
203: ,mtl_item_locations loc
204: ,mtl_lot_numbers lot
205: where msn.current_status = 3
300: ,loc.task_id task_id
301: ,NULL locator_inventory_item_id
302: ,NULL empty_flag
303: ,NULL location_current_units
304: from mtl_serial_numbers msn
305: ,mtl_secondary_inventories sub
306: ,mtl_item_locations loc
307: ,mtl_lot_numbers lot
308: where msn.current_status = 3