Go to most recent revision | Details | Last modification | View Log | RSS feed
/* Package Action Log */
SELECT alog.action_datetime,
usr.FULL_NAME,
usr.USER_EMAIL,
acttype.description as acttype,
alog.description
FROM ACTION_LOG alog, ACTION_TYPE acttype, USERS usr
WHERE alog.PV_ID = :PV_ID
AND alog.ACTTYPE_ID = acttype.ACTTYPE_ID
AND alog.USER_ID = usr.USER_ID
ORDER BY ( alog.ACTION_DATETIME ) DESC