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

189: , item_primary_uom_code
190: , secondary_uom_code
191: , nvl(fulfillment_base, 'P')
192: , organization_id
193: FROM mtl_material_transactions_temp
194: WHERE move_order_line_id = p_line_id;
195:
196: CURSOR serial_number_csr IS
197: SELECT fm_serial_number, to_serial_number

Line 209: FROM mtl_material_transactions_temp

205:
206: --Bug 6696594
207: Cursor c_mmtt(p_move_order_line_id NUMBER)
208: IS SELECT transaction_temp_id
209: FROM mtl_material_transactions_temp
210: WHERE move_order_line_id = p_move_order_line_id;
211:
212: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
213:

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

368: IF (l_detail_rec_count <= 0 AND l_auto_pick_flag = 'N') THEN
369: UPDATE mtl_txn_request_lines
370: SET line_status = 5
371: WHERE line_id = l_trolin_tbl(1).line_id
372: AND NOT EXISTS (SELECT 1 FROM mtl_material_transactions_temp /*6120769Added NOT EXISTS condition*/
373: WHERE move_order_line_id = l_trolin_tbl(1).line_id
374: AND rownum<2 );
375:
376: IF (p_commit) THEN -- Bug8566005: Made the commit conditional

Line 400: UPDATE MTL_MATERIAL_TRANSACTIONS_TEMP

396: print_debug('number of mold record is ' || l_mold_tbl.COUNT);
397: print_debug('calling pick confirm');
398: END IF;
399: IF (p_transaction_date IS NOT NULL) THEN
400: UPDATE MTL_MATERIAL_TRANSACTIONS_TEMP
401: SET transaction_date = p_transaction_date
402: , acct_period_id = p_period_id
403: WHERE move_order_line_id = p_line_id;
404: print_debug('in update');

Line 558: FROM mtl_material_transactions_temp mmtt, wms_user_task_type_attributes wutta

554: l_counter := 1;
555: FOR b in l_transaction_id.first..l_transaction_id.last
556: LOOP
557: /*SELECT wutta. honor_case_pick_flag into honor_case_pick
558: FROM mtl_material_transactions_temp mmtt, wms_user_task_type_attributes wutta
559: WHERE mmtt.standard_operation_id = wutta.user_task_type_id
560: AND mmtt.organization_id = wutta.organization_id
561: AND mmtt.transaction_temp_id = l_transaction_id(b);*/
562:

Line 564: FROM mtl_material_transactions_temp mmtt, wms_user_task_type_attributes wutta

560: AND mmtt.organization_id = wutta.organization_id
561: AND mmtt.transaction_temp_id = l_transaction_id(b);*/
562:
563: SELECT count (*) into l_honor_case_pick_count
564: FROM mtl_material_transactions_temp mmtt, wms_user_task_type_attributes wutta
565: WHERE mmtt.standard_operation_id = wutta.user_task_type_id
566: AND mmtt.organization_id = wutta.organization_id
567: AND mmtt.transaction_temp_id = l_transaction_id(b)
568: AND honor_case_pick_flag = 'Y';

Line 652: -- into the mtl_material_transactions_temp table

648:
649: IF (p_move_order_type <> 3 OR (p_move_order_type = 3 AND l_auto_pick_flag = 'N')) THEN
650: l_num_of_rows := 0;
651: -- insert the records INV_AUTODETAIL.detail_row returns
652: -- into the mtl_material_transactions_temp table
653: --
654: -- Added Bug 3633141
655: -- Considering the Delivered Quantity for the move order line.
656: --

Line 793: UPDATE mtl_material_transactions_temp

789: l_detailed_qty2 := l_detailed_qty2 + ABS(l_transaction_quantity2);
790:
791: IF l_transaction_quantity < 0 THEN
792: -- HW INVCONV - Added qty2
793: UPDATE mtl_material_transactions_temp
794: SET transaction_quantity = ABS(transaction_quantity)
795: , primary_quantity = ABS(primary_quantity)
796: , secondary_transaction_quantity = ABS(secondary_transaction_quantity)
797: WHERE transaction_temp_id = l_transaction_temp_id;

Line 809: Update MTL_MATERIAL_TRANSACTIONS_TEMP

805: IF (l_debug = 1) THEN
806: print_debug('Updating distribution_account_id and ship_to_location_id in MMTT');
807: END IF;
808:
809: Update MTL_MATERIAL_TRANSACTIONS_TEMP
810: SET distribution_account_id = l_trolin_tbl(1).to_account_id,
811: ship_to_location = Nvl(l_trolin_tbl(1).ship_to_location_id, ship_to_location)
812: WHERE move_order_line_id = l_trolin_tbl(1).line_id;
813:

Line 907: FROM mtl_material_transactions_temp

