Subversion Repositories DevTools

Rev

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

Rev 5177 Rev 5207
Line 14... Line 14...
14 
			   rt.ASSOC_MASS_REF,
 14 
			   rt.ASSOC_MASS_REF,
15 
               TO_CHAR(rt.created_stamp,'DD-Mon-YYYY') AS created_stamp,
 15 
               TO_CHAR(rt.created_stamp,'DD-Mon-YYYY') AS created_stamp,
16 
               U2.full_name as creator,
 16 
               U2.full_name as creator,
17 
               TO_CHAR(rt.official_stamp,'DD-Mon-YYYY') AS OFFICIAL_STAMP,
 17 
               TO_CHAR(rt.official_stamp,'DD-Mon-YYYY') AS OFFICIAL_STAMP,
18 
               TRUNC (SYSDATE - rt.official_stamp) as OFFICIAL_STAMP_DAYS,
 18 
               TRUNC (SYSDATE - rt.official_stamp) as OFFICIAL_STAMP_DAYS,
19 
               DECODE(U1.full_name, NULL, 'Unknown', U1.full_name )as modifier
 19 
               DECODE(U1.full_name, NULL, 'Unknown', U1.full_name )as modifier,
- 
 
 20 
               RT.LXR
20 
		 FROM RELEASE_TAGS rt
 21 
		 FROM RELEASE_TAGS rt
21 
               left outer join users U1 on rt.official_id = U1.user_id
 22 
               left outer join users U1 on rt.official_id = U1.user_id
22 
               left outer join users U2 on rt.creator_id = U2.user_id
 23 
               left outer join users U2 on rt.creator_id = U2.user_id
23 
		 WHERE rt.PROJ_ID = :PROJ_ID
 24 
		 WHERE rt.PROJ_ID = :PROJ_ID
24 
  		) rel
 25 
  		) rel