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

2557: transaction_quantity,
2558: lpn_id,
2559: content_lpn_id,
2560: transfer_lpn_id
2561: FROM mtl_material_transactions_temp
2562: WHERE transaction_temp_id=p_source_task_id;
2563:
2564: l_inbound_doc_rec c_inbound_document_details%ROWTYPE;
2565: l_mmtt_rec mtl_material_transactions_temp%ROWTYPE;

Line 2565: l_mmtt_rec mtl_material_transactions_temp%ROWTYPE;

2561: FROM mtl_material_transactions_temp
2562: WHERE transaction_temp_id=p_source_task_id;
2563:
2564: l_inbound_doc_rec c_inbound_document_details%ROWTYPE;
2565: l_mmtt_rec mtl_material_transactions_temp%ROWTYPE;
2566:
2567: -- cursor to get the current active operation instance
2568: -- for the source task
2569:

Line 4050: FROM mtl_txn_request_lines mol, mtl_material_transactions_temp mmtt

4046: CURSOR mol_details IS
4047: SELECT mol.inspection_status,
4048: 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,
4049: mmtt.operation_plan_id,mmtt.transaction_temp_id,mol.lpn_id,mol.inventory_item_id
4050: FROM mtl_txn_request_lines mol, mtl_material_transactions_temp mmtt
4051: WHERE mol.line_id = mmtt.move_order_line_id(+)
4052: AND mol.line_id = p_move_order_line_id
4053: AND mol.organization_id = p_organization_id
4054: AND mol.organization_id = mmtt.organization_id(+)

Line 4060: FROM mtl_txn_request_lines mol, mtl_material_transactions_temp mmtt

4056: GROUP BY mol.inspection_status,mmtt.operation_plan_id,mmtt.transaction_temp_id, mol.lpn_id, mol.inventory_item_id;
4057:
4058: CURSOR lpn_details IS
4059: SELECT mol.inspection_status,mmtt.operation_plan_id,mmtt.transaction_temp_id
4060: FROM mtl_txn_request_lines mol, mtl_material_transactions_temp mmtt
4061: WHERE mol.line_id = mmtt.move_order_line_id(+)
4062: AND mol.lpn_id = p_lpn_id
4063: AND mol.organization_id = p_organization_id
4064: AND mol.line_status <> 5 -- bug 4179991

Line 4072: FROM mtl_txn_request_lines mol, mtl_material_transactions_temp mmtt

