Subversion Repositories DevTools

Rev

Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
13 rsolanki 1 
/* Product Details At Os */
2 
SELECT osc.SEQ_NUM,
3 
	   osc.PROD_ID,
4 
	   osc.OS_ID,
5 
	   pkg.PKG_NAME,
6 
	   pkg.PKG_ID,
7 
	   pv.PKG_VERSION,
8 
	   osc.PRODUCT_COMMENTS
9 
  FROM OS_CONTENTS osc,
10 
  	   PACKAGES pkg,
11 
	   PACKAGE_VERSIONS pv
12 
 WHERE osc.OS_ID = :OS_ID
13 
   AND osc.PROD_ID = :PROD_ID
14 
   AND pv.PKG_ID = pkg.PKG_ID
15 
   AND osc.PROD_ID = pv.PV_ID