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

Line 454: FROM mtl_material_transactions_temp

450: WHERE transaction_temp_id = p_trx_temp_id;
451: ELSIF p_operation = 'UPDATE' THEN -- when cancel qty < sum(mmtt trx qty)
452: SELECT transaction_header_id
453: INTO l_transaction_header_id
454: FROM mtl_material_transactions_temp
455: WHERE transaction_temp_id = p_trx_temp_id;
456:
457: SELECT COUNT(*)
458: INTO l_serial_count

Line 2120: FROM mtl_material_transactions_temp

2116: l_debug number;
2117:
2118: CURSOR cur_mmtt IS
2119: SELECT reservation_id, transaction_quantity, primary_quantity
2120: FROM mtl_material_transactions_temp
2121: WHERE move_order_line_id = p_line_id;
2122:
2123: l_original_reservation_rec inv_reservation_global.mtl_reservation_rec_type;
2124: l_new_reservation_rec inv_reservation_global.mtl_reservation_rec_type;

Line 2154: UPDATE mtl_material_transactions_temp

2150: UPDATE mtl_txn_request_lines
2151: SET txn_source_line_id = p_new_source_line_id
2152: WHERE line_id = p_line_id;
2153:
2154: UPDATE mtl_material_transactions_temp
2155: SET trx_source_line_id = p_new_source_line_id
2156: WHERE move_order_line_id = p_line_id;
2157:
2158: /* Rolling back changes made for bug 2919186.

Line 2628: FROM mtl_material_transactions_temp mmtt

2624:
2625: -- Bug5950172.Added following cursor
2626: CURSOR mmtt_pending_qty_csr ( p_mo_line_id NUMBER) IS
2627: SELECT ABS(transaction_quantity) , mmtt.transaction_uom, ABS(primary_quantity), NVL(ABS(secondary_transaction_quantity), 0)
2628: FROM mtl_material_transactions_temp mmtt
2629: WHERE move_order_line_id = p_mo_line_id;
2630:
2631: l_curr_mmtt_txn_uom VARCHAR2(3) ; -- Bug5950172
2632: l_curr_mmtt_txn_qty NUMBER; -- Bug5950172

Line 2879: FROM mtl_material_transactions_temp

2875: , NVL(SUM(ABS(secondary_transaction_quantity)), 0)
2876: INTO l_pending_quantity
2877: , l_primary_pending_quantity
2878: , l_sec_pending_quantity
2879: FROM mtl_material_transactions_temp
2880: WHERE move_order_line_id = l_trolin_rec.line_id; */
2881:
2882: IF (l_debug = 1) THEN
2883: DEBUG('Pending Quantity from MMTT: '|| l_pending_quantity, 'Finalize_Pick_Confirm');

Line 3003: FROM mtl_material_transactions_temp

2999: SELECT NVL(SUM(ABS(primary_quantity)), 0)
3000: , NVL(SUM(ABS(secondary_transaction_quantity)), 0)
3001: INTO l_rsv_primary_quantity
3002: , l_sec_rsv_quantity
3003: FROM mtl_material_transactions_temp
3004: WHERE reservation_id = l_mmtt_rec.reservation_id;
3005:
3006: IF g_rsv_picked_quantity_tbl.EXISTS(l_mmtt_rec.reservation_id) THEN
3007: l_rsv_primary_quantity

Line 3134: FROM mtl_material_transactions_temp

3130: BEGIN
3131: --
3132: SELECT COUNT(*)
3133: INTO l_other_mmtt_rec
3134: FROM mtl_material_transactions_temp
3135: WHERE move_order_line_id = l_trolin_rec.line_id
3136: AND transaction_temp_id <> l_mmtt_rec.transaction_temp_id;
3137: --
3138: EXCEPTION

Line 4530: FROM mtl_material_transactions_temp mmtt,

