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.WMS_ATF_RUNTIME_PUB_APIS dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 100: FROM mtl_material_transactions_temp

96: transfer_to_location,
97: organization_id,
98: wms_task_type,
99: primary_quantity
100: FROM mtl_material_transactions_temp
101: WHERE transaction_temp_id=p_source_task_id;
102:
103: CURSOR c_operation_plan(v_operation_plan_id NUMBER) IS
104: SELECT plan_type_id, crossdock_to_wip_flag

Line 147: l_mmtt_rec MTL_MATERIAL_TRANSACTIONS_TEMP%ROWTYPE:=NULL;

143: l_module_name VARCHAR2(30) := 'Init_OP_Plan_Instance';
144: l_progress NUMBER;
145:
146: l_inbound_doc_rec inbound_document_details%ROWTYPE :=NULL;
147: l_mmtt_rec MTL_MATERIAL_TRANSACTIONS_TEMP%ROWTYPE:=NULL;
148: l_operation_plan_rec c_operation_plan%ROWTYPE:=NULL;
149: l_operation_plan_detail_rec c_plan_detail%ROWTYPE:=NULL;
150: l_op_plan_instance_rec WMS_OP_PLAN_INSTANCES%ROWTYPE:=NULL;
151: l_operation_instance_rec WMS_OP_OPERATION_INSTANCES%ROWTYPE :=NULL;

Line 780: FROM mtl_material_transactions_temp mmtt

776:
777: CURSOR c_parent_locator IS
778: SELECT Nvl(mmtt.transfer_subinventory, mmtt.subinventory_code) subinventory_code,
779: Nvl(mmtt.transfer_to_location, mmtt.locator_id) locator_id
780: FROM mtl_material_transactions_temp mmtt
781: WHERE mmtt.transaction_temp_id =
782: (SELECT child_mmtt.parent_line_id
783: FROM mtl_material_transactions_temp child_mmtt
784: WHERE child_mmtt.transaction_temp_id = p_source_task_id);

Line 783: FROM mtl_material_transactions_temp child_mmtt

779: Nvl(mmtt.transfer_to_location, mmtt.locator_id) locator_id
780: FROM mtl_material_transactions_temp mmtt
781: WHERE mmtt.transaction_temp_id =
782: (SELECT child_mmtt.parent_line_id
783: FROM mtl_material_transactions_temp child_mmtt
784: WHERE child_mmtt.transaction_temp_id = p_source_task_id);
785:
786: CURSOR c_plan_details IS
787: SELECT wopd.zone_selection_criteria zone_selection_criteria,

Line 812: FROM mtl_material_transactions_temp mmtt,

808:
809: CURSOR c_mmtt_data IS
810: SELECT mol.project_id, mol.task_id,mmtt.organization_id, mmtt.operation_plan_id, mmtt.lpn_id,
811: Nvl(wopb.crossdock_to_wip_flag, 'N') crossdock_to_wip_flag
812: FROM mtl_material_transactions_temp mmtt,
813: mtl_txn_request_lines mol,
814: wms_op_plans_b wopb
815: WHERE mmtt.move_order_line_id = mol.line_id
816: AND mmtt.operation_plan_id = wopb.operation_plan_id

Line 992: mtl_material_transactions_temp mmtt

988:
989: SELECT wopv.operation_plan_name
990: INTO l_operation_plan_name
991: FROM wms_op_plans_vl wopv,
992: mtl_material_transactions_temp mmtt
993: WHERE mmtt.transaction_temp_id = p_source_task_id
994: AND mmtt.operation_plan_id = wopv.operation_plan_id;
995:
996: fnd_message.set_name('WMS', 'DERIVE_DEST_SUGGESTIONS_FAILED');

Line 1015: mtl_material_transactions_temp mmtt

1011:
1012: SELECT wopv.operation_plan_name
1013: INTO l_operation_plan_name
1014: FROM wms_op_plans_vl wopv,
1015: mtl_material_transactions_temp mmtt
1016: WHERE mmtt.transaction_temp_id = p_source_task_id
1017: AND mmtt.operation_plan_id = wopv.operation_plan_id;
1018:
1019: fnd_message.set_name('WMS', 'DERIVE_DEST_SUGGESTIONS_FAILED');

