DBA Data[Home] [Help]

APPS.WMS_RULE_2 dependencies on MTL_SERIAL_NUMBERS

Line 111: from mtl_serial_numbers msn

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

Line 195: from mtl_serial_numbers msn

191: ,loc.task_id task_id
192: ,NULL locator_inventory_item_id
193: ,NULL empty_flag
194: ,NULL location_current_units
195: from mtl_serial_numbers msn
196: ,mtl_secondary_inventories sub
197: ,mtl_item_locations loc
198: ,mtl_lot_numbers lot
199: where msn.current_status = 3

Line 296: from mtl_serial_numbers msn

292: ,loc.task_id task_id
293: ,NULL locator_inventory_item_id
294: ,NULL empty_flag
295: ,NULL location_current_units
296: from mtl_serial_numbers msn
297: ,mtl_secondary_inventories sub
298: ,mtl_item_locations loc
299: ,mtl_lot_numbers lot
300: where msn.current_status = 3