Subversion Repositories DevTools

Rev

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

Rev 5251 Rev 5394
Line 16... Line 16...
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 
               RT.LXR,
21 
               NVL(LX.LXRSERVER, 'N') AS LXRSERVER
21 
               NVL(LX.LXRSERVER, 'N') AS LXRSERVER ,
- 
 
 22 
			   CASE when (TRUNC(SYSDATE - rt.created_stamp) <= 10) AND rt.creator_id = :USER_ID THEN 1 ELSE 0 END as userCanDelete
22 
		 FROM RELEASE_TAGS rt
 23 
		 FROM RELEASE_TAGS rt
23 
               left outer join users U1 on rt.official_id = U1.user_id
 24 
               left outer join users U1 on rt.official_id = U1.user_id
24 
               left outer join users U2 on rt.creator_id = U2.user_id
 25 
               left outer join users U2 on rt.creator_id = U2.user_id
25 
               left outer join lxr_state lx ON rt.RTAG_ID = lx.RTAG_ID
 26 
               left outer join lxr_state lx ON rt.RTAG_ID = lx.RTAG_ID
26 
		 WHERE rt.PROJ_ID = :PROJ_ID
 27 
		 WHERE rt.PROJ_ID = :PROJ_ID