Subversion Repositories DevTools

Rev

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

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