[dbo].[ActivitiesLateCompView]
SET QUOTED_IDENTIFIER OFF
GO
create view ActivitiesLateCompView as SELECT stats.workitemid AS item_id, stats.PROCESSID AS instance_id, stats.NODENAME AS activity, (stats.completed - stats.duedate) / 1000 AS time_late, stats.PROCESSNAME AS process_name, NODEDESC AS activity_description, userlist_worklist.username AS actor
FROM stats, userlist_worklist, productidview
WHERE (stats.workitemid = userlist_worklist.workitemid) AND (stats.completed > stats.duedate) AND (stats.duedate > 0) AND (stats.productid = productidview.productid)
GO
GRANT SELECT ON [dbo].[ActivitiesLateCompView] TO [aionadmin_group]
GO
