Subversion Repositories DevTools

Rev

Go to most recent revision | Blame | Compare with Previous | Last modification | View Log | RSS feed 

/* 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)