Subversion Repositories DevTools

Rev

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

Rev 183 Rev 4080
Line 1... Line 1...
1 
/* Release Version List */
 1 
/* Release Version List */
2 
SELECT qry.*
 2 
SELECT qry.*
3 
   FROM (
 3 
   FROM (
4 
   		    SELECT rel.*,
 4 
            SELECT rel.*,
5 
				   LEVEL AS HIERARCHY
 5 
                   LEVEL AS HIERARCHY
6 
			  FROM (
 6 
              FROM (
7 
			  		SELECT rt.RTAG_ID,
 7 
                    SELECT rt.RTAG_ID,
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,
 15 
				           rt.created_stamp,
16 
                           uc.full_name as creator
 16 
                           U2.full_name as creator,
17 
		            FROM RELEASE_TAGS rt, USERS uc
 17 
                           rt.OFFICIAL_STAMP,
- 
 
 18 
                           DECODE(U1.full_name, NULL, 'Unknown', U1.full_name )as modifier
18 
		            WHERE rt.PROJ_ID = :PROJ_ID
19 
                     FROM RELEASE_TAGS rt
- 
 
 20 
                        left outer join users U1 on rt.official_id = U1.user_id
- 
 
 21 
                        left outer join users U2 on rt.creator_id = U2.user_id
19 
                    AND rt.creator_id = uc.user_id (+)
 22 
                     WHERE rt.PROJ_ID = :PROJ_ID
20 
			  		) rel
 23 
                    ) rel
21 
			START WITH rel.PARENT_RTAG_ID = 0
 24 
            START WITH rel.PARENT_RTAG_ID = 0
22 
			CONNECT BY PRIOR rel.RTAG_ID = rel.PARENT_RTAG_ID
 25 
            CONNECT BY PRIOR rel.RTAG_ID = rel.PARENT_RTAG_ID
23 
			ORDER SIBLINGS BY rel.DISPLAY_ORDER
 26 
            ORDER SIBLINGS BY rel.DISPLAY_ORDER
24 
         ) qry
 27 
         ) qry
25 
 WHERE qry.OFFICIAL IN (/*SHOW_FILTER*/)
 28 
 WHERE qry.OFFICIAL IN ('A')