| 6951 |
dpurdie |
1 |
select rc.pv_id, v.view_name, pv.pkg_id, p.pkg_name, pv.pkg_version, pv.v_ext,
|
|
|
2 |
TO_CHAR( pv.created_stamp,'DD-Mon-YYYY HH24:MI:SS' ) AS created_stamp,
|
|
|
3 |
pvc.pv_id as new_pv_id,
|
|
|
4 |
pvc.pkg_version as new_pkg_version,
|
|
|
5 |
TO_CHAR( pvc.created_stamp,'DD-Mon-YYYY HH24:MI:SS' ) AS new_created_stamp
|
|
|
6 |
from release_content rc, package_versions pv , package_versions pvc, packages p, views v
|
|
|
7 |
where rtag_id = :RTAG_ID and rc.sdktag_id is null and pv.pv_id = rc.pv_id
|
|
|
8 |
and p.pkg_id = pv.pkg_id
|
|
|
9 |
and NVL(pvc.v_ext, 'isNULL') = NVL(pv.v_ext, 'isNULL')
|
|
|
10 |
and pvc.pkg_id = pv.pkg_id
|
|
|
11 |
and pvc.created_stamp > pv.created_stamp
|
|
|
12 |
and pvc.build_type != 'Y'
|
|
|
13 |
and pvc.dlocked = 'Y'
|
|
|
14 |
and rc.base_view_id = v.view_id
|
|
|
15 |
order by UPPER(p.pkg_name), pvc.created_stamp desc
|