Go to most recent revision |
Details |
Last modification |
View Log
| RSS feed
| Rev |
Author |
Line No. |
Line |
| 13 |
rsolanki |
1 |
/* Rejection Trail */
|
|
|
2 |
SELECT rt.ENUM_ENTITY_TYPE,
|
|
|
3 |
rt.ENTITY_ID,
|
|
|
4 |
rt.REJECT_SEQ,
|
|
|
5 |
rt.IS_REJECTED,
|
|
|
6 |
rt.COMMENTS,
|
|
|
7 |
'Created by '|| usr.FULL_NAME ||' ('|| usr.USER_EMAIL ||') on '|| TO_CHAR( rt.DATE_TIME_STAMP, 'DD-MON-YYYY HH24:MI:SS') AS CREATOR
|
|
|
8 |
FROM REJECTION_TRAIL rt,
|
|
|
9 |
USERS usr
|
|
|
10 |
WHERE rt.USER_ID = usr.USER_ID
|
|
|
11 |
AND rt.ENUM_ENTITY_TYPE = GET_SYSTEM_VALUE( :ENUM_ENTITY_TYPE )
|
|
|
12 |
AND rt.ENTITY_ID = :ENTITY_ID
|
|
|
13 |
ORDER BY rt.REJECT_SEQ DESC
|
|
|
14 |
|