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

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

Line 181: UPDATE mtl_material_transactions_temp

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

Line 497: FROM mtl_material_transactions_temp

493: standard_operation_id,
494: transaction_temp_id,
495: operation_plan_id,
496: move_order_line_id
497: FROM mtl_material_transactions_temp
498: WHERE move_order_line_id=l_line_num
499: AND transaction_temp_id <> l_mmtt_id;
500:
501: CURSOR get_mtlt_c(p_temp_id NUMBER) IS

Line 588: FROM mtl_material_transactions_temp

584: ,l_primary_qty
585: ,l_mmtt_transaction_uom
586: ,l_transaction_qty
587: ,l_mso_header_id
588: FROM mtl_material_transactions_temp
589: WHERE transaction_temp_id = l_mmtt_id;
590:
591: mdebug('transaction_uom :'|| l_mmtt_transaction_uom);
592: mdebug('primary_qty :'|| l_primary_qty);

Line 740: /* update mtl_material_transactions_temp

736: WHERE transaction_temp_id = l_mmtt_id;
737: -- transfer reservation is taking care of detailed_quantity in mtl_reservations
738: -- zero the quantity for original mmtt line so pick release is going to work
739:
740: /* update mtl_material_transactions_temp
741: set primary_quantity = 0
742: ,transaction_quantity = 0
743: where transaction_temp_id = l_mmtt_id
744: and organization_id = l_organization_id;

Line 765: UPDATE mtl_material_transactions_temp

761: END;
762:
763:
764: IF NVL(l_do_update_mmtt,'Y') = 'Y' THEN -- Bug : 5886105
765: UPDATE mtl_material_transactions_temp
766: SET primary_quantity = 0
767: ,transaction_quantity = 0
768: WHERE transaction_temp_id = l_mmtt_id
769: AND organization_id = l_organization_id;

Line 1202: from mtl_material_transactions_temp

1198: mdebug('l_quantity_detailed:'||l_old_quantity_detailed);
1199:
1200: select count(*)
1201: into l_old_mmtt_cnt
1202: from mtl_material_transactions_temp
1203: where move_order_line_id = l_line_num;
1204:
1205: --mdebug('before update mol, the quantity_detailed :' || l_old_quantity_detailed);
1206: mdebug('before update mol, the number of mmtt rows :' || l_old_mmtt_cnt);

Line 1371: UPDATE mtl_material_transactions_temp

1367: -- along with manually allocated MO will populate
1368: -- the distribution_account_id of MMTT.
1369:
1370: IF l_to_account_id is not null THEN
1371: UPDATE mtl_material_transactions_temp
1372: SET distribution_account_id = l_to_account_id
1373: WHERE move_order_line_id = l_line_num;
1374: END IF;
1375:

Line 1384: FROM mtl_material_transactions_temp

1380: IF (inv_control.g_current_release_level < inv_release.g_j_release_level)
1381: THEN
1382: SELECT sum(transaction_quantity)
1383: INTO l_new_mmtt_qty
1384: FROM mtl_material_transactions_temp
1385: WHERE move_order_line_id = l_line_num;
1386:
1387: UPDATE mtl_txn_request_lines
1388: SET quantity = nvl(l_new_mmtt_qty,0) + l_quantity_delivered ,

Line 1539: UPDATE mtl_material_transactions_temp

1535: IF (l_debug = 1) THEN
1536: mdebug('p_is_loc_desc is True, updating MMTT header'||p_mmtt_id||' with reason id '||p_reason_id);
1537: END IF;
1538:
1539: UPDATE mtl_material_transactions_temp
1540: SET reason_id = p_reason_id
1541: WHERE transaction_header_id = p_mmtt_id;
1542: END IF;
1543:

Line 1596: FROM mtl_material_transactions_temp mmtt

1592:
1593:
1594: CURSOR rem_mmtt_csr IS
1595: SELECT mmtt.transaction_temp_id
1596: FROM mtl_material_transactions_temp mmtt
1597: WHERE mmtt.organization_id = l_org_id
1598: AND mmtt.inventory_item_id = l_item_id
1599: AND mmtt.subinventory_code = l_sub
1600: AND mmtt.locator_id = l_loc

Line 1626: from mtl_material_transactions_temp

1622:
1623: -- get the sub and loc where we picked the material from
1624: select organization_id,inventory_item_id,subinventory_code,locator_id
1625: into l_org_id,l_item_id,l_sub,l_loc
1626: from mtl_material_transactions_temp
1627: where transaction_temp_id = p_temp_id;
1628:
1629: IF (l_debug = 1) THEN
1630: mdebug('cleanup_task (w) : Calling for the other mmtts');

Line 1781: FROM mtl_material_transactions_temp mmtt

1777: , mmtt.move_order_line_id
1778: , mmtt.transaction_quantity
1779: , mmtt.transaction_uom
1780: , mmtt.primary_quantity
1781: FROM mtl_material_transactions_temp mmtt
1782: WHERE mmtt.transaction_temp_id = p_temp_id
1783: AND NOT EXISTS(SELECT 1
1784: FROM mtl_material_transactions_temp t1
1785: WHERE t1.parent_line_id = mmtt.transaction_temp_id)

Line 1784: FROM mtl_material_transactions_temp t1

1780: , mmtt.primary_quantity
1781: FROM mtl_material_transactions_temp mmtt
1782: WHERE mmtt.transaction_temp_id = p_temp_id
1783: AND NOT EXISTS(SELECT 1
1784: FROM mtl_material_transactions_temp t1
1785: WHERE t1.parent_line_id = mmtt.transaction_temp_id)
1786: UNION ALL
1787: SELECT mmtt.transaction_header_id
1788: , mmtt.transaction_temp_id

Line 1800: FROM mtl_material_transactions_temp mmtt

1796: , mmtt.move_order_line_id
1797: , mmtt.transaction_quantity
1798: , mmtt.transaction_uom
1799: , mmtt.primary_quantity
1800: FROM mtl_material_transactions_temp mmtt
1801: WHERE mmtt.parent_line_id = p_temp_id
1802: AND mmtt.parent_line_id <> mmtt.transaction_temp_id;
1803: -- This union by will end up getting all PARENTS too ***** mrana
1804:

Line 1819: FROM mtl_material_transactions_temp mmtt

1815: AND mtrh.header_id = mtrl.header_id;
1816:
1817: CURSOR c_get_other_mmtt IS
1818: SELECT COUNT(*)
1819: FROM mtl_material_transactions_temp mmtt
1820: WHERE mmtt.move_order_line_id = l_mo_line_id
1821: AND mmtt.transaction_temp_id <> l_txn_temp_id
1822: AND NOT EXISTS(SELECT 1
1823: FROM mtl_material_transactions_temp t1

Line 1823: FROM mtl_material_transactions_temp t1

1819: FROM mtl_material_transactions_temp mmtt
1820: WHERE mmtt.move_order_line_id = l_mo_line_id
1821: AND mmtt.transaction_temp_id <> l_txn_temp_id
1822: AND NOT EXISTS(SELECT 1
1823: FROM mtl_material_transactions_temp t1
1824: WHERE t1.parent_line_id = mmtt.transaction_temp_id);
1825:
1826: BEGIN
1827: x_return_status := fnd_api.g_ret_sts_success;

Line 2031: FROM mtl_material_transactions_temp mmtt , mtl_reservations mr

2027: END IF;
2028: SELECT nvl(mmtt.reservation_id,-1) , mr.primary_reservation_quantity ,
2029: mr.reservation_quantity, mr.primary_uom_code , mr.reservation_uom_code
2030: INTO l_reservation_id , l_pri_rsv_qty, l_rsv_qty , l_pri_rsv_uom, l_rsv_uom
2031: FROM mtl_material_transactions_temp mmtt , mtl_reservations mr
2032: WHERE mmtt.transaction_temp_id = l_txn_temp_id
2033: AND mr.reservation_id = mmtt.reservation_id ;
2034:
2035: IF (l_debug = 1) THEN