Subversion Repositories DevTools

Rev

Rev 5506 | Details | Compare with Previous | Last modification | View Log | RSS feed

Rev Author Line No. Line
119 ghuddy 1 
SELECT pkg.pkg_name,
2 
       pv.pkg_version,
3 
       pv.is_autobuildable,
5632 dpurdie 4 
	   pv.build_time,
119 ghuddy 5 
       pm.*,
5382 dpurdie 6 
       TO_CHAR( pm.created_stamp,'Dy DD-Mon-YYYY HH24:MI:SS AM' ) AS created_stamp,
119 ghuddy 7 
       (CASE
125 ghuddy 8 
         WHEN ut.test_types_fk IS NOT NULL AND ut.test_types_fk != 1 THEN 'Y' ELSE 'N'
119 ghuddy 9 
        END) AS unit_tested,
10 
       (CASE
11 
         WHEN ut.test_types_fk = 7 THEN 'Y' ELSE 'N'
12 
        END) AS autotested
13 
  FROM package_metrics pm,
14 
       package_versions pv,
15 
       packages pkg,
16 
       unit_tests ut
17 
 WHERE pv.pkg_id = pkg.pkg_id
18 
   AND pv.pv_id = :PV_ID
5632 dpurdie 19 
   AND pm.pv_id (+) = pv.pv_id
125 ghuddy 20 
   AND ut.pv_id (+) = pv.pv_id