SET QUOTED_IDENTIFIER OFF
GO
CREATE VIEW dbo.arg_web_class_subclass_view  AS  SELECT  class.name AS class,    subclass.name AS subclass     FROM  ca_resource_class AS class  INNER JOIN ca_resource_family AS family ON family.id = class.family_id  LEFT OUTER JOIN ca_resource_class AS subclass ON subclass.parent_id = class.id    WHERE  family.include_reconciliation = 1 AND class.parent_id = -1  

GO
GRANT SELECT ON  [dbo].[arg_web_class_subclass_view] TO [swcmadmin]
GRANT SELECT ON  [dbo].[arg_web_class_subclass_view] TO [uapmadmin_group]
GRANT SELECT ON  [dbo].[arg_web_class_subclass_view] TO [uapmbatch_group]
GRANT SELECT ON  [dbo].[arg_web_class_subclass_view] TO [uapmreporting_group]
GO