APPS.EAM_MATERIAL_ALLOCATIONS_PVT dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 31: from mtl_material_transactions_temp

27: begin
28: --get primary qty from MMTT
29: select primary_quantity, transaction_quantity, move_order_line_id
30: into x_primary_mmtt_qty, x_tx_qty, x_move_order_line_id
31: from mtl_material_transactions_temp
32: where transaction_temp_id = p_transaction_temp_id;
33:
34: if (l_log and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) then
35: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,

Line 253: -- delete mtl_material_transactions_temp

249: return;
250: --Following elsif (3 lines): not sure whether we should allow delete here
251: --also or only in delete_allocation
252: --elsif (l_final_qty = 0) then
253: -- delete mtl_material_transactions_temp
254: -- where transaction_temp_id = p_transaction_temp_id;
255: else
256: update mtl_material_transactions_temp
257: set primary_quantity = l_final_qty, --following line converts between base to tx uom

Line 256: update mtl_material_transactions_temp

252: --elsif (l_final_qty = 0) then
253: -- delete mtl_material_transactions_temp
254: -- where transaction_temp_id = p_transaction_temp_id;
255: else
256: update mtl_material_transactions_temp
257: set primary_quantity = l_final_qty, --following line converts between base to tx uom
258: transaction_quantity = l_final_qty * (l_tx_qty/l_primary_mmtt_qty)
259: where transaction_temp_id = p_transaction_temp_id;
260: end if;