Subversion Repositories DevTools

Rev

Go to most recent revision | Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
119 ghuddy 1 
/* Package Action Log */
2 
SELECT alog.action_datetime,
3 
	   usr.FULL_NAME,
4 
       usr.USER_EMAIL,
5 
       acttype.description as acttype,
6 
       alog.description
7 
  FROM ACTION_LOG alog, ACTION_TYPE acttype, USERS usr
8 
 WHERE alog.PV_ID = :PV_ID
9 
   AND alog.ACTTYPE_ID = acttype.ACTTYPE_ID
10 
   AND alog.USER_ID = usr.USER_ID
11 
 ORDER BY ( alog.ACTION_DATETIME ) DESC