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,
                           rt.created_stamp,
                           uc.full_name as creator
                            FROM RELEASE_TAGS rt, USERS uc
                            WHERE rt.PROJ_ID = :PROJ_ID  
                    AND rt.creator_id = uc.user_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 (/*SHOW_FILTER*/)