Subversion Repositories DevTools

Rev

Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
119 ghuddy 1 
/* Releases Move 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 
   AND rt.RTAG_ID NOT IN (:RTAG_ID)
12 
   AND rt.OFFICIAL <> 'Y'
13 
 ORDER BY UPPER(rt.RTAG_NAME)