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_CATCH_WEIGHT_PVT dependencies on INV_CONVERT

Line 365: x_secondary_quantity := inv_convert.inv_um_convert(

361: l_uom_code := p_uom_code;
362: END IF;
363:
364: l_progress := '300';
365: x_secondary_quantity := inv_convert.inv_um_convert(
366: p_inventory_item_id
367: , g_precision
368: , p_quantity
369: , l_uom_code

Line 499: l_converted_qty := inv_convert.inv_um_convert(

495:
496: l_progress := '100';
497: IF (l_uom_deviation_high IS NOT NULL OR l_uom_deviation_low IS NOT NULL) THEN
498: l_progress := '200';
499: l_converted_qty := inv_convert.inv_um_convert(
500: p_inventory_item_id
501: , 5 -- Updated precision as 5 for Bug 15877579
502: , p_quantity
503: , l_uom_code

Line 868: l_line_quantity := inv_convert.inv_um_convert(

864: l_attr_counter := l_attr_counter + 1;
865: END IF;
866: ELSE
867: IF ( wdd_rec.requested_quantity_uom <> p_uom_code ) THEN
868: l_line_quantity := inv_convert.inv_um_convert(
869: p_inventory_item_id
870: , 6
871: , wdd_rec.picked_quantity
872: , wdd_rec.requested_quantity_uom

Line 1364: , inv_convert.inv_um_convert( wdd2.inventory_item_id

1360: , wdd2.picked_quantity
1361: , wdd2.shipped_quantity
1362: , DECODE( wdd2.requested_quantity_uom
1363: , msi.primary_uom_code, wdd2.picked_quantity
1364: , inv_convert.inv_um_convert( wdd2.inventory_item_id
1365: , wdd2.lot_number
1366: , wdd2.organization_id
1367: , NULL
1368: , wdd2.picked_quantity

Line 1713: l_primary_qty := inv_convert.inv_um_convert(

1709:
1710: IF l_pr_uom_code = p_uom_code THEN
1711: l_primary_qty := ROUND(p_quantity,5);
1712: ELSE
1713: l_primary_qty := inv_convert.inv_um_convert(
1714: item_id => p_inventory_item_id
1715: , lot_number => p_lot_number
1716: , organization_id => p_organization_id
1717: , precision => NULL

Line 1923: , inv_convert.inv_um_convert(

1919: DECODE( reservation_uom_code
1920: , secondary_uom_code, 0
1921: , DECODE( wms_catch_weight_pvt.get_uom_class(reservation_uom_code)
1922: , wms_catch_weight_pvt.get_uom_class(secondary_uom_code), 0
1923: , inv_convert.inv_um_convert(
1924: inventory_item_id
1925: , lot_number
1926: , organization_id
1927: , NULL

Line 1973: , inv_convert.inv_um_convert(

1969: DECODE( reservation_uom_code
1970: , secondary_uom_code, 0
1971: , DECODE( wms_catch_weight_pvt.get_uom_class(reservation_uom_code)
1972: , wms_catch_weight_pvt.get_uom_class(secondary_uom_code), 0
1973: , inv_convert.inv_um_convert(
1974: inventory_item_id
1975: , lot_number
1976: , organization_id
1977: , NULL

Line 2148: l_wdd_qty_incr := inv_convert.inv_um_convert(

2144: IF (l_debug = 1) THEN
2145: print_debug('l_pri_increase: ' || l_pri_increase, 4);
2146: END IF;
2147: IF ( t_req_uom(i) <> l_pr_uom_code ) THEN
2148: l_wdd_qty_incr := inv_convert.inv_um_convert(
2149: item_id => p_inventory_item_id
2150: , lot_number => p_lot_number
2151: , organization_id => p_organization_id
2152: , precision => NULL

Line 2176: l_wdd_qty_decr := inv_convert.inv_um_convert(

2172: IF (l_debug = 1) THEN
2173: print_debug('l_pri_decrease: ' || l_pri_decrease, 4);
2174: END IF;
2175: IF ( t_req_uom(i) <> l_pr_uom_code ) THEN
2176: l_wdd_qty_decr := inv_convert.inv_um_convert(
2177: item_id => p_inventory_item_id
2178: , lot_number => p_lot_number
2179: , organization_id => p_organization_id
2180: , precision => NULL

Line 2356: , inv_convert.inv_um_convert(

2352: DECODE( reservation_uom_code
2353: , secondary_uom_code, 0
2354: , DECODE( wms_catch_weight_pvt.get_uom_class(reservation_uom_code)
2355: , wms_catch_weight_pvt.get_uom_class(secondary_uom_code), 0
2356: , inv_convert.inv_um_convert(
2357: inventory_item_id
2358: , lot_number
2359: , organization_id
2360: , NULL

Line 2410: , inv_convert.inv_um_convert(

2406: DECODE( reservation_uom_code
2407: , secondary_uom_code, 0
2408: , DECODE( wms_catch_weight_pvt.get_uom_class(reservation_uom_code)
2409: , wms_catch_weight_pvt.get_uom_class(secondary_uom_code), 0
2410: , inv_convert.inv_um_convert(
2411: inventory_item_id
2412: , lot_number
2413: , organization_id
2414: , NULL

Line 2503: , inv_convert.inv_um_convert(

2499: DECODE( reservation_uom_code
2500: , secondary_uom_code, 0
2501: , DECODE( wms_catch_weight_pvt.get_uom_class(reservation_uom_code)
2502: , wms_catch_weight_pvt.get_uom_class(secondary_uom_code), 0
2503: , inv_convert.inv_um_convert(
2504: inventory_item_id
2505: , lot_number
2506: , organization_id
2507: , NULL

Line 2556: , inv_convert.inv_um_convert(

2552: DECODE( reservation_uom_code
2553: , secondary_uom_code, 0
2554: , DECODE( wms_catch_weight_pvt.get_uom_class(reservation_uom_code)
2555: , wms_catch_weight_pvt.get_uom_class(secondary_uom_code), 0
2556: , inv_convert.inv_um_convert(
2557: inventory_item_id
2558: , lot_number
2559: , organization_id
2560: , NULL

Line 2754: , inv_convert.inv_um_convert(

2750: UPDATE mtl_txn_request_lines
2751: SET quantity_detailed = quantity_detailed -
2752: DECODE( uom_code
2753: , l_pr_uom_code, l_sku_pri_decr
2754: , inv_convert.inv_um_convert(
2755: p_inventory_item_id
2756: , NULL
2757: , l_sku_pri_decr
2758: , l_pr_uom_code

Line 2865: l_tot_rsv_qty := inv_convert.inv_um_convert(

2861: THEN --{
2862: IF l_mmtt_rsv_rec.reservation_uom_code = l_pr_uom_code THEN
2863: l_tot_rsv_qty := l_tot_rsv_pri_qty;
2864: ELSE
2865: l_tot_rsv_qty := inv_convert.inv_um_convert(
2866: item_id => p_inventory_item_id
2867: , precision => NULL
2868: , from_quantity => l_tot_rsv_pri_qty
2869: , from_unit => l_pr_uom_code

Line 3071: , inv_convert.inv_um_convert(

3067: UPDATE mtl_txn_request_lines
3068: SET quantity_detailed = quantity_detailed +
3069: DECODE( uom_code
3070: , l_pr_uom_code, l_sku_pri_incr
3071: , inv_convert.inv_um_convert(
3072: p_inventory_item_id
3073: , NULL
3074: , l_sku_pri_incr
3075: , l_pr_uom_code

Line 3429: l_line_quantity := inv_convert.inv_um_convert(

3425: print_debug('Got from MMTT trxtempid='||mmtt_rec.transaction_temp_id||' trxqty='||mmtt_rec.transaction_quantity||' trxuom='||mmtt_rec.transaction_uom, 4);
3426: END IF;
3427:
3428: IF ( mmtt_rec.transaction_uom <> p_uom_code ) THEN
3429: l_line_quantity := inv_convert.inv_um_convert(
3430: p_inventory_item_id
3431: , 6
3432: , mmtt_rec.transaction_quantity
3433: , mmtt_rec.transaction_uom

Line 3491: l_line_quantity := inv_convert.inv_um_convert(

3487: print_debug('Got form MTLT lottrxqty='||mtlt_rec.transaction_quantity, 4);
3488: END IF;
3489:
3490: IF ( mmtt_rec.transaction_uom <> p_uom_code ) THEN
3491: l_line_quantity := inv_convert.inv_um_convert(
3492: p_inventory_item_id
3493: , 6
3494: , mtlt_rec.transaction_quantity
3495: , mmtt_rec.transaction_uom

Line 3718: INV_CONVERT.inv_um_conversion (

3714: -- Check that there is a valid uom conversin between primary and secondary.
3715: IF ( wdd_item_rec.primary_uom_code <> l_prev_pri_uom OR
3716: wdd_item_rec.secondary_uom_code <> l_prev_sec_uom ) THEN
3717: -- Call UOM API to check that there is a valid conversion rate
3718: INV_CONVERT.inv_um_conversion (
3719: from_unit => wdd_item_rec.primary_uom_code
3720: , to_unit => wdd_item_rec.secondary_uom_code
3721: , item_id => wdd_item_rec.inventory_item_id
3722: , uom_rate => l_uom_conv_rate );

Line 3775: INV_CONVERT.inv_um_conversion (

3771: -- if item can defaulted check uom conversion to make sure it is valid
3772: IF ( l_default_ind = G_SECONDARY_DEFAULT ) THEN
3773: IF ( l_prev_pri_uom <> l_pri_uom OR l_prev_sec_uom <> l_sec_uom ) THEN
3774: -- Call UOM API to check that there is a valid conversion rate
3775: INV_CONVERT.inv_um_conversion (
3776: from_unit => l_pri_uom
3777: , to_unit => l_sec_uom
3778: , item_id => mmtt_item_rec.inventory_item_id
3779: , uom_rate => l_uom_conv_rate );

Line 3831: INV_CONVERT.inv_um_conversion (

3827: -- Check UOM conversion to make sure it's valid
3828: IF ( l_temp = 0 AND l_default_ind = G_SECONDARY_DEFAULT ) THEN
3829: IF ( l_prev_pri_uom <> l_pri_uom OR l_prev_sec_uom <> l_sec_uom ) THEN
3830: -- Call UOM API to check that there is a valid conversion rate
3831: INV_CONVERT.inv_um_conversion (
3832: from_unit => l_pri_uom
3833: , to_unit => l_sec_uom
3834: , item_id => mmtt_item_rec.inventory_item_id
3835: , uom_rate => l_uom_conv_rate );

Line 4789: SELECT sum(inv_convert.inv_um_convert(wdd.inventory_item_id,

4785: , x_msg_count OUT NOCOPY NUMBER
4786: ) RETURN NUMBER IS
4787:
4788: CURSOR itemCur IS
4789: SELECT sum(inv_convert.inv_um_convert(wdd.inventory_item_id,
4790: 6,
4791: wdd.REQUESTED_QUANTITY,
4792: wdd.REQUESTED_QUANTITY_UOM,
4793: --msib.primary_uom_code,

Line 4842: /**l_pri_input_qty := inv_convert.inv_um_convert(p_from_item_id,

4838: END IF;
4839:
4840: l_progress := '10';
4841:
4842: /**l_pri_input_qty := inv_convert.inv_um_convert(p_from_item_id,
4843: 6,
4844: p_from_item_pri_qty,
4845: p_from_item_pri_uom,
4846: p_from_item_pri_uom,

Line 5013: INV_CONVERT.inv_um_conversion (

5009: IF (item_rec.secondary_default_ind = G_SECONDARY_DEFAULT AND item_rec.picked_quantity2 IS NULL) THEN
5010:
5011: --call the defaulting logic and see if the return < 0
5012:
5013: INV_CONVERT.inv_um_conversion (
5014: from_unit => item_rec.primary_uom_code
5015: , to_unit => item_rec.secondary_uom_code
5016: , item_id => item_rec.inventory_item_id
5017: , uom_rate => l_uom_conv_rate );

Line 5205: SELECT NVL(SUM(DECODE(tare_weight_uom_code, NULL, 0 , inv_convert.inv_um_convert(

5201: IF(l_curr_tare_wt > 0) THEN
5202: BEGIN
5203: --The following query gets the tare_weight of the immediate child LPNs only and not the entire LPN hierarchy.
5204: --This is done intentionally as the child would already include the tare_weight of any of its children so we don't want to double count.
5205: SELECT NVL(SUM(DECODE(tare_weight_uom_code, NULL, 0 , inv_convert.inv_um_convert(
5206: item_id => NULL
5207: , precision => 5
5208: , from_quantity => NVL(tare_weight, 0)
5209: , from_unit => tare_weight_uom_code

Line 5241: l_converted_qty := inv_convert.inv_um_convert(

5237: IF (l_debug = 1) THEN
5238: print_debug('Inside update_lpn_tare for case where uom is same as curr LPN tare UoM', 4);
5239: END IF;
5240: ELSE
5241: l_converted_qty := inv_convert.inv_um_convert(
5242: item_id => NULL
5243: , precision => 5
5244: , from_quantity => l_tare_weight
5245: , from_unit => p_tare_uom_code