DBA Data[Home] [Help]

APPS.WMS_RULE_14 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 194: from mtl_serial_numbers msn

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

Line 293: from mtl_serial_numbers msn

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