Subversion Repositories DevTools

Rev

Rev 5506 | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 5506 Rev 6510
Line 11... Line 11...
11 
	   usr.USER_NAME,
 11 
	   usr.USER_NAME,
12 
	   usr.DOMAIN,
 12 
	   usr.DOMAIN,
13 
	   usr.LAST_REQUEST
 13 
	   usr.LAST_REQUEST
14 
  FROM (
 14 
  FROM (
15 
		SELECT usr.*
 15 
		SELECT usr.*
16 
		  FROM USERS usr
 - 
 
17 
		MINUS
 - 
 
18 
		SELECT usr.*
 - 
 
19 
		  FROM USERS usr,
 16 
		  FROM USERS usr,
20 
		  	   USER_APPLICATIONS ua
 17 
		  	   USER_APPLICATIONS ua
21 
		 WHERE ua.USER_ID = usr.USER_ID
 18 
		 WHERE ua.USER_ID = usr.USER_ID
22 
		   AND ua.APP_ID = :APP_ID
 19 
		   AND ua.APP_ID = :APP_ID
23 
  		) usr
 20 
  		) usr