APPS.INV_UTILITIES dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 133: FROM mtl_material_transactions_temp

129: , locator_id
130: , transfer_subinventory
131: , transfer_to_location
132: , revision
133: FROM mtl_material_transactions_temp
134: WHERE move_order_line_id = v_line_id
135: AND pick_slip_number IS NULL;
136:
137: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

Line 276: UPDATE mtl_material_transactions_temp

272: , x_pick_slip_number => v_pick_slip_no
273: , x_api_status => v_return_status
274: , x_error_message => v_err_msg
275: );
276: UPDATE mtl_material_transactions_temp
277: SET pick_slip_number = v_pick_slip_no
278: WHERE transaction_temp_id = v_mmtt.transaction_temp_id;
279: END LOOP;
280: END IF;

Line 290: UPDATE mtl_material_transactions_temp

286: -- MOs allocated using MO Pick Slip Report too,
287: -- along with manually allocated MO will populate
288: -- the distribution_account_id of MMTT.
289: IF move_ord_rec.to_account_id IS NOT NULL THEN
290: UPDATE mtl_material_transactions_temp
291: SET distribution_account_id = move_ord_rec.to_account_id
292: WHERE move_order_line_id = v_line_id;
293: END IF;
294: