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_OP_INBOUND_PVT dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 69: , p_document_rec IN mtl_material_transactions_temp%ROWTYPE

65: , x_msg_count OUT NOCOPY NUMBER
66: , x_source_task_id OUT NOCOPY NUMBER
67: , x_error_code OUT NOCOPY NUMBER
68: , p_source_task_id IN NUMBER
69: , p_document_rec IN mtl_material_transactions_temp%ROWTYPE
70: , p_operation_type_id IN NUMBER
71: , p_revert_loc_capacity IN BOOLEAN DEFAULT FALSE
72: , p_subsequent_op_plan_id IN NUMBER DEFAULT NULL
73: ) IS

Line 315: UPDATE mtl_material_transactions_temp

311:
312: /*Update MMTT record where transaction_temp_ID = P_source_task_ID.
313: Null out move_order_line_ID and lpn_ID.*/
314:
315: UPDATE mtl_material_transactions_temp
316: SET lpn_id = NULL,
317: move_order_line_id = NULL,
318: wms_task_type = l_wms_task_type
319: WHERE transaction_temp_id = p_source_task_id;

Line 507: , p_document_rec IN MTL_MATERIAL_TRANSACTIONS_TEMP%ROWTYPE

503: , x_msg_count OUT NOCOPY NUMBER
504: , x_error_code OUT NOCOPY NUMBER
505: , p_source_task_id IN NUMBER
506: , p_update_param_rec IN DEST_PARAM_REC_TYPE
507: , p_document_rec IN MTL_MATERIAL_TRANSACTIONS_TEMP%ROWTYPE
508: )IS
509:
510: /* CURSOR c_locator_type(v_location_id NUMBER,v_org_id NUMBER) IS
511: SELECT Nvl(inventory_location_type, 3)

Line 525: FROM mtl_material_transactions_temp

521:
522: CURSOR c_orig_sugges(v_txn_temp_id NUMBER) IS
523: SELECT nvl(transfer_subinventory,subinventory_code) subinventory_code
524: ,nvl(transfer_to_location,locator_id) locator_id
525: FROM mtl_material_transactions_temp
526: WHERE transaction_temp_id=v_txn_temp_id;
527:
528: l_sub_type NUMBER := -1;
529: l_orig_sugges c_orig_sugges%ROWTYPE;

Line 601: UPDATE MTL_material_transactions_temp

597: IF (l_debug=1) THEN
598: print_debug('Deliver transaction, update sub/loc.',l_module_name,1);
599: END IF;
600:
601: UPDATE MTL_material_transactions_temp
602: SET subinventory_code = p_update_param_rec.sug_sub_code,
603: locator_id = p_update_param_rec.sug_location_id,
604: cartonization_id = p_update_param_rec.cartonization_id
605: WHERE transaction_temp_id = p_source_task_id

Line 613: UPDATE MTL_material_transactions_temp

609: IF (l_debug=1) THEN
610: print_debug('Transfer transaction, update transfer sub/loc.',l_module_name,1);
611: END IF;
612:
613: UPDATE MTL_material_transactions_temp
614: SET transfer_subinventory = p_update_param_rec.sug_sub_code,
615: transfer_to_location = p_update_param_rec.sug_location_id,
616: cartonization_id = p_update_param_rec.cartonization_id,
617: posting_flag = 'Y' -- 12541422

Line 1008: , p_document_rec IN mtl_material_transactions_temp%ROWTYPE

1004: , x_msg_count OUT NOCOPY NUMBER
1005: , x_source_task_id OUT NOCOPY NUMBER
1006: , x_error_code OUT NOCOPY NUMBER
1007: , p_source_task_id IN NUMBER
1008: , p_document_rec IN mtl_material_transactions_temp%ROWTYPE
1009: , p_operation_type_id IN NUMBER
1010: , p_next_operation_type_id IN NUMBER
1011: , p_sug_to_sub_code IN VARCHAR2 DEFAULT NULL
1012: , p_sug_to_locator_id IN NUMBER DEFAULT NULL

Line 1067: FROM mtl_material_transactions_temp mmtt,

1063: mol.crossdock_type,
1064: mol.backorder_delivery_detail_id,
1065: mmtt.transfer_to_location,
1066: mmtt.locator_id
1067: FROM mtl_material_transactions_temp mmtt,
1068: mtl_secondary_inventories msi,
1069: mtl_txn_request_lines mol
1070: WHERE mmtt.transaction_temp_id = p_source_task_id
1071: AND Nvl(mmtt.transfer_subinventory, mmtt.subinventory_code) = msi.secondary_inventory_name (+)

Line 1492: FROM mtl_material_transactions_temp mmtt

1488: UPDATE mtl_txn_request_lines
1489: SET quantity_detailed = quantity_detailed - l_qty_in_mol_uom,
1490: secondary_quantity_detailed = secondary_quantity_detailed - l_mol_sec_qty, --Bug#7716519
1491: lpn_id =(SELECT Nvl(mmtt.transfer_lpn_id, mmtt.content_lpn_id)
1492: FROM mtl_material_transactions_temp mmtt
1493: WHERE mmtt.transaction_temp_id = p_document_rec.transaction_temp_id),
1494: wms_process_flag = 1 -- Bug 4657716
1495: WHERE line_id = p_document_rec.move_order_line_id;
1496:

Line 1996: update mtl_material_transactions_temp

1992:
1993: END IF;
1994: /* Start 12541422 */
1995: IF l_new_txn_source_type_id = g_sourcetype_moveorder THEN
1996: update mtl_material_transactions_temp
1997: set posting_flag = 'N'
1998: where transaction_temp_id = x_source_task_id;
1999: END IF;
2000: /* End 12541422 */

