DBA Data[Home] [Help]

APPS.WMS_RULE_16 dependencies on MTL_SERIAL_NUMBERS

Line 114: from mtl_serial_numbers msn

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

Line 207: from mtl_serial_numbers msn

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

Line 316: from mtl_serial_numbers msn

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