/* User Applications */
SELECT ap.APP_ID,
	   ap.APPLICATION_NAME
  FROM USER_APPLICATIONS ua,
  	   APPLICATIONS ap
 WHERE ua.APP_ID = ap.APP_ID
   AND ua.USER_ID = :USER_ID
 ORDER BY UPPER(ap.APPLICATION_NAME)    