Subversion Repositories DevTools

/* 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 <> 'Y'       
 ORDER BY UPPER(rt.RTAG_NAME)