SET QUOTED_IDENTIFIER OFF
GO

   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 INNER JOIN                         HARAPPROVELIST L
       ON V.STATEOBJID = L.STATEOBJID    
   WHERE     
   (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