CREATE VIEW dbo.arg_sd_change_orders_view
AS
SELECT chg.id as id, chg.persid as persid, chg.chg_ref_num as chg_ref_num, chg.summary as summary, chg.description as description, chg.status as status, chg.active_flag as active_flag, chg.start_date as start_date, chg.open_date as open_date, chg.close_date as close_date, chg.resolve_date as resolve_date, lrel.r_persid as own_resource_uuid
FROM chg INNER JOIN lrel ON chg.persid=lrel.l_persid where lrel.l_attr='asset'
GO
GRANT SELECT ON  [dbo].[arg_sd_change_orders_view] TO [swcmadmin]
GO