[dbo].[HARAPPROVEHISTVIEW]

(local) > harvest > Views > dbo.HARAPPROVEHISTVIEW

Properties
Columns
SQL Script
Uses
Used By

Property	Value
ANSI Nulls On
Quoted Identifier On
Created	5:00:30 AM Monday, March 02, 2009
Last Modified	5:00:30 AM Monday, March 02, 2009

Columns

Name
ENVOBJID
STATEOBJID
PACKAGEOBJID
USROBJID
ACTIONTIME

SQL Script

SET QUOTED_IDENTIFIER OFF
GO

   CREATE VIEW HARAPPROVEHISTVIEW
   (     ENVOBJID
   , STATEOBJID
   , PACKAGEOBJID
   , USROBJID
   , ACTIONTIME ) AS
   SELECT DISTINCT ENVOBJID, STATEOBJID, PACKAGEOBJID,
        USROBJID, MAX(EXECDTIME) ACTIONTIME
   FROM  HARAPPROVEHIST
   GROUP BY ENVOBJID, STATEOBJID, PACKAGEOBJID, USROBJID

GO

Uses

[dbo].[HARAPPROVEHIST]
dbo

Used By

[dbo].[HARAPPROVEHISTACTIONVIEW]