Subversion Repositories DevTools

Rev

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

/* Releases Combo */
SELECT rt.RTAG_ID,
           rt.RTAG_NAME,
           DECODE ( :RTAG_ID,
                                rt.RTAG_ID, 'selected',
                                NULL ) AS SELECTED
  FROM PROJECTS pr,
           RELEASE_TAGS rt
 WHERE rt.PROJ_ID = pr.PROJ_ID
   AND pr.PROJ_ID = :PROJ_ID       
 ORDER BY UPPER(rt.RTAG_NAME)