Subversion Repositories DevTools

/* Common Database Server Products - Solaris */

SELECT distinct pv.pv_id, pkg.pkg_name, pkg.sunos_electronic_name, pv.patch_electronic_name, pv.pkg_version, count(1) AS NUM 
--nn.node_name, --nn.node_name, pv.pv_id, pkg.*, pv.patch_electronic_name, pkg_version
           FROM boms bm,
                bom_contents bc,
                network_nodes nn,
                operating_systems os,
                os_contents osc,
                PACKAGES pkg,
                package_versions pv,
                bos_types bt
          WHERE bm.bom_id = :bom_id
            AND bm.bom_id = bc.bom_id
            AND nn.node_id = bc.node_id
            AND nn.node_type_id IN (1)                 -- For Database Servers
            AND os.node_id = nn.node_id
            AND osc.os_id = os.os_id
            AND osc.prod_id = pv.pv_id
            AND pkg.pkg_id = pv.pkg_id
            AND bt.bos_id IN (2)                               -- Solaris only
            AND os.not_xml IS NULL
            AND osc.not_xml IS NULL
                        group by pv.pv_id, pkg.pkg_name, pkg.sunos_electronic_name, pv.patch_electronic_name, pv.pkg_version
                        order by pkg.pkg_name