5103: WHERE organization_id = p_organization_id
5104: AND inventory_item_id = p_inventory_item_id
5105: AND uom_class IN (SELECT uom_class
5106: FROM mtl_system_items msi,
5107: mtl_units_of_measure muom
5108: WHERE msi.inventory_item_id = p_inventory_item_id
5109: AND msi.organization_id = p_organization_id
5110: AND muom.uom_code = msi.primary_uom_code)
5111: AND uom_code LIKE (l_code)
5123: l_uom_class VARCHAR2(10);
5124: BEGIN
5125: SELECT uom_class
5126: INTO l_uom_class
5127: FROM mtl_units_of_measure_vl
5128: WHERE uom_code = p_uom_code;
5129:
5130: RETURN l_uom_class;
5131: EXCEPTION