903: SELECT transaction_type_id
904: , transaction_action_id
905: INTO l_transaction_type_id
906: , l_transaction_action_id
907: FROM mtl_material_transactions_temp
908: WHERE transaction_temp_id = p_transaction_temp_id;
909:
910:
911:

Line 925: FROM mtl_material_transactions_temp

921: fnd_profile.get('CSE_PA_EXP_TYPE', l_expenditure_type);
922:
923: SELECT organization_id
924: INTO l_organization_id
925: FROM mtl_material_transactions_temp
926: WHERE transaction_temp_id = p_transaction_temp_id;
927:
928: IF (l_transaction_action_id = 1) THEN
929: --fnd_message.debug('copying project_id and task_id from tolines_blk to mtl_Trx_line');

Line 937: FROM mtl_material_transactions_temp

933: INTO l_project_id
934: , l_task_id
935: FROM mtl_txn_request_lines
936: WHERE line_id = (SELECT move_order_line_id
937: FROM mtl_material_transactions_temp
938: WHERE transaction_temp_id = p_transaction_temp_id);
939: END IF;
940:
941: UPDATE mtl_material_transactions_temp

Line 941: UPDATE mtl_material_transactions_temp

937: FROM mtl_material_transactions_temp
938: WHERE transaction_temp_id = p_transaction_temp_id);
939: END IF;
940:
941: UPDATE mtl_material_transactions_temp
942: SET source_project_id = l_project_id
943: , source_task_id = l_task_id
944: , pa_expenditure_org_id = l_organization_id
945: , expenditure_type = l_expenditure_type

Line 1161: from mtl_material_transactions_temp

1157: , p_line_id => p_move_order_line_id
1158: , p_line_detail_id => p_transaction_temp_id);
1159:
1160: /* select count(1) into l_count
1161: from mtl_material_transactions_temp
1162: where move_order_line_id = p_move_order_line_id;
1163:
1164: --inv_debug.message('count = ' || l_count);
1165: */

Line 1215: DELETE mtl_material_transactions_temp

1211:
1212: DELETE mtl_transaction_lots_temp
1213: WHERE group_header_id = p_trx_header_id;
1214:
1215: DELETE mtl_material_transactions_temp
1216: WHERE transaction_header_id = p_trx_header_id;
1217: EXCEPTION
1218: WHEN NO_DATA_FOUND THEN
1219: NULL;

Line 1266: FROM mtl_material_transactions_temp

1262: print_debug('lot count: ' || l_lot_count);
1263:
1264: SELECT transaction_header_id
1265: INTO l_transaction_header_id
1266: FROM mtl_material_transactions_temp
1267: WHERE transaction_temp_id = p_trx_tmp_id;
1268:
1269: --inv_debug.message('ssia', 'l_transaction_header_id is '||l_transaction_header_id);
1270: IF (l_lot_count > 0) THEN

Line 1416: FROM mtl_material_transactions_temp

1412:
1413: --inv_debug.message('after insert row '|| l_return_status );
1414: SELECT COUNT(*)
1415: INTO l_count
1416: FROM mtl_material_transactions_temp
1417: WHERE move_order_line_id = l_mmtt_rec.move_order_line_id;
1418:
1419: --inv_debug.message(' total record = ' || l_count ||' for move order line id ' || l_mmtt_rec.move_order_line_id);
1420: IF (l_return_status = fnd_api.g_ret_sts_error) THEN

Line 2046: FROM mtl_material_transactions_temp

2042: END;
2043:
2044: SELECT NVL(SUM(ABS(transaction_quantity)), 0), NVL(SUM(ABS(secondary_transaction_quantity)), 0)
2045: INTO l_allocation_quantity , l_allocation_quantity2
2046: FROM mtl_material_transactions_temp
2047: WHERE move_order_line_id <> p_line_id
2048: AND inventory_item_id = l_inventory_item_id
2049: AND transaction_action_id = 28
2050: AND trx_source_line_id = l_txn_source_line_id;

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

2177: SELECT mmtt.organization_id
2178: , mtrh.move_order_type
2179: INTO l_org_id
2180: , l_move_order_type
2181: FROM mtl_txn_request_headers mtrh, mtl_txn_request_lines mtrl, mtl_material_transactions_temp mmtt
2182: WHERE mmtt.move_order_line_id = mtrl.line_id
2183: AND mtrl.header_id = mtrh.header_id
2184: AND mmtt.transaction_temp_id = p_transaction_temp_id;
2185:

Line 2275: FROM mtl_material_transactions_temp

2271: INTO l_trx_source_line_id
2272: , l_this_alloc
2273: , l_mo_line_id
2274: , l_this_alloc2
2275: FROM mtl_material_transactions_temp
2276: WHERE transaction_temp_id = l_transaction_temp_id;
2277:
2278: IF (l_debug = 1) THEN
2279: print_debug('OVPK: l_trx_source_line_id = ' || l_trx_source_line_id);

