Subversion Repositories DevTools

Rev

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

Rev 5506 Rev 5632
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 
	   pv.build_time,
4 
       pm.*,
 5 
       pm.*,
5 
       TO_CHAR( pm.created_stamp,'Dy DD-Mon-YYYY HH24:MI:SS AM' ) AS created_stamp,
 6 
       TO_CHAR( pm.created_stamp,'Dy DD-Mon-YYYY HH24:MI:SS AM' ) AS created_stamp,
6 
       (CASE
 7 
       (CASE
7 
         WHEN ut.test_types_fk IS NOT NULL AND ut.test_types_fk != 1 THEN 'Y' ELSE 'N'
 8 
         WHEN ut.test_types_fk IS NOT NULL AND ut.test_types_fk != 1 THEN 'Y' ELSE 'N'
8 
        END) AS unit_tested,
 9 
        END) AS unit_tested,
Line 13... Line 14...
13 
       package_versions pv,
 14 
       package_versions pv,
14 
       packages pkg,
 15 
       packages pkg,
15 
       unit_tests ut
 16 
       unit_tests ut
16 
 WHERE pv.pkg_id = pkg.pkg_id
 17 
 WHERE pv.pkg_id = pkg.pkg_id
17 
   AND pv.pv_id = :PV_ID
 18 
   AND pv.pv_id = :PV_ID
18 
   AND pm.pv_id = pv.pv_id
 19 
   AND pm.pv_id (+) = pv.pv_id
19 
   AND ut.pv_id (+) = pv.pv_id
 20 
   AND ut.pv_id (+) = pv.pv_id