Subversion Repositories DevTools

Rev

Rev 183 | Details | Compare with Previous | Last modification | View Log | RSS feed

Rev Author Line No. Line
119 ghuddy 1 
/* Release Version List */
2 
SELECT qry.*
3 
   FROM (
4 
   		    SELECT rel.*,
5 
				   LEVEL AS HIERARCHY
6 
			  FROM (
157 ghuddy 7 
			  		SELECT rt.RTAG_ID,
8 
					       rt.RTAG_NAME,
119 ghuddy 9 
						   rt.DISPLAY_ORDER,
157 ghuddy 10 
					       DECODE( rt.PARENT_RTAG_ID,
119 ghuddy 11 
						   		   rt.RTAG_ID, 0, rt.PARENT_RTAG_ID ) AS PARENT_RTAG_ID,
12 
						   rt.OFFICIAL,
183 brianf 13 
						   rt.DESCRIPTION,
14 
 			               rt.ASSOC_MASS_REF,
15 
                           rt.created_stamp,
16 
                           uc.full_name as creator
17 
		            FROM RELEASE_TAGS rt, USERS uc
18 
		            WHERE rt.PROJ_ID = :PROJ_ID
19 
                    AND rt.creator_id = uc.user_id (+)
119 ghuddy 20 
			  		) rel
21 
			START WITH rel.PARENT_RTAG_ID = 0
157 ghuddy 22 
			CONNECT BY PRIOR rel.RTAG_ID = rel.PARENT_RTAG_ID
119 ghuddy 23 
			ORDER SIBLINGS BY rel.DISPLAY_ORDER
24 
         ) qry
157 ghuddy 25 
 WHERE qry.OFFICIAL IN (/*SHOW_FILTER*/)