Subversion Repositories DevTools

Rev

Rev 5939 | Go to most recent revision | Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
5925 dpurdie 1 
-- UsedByPackageDetail.sql
2 
-- Determine package versions that depend on a specific package name
3 
-- Provide the package version  id and version text
4 
SELECT DISTINCT
5 
       pkg.pkg_name, pv.pv_id, pv.PKG_VERSION, pv.DLOCKED, pv.MODIFIER_ID, pv.MODIFIED_STAMP, usr.FULL_NAME, usr.USER_EMAIL
6 
 FROM
7 
       package_dependencies dep,
8 
       package_versions pv,
9 
       packages pkg,
10 
       USERS usr
11 
 WHERE dep.pv_id = pv.pv_id
12 
   AND dep.dpv_id = :PV_ID
13 
   AND pv.PKG_ID = :PKG_ID
14 
   AND pv.pkg_id = pkg.pkg_id
15 
   AND pv.MODIFIER_ID = usr.USER_ID(+)
16 
ORDER by UPPER(pv.PKG_VERSION)