Details |
Last modification |
View Log
| RSS feed
| Rev |
Author |
Line No. |
Line |
| 2 |
rsolanki |
1 |
/* Computer Users */
|
|
|
2 |
SELECT DECODE ( usr.IS_ONLINE,
|
|
|
3 |
NULL, NULL,
|
|
|
4 |
'<img src="images/i_online.gif" title="User is online at '|| usr.ONLINE_AT ||'" width="16" height="16" border="0" hspace="2">' ) AS user_online,
|
|
|
5 |
DECODE ( usr.IS_DISABLED,
|
|
|
6 |
NULL, 'LIMG_USER',
|
|
|
7 |
'LIMG_USER_DISABLED' ) AS user_image,
|
|
|
8 |
usr.USER_ID,
|
|
|
9 |
usr.FULL_NAME,
|
|
|
10 |
usr.USER_NAME,
|
|
|
11 |
usr.IS_ONLINE,
|
|
|
12 |
usr.ONLINE_AT
|
|
|
13 |
FROM (
|
|
|
14 |
SELECT DISTINCT lt.USER_NAME
|
|
|
15 |
FROM LOGIN_TRAIL lt
|
|
|
16 |
WHERE lt.CLIENT_IP = :CLIENT_IP
|
|
|
17 |
) cip,
|
|
|
18 |
USERS usr
|
|
|
19 |
WHERE cip.USER_NAME = usr.USER_NAME
|
|
|
20 |
ORDER BY UPPER(usr.FULL_NAME)
|