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.WMS_TXNRSN_ACTIONS_PUB dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 130: FROM mtl_material_transactions_temp

126: SELECT inventory_item_id, locator_id,subinventory_code,revision,lot_number,
127: move_order_line_id, reservation_id, transaction_quantity,transaction_header_id
128: INTO l_item_id,l_locator_id, l_sub_code,l_revision,l_lot,
129: l_line_num, l_reservation_id,l_transaction_quantity,l_mmtt_header_id
130: FROM mtl_material_transactions_temp
131: WHERE transaction_temp_id=l_mmtt_id;
132: IF (l_debug = 1) THEN
133: mdebug('l_transaction_quantity: '|| l_transaction_quantity);
134: END IF;

Line 183: UPDATE mtl_material_transactions_temp

179: IF (l_debug = 1) THEN
180: mdebug('l_qty_diff_prim: '||l_qty_diff_prim);
181: mdebug('before update mmtt');
182: END IF;
183: UPDATE mtl_material_transactions_temp
184: SET primary_quantity = primary_quantity - l_qty_diff_txn,
185: transaction_quantity = l_transaction_quantity - l_qty_diff_prim
186: where transaction_temp_id=l_mmtt_id;
187:

Line 512: FROM mtl_material_transactions_temp

508: standard_operation_id,
509: transaction_temp_id,
510: operation_plan_id,
511: move_order_line_id
512: FROM mtl_material_transactions_temp
513: WHERE move_order_line_id=l_line_num
514: AND transaction_temp_id <> l_mmtt_id;
515:
516: CURSOR get_mtlt_c(p_temp_id NUMBER) IS

Line 641: FROM mtl_material_transactions_temp

637: ,l_secondary_quantity --bug 8197499
638: ,l_sec_uom_code --bug 8197499
639: ,l_parent_line_id --bug 8460179
640: ,l_fulfillment_base
641: FROM mtl_material_transactions_temp
642: WHERE transaction_temp_id = l_mmtt_id;
643:
644: mdebug('l_primary_uom :'|| l_primary_uom);
645: mdebug('primary_qty :'|| l_primary_qty);

Line 861: UPDATE mtl_material_transactions_temp

857:
858: /* Bug 7504490 - Commented out the check for l_do_update_mmtt. The MMTT has to be
859: updated to 0 quantity for the quantity tree to fetch correct quantity to reserve */
860:
861: UPDATE mtl_material_transactions_temp
862: SET primary_quantity = 0
863: ,transaction_quantity = 0
864: ,secondary_transaction_quantity = DECODE(secondary_uom_code,NULL,NULL,0)
865: WHERE transaction_temp_id IN (l_mmtt_id ,l_parent_line_id) --8460179 , added l_parent_line_id

Line 1509: FROM mtl_material_transactions_temp

1505: mdebug('l_quantity_detailed:'||l_old_quantity_detailed);
1506:
1507: SELECT COUNT(*)
1508: INTO l_old_mmtt_cnt
1509: FROM mtl_material_transactions_temp
1510: WHERE move_order_line_id = l_line_num;
1511:
1512: --mdebug('before update mol, the quantity_detailed :' || l_old_quantity_detailed);
1513: mdebug('before update mol, the number of mmtt rows :' || l_old_mmtt_cnt);

Line 1847: UPDATE mtl_material_transactions_temp

1843: -- along with manually allocated MO will populate
1844: -- the distribution_account_id of MMTT.
1845:
1846: IF l_to_account_id is not null THEN
1847: UPDATE mtl_material_transactions_temp
1848: SET distribution_account_id = l_to_account_id
1849: WHERE move_order_line_id = l_line_num;
1850: END IF;
1851:

Line 1860: FROM mtl_material_transactions_temp

1856: IF (inv_control.g_current_release_level < inv_release.g_j_release_level)
1857: THEN
1858: SELECT sum(transaction_quantity)
1859: INTO l_new_mmtt_qty
1860: FROM mtl_material_transactions_temp
1861: WHERE move_order_line_id = l_line_num;
1862:
1863: UPDATE mtl_txn_request_lines
1864: SET quantity = nvl(l_new_mmtt_qty,0) + l_quantity_delivered ,

Line 1981: from mtl_material_transactions_temp

1977: select transaction_type_id, transaction_action_id, transaction_source_type_id,
1978: subinventory_code, locator_id
1979: into l_txn_typ_id, l_txn_action_id, l_txn_src_type_id,
1980: l_sub_code, l_loc_id
1981: from mtl_material_transactions_temp
1982: where transaction_temp_id = p_mmtt_id;
1983:
1984: mdebug('l_txn_typ_id = '||l_txn_typ_id);
1985: mdebug('l_txn_action_id = '||l_txn_action_id);

Line 2059: UPDATE mtl_material_transactions_temp

