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 346: FROM mtl_material_transactions_temp

342: -- Bug 5231114: Added the condition on transaction_source_type_id and
343: -- transaction_action_id for the following combinations:13/12 and 4/27
344: CURSOR c_mmtt IS
345: SELECT transaction_temp_id
346: FROM mtl_material_transactions_temp
347: WHERE move_order_line_id = p_mol_id
348: AND ((transaction_source_type_id = 1 AND transaction_action_id = 27)
349: OR (transaction_source_type_id = 7 AND transaction_action_id = 12)
350: OR (transaction_source_type_id = 12 AND transaction_action_id = 27)

Line 3864: , mtl_material_transactions_temp mmtt

3860: , mtrl.quantity txn_qty
3861: , mtrl.quantity_detailed quantity_detailed
3862: , mtrl.quantity_delivered quantity_delivered
3863: FROM mtl_txn_request_lines mtrl
3864: , mtl_material_transactions_temp mmtt
3865: WHERE mtrl.organization_id = p_org_id
3866: AND nvl(mtrl.from_subinventory_code,'@$#_') = nvl(p_from_sub,'@$#_')
3867: AND nvl(mtrl.from_locator_id,-1) = nvl(p_from_locator_id,-1)
3868: AND ( nvl(mtrl.project_id,-1) = nvl(p_project_id,-1) OR p_project_id IS NULL )

Line 3935: , mtl_material_transactions_temp mmtt

3931: , mtrl.quantity txn_qty
3932: , mtrl.quantity_detailed quantity_detailed
3933: , mtrl.quantity_delivered quantity_delivered
3934: FROM mtl_txn_request_lines mtrl
3935: , mtl_material_transactions_temp mmtt
3936: WHERE mtrl.organization_id = p_org_id
3937: AND nvl(mtrl.from_subinventory_code,'@$#_') = nvl(p_from_sub,'@$#_')
3938: AND nvl(mtrl.from_locator_id,-1) = nvl(p_from_locator_id,-1)
3939: AND ( nvl(mtrl.project_id,-1) = nvl(p_project_id,-1) OR p_project_id IS NULL )

Line 4308: UPDATE mtl_material_transactions_temp

4304:
4305: --{{
4306: --After TRANSFER and DELIVER, make sure MMT for the transaction are
4307: --updated with the correct values }}
4308: UPDATE mtl_material_transactions_temp
4309: SET rcv_transaction_id = l_transaction_id
4310: , transfer_to_location = Decode(transfer_to_location,NULL,transfer_to_location,p_locator_id)
4311: , transfer_subinventory = Decode(transfer_to_location,NULL,transfer_subinventory,p_subinventory)
4312: , locator_id = Decode(transfer_to_location,NULL,p_locator_id,locator_id)

Line 5013: , mtl_material_transactions_temp mmtt

5009: FROM dual
5010: WHERE exists
5011: (SELECT 1
5012: FROM wms_dispatched_tasks wdt
5013: , mtl_material_transactions_temp mmtt
5014: WHERE mmtt.move_order_line_id = l_transfer_mol_rec.line_id
5015: AND wdt.transaction_temp_id = mmtt.transaction_temp_id
5016: AND wdt.status IN (3, 4) -- dispached or loaded
5017: AND wdt.task_type = 2 -- putaway

Line 5414: , mtl_material_transactions_temp mmtt

5410: FROM dual
5411: WHERE exists
5412: (SELECT 1
5413: FROM wms_dispatched_tasks wdt
5414: , mtl_material_transactions_temp mmtt
5415: WHERE mmtt.move_order_line_id = l_transfer_mol_rec.line_id
5416: AND wdt.transaction_temp_id = mmtt.transaction_temp_id
5417: AND wdt.status IN (3, 4) -- dispached or loaded
5418: AND wdt.task_type = 2 -- putaway

Line 6092: UPDATE mtl_material_transactions_temp

6088: --
6089: -- UPDATE THE MOVE ORDER LINE HERE
6090: --
6091: IF (p_mmtt_temp_id IS NOT NULL) THEN
6092: UPDATE mtl_material_transactions_temp
6093: SET move_order_line_id = l_transfer_mol_rec.line_id
6094: WHERE transaction_temp_id = p_mmtt_temp_id;
6095:
6096: l_qty_detailed := l_mol_res_in(1).quantity;

Line 7161: , mtl_material_transactions_temp mmtt

7157: FROM dual
7158: WHERE exists
7159: (SELECT 1
7160: FROM wms_dispatched_tasks wdt
7161: , mtl_material_transactions_temp mmtt
7162: WHERE mmtt.move_order_line_id = l_transfer_mol_rec.line_id
7163: AND wdt.transaction_temp_id = mmtt.transaction_temp_id
7164: AND wdt.status IN (3, 4) -- dispached or loaded
7165: AND wdt.task_type = 2 -- putaway

Line 11031: SELECT mtl_material_transactions_s.NEXTVAL

11027: l_primary_lot_qty := l_lot_rec.quantity;
11028: END IF;
11029:
11030: if l_lot_interface_id is null then
11031: SELECT mtl_material_transactions_s.NEXTVAL
11032: INTO l_lot_Interface_Id
11033: FROM DUAL;
11034: End if;
11035:

Line 11049: SELECT mtl_material_transactions_s.NEXTVAL

11045: )
11046: Loop
11047: -- Generate the serial interface id here
11048: if l_serial_interface_id is null then
11049: SELECT mtl_material_transactions_s.NEXTVAL
11050: INTO l_serial_Interface_Id
11051: FROM DUAL;
11052: End if;
11053:

Line 11112: SELECT mtl_material_transactions_s.NEXTVAL

11108: )
11109: Loop
11110: -- Generate the serial interface id here
11111: if l_serial_interface_id is null then
11112: SELECT mtl_material_transactions_s.NEXTVAL
11113: INTO l_serial_Interface_Id
11114: FROM DUAL;
11115: End if;
11116:

Line 11187: FROM mtl_material_transactions_temp mmtt, mtl_txn_request_lines mtrl

11183: , Nvl(mmtt.transaction_quantity,mtrl.quantity-Nvl(mtrl.quantity_delivered,0)) txn_qty
11184: , Nvl(mmtt.transaction_uom,mtrl.uom_code) txn_uom_code
11185: , Nvl(mmtt.secondary_transaction_quantity
11186: , mtrl.secondary_quantity-Nvl(mtrl.secondary_quantity_delivered,0)) sec_qty --OPM Convergence
11187: FROM mtl_material_transactions_temp mmtt, mtl_txn_request_lines mtrl
11188: WHERE mmtt.move_order_line_id (+)= mtrl.line_id
11189: AND mtrl.lpn_id = v_lpn_id
11190: AND mtrl.line_status = 7
11191: AND mtrl.quantity-Nvl(mtrl.quantity_delivered,0) > 0

Line 11545: SELECT mtl_material_transactions_s.NEXTVAL

11541: END IF;
11542:
11543: IF (l_mol_mmtt_ctnt_tb(i).lot_number IS NOT NULL) THEN
11544: IF l_lot_interface_id IS NULL THEN
11545: SELECT mtl_material_transactions_s.NEXTVAL
11546: INTO l_lot_interface_id
11547: FROM DUAL;
11548: END IF;
11549:

Line 11699: SELECT mtl_material_transactions_s.NEXTVAL

11695: END IF;
11696:
11697: FOR j IN 1..l_rti_serial_tb(l_rti_index).COUNT LOOP
11698: IF l_serial_interface_id IS NULL THEN
11699: SELECT mtl_material_transactions_s.NEXTVAL
11700: INTO l_serial_Interface_Id
11701: FROM DUAL;
11702: END IF;
11703:

Line 11729: SELECT mtl_material_transactions_s.NEXTVAL

11725: END LOOP;--FOR j IN 1..l_rti_serial_tb(l_rti_index).COUNT LOOP
11726:
11727: IF (l_mol_mmtt_ctnt_tb(i).lot_number IS NOT NULL) THEN
11728: IF l_lot_interface_id IS NULL THEN
11729: SELECT mtl_material_transactions_s.NEXTVAL
11730: INTO l_lot_interface_id
11731: FROM DUAL;
11732: END IF;
11733:

Line 16914: SELECT mtl_material_transactions_s.NEXTVAL

16910: -- l_mtli_rec.transaction_quantity - l_remaining_quantity
16911:
16912: IF (l_mtli_rec.serial_transaction_temp_id IS NOT NULL)
16913: THEN
16914: SELECT mtl_material_transactions_s.NEXTVAL
16915: INTO l_new_serial_txn_temp_id
16916: FROM DUAL;
16917: ELSE
16918: l_new_serial_txn_temp_id := NULL;

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

18103: l_return_status VARCHAR2(1);
18104: l_msg_data VARCHAR2(2000);
18105: --END R12
18106:
18107: l_last_transaction_id mtl_material_transactions.transaction_id%type; --bug 5168883
18108: l_last_transaction_type_id mtl_material_transactions.transaction_type_id%type; -- 5168883
18109:
18110: BEGIN
18111: X_RETURN_STATUS := G_RET_STS_SUCCESS;

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

18104: l_msg_data VARCHAR2(2000);
18105: --END R12
18106:
18107: l_last_transaction_id mtl_material_transactions.transaction_id%type; --bug 5168883
18108: l_last_transaction_type_id mtl_material_transactions.transaction_type_id%type; -- 5168883
18109:
18110: BEGIN
18111: X_RETURN_STATUS := G_RET_STS_SUCCESS;
18112:

Line 20771: from mtl_material_transactions

20767: --bug 5168883
20768: BEGIN
20769: select transaction_type_id
20770: into l_last_transaction_type_id
20771: from mtl_material_transactions
20772: where transaction_id = l_last_transaction_id;
20773: EXCEPTION
20774: when others then
20775: l_last_transaction_type_id := null;