| Line 6... |
Line 6... |
| 6 |
pm.branches,
|
6 |
pm.branches,
|
| 7 |
(CASE WHEN ut.test_types_fk IS NOT NULL AND ut.test_types_fk != 1 THEN 'Y' ELSE 'N' END) AS unit_tested,
|
7 |
(CASE WHEN ut.test_types_fk IS NOT NULL AND ut.test_types_fk != 1 THEN 'Y' ELSE 'N' END) AS unit_tested,
|
| 8 |
autotest_qry.autotested,
|
8 |
autotest_qry.autotested,
|
| 9 |
(select count(*) from test_run tr where tr.build_id = cbi.build_id) as test_count,
|
9 |
(select count(*) from test_run tr where tr.build_id = cbi.build_id) as test_count,
|
| 10 |
TO_CHAR( modified_stamp,'DD-Mon-YYYY HH24:MI:SS' ) AS modified_stamp,
|
10 |
TO_CHAR( modified_stamp,'DD-Mon-YYYY HH24:MI:SS' ) AS modified_stamp,
|
| 11 |
(CASE WHEN pv.is_autobuildable != 'Y' THEN 'Manual' ELSE (CASE bi.reason WHEN 'R' THEN 'Ripple' WHEN 'N' THEN 'New Version' ELSE 'Unknown' END ) END) as reason
|
11 |
(CASE WHEN pv.is_autobuildable != 'Y' THEN 'Manual' ELSE (CASE bi.reason WHEN 'R' THEN 'Ripple' WHEN 'N' THEN 'New Version' ELSE 'Unknown' END ) END) as reason,
|
| - |
|
12 |
(CASE WHEN pv.pv_id = :PV_ID THEN 1 ELSE 0 END )as inRelease,
|
| - |
|
13 |
TRUNC( ORA_SYSDATE - modified_stamp ) as ageDays
|
| 12 |
FROM package_metrics pm,
|
14 |
FROM package_metrics pm,
|
| 13 |
package_versions pv,
|
15 |
package_versions pv,
|
| 14 |
packages pkg,
|
16 |
packages pkg,
|
| 15 |
unit_tests ut,
|
17 |
unit_tests ut,
|
| 16 |
(SELECT ut.pv_id, 'Y' AS autotested FROM unit_tests ut WHERE ut.test_types_fk = 7 ) autotest_qry,
|
18 |
(SELECT ut.pv_id, 'Y' AS autotested FROM unit_tests ut WHERE ut.test_types_fk = 7 ) autotest_qry,
|