DBA Data[Home] [Help]

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 366: UPDATE mtl_material_transactions_temp

362: , p_dept_id => NULL
363: , p_push_or_pull => NULL
364: );
365:
366: UPDATE mtl_material_transactions_temp
367: SET pick_slip_number = l_pick_slip_no
368: WHERE transaction_temp_id = v_mmtt.transaction_temp_id;
369: END LOOP;
370: END IF;

Line 376: UPDATE mtl_material_transactions_temp

372: /*Bug#5140639. Commented the updation of 'distribution_account_id' in MMTT as
373: it is already done in 'INV_Replenish_Detail_PUB.Line_Details_PUB' */
374:
375: /* IF v_mo_line_rec.to_account_id IS NOT NULL THEN
376: UPDATE mtl_material_transactions_temp
377: SET distribution_account_id = v_mo_line_rec.to_account_id
378: WHERE move_order_line_id = v_mo_line_rec.line_id;
379: END IF;*/
380: