SET QUOTED_IDENTIFIER OFF
GO
CREATE VIEW dbo.arg_swinstalls_view AS SELECT DISTINCT arg_actiondf.adtext, arg_actiondf.ad1obty,
arg_actiondf.adprot, arg_actiondf.adtype, arg_actiondf.adsystem, arg_linkdef.ndtext, arg_linkdef.ndid,
arg_linkdef.nd2obty, arg_linkdef.nd2subty, arg_linkdef.ndreqd, arg_action.object_uuid, arg_action.acadid,
arg_action.ac1ivid, arg_action.last_update_user as ac_last_update_user, arg_action.last_update_date as
ac_last_update_date, actext1, arg_action.acint1, arg_action.acdate1, arg_action.accommnt, arg_action.acdatedt,
arg_action.actimetm, arg_actionlk.lkinstnc, arg_actionlk.lkcommnt, arg_actionlk.lkstrtdt, arg_actionlk.lkenddt,
arg_actionlk.last_update_user as lk_last_update_user, arg_actionlk.last_update_date as lk_last_update_date,
arg_actionlk.secondary_object_uuid, ca_model_def.name, ca_owned_resource.resource_name AS ASSETITNAME, arg_legaldoc.ledocidn,
ca_company.company_name, ca_contact.last_name, ca_location.location_name, primary_asset.resource_name primary_asset_name
FROM arg_actiondf INNER JOIN arg_action LEFT OUTER JOIN arg_actionlk ON arg_action.acadid = arg_actionlk.lkacadid
AND arg_action.ac1ivid = arg_actionlk.lkac1ivi AND arg_action.object_uuid = arg_actionlk.primary_object_uuid
AND arg_action.actimetm = arg_actionlk.lkactitm AND arg_action.acdatedt = arg_actionlk.lkacdadt LEFT OUTER JOIN
arg_linkdef ON arg_actionlk.lkacadid = arg_linkdef.ndadid AND arg_actionlk.lkndid = arg_linkdef.ndid ON
arg_actiondf.adid = arg_action.acadid LEFT OUTER JOIN ca_model_def ON arg_actionlk.secondary_object_uuid
= ca_model_def.model_uuid LEFT OUTER JOIN ca_owned_resource INNER JOIN ca_model_def ASSETITEM ON
ca_owned_resource.model_uuid = ASSETITEM.model_uuid ON arg_actionlk.secondary_object_uuid
= ca_owned_resource.own_resource_uuid LEFT OUTER JOIN arg_legaldoc ON arg_actionlk.secondary_object_uuid
= arg_legaldoc.legaldoc_uuid LEFT OUTER JOIN ca_company ON arg_actionlk.secondary_object_uuid
= ca_company.company_uuid LEFT OUTER JOIN ca_contact ON arg_actionlk.secondary_object_uuid
= ca_contact.contact_uuid LEFT OUTER JOIN ca_location ON arg_actionlk.secondary_object_uuid
= ca_location.location_uuid LEFT OUTER JOIN ca_owned_resource primary_asset ON arg_actionlk.primary_object_uuid
= primary_asset.own_resource_uuid WHERE (arg_actiondf.adtype = 3);


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