Line 1719: FROM mtl_material_transactions_temp mmtt,

1715: mmtt.inventory_item_id,
1716: mmtt.parent_line_id,
1717: mmtt.primary_quantity,
1718: mmtt.move_order_line_id
1719: FROM mtl_material_transactions_temp mmtt,
1720: wms_op_operation_instances wooi,
1721: wms_op_plan_details wopd
1722: WHERE mmtt.transaction_temp_id=p_source_task_id
1723: AND mmtt.transaction_temp_id = wooi.source_task_id (+)

Line 1753: l_mmtt_rec MTL_MATERIAL_TRANSACTIONS_TEMP%ROWTYPE :=NULL;

1749:
1750: l_wdt_rec WMS_DISPATCHED_TASKS%ROWTYPE := NULL;
1751: l_wdt_details c_wdt_details%ROWTYPE;
1752: l_inbound_doc c_inbound_doc%ROWTYPE;
1753: l_mmtt_rec MTL_MATERIAL_TRANSACTIONS_TEMP%ROWTYPE :=NULL;
1754: l_opertn_instance_details c_operation_instance_details%ROWTYPE := NULL;
1755: l_op_plan_instance_id NUMBER;
1756: l_operation_count NUMBER;
1757: l_wooi_rec wms_op_operation_instances%ROWTYPE := NULL;

Line 2598: FROM mtl_material_transactions_temp

2594: content_lpn_id,
2595: transfer_lpn_id,
2596: secondary_uom_code, --Bug# 7716519 : need to include sec_uom in cursor as this is used to update MTRl later
2597: secondary_transaction_quantity --Bug# 7716519 : need to include sec_qty in cursor as this is used to update MTRl later
2598: FROM mtl_material_transactions_temp
2599: WHERE transaction_temp_id=p_source_task_id;
2600:
2601: l_inbound_doc_rec c_inbound_document_details%ROWTYPE;
2602: l_mmtt_rec mtl_material_transactions_temp%ROWTYPE;

Line 2602: l_mmtt_rec mtl_material_transactions_temp%ROWTYPE;

2598: FROM mtl_material_transactions_temp
2599: WHERE transaction_temp_id=p_source_task_id;
2600:
2601: l_inbound_doc_rec c_inbound_document_details%ROWTYPE;
2602: l_mmtt_rec mtl_material_transactions_temp%ROWTYPE;
2603:
2604: -- cursor to get the current active operation instance
2605: -- for the source task
2606:

Line 4090: FROM mtl_txn_request_lines mol, mtl_material_transactions_temp mmtt

4086: CURSOR mol_details IS
4087: SELECT mol.inspection_status,
4088: SUM(NVL(mmtt.primary_quantity, wms_task_dispatch_gen.get_primary_quantity(mol.inventory_item_id,mol.organization_id,(mol.quantity - Nvl(mol.quantity_delivered,0)),mol.uom_code))) quantity,
4089: mmtt.operation_plan_id,mmtt.transaction_temp_id,mol.lpn_id,mol.inventory_item_id
4090: FROM mtl_txn_request_lines mol, mtl_material_transactions_temp mmtt
4091: WHERE mol.line_id = mmtt.move_order_line_id(+)
4092: AND mol.line_id = p_move_order_line_id
4093: AND mol.organization_id = p_organization_id
4094: AND mol.organization_id = mmtt.organization_id(+)

Line 4100: FROM mtl_txn_request_lines mol, mtl_material_transactions_temp mmtt

4096: GROUP BY mol.inspection_status,mmtt.operation_plan_id,mmtt.transaction_temp_id, mol.lpn_id, mol.inventory_item_id;
4097:
4098: CURSOR lpn_details IS
4099: SELECT mol.inspection_status,mmtt.operation_plan_id,mmtt.transaction_temp_id
4100: FROM mtl_txn_request_lines mol, mtl_material_transactions_temp mmtt
4101: WHERE mol.line_id = mmtt.move_order_line_id(+)
4102: AND mol.lpn_id = p_lpn_id
4103: AND mol.organization_id = p_organization_id
4104: AND mol.line_status <> 5 -- bug 4179991

Line 4112: FROM mtl_txn_request_lines mol, mtl_material_transactions_temp mmtt

