1648: INTO l_from_unit_of_measure,
1649: l_from_uom_code,
1650: l_from_uom_class
1651: FROM mtl_system_items_b i,
1652: mtl_units_of_measure iu,
1653: mtl_units_of_measure bu
1654: WHERE
1655: i.organization_id = c.organization_id
1656: AND i.inventory_item_id = l_inventory_item_id
1649: l_from_uom_code,
1650: l_from_uom_class
1651: FROM mtl_system_items_b i,
1652: mtl_units_of_measure iu,
1653: mtl_units_of_measure bu
1654: WHERE
1655: i.organization_id = c.organization_id
1656: AND i.inventory_item_id = l_inventory_item_id
1657: AND i.primary_uom_code = iu.uom_Code
1661: l_field_name := 'To UOM data';
1662: l_field_value := 'UM Type = '||c.um_type;
1663: SELECT unit_of_measure, uom_code
1664: INTO l_to_unit_of_measure, l_to_uom_code
1665: FROM mtl_units_of_measure
1666: WHERE
1667: uom_class = c.um_type AND
1668: base_uom_flag = 'Y';
1669: