Subversion Repositories DevTools

Rev

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

Rev 183 Rev 4080
Line 9... Line 9...
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,
 13 
               rt.created_stamp,
14 
               uc.full_name as creator
 14 
               U2.full_name as creator,
- 
 
 15 
               rt.OFFICIAL_STAMP,
- 
 
 16 
               DECODE(U1.full_name, NULL, 'Unknown', U1.full_name )as modifier
15 
		 FROM RELEASE_TAGS rt, USERS uc
 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
16 
		 WHERE rt.PROJ_ID = :PROJ_ID
20 
		 WHERE rt.PROJ_ID = :PROJ_ID
17 
         AND rt.creator_id = uc.user_id (+)
 - 
 
18
- 
 
19 
  		) rel
 21 
  		) rel
20 
START WITH rel.PARENT_RTAG_ID = 0
 22 
START WITH rel.PARENT_RTAG_ID = 0
21 
CONNECT BY PRIOR rel.RTAG_ID = rel.PARENT_RTAG_ID
23 
CONNECT BY PRIOR rel.RTAG_ID = rel.PARENT_RTAG_ID
22 
ORDER SIBLINGS BY rel.DISPLAY_ORDER
 24 
ORDER SIBLINGS BY rel.DISPLAY_ORDER
23
25
24 

            26