Subversion Repositories DevTools

Rev

Rev 64 | Blame | Compare with Previous | Last modification | View Log | RSS feed

/* Export Os Product List */
SELECT osc.PROD_ID,
           pkg.PKG_NAME,
           pkg.SUNOS_ELECTRONIC_NAME,
           pkg.WIN_ELECTRONIC_NAME,
           pv.PKG_VERSION,
           pv.PV_DESCRIPTION,
           pv.V_EXT
  FROM OS_CONTENTS osc,
           PACKAGE_VERSIONS pv,
           PACKAGES pkg
 WHERE osc.OS_ID = :OS_ID 
   AND osc.PROD_ID = pv.PV_ID
   AND pv.PKG_ID = pkg.PKG_ID 
   AND osc.IS_NODE_SPEC IS NOT NULL
 ORDER BY UPPER(pkg.PKG_NAME)