| 25 |
rsolanki |
1 |
/* Formatted on 2006/07/24 13:21 (Formatter Plus v4.8.6) */
|
|
|
2 |
|
|
|
3 |
|
|
|
4 |
/* All Base Configurations */
|
|
|
5 |
|
|
|
6 |
SELECT DISTINCT bec.prod_id, pkg.pkg_name, pkg_version
|
|
|
7 |
FROM boms bm,
|
|
|
8 |
bom_contents bc,
|
|
|
9 |
network_nodes nn,
|
|
|
10 |
operating_systems os,
|
|
|
11 |
os_base_env obe,
|
|
|
12 |
base_env_contents bec,
|
|
|
13 |
PACKAGES pkg,
|
|
|
14 |
package_versions pv,
|
|
|
15 |
base_env be,
|
|
|
16 |
bos_types bt
|
|
|
17 |
WHERE bm.bom_id = :bom_id
|
|
|
18 |
AND bm.bom_id = bc.bom_id
|
|
|
19 |
AND nn.node_id = bc.node_id
|
|
|
20 |
-- AND nn.node_type_id IN (1) -- For Database Servers
|
|
|
21 |
AND os.node_id = nn.node_id
|
|
|
22 |
AND obe.os_id = os.os_id
|
|
|
23 |
AND bec.base_env_id = obe.base_env_id
|
|
|
24 |
AND bec.prod_id = pv.pv_id
|
|
|
25 |
AND pkg.pkg_id = pv.pkg_id
|
|
|
26 |
AND be.base_env_id = obe.base_env_id
|
|
|
27 |
AND bt.bos_id = be.bos_id
|
|
|
28 |
ORDER BY UPPER(pkg.pkg_name), UPPER(pv.PKG_VERSION)
|
|
|
29 |
-- AND bt.bos_id IN (2) -- Solaris only
|
|
|
30 |
-- AND os.not_xml IS NULL
|
|
|
31 |
-- AND bec.not_xml IS NULL
|