SET QUOTED_IDENTIFIER OFF
GO
CREATE VIEW [dbo].[arg_event_notification_view] AS SELECT arg_eventnotification_def_view.evid, arg_eventnotification_def_view.evname, arg_eventnotification_def_view.evenable, arg_eventnotification_def_view.table_name, arg_eventnotification_def_view.field_name, arg_eventnotification_def_view.enrecip, arg_eventnotification_def_view.entext, arg_evrem.object_uuid, arg_evrem.object_type, arg_evrem.erobtype, arg_evrem.erissudt, arg_evrem.erstat, arg_evrem.erevntdt, arg_evrem.erchngdt, arg_evrem.eroldv, arg_evrem.ernewv, arg_evrem.erid, arg_evrem.ersys, arg_evrem.eradinfo, arg_evrem.recurring_interval, arg_evrem.recurring_number, arg_evnotify.nyid, arg_evnotify.nytype, arg_evnotify.nysys, arg_evnotify.nytext, arg_evnotify.nyissudt, arg_evnotify.nyrecip, arg_evnotify.nysndate, arg_evnotify.nyrvdate, arg_evnotify.nyrvfrom, arg_legaldoc.ledocidn, ca_location.location_name, ca_company.company_name, ca_contact.last_name, ca_contact.middle_name, ca_contact.first_name, ca_model_def.name AS model_name,ca_organization.org_name, ASSETITEM.name AS asset_model_name, arg_evnotify.last_update_date AS no_last_update_date, arg_evnotify.last_update_user AS no_last_update_user, arg_evrem.last_update_date AS ev_last_update_date, arg_evrem.last_update_user AS ev_last_update_user, arg_eventnotification_def_view.enable, strlst1.slvalue1 AS recur_inter_str, strlst2.slvalue1 AS prostatus, strlst3.slvalue1 AS eventstate, strlst4.slvalue1 AS systemmanual, strlst5.slvalue1 AS notificationtype    FROM  arg_evnotify RIGHT OUTER JOIN arg_evrem ON arg_evnotify.nyerid = arg_evrem.erid LEFT OUTER JOIN ca_model_def ON arg_evrem.object_uuid = ca_model_def.model_uuid LEFT OUTER JOIN ca_owned_resource INNER JOIN ca_model_def AS ASSETITEM ON ca_owned_resource.model_uuid = ASSETITEM.model_uuid ON arg_evrem.object_uuid = ca_owned_resource.own_resource_uuid LEFT OUTER JOIN ca_company ON arg_evrem.object_uuid = ca_company.company_uuid LEFT OUTER JOIN ca_contact ON arg_evrem.object_uuid = ca_contact.contact_uuid LEFT OUTER JOIN ca_location ON arg_evrem.object_uuid = ca_location.location_uuid LEFT OUTER JOIN arg_legaldoc ON arg_evrem.object_uuid = arg_legaldoc.legaldoc_uuid LEFT OUTER JOIN ca_organization ON arg_evrem.object_uuid = ca_organization.organization_uuid LEFT OUTER JOIN arg_eventnotification_def_view ON arg_evrem.erevid = arg_eventnotification_def_view.evid LEFT OUTER JOIN arg_strlst AS strlst1 ON strlst1.slentry = arg_evrem.recurring_interval AND strlst1.slid = 56 LEFT OUTER JOIN arg_strlst AS strlst2 ON strlst2.slentry = arg_evrem.erstat AND strlst2.slid = 57 LEFT OUTER JOIN arg_strlst AS strlst3 ON strlst3.slentry = arg_evrem.ersys AND strlst3.slid = 3 LEFT OUTER JOIN arg_strlst AS strlst4 ON strlst4.slentry = arg_evnotify.nysys AND strlst4.slid = 3 LEFT OUTER JOIN arg_strlst AS strlst5 ON strlst5.slentry = arg_evnotify.nytype AND strlst5.slid = 50

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