| Line 8... |
Line 8... |
| 8 |
and bi.reason not in ('T')
|
8 |
and bi.reason not in ('T')
|
| 9 |
group by pv_id
|
9 |
group by pv_id
|
| 10 |
)
|
10 |
)
|
| 11 |
select rc.pv_id,cbi.build_id, pv.pkg_id, p.PKG_NAME, pv.V_EXT, p.PKG_NAME || pv.V_EXT as pkg_alias, pv.PKG_VERSION,
|
11 |
select rc.pv_id,cbi.build_id, pv.pkg_id, p.PKG_NAME, pv.V_EXT, p.PKG_NAME || pv.V_EXT as pkg_alias, pv.PKG_VERSION,
|
| 12 |
(select count(*) from test_run tr where tr.build_id = cbi.build_id) as test_count, pm.CODE_LINES, pv.is_deployable,
|
12 |
(select count(*) from test_run tr where tr.build_id = cbi.build_id) as test_count, pm.CODE_LINES, pv.is_deployable,
|
| 13 |
TO_CHAR(bi.timestamp,'DD-Mon-YYYY HH24:MI:SS') AS lastBuild, pv.build_time, rc.base_view_id, v.view_name
|
13 |
TO_CHAR(bi.timestamp,'DD-Mon-YYYY HH24:MI:SS') AS lastBuild, pv.build_time, rc.base_view_id, v.view_name, NVL2(rc.sdktag_id, 'Y', 'N') AS isSdk
|
| 14 |
from RELEASE_CONTENT rc, PACKAGE_VERSIONS pv, packages p, CLEAN_BI cbi, BUILD_INSTANCES bi, PACKAGE_METRICS pm, views v
|
14 |
from RELEASE_CONTENT rc, PACKAGE_VERSIONS pv, packages p, CLEAN_BI cbi, BUILD_INSTANCES bi, PACKAGE_METRICS pm, views v
|
| 15 |
where rc.RTAG_ID = :RTAG_ID
|
15 |
where rc.RTAG_ID = :RTAG_ID
|
| 16 |
and rc.pv_id = pv.pv_id
|
16 |
and rc.pv_id = pv.pv_id
|
| 17 |
and p.pkg_id = pv.pkg_id
|
17 |
and p.pkg_id = pv.pkg_id
|
| 18 |
and cbi.pv_id(+) = pv.pv_id
|
18 |
and cbi.pv_id(+) = pv.pv_id
|