Subversion Repositories DevTools

Rev

Details | Last modification | View Log | RSS feed

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