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

Line 181: FROM mtl_material_transactions_temp

177: , lot_number
178: , lot_expiration_date
179: , serial_number
180: , transfer_to_location
181: FROM mtl_material_transactions_temp
182: WHERE move_order_line_id = p_line_id;
183:
184: CURSOR serial_number_csr IS
185: SELECT fm_serial_number, to_serial_number

Line 197: FROM mtl_material_transactions_temp

193:
194: --Bug 6696594
195: Cursor c_mmtt(p_move_order_line_id NUMBER)
196: IS SELECT transaction_temp_id
197: FROM mtl_material_transactions_temp
198: WHERE move_order_line_id = p_move_order_line_id;
199:
200: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
201:

Line 341: AND NOT EXISTS (SELECT 1 FROM mtl_material_transactions_temp /6120769Added NOT EXISTS condition/

337: IF (l_detail_rec_count <= 0 AND l_auto_pick_flag = 'N') THEN
338: UPDATE mtl_txn_request_lines
339: SET line_status = 5
340: WHERE line_id = l_trolin_tbl(1).line_id
341: AND NOT EXISTS (SELECT 1 FROM mtl_material_transactions_temp /*6120769Added NOT EXISTS condition*/
342: WHERE move_order_line_id = l_trolin_tbl(1).line_id
343: AND rownum<2 );
344: COMMIT;
345: END IF;

Line 515: FROM mtl_material_transactions_temp mmtt, wms_user_task_type_attributes wutta

511: l_counter := 1;
512: FOR b in l_transaction_id.first..l_transaction_id.last
513: LOOP
514: /*SELECT wutta. honor_case_pick_flag into honor_case_pick
515: FROM mtl_material_transactions_temp mmtt, wms_user_task_type_attributes wutta
516: WHERE mmtt.standard_operation_id = wutta.user_task_type_id
517: AND mmtt.organization_id = wutta.organization_id
518: AND mmtt.transaction_temp_id = l_transaction_id(b);*/
519:

Line 521: FROM mtl_material_transactions_temp mmtt, wms_user_task_type_attributes wutta

517: AND mmtt.organization_id = wutta.organization_id
518: AND mmtt.transaction_temp_id = l_transaction_id(b);*/
519:
520: SELECT count (*) into l_honor_case_pick_count
521: FROM mtl_material_transactions_temp mmtt, wms_user_task_type_attributes wutta
522: WHERE mmtt.standard_operation_id = wutta.user_task_type_id
523: AND mmtt.organization_id = wutta.organization_id
524: AND mmtt.transaction_temp_id = l_transaction_id(b)
525: AND honor_case_pick_flag = 'Y';

Line 609: -- into the mtl_material_transactions_temp table

605:
606: IF (p_move_order_type <> 3 OR (p_move_order_type = 3 AND l_auto_pick_flag = 'N')) THEN
607: l_num_of_rows := 0;
608: -- insert the records INV_AUTODETAIL.detail_row returns
609: -- into the mtl_material_transactions_temp table
610: --
611: -- Added Bug 3633141
612: -- Considering the Delivered Quantity for the move order line.
613: --

Line 666: UPDATE mtl_material_transactions_temp

662: l_detailed_qty2 := l_detailed_qty2 + ABS(l_transaction_quantity2);
663:
664: IF l_transaction_quantity < 0 THEN
665: -- HW INVCONV - Added qty2
666: UPDATE mtl_material_transactions_temp
667: SET transaction_quantity = ABS(transaction_quantity)
668: , primary_quantity = ABS(primary_quantity)
669: , secondary_transaction_quantity = ABS(secondary_transaction_quantity)
670: WHERE transaction_temp_id = l_transaction_temp_id;

Line 682: Update MTL_MATERIAL_TRANSACTIONS_TEMP

678: IF (l_debug = 1) THEN
679: print_debug('Updating distribution_account_id and ship_to_location_id in MMTT');
680: END IF;
681:
682: Update MTL_MATERIAL_TRANSACTIONS_TEMP
683: SET distribution_account_id = l_trolin_tbl(1).to_account_id,
684: ship_to_location = Nvl(l_trolin_tbl(1).ship_to_location_id, ship_to_location)
685: WHERE move_order_line_id = l_trolin_tbl(1).line_id;
686:

Line 780: FROM mtl_material_transactions_temp

776: SELECT transaction_type_id
777: , transaction_action_id
778: INTO l_transaction_type_id
779: , l_transaction_action_id
780: FROM mtl_material_transactions_temp
781: WHERE transaction_temp_id = p_transaction_temp_id;
782:
783:
784:

Line 798: FROM mtl_material_transactions_temp

794: fnd_profile.get('CSE_PA_EXP_TYPE', l_expenditure_type);
795:
796: SELECT organization_id
797: INTO l_organization_id
798: FROM mtl_material_transactions_temp
799: WHERE transaction_temp_id = p_transaction_temp_id;
800:
801: IF (l_transaction_action_id = 1) THEN
802: --fnd_message.debug('copying project_id and task_id from tolines_blk to mtl_Trx_line');

Line 810: FROM mtl_material_transactions_temp

806: INTO l_project_id
807: , l_task_id
808: FROM mtl_txn_request_lines
809: WHERE line_id = (SELECT move_order_line_id
810: FROM mtl_material_transactions_temp
811: WHERE transaction_temp_id = p_transaction_temp_id);
812: END IF;
813:
814: UPDATE mtl_material_transactions_temp

Line 814: UPDATE mtl_material_transactions_temp

810: FROM mtl_material_transactions_temp
811: WHERE transaction_temp_id = p_transaction_temp_id);
812: END IF;
813:
814: UPDATE mtl_material_transactions_temp
815: SET source_project_id = l_project_id
816: , source_task_id = l_task_id
817: , pa_expenditure_org_id = l_organization_id
818: , expenditure_type = l_expenditure_type

