Subversion Repositories DevTools

Rev

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

Rev Author Line No. Line
2 rsolanki 1 
/* Multi Role Members */
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_EMAIL,
11 
	   usr.USER_NAME,
12 
	   usr.DOMAIN,
13 
	   usr.LAST_REQUEST
14 
  FROM (
15 
		SELECT ur.USER_ID, COUNT(ur.USER_ID) AS ROLE_SUM
16 
		  FROM USER_ROLES ur
17 
		 WHERE ur.ROLE_ID IN (
18 
		 	   			  	  SELECT *
19 
					   	        FROM THE ( SELECT CAST( IN_LIST_NUMBER( :ROLE_ID_LIST ) AS ACCMGR_NUMBER_TAB_t ) FROM dual )
20 
		 	   			  	  )
21 
		GROUP BY ur.USER_ID
22 
		) qry,
23 
		USERS usr
24 
 WHERE qry.ROLE_SUM = :ROLE_SUM
25 
   AND qry.USER_ID = usr.USER_ID
26 
 
27 
ORDER BY UPPER(usr.FULL_NAME)