Subversion Repositories DevTools

Rev

Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
119 ghuddy 1 
/* Release References */
2 
SELECT proj.PROJ_NAME,
3 
	   rt.RTAG_NAME,
4 
	   rt.OFFICIAL,
5 
	   rt.RTAG_ID
6 
  FROM RELEASE_LINKS rl,
7 
  	   PROJECTS proj,
8 
	   RELEASE_TAGS rt
9 
 WHERE rl.RTAG_ID = :RTAG_ID
10 
   AND rl.REF_RTAG_ID = rt.RTAG_ID
11 
   AND rt.PROJ_ID = proj.PROJ_ID
12 
ORDER BY UPPER( proj.PROJ_NAME ), UPPER(rt.RTAG_NAME)