Subversion Repositories DevTools

-- UsedByPackageDetail.sql
-- Determine package versions that depend on a specific package name
-- Provide the package version  id and version text
SELECT DISTINCT
       pkg.pkg_name, pv.pv_id, pv.PKG_VERSION, pv.DLOCKED, pv.MODIFIER_ID, pv.MODIFIED_STAMP, usr.FULL_NAME, usr.USER_EMAIL
 FROM 
       package_dependencies dep,
       package_versions pv,
       packages pkg,
       USERS usr
 WHERE dep.pv_id = pv.pv_id
   AND dep.dpv_id = :PV_ID
   AND pv.PKG_ID = :PKG_ID
   AND pv.pkg_id = pkg.pkg_id
   AND pv.MODIFIER_ID = usr.USER_ID(+)
ORDER by UPPER(pv.PKG_VERSION)