Subversion Repositories DevTools

Rev

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

/* Releases Move 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    
   AND rt.RTAG_ID NOT IN (:RTAG_ID)   
   AND rt.OFFICIAL IN ('N', 'R', 'C')
 ORDER BY UPPER(rt.RTAG_NAME)