APPS.INV_PICK_SLIP_REPORT dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 208: FROM mtl_material_transactions_temp

204: , locator_id
205: , transfer_subinventory
206: , transfer_to_location
207: , revision
208: FROM mtl_material_transactions_temp
209: WHERE move_order_line_id = p_mo_line_id
210: AND pick_slip_number IS NULL;
211:
212: l_debug NUMBER;

Line 394: UPDATE mtl_material_transactions_temp

390: , p_dept_id => NULL
391: , p_push_or_pull => NULL
392: );
393:
394: UPDATE mtl_material_transactions_temp
395: SET pick_slip_number = l_pick_slip_no
396: WHERE transaction_temp_id = v_mmtt.transaction_temp_id;
397: END LOOP;
398: END IF;

Line 404: UPDATE mtl_material_transactions_temp

400: /*Bug#5140639. Commented the updation of 'distribution_account_id' in MMTT as
401: it is already done in 'INV_Replenish_Detail_PUB.Line_Details_PUB' */
402:
403: /* IF v_mo_line_rec.to_account_id IS NOT NULL THEN
404: UPDATE mtl_material_transactions_temp
405: SET distribution_account_id = v_mo_line_rec.to_account_id
406: WHERE move_order_line_id = v_mo_line_rec.line_id;
407: END IF;*/
408: