[dbo].[usm_vw_ca_model_def]
create view usm_vw_ca_model_def as
select
subclass_id,inactive,name,abbreviation,creation_user,creation_date,last_update_user,last_update_date,version_number,description,
current_as_of_date,class_id,family_id,preferred_seller_uuid,manufacturer_uuid,exclude_registration,delete_time,operating_system,
capacity,capacity_unit,gl_code,sys.fn_varbintohexsubstring(1,ca_model_def.model_uuid,1,0) as model_uuid,tenant,asset_capable
from ca_model_def
GO
GRANT SELECT ON [dbo].[usm_vw_ca_model_def] TO [usmgroup]
GO
