/* Project List */
SELECT dmp.PROJ_ID,
	   dmp.PROJ_NAME,
	   dmp.RM_PROJECTS_FK,
	   proj.PROJ_NAME AS RM_PROJECT_NAME,
	   dmp.IS_HIDDEN,
	   dmp.IS_DOWNLOAD
  FROM DM_PROJECTS dmp,
  	   PROJECTS proj
 WHERE dmp.RM_PROJECTS_FK = proj.PROJ_ID (+)
 ORDER BY UPPER(dmp.PROJ_NAME)
  