Subversion Repositories DevTools

Rev

Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
13 rsolanki 1 
/* Product Details At Base Env */
2 
SELECT bec.SEQ_NUM,
3 
	   bec.PROD_ID,
15 rsolanki 4 
                 bec.IS_NODE_SPEC,
13 rsolanki 5 
	   bec.BASE_ENV_ID,
6 
	   pkg.PKG_NAME,
15 rsolanki 7 
	   pkg.SUNOS_ELECTRONIC_NAME,
8 
	   pkg.WIN_ELECTRONIC_NAME,
13 rsolanki 9 
	   pkg.PKG_ID,
10 
	   pv.PKG_VERSION,
19 rsolanki 11 
	   pv.IS_PATCH,
12 
	   pv.PATCH_ELECTRONIC_NAME,
13 
	   bec.BASE_ENV_COMMENTS AS PRODUCT_COMMENTS,
14 
	   bec.NOT_XML
13 rsolanki 15 
  FROM BASE_ENV_CONTENTS bec,
16 
  	   PACKAGES pkg,
17 
	   PACKAGE_VERSIONS pv
18 
 WHERE bec.BASE_ENV_ID = :BASE_ENV_ID
19 
   AND bec.PROD_ID = :PROD_ID
20 
   AND pv.PKG_ID = pkg.PKG_ID
21 
   AND bec.PROD_ID = pv.PV_ID