Subversion Repositories DevTools

Rev

Go to most recent revision | 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)