/* Product Details At Base Env */
SELECT bec.SEQ_NUM,
	   bec.PROD_ID,
                 bec.IS_NODE_SPEC,
	   bec.BASE_ENV_ID,
	   pkg.PKG_NAME,
	   pkg.SUNOS_ELECTRONIC_NAME,
	   pkg.WIN_ELECTRONIC_NAME,
	   pkg.PKG_ID,
	   pv.PKG_VERSION,
	   pv.IS_PATCH,
	   pv.PATCH_ELECTRONIC_NAME,
	   bec.BASE_ENV_COMMENTS AS PRODUCT_COMMENTS,
	   bec.NOT_XML	
  FROM BASE_ENV_CONTENTS bec,
  	   PACKAGES pkg,
	   PACKAGE_VERSIONS pv
 WHERE bec.BASE_ENV_ID = :BASE_ENV_ID
   AND bec.PROD_ID = :PROD_ID
   AND pv.PKG_ID = pkg.PKG_ID
   AND bec.PROD_ID = pv.PV_ID 
