Subversion Repositories DevTools

/* Release Version List */
SELECT qry.*
   FROM (
                    SELECT rel.*,
                                   LEVEL AS HIERARCHY
                          FROM (
                                        SELECT rt.RTAG_ID, 
                                               rt.RTAG_NAME, 
                                                   rt.DISPLAY_ORDER,
                                               DECODE( rt.PARENT_RTAG_ID, 
                                                                   rt.RTAG_ID, 0, rt.PARENT_RTAG_ID ) AS PARENT_RTAG_ID,
                                                   rt.OFFICIAL,
                                                    rt.DESCRIPTION,
                                                        rt.ASSOC_MASS_REF                                          
                                          FROM RELEASE_TAGS rt
                                         WHERE rt.PROJ_ID = :PROJ_ID 
                                        ) rel
                        START WITH rel.PARENT_RTAG_ID = 0
                        CONNECT BY PRIOR rel.RTAG_ID = rel.PARENT_RTAG_ID   
                        ORDER SIBLINGS BY rel.DISPLAY_ORDER
         ) qry
 WHERE qry.OFFICIAL IN ('N','R','C')