APPS.INV_MO_LINE_DETAIL_UTIL dependencies on MTL_TRANSACTION_LOTS_TEMP

Line 2134: := 'DELETE mtl_transaction_lots_temp '

2130: tab_index INTEGER;
2131: l_sql_p INTEGER := NULL;
2132: l_rows_processed INTEGER := NULL;
2133: l_del_mtlt LONG
2134: := 'DELETE mtl_transaction_lots_temp '
2135: || 'WHERE transaction_temp_id in '
2136: || '(select transaction_temp_id '
2137: || ' from mtl_material_transactions_temp '
2138: || ' where move_order_line_id = :b_move_order_line_id) ';

Line 2352: FROM mtl_transaction_lots_temp

2348: INTO l_mtlt_rowid
2349: , l_mtlt_primary_quantity
2350: , l_mtlt_transaction_quantity
2351: , l_mtlt_sec_transaction_qty
2352: FROM mtl_transaction_lots_temp
2353: WHERE transaction_temp_id = l_transaction_temp_id
2354: AND lot_number = p_mold_table(i).lot_number
2355: FOR UPDATE OF primary_quantity, transaction_quantity;
2356:

Line 2390: UPDATE mtl_transaction_lots_temp

2386: , primary_quantity = l_mmtt_table(l_transaction_temp_id).picked_primary_quantity
2387: WHERE ROWID = l_mmtt_rowid;
2388:
2389: IF l_mtlt_transaction_quantity > p_mold_table(i).transaction_quantity THEN
2390: UPDATE mtl_transaction_lots_temp
2391: SET transaction_quantity = p_mold_table(i).transaction_quantity
2392: , secondary_quantity = p_mold_table(i).secondary_transaction_quantity
2393: , primary_quantity = l_primary_quantity
2394: WHERE ROWID = l_mtlt_rowid;

Line 2590: FROM mtl_transaction_lots_temp

2586: SELECT transaction_quantity
2587: , secondary_quantity --INVCONV
2588: , serial_transaction_temp_id
2589: , ROWID
2590: FROM mtl_transaction_lots_temp
2591: WHERE transaction_temp_id = p_transaction_temp_id
2592: ORDER BY transaction_quantity ASC;
2593:
2594: CURSOR c_serial_allocations IS

Line 2709: DELETE FROM mtl_transaction_lots_temp

2705:
2706: CLOSE c_serial_allocations;
2707:
2708: IF l_lot_qty_to_delete = l_lot_quantity THEN
2709: DELETE FROM mtl_transaction_lots_temp
2710: WHERE ROWID = l_lot_rowid;
2711: ELSE
2712: l_new_lot_quantity := l_lot_quantity - l_lot_qty_to_delete;
2713: --convert quantity

Line 2722: UPDATE mtl_transaction_lots_temp

2718: IF l_new_prim_quantity = -99999 THEN
2719: RAISE fnd_api.g_exc_error;
2720: END IF;
2721:
2722: UPDATE mtl_transaction_lots_temp
2723: SET transaction_quantity = l_new_lot_quantity
2724: , primary_quantity = l_new_lot_prim_quantity
2725: WHERE ROWID = l_lot_rowid;
2726: END IF;

Line 2764: FROM mtl_transaction_lots_temp mtlt

2760: l_procedure_name VARCHAR2(30) := 'GET_LOT_QUANTITY';
2761:
2762: CURSOR lot_records IS
2763: SELECT NVL(SUM(mtlt.primary_quantity), 0)
2764: FROM mtl_transaction_lots_temp mtlt
2765: WHERE mtlt.transaction_temp_id = p_transaction_temp_id;
2766:
2767: l_lot_quantity NUMBER := 0;
2768: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

Line 2865: FROM mtl_transaction_lots_temp mtlt

2861:
2862: CURSOR lot_records(c_transaction_temp_id NUMBER) IS
2863: SELECT mtlt.serial_transaction_temp_id
2864: , mtlt.primary_quantity
2865: FROM mtl_transaction_lots_temp mtlt
2866: WHERE mtlt.transaction_temp_id = c_transaction_temp_id;
2867:
2868: l_quantity NUMBER := 0;
2869: l_lot_quantity NUMBER := 0;