Details |
Last modification |
View Log
| RSS feed
| Rev |
Author |
Line No. |
Line |
| 13 |
rsolanki |
1 |
/* Project List */
|
|
|
2 |
SELECT dmp.PROJ_ID,
|
|
|
3 |
dmp.PROJ_NAME,
|
|
|
4 |
dmp.RM_PROJECTS_FK,
|
|
|
5 |
proj.PROJ_NAME AS RM_PROJECT_NAME,
|
|
|
6 |
dmp.IS_HIDDEN
|
|
|
7 |
FROM DM_PROJECTS dmp,
|
|
|
8 |
PROJECTS proj
|
|
|
9 |
WHERE dmp.RM_PROJECTS_FK = proj.PROJ_ID (+)
|
|
|
10 |
ORDER BY UPPER(dmp.PROJ_NAME)
|
|
|
11 |
|