4068: SELECT mol.inspection_status,
4069: SUM(NVL(mmtt.primary_quantity,
4070: 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,
4071: mol.lpn_id,mmtt.operation_plan_id,mmtt.transaction_temp_id,mol.lot_number,mol.revision
4072: FROM mtl_txn_request_lines mol, mtl_material_transactions_temp mmtt
4073: WHERE mol.lpn_id = p_lpn_id
4074: AND mol.inventory_item_id = p_inventory_item_id
4075: AND mol.line_id = mmtt.move_order_line_id(+)
4076: AND mol.organization_id = p_organization_id

Line 4094: FROM mtl_material_transactions_temp mmtt , mtl_txn_request_lines mol

4090:
4091: CURSOR c_doc_detail IS
4092: SELECT mol.inspection_status,mmtt.operation_plan_id,
4093: 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
4094: FROM mtl_material_transactions_temp mmtt , mtl_txn_request_lines mol
4095: WHERE mmtt.transaction_temp_id = p_source_task_id
4096: AND mol.line_status <> 5 -- bug 4179991
4097: AND mmtt.move_order_line_id = mol.line_id;
4098:

Line 4593: FROM mtl_material_transactions_temp

4589: IF (p_activity_type_id=G_OP_ACTIVITY_INBOUND) THEN
4590:
4591: SELECT primary_quantity
4592: INTO l_mmtt_pri_qty
4593: FROM mtl_material_transactions_temp
4594: WHERE transaction_temp_id = l_src_taskid_tab(j);
4595:
4596: END IF;
4597:

Line 4897: FROM mtl_material_transactions_temp

4893: , transaction_temp_id
4894: , inventory_item_id
4895: , organization_id
4896: , move_order_line_id
4897: FROM mtl_material_transactions_temp
4898: WHERE transaction_temp_id=v_task_id;
4899:
4900:
4901: CURSOR c_item_details(v_inventory_item_id NUMBER,v_organization_id NUMBER) IS

Line 5245: UPDATE mtl_material_transactions_temp

5241:
5242: l_progress := 40;
5243: --call MMTT table handler to update records in the table
5244:
5245: UPDATE mtl_material_transactions_temp
5246: SET transaction_quantity = l_inbound_doc_parent_rec.transaction_quantity,
5247: primary_quantity = l_inbound_doc_child_rec.primary_quantity,
5248: last_update_date = SYSDATE
5249: WHERE transaction_temp_id = l_inbound_doc_parent_rec.transaction_temp_id;

Line 5512: UPDATE mtl_material_transactions_temp

5508: l_progress := 120;
5509:
5510: l_inbound_doc_child_split_rec.parent_line_id := l_inbound_doc_parent_split_rec.transaction_temp_id;
5511: --call MMTT table handlers to update the new child task record
5512: UPDATE mtl_material_transactions_temp
5513: SET parent_line_id = l_inbound_doc_parent_split_rec.transaction_temp_id
5514: WHERE transaction_temp_id = l_inbound_doc_child_split_rec.transaction_temp_id;
5515: l_progress := 140;
5516:

Line 6340: FROM mtl_material_transactions_temp

6336: CURSOR c_inbound_document_details IS
6337: SELECT transaction_temp_id,
6338: operation_plan_id,
6339: organization_id
6340: FROM mtl_material_transactions_temp
6341: WHERE transaction_temp_id=p_source_task_id;
6342:
6343: l_inbound_doc_rec c_inbound_document_details%ROWTYPE;
6344:

Line 6808: FROM MTL_MATERIAL_TRANSACTIONS_TEMP

6804: CURSOR c_inbound_doc IS
6805: SELECT operation_plan_id,
6806: transaction_temp_id,
6807: parent_line_id
6808: FROM MTL_MATERIAL_TRANSACTIONS_TEMP
6809: WHERE transaction_temp_id = p_source_task_id;
6810:
6811: CURSOR c_operation_instance IS
6812: SELECT operation_instance_id,

Line 7258: FROM MTL_MATERIAL_TRANSACTIONS_TEMP

7254: locator_id,
7255: organization_id,
7256: inventory_item_id,
7257: primary_quantity
7258: FROM MTL_MATERIAL_TRANSACTIONS_TEMP
7259: WHERE transaction_temp_id = p_source_task_id;
7260:
7261: CURSOR c_operation_instance IS
7262: SELECT operation_instance_id,

Line 7290: l_document_rec mtl_material_transactions_temp%ROWTYPE;

7286: l_plan_inst_status NUMBER := -1;
7287: l_wooi_update_rec WMS_OP_OPERATION_INSTANCES%ROWTYPE:=NULL;
7288: l_wopi_update_rec WMS_OP_PLAN_INSTANCES%ROWTYPE:=NULL;
7289: l_parent_source_task_id NUMBER;
7290: l_document_rec mtl_material_transactions_temp%ROWTYPE;
7291:
7292:
7293:
7294: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

Line 7607: UPDATE MTL_MATERIAL_TRANSACTIONS_TEMP

7603: print_debug('l_inbound_doc.transfer_to_location = '|| l_inbound_doc.transfer_to_location,l_module_name,9);
7604: END IF;
7605:
7606: IF l_inbound_doc.locator_id IS NULL THEN
7607: UPDATE MTL_MATERIAL_TRANSACTIONS_TEMP
7608: SET operation_plan_id = NULL ,
7609: parent_line_id = NULL,
7610: subinventory_code = l_plan_orig_dest_sub,
7611: locator_id = l_plan_orig_dest_loc_id

Line 7614: UPDATE MTL_MATERIAL_TRANSACTIONS_TEMP

7610: subinventory_code = l_plan_orig_dest_sub,
7611: locator_id = l_plan_orig_dest_loc_id
7612: WHERE transaction_temp_id = p_source_task_id;
7613: ELSIF l_inbound_doc.transfer_to_location IS NULL THEN
7614: UPDATE MTL_MATERIAL_TRANSACTIONS_TEMP
7615: SET operation_plan_id = NULL ,
7616: parent_line_id = NULL,
7617: transfer_subinventory = l_plan_orig_dest_sub,
7618: transfer_to_location = l_plan_orig_dest_loc_id

Line 7846: FROM mtl_material_transactions_temp

7842: WHERE transaction_temp_id = p_source_task_id;
7843:
7844: CURSOR c_inbound_document_details IS
7845: SELECT operation_plan_id
7846: FROM mtl_material_transactions_temp
7847: WHERE transaction_temp_id = p_source_task_id;
7848:
7849:
7850: CURSOR c_operation_instances IS

Line 8432: FROM mtl_material_transactions_temp mmtt

8428: l_plan_id NUMBER := -1;
8429:
8430: CURSOR source_plan IS
8431: SELECT mmtt.operation_plan_id
8432: FROM mtl_material_transactions_temp mmtt
8433: WHERE mmtt.transaction_temp_id = p_source_task_id;
8434:
8435: CURSOR plan_status IS
8436: SELECT wopi.status