4108: SELECT mol.inspection_status,
4109: SUM(NVL(mmtt.primary_quantity,
4110: wms_task_dispatch_gen.get_primary_quantity(mol.inventory_item_id,mol.organization_id,(mol.quantity - Nvl(mol.quantity_delivered, 0)),mol.uom_code))) quantity,
4111: mol.lpn_id,mmtt.operation_plan_id,mmtt.transaction_temp_id,mol.lot_number,mol.revision
4112: FROM mtl_txn_request_lines mol, mtl_material_transactions_temp mmtt
4113: WHERE mol.lpn_id = p_lpn_id
4114: AND mol.inventory_item_id = p_inventory_item_id
4115: AND mol.line_id = mmtt.move_order_line_id(+)
4116: AND mol.organization_id = p_organization_id

Line 4134: FROM mtl_material_transactions_temp mmtt , mtl_txn_request_lines mol

4130:
4131: CURSOR c_doc_detail IS
4132: SELECT mol.inspection_status,mmtt.operation_plan_id,mmtt.transaction_source_type_id,
4133: NVL(mmtt.primary_quantity, wms_task_dispatch_gen.get_primary_quantity(mol.inventory_item_id,mol.organization_id,(mol.quantity - Nvl(mol.quantity_delivered,0)),mol.uom_code)) quantity
4134: FROM mtl_material_transactions_temp mmtt , mtl_txn_request_lines mol
4135: WHERE mmtt.transaction_temp_id = p_source_task_id
4136: AND mol.line_status <> 5 -- bug 4179991
4137: AND mmtt.move_order_line_id = mol.line_id;
4138:

Line 4604: FROM mtl_material_transactions_temp

4600:
4601:
4602: SELECT primary_quantity
4603: INTO l_mmtt_pri_qty
4604: FROM mtl_material_transactions_temp
4605: WHERE transaction_temp_id = p_source_task_id;
4606:
4607: --code for the bug 11879482
4608:

Line 4617: WHERE wip_entity_id = (SELECT demand_source_header_id FROM mtl_material_transactions_temp WHERE transaction_temp_id = p_source_task_id ) ;

4613:
4614:
4615:
4616: SELECT quantity_issued,required_quantity INTO l_issued_qty,l_required_qty FROM wip_requirement_operations
4617: WHERE wip_entity_id = (SELECT demand_source_header_id FROM mtl_material_transactions_temp WHERE transaction_temp_id = p_source_task_id ) ;
4618:
4619: EXCEPTION
4620:
4621: WHEN no_data_found THEN

Line 4703: FROM mtl_material_transactions_temp

4699: IF (p_activity_type_id=G_OP_ACTIVITY_INBOUND) THEN
4700:
4701: SELECT primary_quantity
4702: INTO l_mmtt_pri_qty
4703: FROM mtl_material_transactions_temp
4704: WHERE transaction_temp_id = l_src_taskid_tab(j);
4705:
4706: END IF;
4707:

Line 5009: FROM mtl_material_transactions_temp

5005: , organization_id
5006: , move_order_line_id
5007: , secondary_transaction_quantity -- 9037915
5008: , secondary_uom_code -- 9037915
5009: FROM mtl_material_transactions_temp
5010: WHERE transaction_temp_id=v_task_id;
5011:
5012:
5013: CURSOR c_item_details(v_inventory_item_id NUMBER,v_organization_id NUMBER) IS

Line 5365: UPDATE mtl_material_transactions_temp

5361: print_debug('Secondary transaction quantity: '||l_inbound_doc_child_rec.secondary_transaction_quantity,l_module_name,9);
5362: END IF;
5363: --end of debug messages as part of 13431255
5364:
5365: UPDATE mtl_material_transactions_temp
5366: SET transaction_quantity = l_inbound_doc_parent_rec.transaction_quantity,
5367: primary_quantity = l_inbound_doc_child_rec.primary_quantity,
5368: secondary_transaction_quantity = l_inbound_doc_child_rec.secondary_transaction_quantity, --13431255
5369: last_update_date = SYSDATE

Line 5637: UPDATE mtl_material_transactions_temp

