DBA Data[Home] [Help]

APPS.WMS_RULE_18 dependencies on MTL_SERIAL_NUMBERS

Line 112: from mtl_serial_numbers msn

108: ,loc.task_id task_id
109: ,NULL locator_inventory_item_id
110: ,NULL empty_flag
111: ,NULL location_current_units
112: from mtl_serial_numbers msn
113: ,mtl_secondary_inventories sub
114: ,mtl_item_locations loc
115: ,mtl_lot_numbers lot
116: where msn.current_status = 3

Line 201: from mtl_serial_numbers msn

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

Line 306: from mtl_serial_numbers msn

302: ,loc.task_id task_id
303: ,NULL locator_inventory_item_id
304: ,NULL empty_flag
305: ,NULL location_current_units
306: from mtl_serial_numbers msn
307: ,mtl_secondary_inventories sub
308: ,mtl_item_locations loc
309: ,mtl_lot_numbers lot
310: where msn.current_status = 3