APPS.INV_SERIAL_PICK_PKG dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 117: mtl_material_transactions_temp mmtt

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
120: and msnt.transaction_temp_id = mtlt.serial_transaction_temp_id
121: UNION

Line 124: mtl_material_transactions_temp mmtt

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:
128: delete from mtl_serial_numbers_temp

Line 130: from mtl_material_transactions_temp mmtt

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
133: select mtlt.serial_transaction_temp_id
134: from mtl_material_transactions_temp mmtt,

Line 134: from mtl_material_transactions_temp mmtt,

130: from mtl_material_transactions_temp mmtt
131: where mmtt.move_order_line_id = p_move_order_line_id
132: UNION
133: select mtlt.serial_transaction_temp_id
134: from mtl_material_transactions_temp mmtt,
135: mtl_transaction_lots_temp mtlt
136: where mmtt.move_order_line_id = p_move_order_line_id
137: and mtlt.transaction_temp_id = mmtt.transaction_temp_id);
138:

Line 141: from mtl_material_transactions_temp mmtt

137: and mtlt.transaction_temp_id = mmtt.transaction_temp_id);
138:
139: delete from mtl_transaction_lots_temp
140: where transaction_temp_id in (select transaction_temp_id
141: from mtl_material_transactions_temp mmtt
142: where mmtt.move_order_line_id = p_move_order_line_id);
143:
144: delete from mtl_material_transactions_temp
145: where move_order_line_id = p_move_order_line_id;

Line 144: delete from mtl_material_transactions_temp

140: where transaction_temp_id in (select transaction_temp_id
141: from mtl_material_transactions_temp mmtt
142: where mmtt.move_order_line_id = p_move_order_line_id);
143:
144: delete from mtl_material_transactions_temp
145: where move_order_line_id = p_move_order_line_id;
146: EXCEPTION
147: WHEN OTHERS THEN
148: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 174: from mtl_material_transactions_temp

170: p_user_id IN NUMBER
171: ) IS
172: CURSOR MMTT_TEMP_ID is
173: select transaction_temp_id,transaction_quantity
174: from mtl_material_transactions_temp
175: where move_order_line_id = p_move_order_line_id;
176:
177: l_mmtt_rec mtl_material_transactions_temp%ROWTYPE;
178: l_trx_temp_id NUMBER;

Line 177: l_mmtt_rec mtl_material_transactions_temp%ROWTYPE;

173: select transaction_temp_id,transaction_quantity
174: from mtl_material_transactions_temp
175: where move_order_line_id = p_move_order_line_id;
176:
177: l_mmtt_rec mtl_material_transactions_temp%ROWTYPE;
178: l_trx_temp_id NUMBER;
179: l_new_temp_id NUMBER;
180: l_serial_temp_id NUMBER;
181: l_return_result NUMBER;

Line 339: from mtl_material_transactions_temp

335:
336:
337: -- reserve the first record to act as a base when inserting the record
338: select * into l_mmtt_rec
339: from mtl_material_transactions_temp
340: where move_order_line_id = p_move_order_line_id
341: and rownum = 1;
342:
343:

Line 697: INSERT INTO MTL_MATERIAL_TRANSACTIONS_TEMP

693: RAISE fnd_api.g_exc_error;
694: END IF;
695:
696: -- insert a new record for the new serial number
697: INSERT INTO MTL_MATERIAL_TRANSACTIONS_TEMP
698: (
699: TRANSACTION_HEADER_ID
700: , TRANSACTION_TEMP_ID
701: , SOURCE_CODE