APPS.INV_SERIAL_PICK_PKG dependencies on MTL_SERIAL_NUMBERS

Line 112: update mtl_serial_numbers

108: BEGIN
109: x_return_status := fnd_api.g_ret_sts_success;
110:
111: -- clean up the marks for the serial numbers
112: update mtl_serial_numbers
113: set group_mark_id = null
114: where serial_number in (select fm_serial_number
115: from mtl_serial_numbers_temp msnt,
116: mtl_transaction_lots_temp mtlt,

Line 115: from mtl_serial_numbers_temp msnt,

111: -- clean up the marks for the serial numbers
112: update mtl_serial_numbers
113: set group_mark_id = null
114: where serial_number in (select fm_serial_number
115: from mtl_serial_numbers_temp msnt,
116: mtl_transaction_lots_temp mtlt,
117: mtl_material_transactions_temp mmtt
118: where mmtt.move_order_line_id = p_move_order_line_id
119: and mtlt.transaction_temp_id = mmtt.transaction_temp_id

Line 123: from mtl_serial_numbers_temp msnt,

119: and mtlt.transaction_temp_id = mmtt.transaction_temp_id
120: and msnt.transaction_temp_id = mtlt.serial_transaction_temp_id
121: UNION
122: select fm_serial_number
123: from mtl_serial_numbers_temp msnt,
124: mtl_material_transactions_temp mmtt
125: where mmtt.move_order_line_id = p_move_order_line_id
126: and msnt.transaction_temp_id = mmtt.transaction_temp_id);
127:

Line 128: delete from mtl_serial_numbers_temp

124: mtl_material_transactions_temp mmtt
125: where mmtt.move_order_line_id = p_move_order_line_id
126: and msnt.transaction_temp_id = mmtt.transaction_temp_id);
127:
128: delete from mtl_serial_numbers_temp
129: where transaction_temp_id in (select transaction_temp_id
130: from mtl_material_transactions_temp mmtt
131: where mmtt.move_order_line_id = p_move_order_line_id
132: UNION