DBA Data[Home] [Help]

APPS.WMS_RULE_15 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 208: from mtl_serial_numbers msn

204: ,loc.task_id task_id
205: ,NULL locator_inventory_item_id
206: ,NULL empty_flag
207: ,NULL location_current_units
208: from mtl_serial_numbers msn
209: ,mtl_secondary_inventories sub
210: ,mtl_item_locations loc
211: ,mtl_lot_numbers lot
212: where msn.current_status = 3

Line 318: from mtl_serial_numbers msn

314: ,loc.task_id task_id
315: ,NULL locator_inventory_item_id
316: ,NULL empty_flag
317: ,NULL location_current_units
318: from mtl_serial_numbers msn
319: ,mtl_secondary_inventories sub
320: ,mtl_item_locations loc
321: ,mtl_lot_numbers lot
322: where msn.current_status = 3