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

Line 17: UPDATE mtl_material_transactions_temp

13: -- Procedure Update_Row
14:
15: PROCEDURE update_row(x_return_status OUT NOCOPY VARCHAR2, p_mo_line_detail_rec IN g_mmtt_rec) IS
16: BEGIN
17: UPDATE mtl_material_transactions_temp
18: SET transaction_header_id = p_mo_line_detail_rec.transaction_header_id
19: , source_code = p_mo_line_detail_rec.source_code
20: , source_line_id = p_mo_line_detail_rec.source_line_id
21: , transaction_mode = p_mo_line_detail_rec.transaction_mode

Line 212: INSERT INTO mtl_material_transactions_temp

208: PROCEDURE insert_row(x_return_status OUT NOCOPY VARCHAR2, p_mo_line_detail_rec IN g_mmtt_rec) IS
209: BEGIN
210: x_return_status := fnd_api.g_ret_sts_success;
211:
212: INSERT INTO mtl_material_transactions_temp
213: (
214: transaction_header_id
215: , transaction_temp_id
216: , source_code

Line 606: DELETE FROM mtl_material_transactions_temp

602:
603: -- Procedure Delete_Row
604: PROCEDURE delete_row(x_return_status OUT NOCOPY VARCHAR2, p_line_id IN NUMBER, p_line_detail_id IN NUMBER) IS
605: BEGIN
606: DELETE FROM mtl_material_transactions_temp
607: WHERE move_order_line_id = p_line_id
608: AND transaction_temp_id = p_line_detail_id;
609:
610: x_return_status := fnd_api.g_ret_sts_success;

Line 1014: FROM mtl_material_transactions_temp

1010: , l_mmtt_rec.pick_slip_date
1011: , l_mmtt_rec.content_lpn_id
1012: , l_mmtt_rec.secondary_transaction_quantity -- INVCONV change
1013: , l_mmtt_rec.secondary_uom_code -- INVCONV change
1014: FROM mtl_material_transactions_temp
1015: WHERE move_order_line_id = p_mo_line_detail_rec.move_order_line_id
1016: FOR UPDATE NOWAIT;
1017:
1018: -- Row locked. Compare IN attributes to DB attributes.

Line 1458: FROM mtl_material_transactions_temp

1454: , pick_slip_date
1455: , content_lpn_id
1456: , secondary_transaction_quantity -- INVCONV change
1457: , secondary_uom_code -- INVCONV change
1458: FROM mtl_material_transactions_temp
1459: WHERE move_order_line_id = p_line_id;
1460:
1461: CURSOR l_mmtt_csr_temp IS
1462: SELECT transaction_header_id

Line 1654: FROM mtl_material_transactions_temp

1650: , pick_slip_date
1651: , content_lpn_id
1652: , secondary_transaction_quantity -- INVCONV change
1653: , secondary_uom_code -- INVCONV change
1654: FROM mtl_material_transactions_temp
1655: WHERE transaction_temp_id = p_line_detail_id;
1656:
1657: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
1658: BEGIN

Line 2137: || ' from mtl_material_transactions_temp '

2133: l_del_mtlt LONG
2134: := 'DELETE mtl_transaction_lots_temp '
2135: || 'WHERE transaction_temp_id in '
2136: || '(select transaction_temp_id '
2137: || ' from mtl_material_transactions_temp '
2138: || ' where move_order_line_id = :b_move_order_line_id) ';
2139: l_del_mmtt LONG
2140: := 'DELETE mtl_material_transactions_temp ' || ' where move_order_line_id = :b_move_order_line_id ';
2141: l_current_table VARCHAR2(30);

Line 2140: := 'DELETE mtl_material_transactions_temp ' || ' where move_order_line_id = :b_move_order_line_id ';

2136: || '(select transaction_temp_id '
2137: || ' from mtl_material_transactions_temp '
2138: || ' where move_order_line_id = :b_move_order_line_id) ';
2139: l_del_mmtt LONG
2140: := 'DELETE mtl_material_transactions_temp ' || ' where move_order_line_id = :b_move_order_line_id ';
2141: l_current_table VARCHAR2(30);
2142: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
2143: BEGIN
2144: SAVEPOINT update_qty;

Line 2273: l_current_table := 'MTL_MATERIAL_TRANSACTIONS_TEMP';

2269:
2270: IF l_lot_control_code = 1
2271: AND l_serial_control_code IN(1, 6) THEN
2272: -- No control item
2273: l_current_table := 'MTL_MATERIAL_TRANSACTIONS_TEMP';
2274:
2275: SELECT ROWID
2276: , transaction_temp_id
2277: , transaction_quantity

Line 2285: FROM mtl_material_transactions_temp

2281: , l_transaction_temp_id
2282: , l_mmtt_transaction_quantity
2283: , l_mmtt_primary_quantity
2284: , l_mmtt_sec_transaction_qty
2285: FROM mtl_material_transactions_temp
2286: WHERE organization_id = p_mold_table(i).organization_id
2287: AND subinventory_code = p_mold_table(i).subinventory_code
2288: AND NVL(locator_id, -1) = NVL(p_mold_table(i).locator_id, -1)
2289: AND inventory_item_id = p_mold_table(i).inventory_item_id

Line 2311: UPDATE mtl_material_transactions_temp

2307: + p_mold_table(i).secondary_transaction_quantity;
2308: END IF;
2309:
2310: IF l_mmtt_transaction_quantity > p_mold_table(i).transaction_quantity THEN
2311: UPDATE mtl_material_transactions_temp
2312: SET transaction_quantity = p_mold_table(i).transaction_quantity
2313: , secondary_transaction_quantity = p_mold_table(i).secondary_transaction_quantity
2314: , primary_quantity = l_primary_quantity
2315: WHERE ROWID = l_mmtt_rowid;

Line 2324: l_current_table := 'MTL_MATERIAL_TRANSACTIONS_TEMP';

2320: END IF;
2321: ELSIF l_lot_control_code = 2
2322: AND l_serial_control_code IN(1, 6) THEN
2323: -- Lot controlled item
2324: l_current_table := 'MTL_MATERIAL_TRANSACTIONS_TEMP';
2325:
2326: SELECT ROWID
2327: , transaction_temp_id
2328: , transaction_quantity

Line 2334: FROM mtl_material_transactions_temp

2330: INTO l_mmtt_rowid
2331: , l_transaction_temp_id
2332: , l_mmtt_transaction_quantity
2333: , l_mmtt_sec_transaction_qty
2334: FROM mtl_material_transactions_temp
2335: WHERE organization_id = p_mold_table(i).organization_id
2336: AND subinventory_code = p_mold_table(i).subinventory_code
2337: AND NVL(locator_id, -1) = NVL(p_mold_table(i).locator_id, -1)
2338: AND inventory_item_id = p_mold_table(i).inventory_item_id

Line 2383: UPDATE mtl_material_transactions_temp

2379: -- Put the processed MTLT line rowid in the table
2380: l_mtlt_table(l_mtlt_table_counter) := l_mtlt_rowid;
2381: l_mtlt_table_counter := l_mtlt_table_counter + 1;
2382:
2383: UPDATE mtl_material_transactions_temp
2384: SET transaction_quantity = l_mmtt_table(l_transaction_temp_id).picked_transaction_quantity
2385: , secondary_transaction_quantity = l_mmtt_table(l_transaction_temp_id).picked_sec_transaction_qty
2386: , primary_quantity = l_mmtt_table(l_transaction_temp_id).picked_primary_quantity
2387: WHERE ROWID = l_mmtt_rowid;

Line 2493: FROM mtl_material_transactions_temp

2489: , p_transaction_temp_id IN NUMBER
2490: ) IS
2491: CURSOR c_mmtt_info IS
2492: SELECT transaction_temp_id
2493: FROM mtl_material_transactions_temp
2494: WHERE (p_mo_line_id IS NOT NULL AND move_order_line_id = p_mo_line_id)
2495: AND (p_transaction_temp_id IS NULL)
2496: UNION ALL
2497: SELECT transaction_temp_id

