Subversion Repositories DevTools

Rev

Go to most recent revision | Blame | Compare with Previous | Last modification | View Log | RSS feed 

SELECT pp.PATCH_ID, pv.PKG_VERSION, pkg.pkg_name
 FROM PACKAGE_PATCHES pp, PACKAGE_VERSIONS pv, PACKAGES pkg
 WHERE pp.PV_ID = (
                                  /* Patch Parent */
                                  SELECT pp.PV_ID
                                  FROM PACKAGE_PATCHES pp
                                  WHERE pp.PATCH_ID = :PV_ID
                                  )  
AND pv.PV_ID = pp.PATCH_ID
AND pkg.PKG_ID = pv.PKG_ID
ORDER BY PKG_VERSION