Subversion Repositories DevTools

Rev

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

Rev 125 Rev 5382
Line 1... Line 1...
1 
SELECT pkg.pkg_name,
 1 
SELECT pkg.pkg_name,
2 
       pv.pkg_version,
 2 
       pv.pkg_version,
3 
       pv.is_autobuildable,
 3 
       pv.is_autobuildable,
4 
       pm.*,
 4 
       pm.*,
- 
 
 5 
       TO_CHAR( pm.created_stamp,'Dy DD-Mon-YYYY HH24:MI:SS AM' ) AS created_stamp,
5 
       (CASE
 6 
       (CASE
6 
         WHEN ut.test_types_fk IS NOT NULL AND ut.test_types_fk != 1 THEN 'Y' ELSE 'N'
 7 
         WHEN ut.test_types_fk IS NOT NULL AND ut.test_types_fk != 1 THEN 'Y' ELSE 'N'
7 
        END) AS unit_tested,
 8 
        END) AS unit_tested,
8 
       (CASE
 9 
       (CASE
9 
         WHEN ut.test_types_fk = 7 THEN 'Y' ELSE 'N'
 10 
         WHEN ut.test_types_fk = 7 THEN 'Y' ELSE 'N'