Subversion Repositories DevTools

Rev

Rev 2 | Details | Compare with Previous | Last modification | View Log | RSS feed

Rev Author Line No. Line
2 rsolanki 1 
/* User Applications */
2 
SELECT ap.APP_ID,
3 
	   ap.APPLICATION_NAME
4 
  FROM USER_APPLICATIONS ua,
5 
  	   APPLICATIONS ap
6 
 WHERE ua.APP_ID = ap.APP_ID
7 
   AND ua.USER_ID = :USER_ID
8 
 ORDER BY UPPER(ap.APPLICATION_NAME)