2055: IF (l_debug = 1) THEN
2056: mdebug('p_is_loc_desc is True, updating MMTT header'||p_mmtt_id||' with reason id '||p_reason_id);
2057: END IF;
2058:
2059: UPDATE mtl_material_transactions_temp
2060: SET reason_id = p_reason_id
2061: WHERE transaction_header_id = p_mmtt_id;
2062: END IF;
2063:

Line 2120: FROM mtl_material_transactions_temp mmtt

2116:
2117:
2118: CURSOR rem_mmtt_csr IS
2119: SELECT mmtt.transaction_temp_id
2120: FROM mtl_material_transactions_temp mmtt
2121: WHERE mmtt.organization_id = l_org_id
2122: AND mmtt.inventory_item_id = l_item_id
2123: AND mmtt.subinventory_code = l_sub
2124: AND mmtt.locator_id = l_loc

Line 2156: from mtl_material_transactions_temp

2152: -- get the sub and loc where we picked the material from
2153: /* Bug 7504490 - Adding revision and allocated_lpn_id to the query */
2154: select organization_id,inventory_item_id,subinventory_code,locator_id,revision,allocated_lpn_id
2155: into l_org_id,l_item_id,l_sub,l_loc,l_revision,l_allocated_lpn_id
2156: from mtl_material_transactions_temp
2157: where transaction_temp_id = p_temp_id;
2158:
2159: IF (l_debug = 1) THEN
2160: mdebug('cleanup_task (w) : Calling for the other mmtts');

Line 2327: FROM mtl_material_transactions_temp mmtt

2323: , mmtt.item_primary_uom_code
2324: , mmtt.secondary_transaction_quantity
2325: , mmtt.secondary_uom_code
2326: , mmtt.fulfillment_base
2327: FROM mtl_material_transactions_temp mmtt
2328: WHERE mmtt.transaction_temp_id = p_temp_id
2329: AND NOT EXISTS(SELECT 1
2330: FROM mtl_material_transactions_temp t1
2331: WHERE t1.parent_line_id = mmtt.transaction_temp_id)

Line 2330: FROM mtl_material_transactions_temp t1

2326: , mmtt.fulfillment_base
2327: FROM mtl_material_transactions_temp mmtt
2328: WHERE mmtt.transaction_temp_id = p_temp_id
2329: AND NOT EXISTS(SELECT 1
2330: FROM mtl_material_transactions_temp t1
2331: WHERE t1.parent_line_id = mmtt.transaction_temp_id)
2332: UNION ALL
2333: SELECT mmtt.transaction_header_id
2334: , mmtt.transaction_temp_id

Line 2350: FROM mtl_material_transactions_temp mmtt

2346: , mmtt.item_primary_uom_code
2347: , mmtt.secondary_transaction_quantity
2348: , mmtt.secondary_uom_code
2349: , mmtt.fulfillment_base
2350: FROM mtl_material_transactions_temp mmtt
2351: WHERE mmtt.parent_line_id = p_temp_id
2352: AND mmtt.parent_line_id <> mmtt.transaction_temp_id;
2353: -- This union by will end up getting all PARENTS too ***** mrana
2354:

Line 2372: FROM mtl_material_transactions_temp mmtt

2368: AND mtrh.header_id = mtrl.header_id;
2369:
2370: CURSOR c_get_other_mmtt IS
2371: SELECT COUNT(*)
2372: FROM mtl_material_transactions_temp mmtt
2373: WHERE mmtt.move_order_line_id = l_mo_line_id
2374: AND mmtt.transaction_temp_id <> l_txn_temp_id
2375: AND NOT EXISTS(SELECT 1
2376: FROM mtl_material_transactions_temp t1

Line 2376: FROM mtl_material_transactions_temp t1

2372: FROM mtl_material_transactions_temp mmtt
2373: WHERE mmtt.move_order_line_id = l_mo_line_id
2374: AND mmtt.transaction_temp_id <> l_txn_temp_id
2375: AND NOT EXISTS(SELECT 1
2376: FROM mtl_material_transactions_temp t1
2377: WHERE t1.parent_line_id = mmtt.transaction_temp_id);
2378:
2379: BEGIN
2380: x_return_status := fnd_api.g_ret_sts_success;

Line 2628: FROM mtl_material_transactions_temp mmtt , mtl_reservations mr

2624: ,l_sec_rsv_qty
2625: ,l_sec_rsv_uom
2626: ,l_rsv_lot_num
2627: ,l_rsv_org_id
2628: FROM mtl_material_transactions_temp mmtt , mtl_reservations mr
2629: WHERE mmtt.transaction_temp_id = l_txn_temp_id
2630: AND mr.reservation_id = mmtt.reservation_id ;
2631:
2632: IF (l_debug = 1) THEN