Line 2288: FROM mtl_material_transactions_temp

2284:
2285: -- Get the sum of all allocations for that trx_source_line_id
2286: SELECT SUM(transaction_quantity) , sum(secondary_transaction_quantity)
2287: INTO l_all_alloc , l_all_alloc2
2288: FROM mtl_material_transactions_temp
2289: WHERE trx_source_line_id = l_trx_source_line_id;
2290:
2291: -- The difference will be l_other_alloc
2292: l_other_alloc := l_all_alloc - l_this_alloc;

Line 2458: l_alloc_lpn_id mtl_material_transactions_temp.allocated_lpn_id%TYPE;

2454: l_rqoh NUMBER;
2455: l_qr NUMBER;
2456: l_qs NUMBER;
2457: l_atr NUMBER;
2458: l_alloc_lpn_id mtl_material_transactions_temp.allocated_lpn_id%TYPE;
2459: --l_txn_qty NUMBER;
2460: --For DB log
2461: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
2462:

Line 2463: l_fulfill_base mtl_material_transactions_temp.fulfillment_base%TYPE;

2459: --l_txn_qty NUMBER;
2460: --For DB log
2461: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
2462:
2463: l_fulfill_base mtl_material_transactions_temp.fulfillment_base%TYPE;
2464: l_source_line_id number;
2465: l_txn_source_type_id NUMBER;
2466: BEGIN
2467: x_return_status := fnd_api.g_ret_sts_success;

Line 2489: FROM mtl_material_transactions_temp

2485: , l_this_alloc2
2486: , l_source_line_id
2487: , l_txn_source_type_id
2488: , l_fulfill_base
2489: FROM mtl_material_transactions_temp
2490: WHERE transaction_temp_id = p_transaction_temp_id;
2491:
2492: IF (l_debug = 1) THEN
2493: print_debug('OVPK: Entered check_overpick with the following params');

Line 2850: FROM mtl_material_transactions_temp

2846: , move_order_line_id
2847: INTO l_org_id
2848: , l_this_alloc
2849: , l_mo_line_id
2850: FROM mtl_material_transactions_temp
2851: WHERE transaction_temp_id = p_transaction_temp_id;
2852:
2853:
2854: IF (l_debug = 1) THEN

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

3187: SELECT mmtt.organization_id
3188: , mtrh.move_order_type
3189: INTO l_org_id
3190: , l_move_order_type
3191: FROM mtl_txn_request_headers mtrh, mtl_txn_request_lines mtrl, mtl_material_transactions_temp mmtt
3192: WHERE mmtt.move_order_line_id = mtrl.line_id
3193: AND mtrl.header_id = mtrh.header_id
3194: AND mmtt.transaction_temp_id = p_transaction_temp_id;
3195:

Line 3285: FROM mtl_material_transactions_temp

3281: INTO l_trx_source_line_id
3282: , l_this_alloc
3283: , l_mo_line_id
3284: , l_this_alloc2
3285: FROM mtl_material_transactions_temp
3286: WHERE transaction_temp_id = l_transaction_temp_id;
3287:
3288: IF (l_debug = 1) THEN
3289: print_debug('OVPK: l_trx_source_line_id = ' || l_trx_source_line_id);

Line 3298: FROM mtl_material_transactions_temp

3294:
3295: -- Get the sum of all allocations for that trx_source_line_id
3296: SELECT SUM(transaction_quantity), SUM(SECONDARY_TRANSACTION_QUANTITY)
3297: INTO l_all_alloc, l_all_alloc2
3298: FROM mtl_material_transactions_temp
3299: WHERE trx_source_line_id = l_trx_source_line_id;
3300:
3301: -- The difference will be l_other_alloc
3302: l_other_alloc := l_all_alloc - l_this_alloc;

Line 3529: l_fulfill_base mtl_material_transactions_temp.fulfillment_base%TYPE;

3525: l_atr NUMBER;
3526: --For DB log
3527: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
3528: --MUOM Fulfillemnt Project
3529: l_fulfill_base mtl_material_transactions_temp.fulfillment_base%TYPE;
3530:
3531: BEGIN
3532: x_return_status := fnd_api.g_ret_sts_success;
3533: x_check_overpick_passed := 'N';

Line 3547: FROM mtl_material_transactions_temp

3543: , l_this_alloc
3544: , l_mo_line_id
3545: , l_this_alloc2
3546: , l_fulfill_base
3547: FROM mtl_material_transactions_temp
3548: WHERE transaction_temp_id = p_transaction_temp_id;
3549:
3550: IF (l_debug = 1) THEN
3551: print_debug('OVPK: Entered check_overpick with the following params');