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

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

Line 2133: FROM mtl_material_transactions_temp

2129: l_debug number;
2130:
2131: CURSOR cur_mmtt IS
2132: SELECT reservation_id, transaction_quantity, primary_quantity
2133: FROM mtl_material_transactions_temp
2134: WHERE move_order_line_id = p_line_id;
2135:
2136: l_original_reservation_rec inv_reservation_global.mtl_reservation_rec_type;
2137: l_new_reservation_rec inv_reservation_global.mtl_reservation_rec_type;

Line 2167: UPDATE mtl_material_transactions_temp

2163: UPDATE mtl_txn_request_lines
2164: SET txn_source_line_id = p_new_source_line_id
2165: WHERE line_id = p_line_id;
2166:
2167: UPDATE mtl_material_transactions_temp
2168: SET trx_source_line_id = p_new_source_line_id
2169: WHERE move_order_line_id = p_line_id;
2170:
2171: /* Rolling back changes made for bug 2919186.

Line 2656: FROM mtl_material_transactions_temp mmtt

2652: mmtt.transaction_uom,
2653: ABS(primary_quantity),
2654: NVL(ABS(secondary_transaction_quantity), 0),
2655: secondary_uom_code
2656: FROM mtl_material_transactions_temp mmtt
2657: WHERE move_order_line_id = p_mo_line_id;
2658:
2659: l_curr_mmtt_txn_uom VARCHAR2(3) ; -- Bug5950172
2660: l_curr_mmtt_txn_qty NUMBER; -- Bug5950172

Line 3031: FROM mtl_material_transactions_temp

3027: , NVL(SUM(ABS(secondary_transaction_quantity)), 0)
3028: INTO l_pending_quantity
3029: , l_primary_pending_quantity
3030: , l_sec_pending_quantity
3031: FROM mtl_material_transactions_temp
3032: WHERE move_order_line_id = l_trolin_rec.line_id; */
3033:
3034: IF (l_debug = 1) THEN
3035: DEBUG('Pending Quantity from MMTT: '|| l_pending_quantity, 'Finalize_Pick_Confirm');

Line 3216: FROM mtl_material_transactions_temp

3212: SELECT NVL(SUM(ABS(primary_quantity)), 0)
3213: , NVL(SUM(ABS(secondary_transaction_quantity)), 0)
3214: INTO l_rsv_primary_quantity
3215: , l_sec_rsv_quantity
3216: FROM mtl_material_transactions_temp
3217: WHERE reservation_id = l_mmtt_rec.reservation_id;
3218:
3219: IF g_rsv_picked_quantity_tbl.EXISTS(l_mmtt_rec.reservation_id) THEN
3220: l_rsv_primary_quantity := l_rsv_primary_quantity - g_rsv_picked_quantity_tbl(l_mmtt_rec.reservation_id).picked_quantity;

Line 3345: FROM mtl_material_transactions_temp

3341: BEGIN
3342: --
3343: SELECT COUNT(*)
3344: INTO l_other_mmtt_rec
3345: FROM mtl_material_transactions_temp
3346: WHERE move_order_line_id = l_trolin_rec.line_id
3347: AND transaction_temp_id <> l_mmtt_rec.transaction_temp_id;
3348: --
3349: EXCEPTION

Line 4371: UPDATE MTL_MATERIAL_TRANSACTIONS_TEMP

4367: IF NVL(l_lot_divisible_flag,'Y') = 'N' THEN
4368: --for indivisible item,clear qty tree before creating reservations.
4369: inv_quantity_tree_pvt.clear_quantity_cache;
4370:
4371: UPDATE MTL_MATERIAL_TRANSACTIONS_TEMP
4372: SET POSTING_FLAG = 'N'
4373: WHERE inventory_item_id = l_mmtt_rec.inventory_item_id
4374: AND organization_id = l_mmtt_rec.organization_id
4375: AND transaction_source_id= l_mmtt_rec.transaction_source_id

Line 4420: UPDATE MTL_MATERIAL_TRANSACTIONS_TEMP

4416:
4417: --Bug 13961830 start,for indivisible item,update posting_flag back to Y
4418: IF NVL(l_lot_divisible_flag,'Y') = 'N' THEN
4419: --update flag back to Y
4420: UPDATE MTL_MATERIAL_TRANSACTIONS_TEMP
4421: SET POSTING_FLAG = 'Y'
4422: WHERE inventory_item_id = l_mmtt_rec.inventory_item_id
4423: AND organization_id = l_mmtt_rec.organization_id
4424: AND transaction_source_id= l_mmtt_rec.transaction_source_id

Line 4867: FROM mtl_material_transactions_temp mmtt,

