Subversion Repositories DevTools

Rev

Rev 119 | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 119 Rev 183
Line 6... Line 6...
6 
		       rt.RTAG_NAME,
6 
		       rt.RTAG_NAME,
7 
			   rt.DISPLAY_ORDER,
 7 
			   rt.DISPLAY_ORDER,
8 
		       DECODE( rt.PARENT_RTAG_ID,
8 
		       DECODE( rt.PARENT_RTAG_ID,
9 
			   		   rt.RTAG_ID, 0, rt.PARENT_RTAG_ID ) AS PARENT_RTAG_ID,
 9 
			   		   rt.RTAG_ID, 0, rt.PARENT_RTAG_ID ) AS PARENT_RTAG_ID,
10 
			   rt.OFFICIAL,
 10 
			   rt.OFFICIAL,
11 
			    rt.DESCRIPTION,
 11 
			   rt.DESCRIPTION,
12 
				rt.ASSOC_MASS_REF
12 
			   rt.ASSOC_MASS_REF,
- 
 
 13 
               rt.created_stamp,
- 
 
 14 
               uc.full_name as creator
13 
		  FROM RELEASE_TAGS rt
 15 
		 FROM RELEASE_TAGS rt, USERS uc
14 
		 WHERE rt.PROJ_ID = :PROJ_ID
16 
		 WHERE rt.PROJ_ID = :PROJ_ID
- 
 
 17 
         AND rt.creator_id = uc.user_id (+)
15
18
16 
  		) rel
 19 
  		) rel
17 
START WITH rel.PARENT_RTAG_ID = 0
 20 
START WITH rel.PARENT_RTAG_ID = 0
18 
CONNECT BY PRIOR rel.RTAG_ID = rel.PARENT_RTAG_ID
21 
CONNECT BY PRIOR rel.RTAG_ID = rel.PARENT_RTAG_ID
19 
ORDER SIBLINGS BY rel.DISPLAY_ORDER
 22 
ORDER SIBLINGS BY rel.DISPLAY_ORDER