Subversion Repositories DevTools

Rev

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

Rev 7379 Rev 7395
Line 19... Line 19...
19 
                           TO_CHAR(rt.official_stamp,'DD-Mon-YYYY') AS OFFICIAL_STAMP,
 19 
                           TO_CHAR(rt.official_stamp,'DD-Mon-YYYY') AS OFFICIAL_STAMP,
20 
                           TRUNC (SYSDATE - rt.official_stamp) as OFFICIAL_STAMP_DAYS,
 20 
                           TRUNC (SYSDATE - rt.official_stamp) as OFFICIAL_STAMP_DAYS,
21 
                           DECODE(U1.full_name, NULL, 'Unknown', U1.full_name )as modifier,
 21 
                           DECODE(U1.full_name, NULL, 'Unknown', U1.full_name )as modifier,
22 
                           RT.LXR,
 22 
                           RT.LXR,
23 
                           NVL(LX.LXRSERVER, 'N') AS LXRSERVER,
 23 
                           NVL(LX.LXRSERVER, 'N') AS LXRSERVER,
- 
 
 24 
                           NVL(RT.S3SYNC, 'N') AS S3SYNC ,
24 
                           CASE when (TRUNC(SYSDATE - rt.created_stamp) <= 20) AND rt.creator_id = :USER_ID THEN 1 ELSE 0 END as userCanDelete,
 25 
                           CASE when (TRUNC(SYSDATE - rt.created_stamp) <= 20) AND rt.creator_id = :USER_ID THEN 1 ELSE 0 END as userCanDelete,
25 
                           TO_CHAR(rm.timestamp,'DD-Mon-YYYY HH24:MI:SS') AS lastModified ,
 26 
                           TO_CHAR(rm.timestamp,'DD-Mon-YYYY HH24:MI:SS') AS lastModified ,
26 
                           EXTRACT(DAY FROM (SYSTIMESTAMP - rm.timestamp)) as lastModified_DAYS
 27 
                           EXTRACT(DAY FROM (SYSTIMESTAMP - rm.timestamp)) as lastModified_DAYS
27 
                     FROM RELEASE_TAGS rt
 28 
                     FROM RELEASE_TAGS rt
28 
                        left outer join users U1 on rt.official_id = U1.user_id
 29 
                        left outer join users U1 on rt.official_id = U1.user_id