4863: BEGIN
4864: SELECT WMS_CATCH_WEIGHT_PVT.G_PRICE_PRIMARY INTO l_catch_weight_enabled FROM DUAL
4865: WHERE EXISTS (
4866: SELECT 1
4867: FROM mtl_material_transactions_temp mmtt,
4868: mtl_transaction_lots_temp mtlt
4869: WHERE mmtt.organization_id = l_mmtt_rec.organization_id
4870: AND mmtt.inventory_item_id = l_mmtt_rec.inventory_item_id
4871: 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 5351: FROM mtl_material_transactions_temp mmtt,

5347: BEGIN
5348: SELECT WMS_CATCH_WEIGHT_PVT.G_PRICE_PRIMARY INTO l_catch_weight_enabled FROM DUAL
5349: WHERE EXISTS (
5350: SELECT 1
5351: FROM mtl_material_transactions_temp mmtt,
5352: mtl_transaction_lots_temp mtlt
5353: WHERE mmtt.organization_id = l_mmtt_rec.organization_id
5354: AND mmtt.inventory_item_id = l_mmtt_rec.inventory_item_id
5355: AND NVL(mmtt.revision, '@') = NVL(l_mmtt_rec.revision, '@')

Line 5467: FROM mtl_material_transactions_temp mmtt

5463: BEGIN
5464: SELECT WMS_CATCH_WEIGHT_PVT.G_PRICE_PRIMARY INTO l_catch_weight_enabled FROM DUAL
5465: WHERE EXISTS (
5466: SELECT 1
5467: FROM mtl_material_transactions_temp mmtt
5468: WHERE mmtt.organization_id = l_mmtt_rec.organization_id
5469: AND mmtt.inventory_item_id = l_mmtt_rec.inventory_item_id
5470: AND NVL(mmtt.revision, '@') = NVL(l_mmtt_rec.revision, '@')
5471: AND mmtt.transaction_source_type_id = INV_GLOBALS.G_SourceType_SalesOrder

Line 5611: FROM mtl_material_transactions_temp

5607: SELECT NVL(SUM(ABS(primary_quantity)), 0)
5608: , NVL(SUM(ABS(secondary_transaction_quantity)), 0)
5609: INTO l_mmtt_rsv_quantity
5610: , l_sec_mmtt_rsv_quantity
5611: FROM mtl_material_transactions_temp
5612: WHERE reservation_id = l_reservation_id;
5613:
5614: -- need to subtract from the mmtt rsv quantity the
5615: -- quantity of the reservations that have already been

Line 6522: FROM mtl_material_transactions_temp

6518: SELECT NVL(SUM(ABS(primary_quantity)), 0)
6519: , NVL(SUM(ABS(secondary_transaction_quantity)), 0)
6520: INTO l_mmtt_rsv_quantity
6521: , l_sec_mmtt_rsv_quantity
6522: FROM mtl_material_transactions_temp
6523: WHERE reservation_id = l_reservation_id;
6524:
6525: -- L.G. Logic might need to be put here is reservations are not used but
6526: -- user manually allocated the line, which the mmtt still may have the reservation_id as null

Line 6627: FROM mtl_material_transactions_temp a

6623: -- Bug 5059984, Adding cursor c_rep_mo_mmtt.
6624:
6625: CURSOR c_rep_mo_mmtt IS
6626: SELECT DISTINCT move_order_line_id
6627: FROM mtl_material_transactions_temp a
6628: WHERE transaction_header_id = p_transaction_header_id
6629: AND transaction_source_type_id = 4
6630: AND transaction_action_id = 2
6631: AND move_order_line_id IS NOT NULL

Line 6635: FROM mtl_material_transactions_temp b

6631: AND move_order_line_id IS NOT NULL
6632: AND nvl(transaction_status, 1) <> 2
6633: AND process_flag = 'Y'
6634: AND NOT EXISTS ( SELECT 1
6635: FROM mtl_material_transactions_temp b
6636: WHERE b.move_order_line_id = a.move_order_line_id
6637: AND (nvl(transaction_status,1) = 2 OR error_code IS NOT NULL));
6638:
6639: CURSOR c_mo_lines IS

Line 6641: FROM mtl_material_transactions_temp a

6637: AND (nvl(transaction_status,1) = 2 OR error_code IS NOT NULL));
6638:
6639: CURSOR c_mo_lines IS
6640: SELECT DISTINCT move_order_line_id
6641: FROM mtl_material_transactions_temp a
6642: WHERE transaction_header_id = p_transaction_header_id
6643: AND move_order_line_id IS NOT NULL
6644: AND nvl(transaction_status,1) <> 2
6645: AND process_flag = 'Y'

Line 6647: FROM mtl_material_transactions_temp b

6643: AND move_order_line_id IS NOT NULL
6644: AND nvl(transaction_status,1) <> 2
6645: AND process_flag = 'Y'
6646: AND NOT EXISTS ( SELECT 1
6647: FROM mtl_material_transactions_temp b
6648: WHERE b.move_order_line_id = a.move_order_line_id
6649: AND (nvl(transaction_status,1) = 2 OR error_code IS NOT NULL));
6650:
6651: CURSOR c_mo_type (p_mo_line_id NUMBER) IS

Line 6813: FROM mtl_Serial_numbers_temp a, mtl_material_transactions_temp b

6809: ,a.FM_SERIAL_NUMBER
6810: ,a.TO_SERIAL_NUMBER
6811: ,b.organization_id
6812: ,b.inventory_item_id
6813: FROM mtl_Serial_numbers_temp a, mtl_material_transactions_temp b
6814: where a.transaction_temp_id= p_transaction_temp_id
6815: and a.transaction_temp_id = b.transaction_temp_id;
6816:
6817: l_Serial_cursor serial_cursor%ROWTYPE;