Subversion Repositories DevTools

Rev

Go to most recent revision | Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
64 jtweddle 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