5633: l_progress := 120;
5634:
5635: l_inbound_doc_child_split_rec.parent_line_id := l_inbound_doc_parent_split_rec.transaction_temp_id;
5636: --call MMTT table handlers to update the new child task record
5637: UPDATE mtl_material_transactions_temp
5638: SET parent_line_id = l_inbound_doc_parent_split_rec.transaction_temp_id
5639: WHERE transaction_temp_id = l_inbound_doc_child_split_rec.transaction_temp_id;
5640: l_progress := 140;
5641:

Line 6470: FROM mtl_material_transactions_temp

6466: CURSOR c_inbound_document_details IS
6467: SELECT transaction_temp_id,
6468: operation_plan_id,
6469: organization_id
6470: FROM mtl_material_transactions_temp
6471: WHERE transaction_temp_id=p_source_task_id;
6472:
6473: l_inbound_doc_rec c_inbound_document_details%ROWTYPE;
6474:

Line 6938: FROM MTL_MATERIAL_TRANSACTIONS_TEMP

6934: CURSOR c_inbound_doc IS
6935: SELECT operation_plan_id,
6936: transaction_temp_id,
6937: parent_line_id
6938: FROM MTL_MATERIAL_TRANSACTIONS_TEMP
6939: WHERE transaction_temp_id = p_source_task_id;
6940:
6941: CURSOR c_operation_instance IS
6942: SELECT operation_instance_id,

Line 7388: FROM MTL_MATERIAL_TRANSACTIONS_TEMP

7384: locator_id,
7385: organization_id,
7386: inventory_item_id,
7387: primary_quantity
7388: FROM MTL_MATERIAL_TRANSACTIONS_TEMP
7389: WHERE transaction_temp_id = p_source_task_id;
7390:
7391: CURSOR c_operation_instance IS
7392: SELECT operation_instance_id,

Line 7420: l_document_rec mtl_material_transactions_temp%ROWTYPE;

7416: l_plan_inst_status NUMBER := -1;
7417: l_wooi_update_rec WMS_OP_OPERATION_INSTANCES%ROWTYPE:=NULL;
7418: l_wopi_update_rec WMS_OP_PLAN_INSTANCES%ROWTYPE:=NULL;
7419: l_parent_source_task_id NUMBER;
7420: l_document_rec mtl_material_transactions_temp%ROWTYPE;
7421:
7422:
7423:
7424: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

Line 7737: UPDATE MTL_MATERIAL_TRANSACTIONS_TEMP

7733: print_debug('l_inbound_doc.transfer_to_location = '|| l_inbound_doc.transfer_to_location,l_module_name,9);
7734: END IF;
7735:
7736: IF l_inbound_doc.locator_id IS NULL THEN
7737: UPDATE MTL_MATERIAL_TRANSACTIONS_TEMP
7738: SET operation_plan_id = NULL ,
7739: parent_line_id = NULL,
7740: subinventory_code = l_plan_orig_dest_sub,
7741: locator_id = l_plan_orig_dest_loc_id

Line 7744: UPDATE MTL_MATERIAL_TRANSACTIONS_TEMP

7740: subinventory_code = l_plan_orig_dest_sub,
7741: locator_id = l_plan_orig_dest_loc_id
7742: WHERE transaction_temp_id = p_source_task_id;
7743: ELSIF l_inbound_doc.transfer_to_location IS NULL THEN
7744: UPDATE MTL_MATERIAL_TRANSACTIONS_TEMP
7745: SET operation_plan_id = NULL ,
7746: parent_line_id = NULL,
7747: transfer_subinventory = l_plan_orig_dest_sub,
7748: transfer_to_location = l_plan_orig_dest_loc_id

Line 7976: FROM mtl_material_transactions_temp

7972: WHERE transaction_temp_id = p_source_task_id;
7973:
7974: CURSOR c_inbound_document_details IS
7975: SELECT operation_plan_id
7976: FROM mtl_material_transactions_temp
7977: WHERE transaction_temp_id = p_source_task_id;
7978:
7979:
7980: CURSOR c_operation_instances IS

Line 8562: FROM mtl_material_transactions_temp mmtt

8558: l_plan_id NUMBER := -1;
8559:
8560: CURSOR source_plan IS
8561: SELECT mmtt.operation_plan_id
8562: FROM mtl_material_transactions_temp mmtt
8563: WHERE mmtt.transaction_temp_id = p_source_task_id;
8564:
8565: CURSOR plan_status IS
8566: SELECT wopi.status