Subversion Repositories DevTools

Rev

Rev 2 | Details | Compare with Previous | 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)