CREATE VIEW "harapproveactionview" ("ENVOBJID", "STATEOBJID", "PACKAGEOBJID", "USROBJID", "ACTIONTIME", "ACTION", "USRGRPOBJID", "PROCESSOBJID")  AS
       SELECT "v"."envobjid", "v"."stateobjid", "v"."packageobjid", "v"."usrobjid", "v"."actiontime", "v"."ACTION", "l"."usrgrpobjid", "l"."processobjid"
       FROM "harapprovehistactionview" "v", "harapprovelist" "l"
       WHERE v.stateobjid = l.stateobjid AND ((l.isgroup = 'N' AND l.usrobjid = v.usrobjid) OR (l.isgroup = 'Y' AND l.usrgrpobjid IN (SELECT usrgrpobjid FROM harusersingroup g WHERE v.usrobjid = g.usrobjid)))
GO
GRANT SELECT ON  [dbo].[harapproveactionview] TO [harvest_group]
GRANT SELECT ON  [dbo].[harapproveactionview] TO [harvest_rep]
GO