DBA Data[Home] [Help]

APPS.WIP_UTILITIES dependencies on MTL_MATERIAL_TRANSACTIONS_S

Line 176: select mtl_material_transactions_s.nextval into l_temp_id

172: if (inv_rec.transaction_interface_id is null) then
173: -- transaction interface id not assigned to mti, probably no lot/serial
174: -- generate one
175:
176: select mtl_material_transactions_s.nextval into l_temp_id
177: from sys.dual;
178: update mtl_transactions_interface
179: set transaction_interface_id = l_temp_id
180: where rowid = inv_rec.rowid;

Line 222: select mtl_material_transactions_s.nextval into l_temp_id

218: for inv_rec in get_mmtt(p_txn_id) loop
219: if (inv_rec.transaction_temp_id is null) then
220: -- temp id not assigned to mmtt record (probably no lot/serial),
221: -- generate one
222: select mtl_material_transactions_s.nextval into l_temp_id
223: from sys.dual;
224: update mtl_material_transactions_temp
225: set transaction_temp_id = l_temp_id
226: where rowid = inv_rec.rowid;