Details |
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)
|