Subversion Repositories DevTools

Rev

Rev 13 | Rev 19 | Go to most recent revision | Blame | Compare with Previous | Last modification | View Log | RSS feed 

/* 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,
           osc.PRODUCT_COMMENTS
  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