Line 2498: FROM mtl_material_transactions_temp

2494: WHERE (p_mo_line_id IS NOT NULL AND move_order_line_id = p_mo_line_id)
2495: AND (p_transaction_temp_id IS NULL)
2496: UNION ALL
2497: SELECT transaction_temp_id
2498: FROM mtl_material_transactions_temp
2499: WHERE (p_transaction_temp_id IS NOT NULL AND transaction_temp_id = p_transaction_temp_id);
2500: BEGIN
2501: x_return_status := fnd_api.g_ret_sts_success;
2502: IF p_mo_line_id IS NULL AND p_transaction_temp_id IS NULL THEN

Line 2575: FROM mtl_material_transactions_temp

2571: , inventory_item_id
2572: , item_primary_uom_code
2573: , transaction_uom
2574: , secondary_uom_code --INVCONV
2575: FROM mtl_material_transactions_temp
2576: WHERE transaction_temp_id = p_transaction_temp_id
2577: FOR UPDATE;
2578:
2579: CURSOR c_primary_uom IS

Line 2740: UPDATE mtl_material_transactions_temp

2736: IF l_new_prim_quantity = -99999 THEN
2737: RAISE fnd_api.g_exc_error;
2738: END IF;
2739:
2740: UPDATE mtl_material_transactions_temp
2741: SET transaction_quantity = l_new_quantity
2742: , primary_quantity = l_new_prim_quantity
2743: WHERE transaction_temp_id = p_transaction_temp_id;
2744:

Line 2857: FROM mtl_system_items_b msi, mtl_material_transactions_temp mmtt

2853: , mmtt.primary_quantity primary_quantity
2854: , mmtt.lot_number
2855: , mmtt.lot_expiration_date
2856: , mmtt.transaction_date
2857: FROM mtl_system_items_b msi, mtl_material_transactions_temp mmtt
2858: WHERE msi.inventory_item_id = mmtt.inventory_item_id
2859: AND msi.organization_id = mmtt.organization_id
2860: AND mmtt.transaction_temp_id = c_transaction_temp_id;
2861:

Line 3024: FROM mtl_material_transactions_temp mmtt

3020: l_procedure_name VARCHAR2(30) := 'IS_LINE_DETAILED';
3021:
3022: CURSOR mmtt_records IS
3023: SELECT mmtt.transaction_temp_id
3024: FROM mtl_material_transactions_temp mmtt
3025: WHERE mmtt.move_order_line_id = p_move_order_line_id;
3026:
3027: l_return_status VARCHAR2(1);
3028: l_msg_count NUMBER;