Subversion Repositories DevTools

Rev

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

Rev 4081 Rev 4804
Line 10... Line 10...
10 
                           DECODE( rt.PARENT_RTAG_ID,
 10 
                           DECODE( rt.PARENT_RTAG_ID,
11 
                                   rt.RTAG_ID, 0, rt.PARENT_RTAG_ID ) AS PARENT_RTAG_ID,
 11 
                                   rt.RTAG_ID, 0, rt.PARENT_RTAG_ID ) AS PARENT_RTAG_ID,
12 
                           rt.OFFICIAL,
 12 
                           rt.OFFICIAL,
13 
                           rt.DESCRIPTION,
 13 
                           rt.DESCRIPTION,
14 
                     	   rt.ASSOC_MASS_REF,
 14 
                     	   rt.ASSOC_MASS_REF,
15 
				           rt.created_stamp,
 15 
				           TO_CHAR(rt.created_stamp,'DD-Mon-YYYY') AS created_stamp,
16 
                           U2.full_name as creator,
 16 
                           U2.full_name as creator,
17 
                           rt.OFFICIAL_STAMP,
 17 
                           rt.OFFICIAL_STAMP,
18 
                           DECODE(U1.full_name, NULL, 'Unknown', U1.full_name )as modifier
 18 
                           DECODE(U1.full_name, NULL, 'Unknown', U1.full_name )as modifier
19 
                     FROM RELEASE_TAGS rt
 19 
                     FROM RELEASE_TAGS rt
20 
                        left outer join users U1 on rt.official_id = U1.user_id
 20 
                        left outer join users U1 on rt.official_id = U1.user_id