DBA Data[Home] [Help]

APPS.WIP_UTILITIES dependencies on MTL_MATERIAL_TRANSACTIONS_S

Line 166: select mtl_material_transactions_s.nextval into l_temp_id

162: for inv_rec in get_mti(p_txn_id) loop
163: if (inv_rec.transaction_interface_id is null) then
164: -- transaction interface id not assigned to mti, probably no lot/serial
165: -- generate one
166: select mtl_material_transactions_s.nextval into l_temp_id
167: from sys.dual;
168: update mtl_transactions_interface
169: set transaction_interface_id = l_temp_id
170: where rowid = inv_rec.rowid;

Line 190: select mtl_material_transactions_s.nextval into l_temp_id

186: for inv_rec in get_mmtt(p_txn_id) loop
187: if (inv_rec.transaction_temp_id is null) then
188: -- temp id not assigned to mmtt record (probably no lot/serial),
189: -- generate one
190: select mtl_material_transactions_s.nextval into l_temp_id
191: from sys.dual;
192: update mtl_material_transactions_temp
193: set transaction_temp_id = l_temp_id
194: where rowid = inv_rec.rowid;