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
|