Line 2308: FROM mtl_material_transactions_temp

2304: transaction_source_type_id,
2305: organization_id,
2306: inventory_item_id,
2307: primary_quantity
2308: FROM mtl_material_transactions_temp
2309: WHERE transaction_temp_id = p_source_task_id;
2310:
2311: l_mmtt_data_rec c_mmtt_data_rec%ROWTYPE;
2312:

Line 2347: FROM mtl_material_transactions_temp

2343: INTO l_mol_lpn_id
2344: FROM mtl_txn_request_lines mol
2345: WHERE mol.line_id =
2346: (SELECT move_order_line_id
2347: FROM mtl_material_transactions_temp
2348: WHERE transaction_temp_id = p_source_task_id);
2349:
2350: l_progress := 34;
2351:

Line 2405: UPDATE mtl_material_transactions_temp

2401: -- If MMTT.operation_plan_ID is null we don't need to cleanup
2402: -- transfer_to_location, transfer_subinventory, and cartonization_id,
2403: -- which were NOT suggested by ATF.
2404:
2405: UPDATE mtl_material_transactions_temp
2406: SET transfer_subinventory = Decode(operation_plan_id, NULL, transfer_subinventory, NULL),
2407: transfer_to_location = Decode(operation_plan_id, NULL, transfer_to_location, NULL),
2408: cartonization_id = Decode(operation_plan_id, NULL, cartonization_id, NULL),
2409: transfer_lpn_id = NULL,

Line 2435: UPDATE mtl_material_transactions_temp

2431: -- If MMTT.operation_plan_ID is null we don't need to cleanup
2432: -- locator_ID, subinventory_code, and cartonization_id,
2433: -- which were NOT suggested by ATF.
2434:
2435: UPDATE mtl_material_transactions_temp
2436: SET subinventory_code = Decode(operation_plan_id, NULL, subinventory_code, NULL),
2437: locator_id = Decode(operation_plan_id, NULL, locator_id, NULL),
2438: cartonization_id = Decode(operation_plan_id, NULL, cartonization_id, NULL),
2439: transfer_lpn_id = NULL,

Line 2597: FROM mtl_material_transactions_temp mmtt,

2593: mmtt.repetitive_line_id,
2594: mmtt.operation_seq_num,
2595: mmtt.primary_quantity,
2596: mmtt.secondary_transaction_quantity --BUG10285949
2597: FROM mtl_material_transactions_temp mmtt,
2598: mtl_txn_request_lines mol
2599: WHERE transaction_temp_id = p_source_task_id
2600: AND mmtt.move_order_line_id = mol.line_id;
2601:

Line 2608: FROM mtl_material_transactions_temp

2604: nvl(transfer_to_location,locator_id) locator_id,
2605: primary_quantity,
2606: organization_id,
2607: inventory_item_id
2608: FROM mtl_material_transactions_temp
2609: WHERE transaction_temp_id=v_txn_temp_id;
2610:
2611:
2612: CURSOR c_wdt_status IS

Line 2847: , mtl_material_transactions_temp mmtt

2843: , wlpn.locator_id
2844: INTO l_subinventory_code
2845: , l_locator_id
2846: FROM wms_license_plate_numbers wlpn
2847: , mtl_material_transactions_temp mmtt
2848: WHERE mmtt.lpn_id = wlpn.lpn_id
2849: AND mmtt.transaction_temp_id = p_source_task_id;
2850: EXCEPTION
2851: WHEN OTHERS THEN

Line 2861: UPDATE mtl_material_transactions_temp mmtt

2857: AND l_locator_id IS NOT NULL THEN
2858: IF l_debug = 1 THEN
2859: print_debug('Updating MMTT:'||l_subinventory_code||':'||l_locator_id,l_module_name,4);
2860: END IF;
2861: UPDATE mtl_material_transactions_temp mmtt
2862: SET (subinventory_code,
2863: locator_id,
2864: error_code,
2865: error_explanation,

Line 3077: , p_document_rec IN mtl_material_transactions_temp%ROWTYPE

3073: (
3074: x_return_status OUT NOCOPY VARCHAR2
3075: , x_msg_data OUT NOCOPY fnd_new_messages.MESSAGE_TEXT%TYPE
3076: , x_msg_count OUT NOCOPY NUMBER
3077: , p_document_rec IN mtl_material_transactions_temp%ROWTYPE
3078: , p_plan_orig_sub_code IN VARCHAR2
3079: , p_plan_orig_loc_id IN NUMBER
3080: , p_for_manual_drop IN BOOLEAN DEFAULT FALSE
3081: )

Line 3213: UPDATE MTL_MATERIAL_TRANSACTIONS_TEMP

3209: END IF;
3210:
3211: IF p_document_rec.locator_id IS NULL THEN
3212:
3213: UPDATE MTL_MATERIAL_TRANSACTIONS_TEMP
3214: SET operation_plan_id = NULL ,
3215: parent_line_id = NULL,
3216: subinventory_code = p_plan_orig_sub_code,
3217: locator_id = p_plan_orig_loc_id

Line 3222: UPDATE MTL_MATERIAL_TRANSACTIONS_TEMP

3218: WHERE transaction_temp_id = p_document_rec.transaction_temp_id;
3219:
3220: ELSIF p_document_rec.transfer_to_location IS NULL THEN
3221:
3222: UPDATE MTL_MATERIAL_TRANSACTIONS_TEMP
3223: SET operation_plan_id = NULL ,
3224: parent_line_id = NULL,
3225: transfer_subinventory = p_plan_orig_sub_code,
3226: transfer_to_location = p_plan_orig_loc_id