[dbo].[harapprovehistactionview]
CREATE VIEW "harapprovehistactionview" ("envobjid", "stateobjid", "packageobjid", "usrobjid", "actiontime", "ACTION", "note") AS
SELECT "h"."envobjid", "h"."stateobjid", "h"."packageobjid", "h"."usrobjid", "h"."execdtime", "h"."action", "h"."note"
FROM "harapprovehist" "h", "harapprovehistview" "v", "harpackage" "p"
WHERE v.packageobjid = p.packageobjid AND v.stateobjid = p.stateobjid AND h.envobjid = v.envobjid AND h.stateobjid = v.stateobjid AND h.packageobjid = v.packageobjid AND h.usrobjid = v.usrobjid AND h.execdtime = v.actiontime
GO
GRANT SELECT ON [dbo].[harapprovehistactionview] TO [harvest_group]
GRANT SELECT ON [dbo].[harapprovehistactionview] TO [harvest_rep]
GO
