Subversion Repositories DevTools

Rev

Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
13 rsolanki 1
/* Release Manager Projects */
2
SELECT proj.proj_id,
3
	   proj.PROJ_NAME,
4
	   DECODE ( :RM_PROJECTS_FK,
5
	   		  	proj.PROJ_ID, 'selected',
6
				NULL ) AS SELECTED
7
  FROM PROJECTS proj
8
 ORDER BY UPPER(proj.PROJ_NAME)