Subversion Repositories DevTools

Rev

Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
119 ghuddy 1 
/* Release Version List */
2 
SELECT qry.*
3 
   FROM (
4080 dpurdie 4 
            SELECT rel.*,
5 
                   LEVEL AS HIERARCHY
6 
              FROM (
7 
                    SELECT rt.RTAG_ID,
8 
                           rt.RTAG_NAME,
9 
                           rt.DISPLAY_ORDER,
10 
                           DECODE( rt.PARENT_RTAG_ID,
11 
                                   rt.RTAG_ID, 0, rt.PARENT_RTAG_ID ) AS PARENT_RTAG_ID,
12 
                           rt.OFFICIAL,
13 
                           rt.DESCRIPTION,
14 
                     	   rt.ASSOC_MASS_REF,
15 
				           rt.created_stamp,
16 
                           U2.full_name as creator,
17 
                           rt.OFFICIAL_STAMP,
18 
                           DECODE(U1.full_name, NULL, 'Unknown', U1.full_name )as modifier
19 
                     FROM RELEASE_TAGS rt
20 
                        left outer join users U1 on rt.official_id = U1.user_id
21 
                        left outer join users U2 on rt.creator_id = U2.user_id
22 
                     WHERE rt.PROJ_ID = :PROJ_ID
23 
                    ) rel
24 
            START WITH rel.PARENT_RTAG_ID = 0
25 
            CONNECT BY PRIOR rel.RTAG_ID = rel.PARENT_RTAG_ID
26 
            ORDER SIBLINGS BY rel.DISPLAY_ORDER
119 ghuddy 27 
         ) qry
4081 dpurdie 28 
 WHERE qry.OFFICIAL IN (/*SHOW_FILTER*/)