Subversion Repositories DevTools

Rev

Rev 119 | Details | Compare with Previous | Last modification | View Log | RSS feed

Rev Author Line No. Line
119 ghuddy 1 
/* Releases Combo */
2 
SELECT rt.RTAG_ID,
3 
	   rt.RTAG_NAME,
4 
	   DECODE ( :RTAG_ID,
5 
	   			rt.RTAG_ID, 'selected',
6 
				NULL ) AS SELECTED
7 
  FROM PROJECTS pr,
8 
  	   RELEASE_TAGS rt
9 
 WHERE rt.PROJ_ID = pr.PROJ_ID
10 
   AND pr.PROJ_ID = :PROJ_ID
11 
 ORDER BY UPPER(rt.RTAG_NAME)