Line 1029: from mtl_material_transactions_temp

1025: , p_line_id => p_move_order_line_id
1026: , p_line_detail_id => p_transaction_temp_id);
1027:
1028: /* select count(1) into l_count
1029: from mtl_material_transactions_temp
1030: where move_order_line_id = p_move_order_line_id;
1031:
1032: --inv_debug.message('count = ' || l_count);
1033: */

Line 1083: DELETE mtl_material_transactions_temp

1079:
1080: DELETE mtl_transaction_lots_temp
1081: WHERE group_header_id = p_trx_header_id;
1082:
1083: DELETE mtl_material_transactions_temp
1084: WHERE transaction_header_id = p_trx_header_id;
1085: EXCEPTION
1086: WHEN NO_DATA_FOUND THEN
1087: NULL;

Line 1134: FROM mtl_material_transactions_temp

1130: print_debug('lot count: ' || l_lot_count);
1131:
1132: SELECT transaction_header_id
1133: INTO l_transaction_header_id
1134: FROM mtl_material_transactions_temp
1135: WHERE transaction_temp_id = p_trx_tmp_id;
1136:
1137: --inv_debug.message('ssia', 'l_transaction_header_id is '||l_transaction_header_id);
1138: IF (l_lot_count > 0) THEN

Line 1284: FROM mtl_material_transactions_temp

1280:
1281: --inv_debug.message('after insert row '|| l_return_status );
1282: SELECT COUNT(*)
1283: INTO l_count
1284: FROM mtl_material_transactions_temp
1285: WHERE move_order_line_id = l_mmtt_rec.move_order_line_id;
1286:
1287: --inv_debug.message(' total record = ' || l_count ||' for move order line id ' || l_mmtt_rec.move_order_line_id);
1288: IF (l_return_status = fnd_api.g_ret_sts_error) THEN

Line 1853: FROM mtl_material_transactions_temp

1849: END;
1850:
1851: SELECT NVL(SUM(ABS(transaction_quantity)), 0)
1852: INTO l_allocation_quantity
1853: FROM mtl_material_transactions_temp
1854: WHERE move_order_line_id <> p_line_id
1855: AND inventory_item_id = l_inventory_item_id
1856: AND transaction_action_id = 28
1857: AND trx_source_line_id = l_txn_source_line_id;

Line 1955: FROM mtl_txn_request_headers mtrh, mtl_txn_request_lines mtrl, mtl_material_transactions_temp mmtt

1951: SELECT mmtt.organization_id
1952: , mtrh.move_order_type
1953: INTO l_org_id
1954: , l_move_order_type
1955: FROM mtl_txn_request_headers mtrh, mtl_txn_request_lines mtrl, mtl_material_transactions_temp mmtt
1956: WHERE mmtt.move_order_line_id = mtrl.line_id
1957: AND mtrl.header_id = mtrh.header_id
1958: AND mmtt.transaction_temp_id = p_transaction_temp_id;
1959:

