DBA Data[Home] [Help]

APPS.WMS_RULE_2 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 202: from mtl_serial_numbers msn

198: ,loc.task_id task_id
199: ,NULL locator_inventory_item_id
200: ,NULL empty_flag
201: ,NULL location_current_units
202: from mtl_serial_numbers msn
203: ,mtl_secondary_inventories sub
204: ,mtl_item_locations loc
205: ,mtl_lot_numbers lot
206: where msn.current_status = 3

Line 307: from mtl_serial_numbers msn

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