Subversion Repositories DevTools

Rev

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

Rev 5251 Rev 5394
Line 18... Line 18...
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') 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 
						   CASE when (TRUNC(SYSDATE - rt.created_stamp) <= 10) AND rt.creator_id = :USER_ID THEN 1 ELSE 0 END as userCanDelete
24 
                     FROM RELEASE_TAGS rt
 25 
                     FROM RELEASE_TAGS rt
25 
                        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
26 
                        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
27 
                        left outer join lxr_state lx ON rt.RTAG_ID = lx.RTAG_ID
 28 
                        left outer join lxr_state lx ON rt.RTAG_ID = lx.RTAG_ID
28 
                     WHERE rt.PROJ_ID = :PROJ_ID
 29 
                     WHERE rt.PROJ_ID = :PROJ_ID