Subversion Repositories DevTools

Rev

Go to most recent revision | Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
2 rsolanki 1 
/* Application 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 
  	   USER_APPLICATIONS usra
11 
 WHERE usra.USER_ID = usr.USER_ID
12 
   AND usra.APP_ID = :APP_ID
13 
ORDER BY UPPER(usr.FULL_NAME)