| Line 10... |
Line 10... |
| 10 |
DECODE( rt.official ,
|
10 |
DECODE( rt.official ,
|
| 11 |
'Y', CASE WHEN TRUNC (SYSDATE - rt.official_stamp) > 60 THEN 'O' ELSE 'Y' END,
|
11 |
'Y', CASE WHEN TRUNC (SYSDATE - rt.official_stamp) > 60 THEN 'O' ELSE 'Y' END,
|
| 12 |
rt.official ) as OFFICIAL,
|
12 |
rt.official ) as OFFICIAL,
|
| 13 |
rt.DESCRIPTION,
|
13 |
rt.DESCRIPTION,
|
| 14 |
rt.ASSOC_MASS_REF,
|
14 |
rt.ASSOC_MASS_REF,
|
| 15 |
TO_CHAR(rt.created_stamp,'DD-Mon-YYYY') AS created_stamp,
|
15 |
TO_CHAR(rt.created_stamp,'DD-Mon-YYYY HH24:MI:SS') AS created_stamp,
|
| 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 HH24:MI:SS') 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 |
NVL(RT.S3MANIFEST, 'N') AS S3MANIFEST ,
|
22 |
NVL(RT.S3MANIFEST, 'N') AS S3MANIFEST ,
|
| 23 |
CASE when (TRUNC(SYSTIMESTAMP) - TRUNC(rt.created_stamp) <= 20) AND rt.creator_id = :USER_ID THEN 1 ELSE 0 END as userCanDelete,
|
23 |
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,
|
| 24 |
TO_CHAR(rm.timestamp,'DD-Mon-YYYY HH24:MI:SS') AS lastModified ,
|
24 |
TO_CHAR(rm.timestamp,'DD-Mon-YYYY HH24:MI:SS') AS lastModified ,
|
| 25 |
EXTRACT(DAY FROM (SYSTIMESTAMP - rm.timestamp)) as lastModified_DAYS
|
25 |
EXTRACT(DAY FROM (SYSTIMESTAMP - rm.timestamp)) as lastModified_DAYS
|
| 26 |
FROM RELEASE_TAGS rt
|
26 |
FROM RELEASE_TAGS rt
|
| 27 |
left outer join users U1 on rt.official_id = U1.user_id
|
27 |
left outer join users U1 on rt.official_id = U1.user_id
|
| 28 |
left outer join users U2 on rt.creator_id = U2.user_id
|
28 |
left outer join users U2 on rt.creator_id = U2.user_id
|
| 29 |
left outer join lxr_state lx ON rt.RTAG_ID = lx.RTAG_ID
|
29 |
left outer join lxr_state lx ON rt.RTAG_ID = lx.RTAG_ID
|
| 30 |
left outer join release_modified rm ON rt.RTAG_ID = rm.RTAG_ID
|
30 |
left outer join release_modified rm ON rt.RTAG_ID = rm.RTAG_ID
|
| 31 |
WHERE rt.PROJ_ID = :PROJ_ID
|
31 |
WHERE rt.PROJ_ID = :PROJ_ID
|
| - |
|
32 |
/*TREE_FILTER*/
|
| 32 |
) rel
|
33 |
) rel
|
| 33 |
START WITH rel.PARENT_RTAG_ID = 0
|
34 |
START WITH rel.PARENT_RTAG_ID = 0
|
| 34 |
CONNECT BY PRIOR rel.RTAG_ID = rel.PARENT_RTAG_ID
|
35 |
CONNECT BY PRIOR rel.RTAG_ID = rel.PARENT_RTAG_ID
|
| 35 |
ORDER SIBLINGS BY rel.DISPLAY_ORDER
|
36 |
ORDER SIBLINGS BY rel.DISPLAY_ORDER
|
| 36 |
|
37 |
|
| 37 |
|
38 |
|