Subversion Repositories DevTools

select rc.pv_id, v.view_name, pv.pkg_id, p.pkg_name, pv.pkg_version, pv.v_ext,
    TO_CHAR( pv.created_stamp,'DD-Mon-YYYY HH24:MI:SS' ) AS created_stamp, 
    pvc.pv_id as new_pv_id, 
    pvc.pkg_version as new_pkg_version, 
    TO_CHAR( pvc.created_stamp,'DD-Mon-YYYY HH24:MI:SS' ) AS new_created_stamp
from release_content rc, package_versions pv , package_versions pvc, packages p, views v
where rtag_id = :RTAG_ID and rc.sdktag_id is null and pv.pv_id = rc.pv_id
and p.pkg_id = pv.pkg_id
and NVL(pvc.v_ext, 'isNULL') = NVL(pv.v_ext, 'isNULL')
and pvc.pkg_id = pv.pkg_id
and pvc.created_stamp > pv.created_stamp
and pvc.build_type != 'Y'
and pvc.dlocked = 'Y'
and rc.base_view_id = v.view_id
order by UPPER(p.pkg_name), pvc.created_stamp desc