SET QUOTED_IDENTIFIER OFF
GO
CREATE VIEW dbo.arg_relationships_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_contact.first_name as "last_name", ca_location.location_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 WHERE (arg_actiondf.adtype=0);


GO
GRANT SELECT ON  [dbo].[arg_relationships_view] TO [uapmadmin]
GRANT SELECT ON  [dbo].[arg_relationships_view] TO [uapmadmin_group]
GRANT SELECT ON  [dbo].[arg_relationships_view] TO [uapmbatch]
GRANT SELECT ON  [dbo].[arg_relationships_view] TO [uapmbatch_group]
GRANT SELECT ON  [dbo].[arg_relationships_view] TO [uapmreporting]
GRANT SELECT ON  [dbo].[arg_relationships_view] TO [uapmreporting_group]
GO