Subversion Repositories DevTools

Rev

Rev 119 | Details | Compare with Previous | Last modification | View Log | RSS feed

Rev Author Line No. Line
119 ghuddy 1 
SELECT pp.PATCH_ID, pv.PKG_VERSION, pkg.pkg_name
2 
 FROM PACKAGE_PATCHES pp, PACKAGE_VERSIONS pv, PACKAGES pkg
3 
 WHERE pp.PV_ID = (
4 
  	   			  /* Patch Parent */
5 
				  SELECT pp.PV_ID
6 
				  FROM PACKAGE_PATCHES pp
7 
				  WHERE pp.PATCH_ID = :PV_ID
8 
  	   			  )
9 
AND pv.PV_ID = pp.PATCH_ID
10 
AND pkg.PKG_ID = pv.PKG_ID
11 
ORDER BY PKG_VERSION