Subversion Repositories DevTools

/* Release Children Elements */
SELECT rt.RTAG_ID,
           rt.RTAG_NAME,
           rt.OFFICIAL
  FROM RELEASE_TAGS rt
 WHERE rt.PROJ_ID = :PROJ_ID
   AND rt.PARENT_RTAG_ID = :PARENT_RTAG_ID
   AND rt.RTAG_ID != rt.PARENT_RTAG_ID
 ORDER BY rt.DISPLAY_ORDER