Subversion Repositories DevTools

Rev

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

Rev 7468 Rev 7493
Line 12... Line 12...
12 
                           DECODE( rt.official ,
 12 
                           DECODE( rt.official ,
13 
                                   'Y', CASE WHEN TRUNC (SYSDATE - rt.official_stamp) > 60 THEN 'O' ELSE 'Y' END,
13 
                                   'Y', CASE WHEN TRUNC (SYSDATE - rt.official_stamp) > 60 THEN 'O' ELSE 'Y' END,
14 
                                   rt.official ) as OFFICIAL,
 14 
                                   rt.official ) as OFFICIAL,
15 
                           rt.DESCRIPTION,
 15 
                           rt.DESCRIPTION,
16 
                           rt.ASSOC_MASS_REF,
 16 
                           rt.ASSOC_MASS_REF,
17 
                           TO_CHAR(rt.created_stamp,'DD-Mon-YYYY') AS created_stamp,
 17 
                           TO_CHAR(rt.created_stamp,'DD-Mon-YYYY HH24:MI:SS') AS created_stamp,
18 
                           U2.full_name as creator,
 18 
                           U2.full_name as creator,
19 
                           TO_CHAR(rt.official_stamp,'DD-Mon-YYYY') AS OFFICIAL_STAMP,
 19 
                           TO_CHAR(rt.official_stamp,'DD-Mon-YYYY HH24:MI:SS') 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.S3MANIFEST, 'N') AS S3MANIFEST ,
 24 
                           NVL(RT.S3MANIFEST, 'N') AS S3MANIFEST ,
25 
                           CASE when (TRUNC(SYSTIMESTAMP) - TRUNC(rt.created_stamp) <= 20) AND rt.creator_id = :USER_ID THEN 1 ELSE 0 END as userCanDelete,
 25 
                           CASE when (TRUNC(SYSTIMESTAMP) - TRUNC(rt.created_stamp) <= 20) AND rt.creator_id = :USER_ID AND rt.OFFICIAL != 'S' THEN 1 ELSE 0 END as userCanDelete,
26 
                           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 ,
27 
                           EXTRACT(DAY FROM (SYSTIMESTAMP - rm.timestamp)) as lastModified_DAYS
 27 
                           EXTRACT(DAY FROM (SYSTIMESTAMP - rm.timestamp)) as lastModified_DAYS
28 
                     FROM RELEASE_TAGS rt
 28 
                     FROM RELEASE_TAGS rt
29 
                        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
30 
                        left outer join users U2 on rt.creator_id = U2.user_id
 30 
                        left outer join users U2 on rt.creator_id = U2.user_id