4526: BEGIN
4527: SELECT WMS_CATCH_WEIGHT_PVT.G_PRICE_PRIMARY INTO l_catch_weight_enabled FROM DUAL
4528: WHERE EXISTS (
4529: SELECT 1
4530: FROM mtl_material_transactions_temp mmtt,
4531: mtl_transaction_lots_temp mtlt
4532: WHERE mmtt.organization_id = l_mmtt_rec.organization_id
4533: AND mmtt.inventory_item_id = l_mmtt_rec.inventory_item_id
4534: AND NVL(mmtt.revision, '@') = NVL(l_mmtt_rec.revision, '@')

Line 4776: FROM mtl_material_transactions_temp mmtt

4772: BEGIN
4773: SELECT WMS_CATCH_WEIGHT_PVT.G_PRICE_PRIMARY INTO l_catch_weight_enabled FROM DUAL
4774: WHERE EXISTS (
4775: SELECT 1
4776: FROM mtl_material_transactions_temp mmtt
4777: WHERE mmtt.organization_id = l_mmtt_rec.organization_id
4778: AND mmtt.inventory_item_id = l_mmtt_rec.inventory_item_id
4779: AND NVL(mmtt.revision, '@') = NVL(l_mmtt_rec.revision, '@')
4780: AND mmtt.transaction_source_type_id = INV_GLOBALS.G_SourceType_SalesOrder

Line 5007: FROM mtl_material_transactions_temp mmtt,

5003: BEGIN
5004: SELECT WMS_CATCH_WEIGHT_PVT.G_PRICE_PRIMARY INTO l_catch_weight_enabled FROM DUAL
5005: WHERE EXISTS (
5006: SELECT 1
5007: FROM mtl_material_transactions_temp mmtt,
5008: mtl_transaction_lots_temp mtlt
5009: WHERE mmtt.organization_id = l_mmtt_rec.organization_id
5010: AND mmtt.inventory_item_id = l_mmtt_rec.inventory_item_id
5011: AND NVL(mmtt.revision, '@') = NVL(l_mmtt_rec.revision, '@')

Line 5112: FROM mtl_material_transactions_temp mmtt

5108: BEGIN
5109: SELECT WMS_CATCH_WEIGHT_PVT.G_PRICE_PRIMARY INTO l_catch_weight_enabled FROM DUAL
5110: WHERE EXISTS (
5111: SELECT 1
5112: FROM mtl_material_transactions_temp mmtt
5113: WHERE mmtt.organization_id = l_mmtt_rec.organization_id
5114: AND mmtt.inventory_item_id = l_mmtt_rec.inventory_item_id
5115: AND NVL(mmtt.revision, '@') = NVL(l_mmtt_rec.revision, '@')
5116: AND mmtt.transaction_source_type_id = INV_GLOBALS.G_SourceType_SalesOrder

Line 5232: FROM mtl_material_transactions_temp

5228: SELECT NVL(SUM(ABS(primary_quantity)), 0)
5229: , NVL(SUM(ABS(secondary_transaction_quantity)), 0)
5230: INTO l_mmtt_rsv_quantity
5231: , l_sec_mmtt_rsv_quantity
5232: FROM mtl_material_transactions_temp
5233: WHERE reservation_id = l_reservation_id;
5234:
5235: -- need to subtract from the mmtt rsv quantity the
5236: -- quantity of the reservations that have already been

Line 6098: FROM mtl_material_transactions_temp

6094: SELECT NVL(SUM(ABS(primary_quantity)), 0)
6095: , NVL(SUM(ABS(secondary_transaction_quantity)), 0)
6096: INTO l_mmtt_rsv_quantity
6097: , l_sec_mmtt_rsv_quantity
6098: FROM mtl_material_transactions_temp
6099: WHERE reservation_id = l_reservation_id;
6100:
6101: -- L.G. Logic might need to be put here is reservations are not used but
6102: -- user manually allocated the line, which the mmtt still may have the reservation_id as null

Line 6194: FROM mtl_material_transactions_temp a

6190: -- Bug 5059984, Adding cursor c_rep_mo_mmtt.
6191:
6192: CURSOR c_rep_mo_mmtt IS
6193: SELECT DISTINCT move_order_line_id
6194: FROM mtl_material_transactions_temp a
6195: WHERE transaction_header_id = p_transaction_header_id
6196: AND transaction_source_type_id = 4
6197: AND transaction_action_id = 2
6198: AND move_order_line_id IS NOT NULL

Line 6202: FROM mtl_material_transactions_temp b

6198: AND move_order_line_id IS NOT NULL
6199: AND nvl(transaction_status, 1) <> 2
6200: AND process_flag = 'Y'
6201: AND NOT EXISTS ( SELECT 1
6202: FROM mtl_material_transactions_temp b
6203: WHERE b.move_order_line_id = a.move_order_line_id
6204: AND (nvl(transaction_status,1) = 2 OR error_code IS NOT NULL));
6205:
6206: CURSOR c_mo_lines IS

Line 6208: FROM mtl_material_transactions_temp a

6204: AND (nvl(transaction_status,1) = 2 OR error_code IS NOT NULL));
6205:
6206: CURSOR c_mo_lines IS
6207: SELECT DISTINCT move_order_line_id
6208: FROM mtl_material_transactions_temp a
6209: WHERE transaction_header_id = p_transaction_header_id
6210: AND move_order_line_id IS NOT NULL
6211: AND nvl(transaction_status,1) <> 2
6212: AND process_flag = 'Y'

Line 6214: FROM mtl_material_transactions_temp b

6210: AND move_order_line_id IS NOT NULL
6211: AND nvl(transaction_status,1) <> 2
6212: AND process_flag = 'Y'
6213: AND NOT EXISTS ( SELECT 1
6214: FROM mtl_material_transactions_temp b
6215: WHERE b.move_order_line_id = a.move_order_line_id
6216: AND (nvl(transaction_status,1) = 2 OR error_code IS NOT NULL));
6217:
6218: CURSOR c_mo_type (p_mo_line_id NUMBER) IS

Line 6379: FROM mtl_Serial_numbers_temp a, mtl_material_transactions_temp b

6375: ,a.FM_SERIAL_NUMBER
6376: ,a.TO_SERIAL_NUMBER
6377: ,b.organization_id
6378: ,b.inventory_item_id
6379: FROM mtl_Serial_numbers_temp a, mtl_material_transactions_temp b
6380: where a.transaction_temp_id= p_transaction_temp_id
6381: and a.transaction_temp_id = b.transaction_temp_id;
6382:
6383: l_Serial_cursor serial_cursor%ROWTYPE;