Line 2046: FROM mtl_material_transactions_temp

2042: , move_order_line_id
2043: INTO l_trx_source_line_id
2044: , l_this_alloc
2045: , l_mo_line_id
2046: FROM mtl_material_transactions_temp
2047: WHERE transaction_temp_id = l_transaction_temp_id;
2048:
2049: IF (l_debug = 1) THEN
2050: print_debug('OVPK: l_trx_source_line_id = ' || l_trx_source_line_id);

Line 2058: FROM mtl_material_transactions_temp

2054:
2055: -- Get the sum of all allocations for that trx_source_line_id
2056: SELECT SUM(transaction_quantity)
2057: INTO l_all_alloc
2058: FROM mtl_material_transactions_temp
2059: WHERE trx_source_line_id = l_trx_source_line_id;
2060:
2061: -- The difference will be l_other_alloc
2062: l_other_alloc := l_all_alloc - l_this_alloc;

Line 2214: l_alloc_lpn_id mtl_material_transactions_temp.allocated_lpn_id%TYPE;

2210: l_rqoh NUMBER;
2211: l_qr NUMBER;
2212: l_qs NUMBER;
2213: l_atr NUMBER;
2214: l_alloc_lpn_id mtl_material_transactions_temp.allocated_lpn_id%TYPE;
2215: --l_txn_qty NUMBER;
2216: --For DB log
2217: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
2218: BEGIN

Line 2233: FROM mtl_material_transactions_temp

2229: INTO l_org_id
2230: , l_this_alloc
2231: , l_mo_line_id
2232: , l_alloc_lpn_id
2233: FROM mtl_material_transactions_temp
2234: WHERE transaction_temp_id = p_transaction_temp_id;
2235:
2236: IF (l_debug = 1) THEN
2237: print_debug('OVPK: Entered check_overpick with the following params');

Line 2572: FROM mtl_material_transactions_temp

2568: , move_order_line_id
2569: INTO l_org_id
2570: , l_this_alloc
2571: , l_mo_line_id
2572: FROM mtl_material_transactions_temp
2573: WHERE transaction_temp_id = p_transaction_temp_id;
2574:
2575:
2576: IF (l_debug = 1) THEN

Line 2837: FROM mtl_txn_request_headers mtrh, mtl_txn_request_lines mtrl, mtl_material_transactions_temp mmtt

2833: SELECT mmtt.organization_id
2834: , mtrh.move_order_type
2835: INTO l_org_id
2836: , l_move_order_type
2837: FROM mtl_txn_request_headers mtrh, mtl_txn_request_lines mtrl, mtl_material_transactions_temp mmtt
2838: WHERE mmtt.move_order_line_id = mtrl.line_id
2839: AND mtrl.header_id = mtrh.header_id
2840: AND mmtt.transaction_temp_id = p_transaction_temp_id;
2841:

Line 2929: FROM mtl_material_transactions_temp

2925: , move_order_line_id
2926: INTO l_trx_source_line_id
2927: , l_this_alloc
2928: , l_mo_line_id
2929: FROM mtl_material_transactions_temp
2930: WHERE transaction_temp_id = l_transaction_temp_id;
2931:
2932: IF (l_debug = 1) THEN
2933: print_debug('OVPK: l_trx_source_line_id = ' || l_trx_source_line_id);

Line 2941: FROM mtl_material_transactions_temp

2937:
2938: -- Get the sum of all allocations for that trx_source_line_id
2939: SELECT SUM(transaction_quantity)
2940: INTO l_all_alloc
2941: FROM mtl_material_transactions_temp
2942: WHERE trx_source_line_id = l_trx_source_line_id;
2943:
2944: -- The difference will be l_other_alloc
2945: l_other_alloc := l_all_alloc - l_this_alloc;

Line 3116: FROM mtl_material_transactions_temp

3112: , move_order_line_id
3113: INTO l_org_id
3114: , l_this_alloc
3115: , l_mo_line_id
3116: FROM mtl_material_transactions_temp
3117: WHERE transaction_temp_id = p_transaction_temp_id;
3118:
3119: IF (l_debug = 1) THEN
3120: print_debug('OVPK: Entered check_overpick with the following params');