Subversion Repositories DevTools

Rev

Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
2 rsolanki 1 
/* User List*/
2 
SELECT 'User_General.asp' AS file_name,
3 
	   DECODE ( usr.IS_DISABLED,
4 
	   		  	NULL, 'IMG_USER',
5 
				'IMG_USER_DISABLED' ) AS item_image,
6 
	   usr.user_id AS item_id,
7 
	   usr.full_name ||' ['|| usr.user_name ||']' AS item_name,
8 
	   'user_id='|| usr.user_id AS param
9 
  FROM USERS usr
10 
ORDER BY UPPER(usr.FULL_NAME)
11