Subversion Repositories DevTools

Rev

Rev 25 | Details | Compare with Previous | 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,
25 rsolanki 6 
	   dmp.IS_HIDDEN,
7 
	   dmp.IS_DOWNLOAD
13 rsolanki 8 
  FROM DM_PROJECTS dmp,
9 
  	   PROJECTS proj
10 
 WHERE dmp.RM_PROJECTS_FK = proj.PROJ_ID (+)
11 
 ORDER BY UPPER(dmp.PROJ_NAME)
12