Subversion Repositories DevTools

/* ReleaseManager Vtree Release Tag */
SELECT MAX( rt.rtag_id ) AS RTAG_ID
  FROM RELEASE_TAGS rt
 WHERE rt.vtree_id IN (
                                            SELECT br.RM_VTREE_FK
                          FROM BRANCHES br
                         WHERE br.BRANCH_ID = :BRANCH_ID
                                          )