/* Product Details At Os */
SELECT osc.SEQ_NUM,
	   osc.PROD_ID,
	   osc.OS_ID,
	   osc.IS_NODE_SPEC,
	   pkg.PKG_NAME,
	   pkg.SUNOS_ELECTRONIC_NAME,
	   pkg.WIN_ELECTRONIC_NAME,
	   pkg.PKG_ID,
	   pv.PKG_VERSION,
          	   pv.IS_PATCH,	
	   pv.PATCH_ELECTRONIC_NAME,		
	   osc.PRODUCT_COMMENTS,
	   osc.NOT_XML	
  FROM OS_CONTENTS osc,
  	   PACKAGES pkg,
	   PACKAGE_VERSIONS pv
 WHERE osc.OS_ID = :OS_ID
   AND osc.PROD_ID = :PROD_ID
   AND pv.PKG_ID = pkg.PKG_ID
   AND osc.PROD_ID = pv.PV_ID 
