eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_RCV_INTEGRATION_PVT dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 370: FROM mtl_material_transactions_temp

366: -- Bug 5231114: Added the condition on transaction_source_type_id and
367: -- transaction_action_id for the following combinations:13/12 and 4/27
368: CURSOR c_mmtt IS
369: SELECT transaction_temp_id
370: FROM mtl_material_transactions_temp
371: WHERE move_order_line_id = p_mol_id
372: AND ((transaction_source_type_id = 1 AND transaction_action_id = 27)
373: OR (transaction_source_type_id = 7 AND transaction_action_id = 12)
374: OR (transaction_source_type_id = 12 AND transaction_action_id = 27)

Line 3920: , mtl_material_transactions_temp mmtt

3916: , mtrl.quantity txn_qty
3917: , mtrl.quantity_detailed quantity_detailed
3918: , mtrl.quantity_delivered quantity_delivered
3919: FROM mtl_txn_request_lines mtrl
3920: , mtl_material_transactions_temp mmtt
3921: WHERE mtrl.organization_id = p_org_id
3922: AND nvl(mtrl.from_subinventory_code,'@$#_') = nvl(p_from_sub,'@$#_')
3923: AND nvl(mtrl.from_locator_id,-1) = nvl(p_from_locator_id,-1)
3924: AND ( nvl(mtrl.project_id,-1) = nvl(p_project_id,-1) OR p_project_id IS NULL )

Line 3993: , mtl_material_transactions_temp mmtt

3989: , mtrl.quantity txn_qty
3990: , mtrl.quantity_detailed quantity_detailed
3991: , mtrl.quantity_delivered quantity_delivered
3992: FROM mtl_txn_request_lines mtrl
3993: , mtl_material_transactions_temp mmtt
3994: WHERE mtrl.organization_id = p_org_id
3995: AND nvl(mtrl.from_subinventory_code,'@$#_') = nvl(p_from_sub,'@$#_')
3996: AND nvl(mtrl.from_locator_id,-1) = nvl(p_from_locator_id,-1)
3997: AND ( nvl(mtrl.project_id,-1) = nvl(p_project_id,-1) OR p_lpn IS NULL)

Line 4380: UPDATE mtl_material_transactions_temp

4376:
4377: --{{
4378: --After TRANSFER and DELIVER, make sure MMT for the transaction are
4379: --updated with the correct values }}
4380: UPDATE mtl_material_transactions_temp
4381: SET rcv_transaction_id = l_transaction_id
4382: , transfer_to_location = Decode(transfer_to_location,NULL,transfer_to_location,p_locator_id)
4383: , transfer_subinventory = Decode(transfer_to_location,NULL,transfer_subinventory,p_subinventory)
4384: , locator_id = Decode(transfer_to_location,NULL,p_locator_id,locator_id)

Line 5102: , mtl_material_transactions_temp mmtt

5098: FROM dual
5099: WHERE exists
5100: (SELECT 1
5101: FROM wms_dispatched_tasks wdt
5102: , mtl_material_transactions_temp mmtt
5103: WHERE mmtt.move_order_line_id = l_transfer_mol_rec.line_id
5104: AND wdt.transaction_temp_id = mmtt.transaction_temp_id
5105: AND wdt.status IN (3, 4) -- dispached or loaded
5106: AND wdt.task_type = 2 -- putaway

Line 5508: , mtl_material_transactions_temp mmtt

5504: FROM dual
5505: WHERE exists
5506: (SELECT 1
5507: FROM wms_dispatched_tasks wdt
5508: , mtl_material_transactions_temp mmtt
5509: WHERE mmtt.move_order_line_id = l_transfer_mol_rec.line_id
5510: AND wdt.transaction_temp_id = mmtt.transaction_temp_id
5511: AND wdt.status IN (3, 4) -- dispached or loaded
5512: AND wdt.task_type = 2 -- putaway

Line 6263: UPDATE mtl_material_transactions_temp

6259: --
6260: -- UPDATE THE MOVE ORDER LINE HERE
6261: --
6262: IF (p_mmtt_temp_id IS NOT NULL) THEN
6263: UPDATE mtl_material_transactions_temp
6264: SET move_order_line_id = l_transfer_mol_rec.line_id
6265: WHERE transaction_temp_id = p_mmtt_temp_id;
6266:
6267: l_qty_detailed := l_mol_res_in(1).quantity;

Line 7339: , mtl_material_transactions_temp mmtt

7335: FROM dual
7336: WHERE exists
7337: (SELECT 1
7338: FROM wms_dispatched_tasks wdt
7339: , mtl_material_transactions_temp mmtt
7340: WHERE mmtt.move_order_line_id = l_transfer_mol_rec.line_id
7341: AND wdt.transaction_temp_id = mmtt.transaction_temp_id
7342: AND wdt.status IN (3, 4) -- dispached or loaded
7343: AND wdt.task_type = 2 -- putaway

Line 11664: FROM mtl_material_transactions_temp mmtt, mtl_txn_request_lines mtrl

11660: , Nvl(mmtt.transaction_quantity,mtrl.quantity-Nvl(mtrl.quantity_delivered,0)) txn_qty
11661: , Nvl(mmtt.transaction_uom,mtrl.uom_code) txn_uom_code
11662: , Nvl(mmtt.secondary_transaction_quantity
11663: , mtrl.secondary_quantity-Nvl(mtrl.secondary_quantity_delivered,0)) sec_qty --OPM Convergence
11664: FROM mtl_material_transactions_temp mmtt, mtl_txn_request_lines mtrl
11665: WHERE mmtt.move_order_line_id (+)= mtrl.line_id
11666: AND mtrl.lpn_id = v_lpn_id
11667: AND mtrl.line_status = 7
11668: AND mtrl.quantity-Nvl(mtrl.quantity_delivered,0) > 0

Line 29184: MTL_MATERIAL_TRANSACTIONS_TEMP MMTT

29180: SELECT
29181: 1
29182: FROM
29183: WMS_DISPATCHED_TASKS WDT,
29184: MTL_MATERIAL_TRANSACTIONS_TEMP MMTT
29185: WHERE
29186: NVL(MMTT.content_lpn_id, MMTT.lpn_id) = p_lpn_id
29187: AND MMTT.transaction_temp_id = WDT.transaction_temp_id
29188: AND WDT.STATUS = 4 ;