[Home] [Help]
699: END IF;
700:
701: /* Convert the routing qty from its uom to the routing class UOM */
702: /* Routing UOM needs to be convertible to the routing class UOM */
703: l_routing_qty := INV_CONVERT.inv_um_convert(item_id => 0
704: ,precision => 5
705: ,from_quantity => l_routing_qty
706: ,from_unit => l_item_um
707: ,to_unit => l_routing_uom
756: CLOSE get_total_qty_cur;
757: IF (l_recipe_qty IS NULL) THEN
758: l_recipe_qty := -20;
759: ELSE
760: l_recipe_qty := INV_CONVERT.inv_um_convert(item_id => 0
761: ,precision => 5
762: ,from_quantity => l_recipe_qty
763: ,from_unit => l_uom
764: ,to_unit => l_routing_uom
1110: /*Bug 2880618 - Thomas Daniel */
1111: /*Need to compute only for ingredients contributing to yield */
1112: l_material_tab(i).contribute_yield_ind = 'Y' THEN
1113: -- NPD Conv.
1114: l_temp_qty := INV_CONVERT.inv_um_convert( item_id => l_material_tab(i).inventory_item_id
1115: ,precision => 5
1116: ,from_quantity => l_material_tab(i).qty
1117: ,from_unit => l_material_tab(i).detail_uom
1118: ,to_unit => x_uom
1133: /* Now let us calculate the product total quantities */
1134: FOR i IN 1..l_material_tab.COUNT LOOP
1135: IF l_material_tab(i).line_type IN (1,2) THEN
1136: -- NPD Conv.
1137: l_temp_qty := INV_CONVERT.inv_um_convert( item_id => l_material_tab(i).inventory_item_id
1138: ,precision => 5
1139: ,from_quantity => l_material_tab(i).qty
1140: ,from_unit => l_material_tab(i).detail_uom
1141: ,to_unit => x_uom
1228: END IF;
1229: FOR rout_rec IN get_routrecipe_qty(l_formula_Id, l_routing_Id) LOOP
1230: IF(l_calculate_step_qty <> 1) THEN
1231: IF (rout_rec.rout_uom <> rout_rec.yield_typ_uom) THEN
1232: l_recipe_qty := INV_CONVERT.inv_um_convert(item_id => 0
1233: ,precision => 5
1234: ,from_quantity => rout_rec.recipe_qty
1235: ,from_unit => rout_rec.yield_typ_uom
1236: ,to_unit => rout_rec.rout_uom
1522:
1523: /* The min of max_capacity needs to derived for a step */
1524: /* Please remember if the max capacity is -ve */
1525: /* it probably means that the capcity conversion to step qty um was not set */
1526: l_max_capacity := INV_CONVERT.inv_um_convert(item_id => 0
1527: ,precision => 5
1528: ,from_quantity => nvl(Capacity_rec.max_cap,0)
1529: ,from_unit => Capacity_rec.capacity_um
1530: ,to_unit => l_step_qty_uom
1552: /* process_um but convertible to the mass_ref_um */
1553: IF (l_max_capacity < 0) THEN
1554: l_step_qty := P_step_tbl(i).step_mass_qty;
1555: l_step_qty_uom := P_step_tbl(i).step_mass_uom;
1556: l_max_capacity := INV_CONVERT.inv_um_convert(item_id => 0
1557: ,precision => 5
1558: ,from_quantity => Capacity_rec.max_cap
1559: ,from_unit => l_capacity_uom
1560: ,to_unit => l_step_qty_uom
1571: /* process_um and mass_um but convertible to the volume_ref_um */
1572: IF (l_max_capacity < 0) THEN
1573: l_step_qty := P_step_tbl(i).step_vol_qty;
1574: l_step_qty_uom := P_step_tbl(i).step_vol_uom;
1575: l_max_capacity := INV_CONVERT.inv_um_convert(item_id => 0
1576: ,precision => 5
1577: ,from_quantity => Capacity_rec.max_cap
1578: ,from_unit => l_capacity_uom
1579: ,to_unit => l_step_qty_uom
2685: FOR i IN 1 .. l_material_tab.COUNT
2686: LOOP
2687: IF l_different_uom = 'Y'
2688: THEN
2689: l_temp_qty := INV_CONVERT.inv_um_convert(item_id => l_material_tab (i).inventory_item_id
2690: ,precision => 5
2691: ,from_quantity => l_material_tab (i).qty
2692: ,from_unit => l_material_tab (i).detail_uom
2693: ,to_unit => l_conv_uom
2777: lhdrqty := lhdrqty + l_one_prodqty;
2778: -- Changed
2779: IF l_different_uom = 'Y'
2780: THEN
2781: l_temp_qty := INV_CONVERT.inv_um_convert(item_id => l_material_tab (i).inventory_item_id
2782: ,precision => 5
2783: ,from_quantity => l_one_prodqty
2784: ,from_unit => l_conv_uom
2785: ,to_unit => temp_prod_tbl1 (i).orig_uom