Subversion Repositories DevTools

Rev

Rev 6576 | Rev 7395 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 6576 Rev 7380
Line 17... Line 17...
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 
			   CASE when (TRUNC(SYSDATE - rt.created_stamp) <= 20) AND rt.creator_id = :USER_ID THEN 1 ELSE 0 END as userCanDelete,
23 
               TO_CHAR(rm.timestamp,'DD-Mon-YYYY HH24:MI:SS') AS lastModified ,
 23 
               TO_CHAR(rm.timestamp,'DD-Mon-YYYY HH24:MI:SS') AS lastModified ,
24 
               EXTRACT(DAY FROM (SYSTIMESTAMP - rm.timestamp)) as lastModified_DAYS
 24 
               EXTRACT(DAY FROM (SYSTIMESTAMP - rm.timestamp)) as lastModified_DAYS
25 
		 FROM RELEASE_TAGS rt
 25 
		 FROM RELEASE_TAGS rt
26 
               left outer join users U1 on rt.official_id = U1.user_id
 26 
               left outer join users U1 on rt.official_id = U1.user_id
27 
               left outer join users U2 on rt.creator_id = U2.user_id
 27 
               left outer join users U2 on rt.creator_id = U2.user_id