Subversion Repositories DevTools

Rev

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

Rev 5177 Rev 5207
Line 16... Line 16...
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') 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') 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 
                     FROM RELEASE_TAGS rt
 23 
                     FROM RELEASE_TAGS rt
23 
                        left outer join users U1 on rt.official_id = U1.user_id
 24 
                        left outer join users U1 on rt.official_id = U1.user_id
24 
                        left outer join users U2 on rt.creator_id = U2.user_id
 25 
                        left outer join users U2 on rt.creator_id = U2.user_id
25 
                     WHERE rt.PROJ_ID = :PROJ_ID
 26 
                     WHERE rt.PROJ_ID = :PROJ_ID
26 
                    ) rel
 27 
                    ) rel