[dbo].[ActivitiesLateIncompView]
SET QUOTED_IDENTIFIER OFF
GO
create view ActivitiesLateIncompView as SELECT stats.workitemid AS item_id, stats.PROCESSID AS instance_id, stats.NODENAME AS activity, 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 is null) OR (stats.completed = 0)) AND (stats.DUEDATE > 0) AND (stats.productid = productidview.productid)
GO
GRANT SELECT ON [dbo].[ActivitiesLateIncompView] TO [aionadmin_group]
GO
