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

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 11508: SELECT mtl_material_transactions_s.NEXTVAL

11504: l_primary_lot_qty := l_lot_rec.quantity;
11505: END IF;
11506:
11507: if l_lot_interface_id is null then
11508: SELECT mtl_material_transactions_s.NEXTVAL
11509: INTO l_lot_Interface_Id
11510: FROM DUAL;
11511: End if;
11512:

Line 11526: SELECT mtl_material_transactions_s.NEXTVAL

11522: )
11523: Loop
11524: -- Generate the serial interface id here
11525: if l_serial_interface_id is null then
11526: SELECT mtl_material_transactions_s.NEXTVAL
11527: INTO l_serial_Interface_Id
11528: FROM DUAL;
11529: End if;
11530:

Line 11589: SELECT mtl_material_transactions_s.NEXTVAL

11585: )
11586: Loop
11587: -- Generate the serial interface id here
11588: if l_serial_interface_id is null then
11589: SELECT mtl_material_transactions_s.NEXTVAL
11590: INTO l_serial_Interface_Id
11591: FROM DUAL;
11592: End if;
11593:

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 12030: SELECT mtl_material_transactions_s.NEXTVAL

12026: END IF;
12027:
12028: IF (l_mol_mmtt_ctnt_tb(i).lot_number IS NOT NULL) THEN
12029: IF l_lot_interface_id IS NULL THEN
12030: SELECT mtl_material_transactions_s.NEXTVAL
12031: INTO l_lot_interface_id
12032: FROM DUAL;
12033: END IF;
12034:

Line 12184: SELECT mtl_material_transactions_s.NEXTVAL

12180: END IF;
12181:
12182: FOR j IN 1..l_rti_serial_tb(l_rti_index).COUNT LOOP
12183: IF l_serial_interface_id IS NULL THEN
12184: SELECT mtl_material_transactions_s.NEXTVAL
12185: INTO l_serial_Interface_Id
12186: FROM DUAL;
12187: END IF;
12188:

Line 12214: SELECT mtl_material_transactions_s.NEXTVAL

12210: END LOOP;--FOR j IN 1..l_rti_serial_tb(l_rti_index).COUNT LOOP
12211:
12212: IF (l_mol_mmtt_ctnt_tb(i).lot_number IS NOT NULL) THEN
12213: IF l_lot_interface_id IS NULL THEN
12214: SELECT mtl_material_transactions_s.NEXTVAL
12215: INTO l_lot_interface_id
12216: FROM DUAL;
12217: END IF;
12218:

Line 17772: SELECT mtl_material_transactions_s.NEXTVAL

17768: -- l_mtli_rec.transaction_quantity - l_remaining_quantity
17769:
17770: IF (l_mtli_rec.serial_transaction_temp_id IS NOT NULL)
17771: THEN
17772: SELECT mtl_material_transactions_s.NEXTVAL
17773: INTO l_new_serial_txn_temp_id
17774: FROM DUAL;
17775: ELSE
17776: l_new_serial_txn_temp_id := NULL;

Line 19116: l_last_transaction_id mtl_material_transactions.transaction_id%type; --bug 5168883

19112: l_return_status VARCHAR2(1);
19113: l_msg_data VARCHAR2(2000);
19114: --END R12
19115:
19116: l_last_transaction_id mtl_material_transactions.transaction_id%type; --bug 5168883
19117: l_last_transaction_type_id mtl_material_transactions.transaction_type_id%type; -- 5168883
19118:
19119: --Serial tagging
19120: l_parent_transaction_type VARCHAR2(25);

Line 19117: l_last_transaction_type_id mtl_material_transactions.transaction_type_id%type; -- 5168883

19113: l_msg_data VARCHAR2(2000);
19114: --END R12
19115:
19116: l_last_transaction_id mtl_material_transactions.transaction_id%type; --bug 5168883
19117: l_last_transaction_type_id mtl_material_transactions.transaction_type_id%type; -- 5168883
19118:
19119: --Serial tagging
19120: l_parent_transaction_type VARCHAR2(25);
19121: l_serial_tagged NUMBER := 1; -- Bug 13886318 added initianlization

Line 21966: from mtl_material_transactions

21962: --bug 5168883
21963: BEGIN
21964: select transaction_type_id
21965: into l_last_transaction_type_id
21966: from mtl_material_transactions
21967: where transaction_id = l_last_transaction_id;
21968: EXCEPTION
21969: when others then
21970: l_last_transaction_type_id := null;

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 ;