DBA Data[Home] [Help]

APPS.INV_MATERIAL_ALLOCATIONS_GRP dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 38: from mtl_material_transactions_temp

34: select primary_quantity, transaction_quantity, move_order_line_id,
35: item_primary_uom_code, transaction_uom, inventory_item_id
36: into x_primary_mmtt_qty, x_tx_qty, x_move_order_line_id,
37: x_item_primary_uom_code, x_transaction_uom, x_inventory_item_id
38: from mtl_material_transactions_temp
39: where transaction_temp_id = p_transaction_temp_id;
40:
41: if (l_slog) then
42: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,

Line 285: -- delete mtl_material_transactions_temp

281: return;
282: --Following elsif (3 lines): not sure whether we should allow delete here
283: --also or only in delete_allocation
284: --elsif (l_final_qty = 0) then
285: -- delete mtl_material_transactions_temp
286: -- where transaction_temp_id = p_transaction_temp_id;
287: else
288: -- Convert the count quantity into the item primary uom quantity
289: l_final_tx_qty :=

Line 298: update mtl_material_transactions_temp

294: l_transaction_uom,
295: NULL,
296: NULL
297: );
298: update mtl_material_transactions_temp
299: set primary_quantity = l_final_qty, --following line converts between base to tx uom
300: transaction_quantity = l_final_tx_qty
301: where transaction_temp_id = p_transaction_temp_id;
302: end if;