Subversion Repositories DevTools

Rev

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

Rev 4804 Rev 5177
Line 4... Line 4...
4
4
5 
  		SELECT rt.RTAG_ID,
5 
  		SELECT rt.RTAG_ID,
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 
               DECODE( rt.official ,
- 
 
 11 
                       'Y', CASE WHEN TRUNC (SYSDATE - rt.official_stamp) > 60 THEN 'O' ELSE 'Y' END,
10 
			   rt.OFFICIAL,
 12 
                       rt.official ) as OFFICIAL,
11 
			   rt.DESCRIPTION,
 13 
			   rt.DESCRIPTION,
12 
			   rt.ASSOC_MASS_REF,
 14 
			   rt.ASSOC_MASS_REF,
13 
               TO_CHAR(rt.created_stamp,'DD-Mon-YYYY') AS created_stamp,
 15 
               TO_CHAR(rt.created_stamp,'DD-Mon-YYYY') AS created_stamp,
14 
               U2.full_name as creator,
 16 
               U2.full_name as creator,
- 
 
 17 
               TO_CHAR(rt.official_stamp,'DD-Mon-YYYY') AS OFFICIAL_STAMP,
15 
               rt.OFFICIAL_STAMP,
 18 
               TRUNC (SYSDATE - rt.official_stamp) as OFFICIAL_STAMP_DAYS,
16 
               DECODE(U1.full_name, NULL, 'Unknown', U1.full_name )as modifier
 19 
               DECODE(U1.full_name, NULL, 'Unknown', U1.full_name )as modifier
17 
		 FROM RELEASE_TAGS rt
 20 
		 FROM RELEASE_TAGS rt
18 
               left outer join users U1 on rt.official_id = U1.user_id
 21 
               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
 22 
               left outer join users U2 on rt.creator_id = U2.user_id
20 
		 WHERE rt.PROJ_ID = :PROJ_ID
 23 
		 WHERE rt.PROJ_ID = :PROJ_ID