SET QUOTED_IDENTIFIER OFF
GO

CREATE VIEW dbo.arg_notes_view as
SELECT    arg_notes.contact_uuid, arg_notes.creation_date, arg_notes.creation_user, arg_notes.last_update_date, arg_notes.last_update_user, arg_notes.version_number,
        arg_notes.nodate, arg_notes.noinstnc, arg_notes.noivid, arg_notes.notime,
    arg_notes.object_uuid, arg_notes.object_type, arg_drpdnlst.dlvalue as notype, arg_note_text.text as notext
FROM    arg_notes LEFT OUTER JOIN arg_note_text
ON    arg_notes.object_uuid = arg_note_text.object_uuid
AND    arg_notes.noinstnc = arg_note_text.instance
LEFT OUTER JOIN arg_drpdnlst ON 33000059 = arg_drpdnlst.dlldid AND arg_notes.notype = arg_drpdnlst.dlkey

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