| 119 |
ghuddy |
1 |
SELECT distinct b.bom_id,
|
|
|
2 |
br.branch_name, bn.bom_name, b.BOM_VERSION ||'.'|| b.BOM_LIFECYCLE AS VERSION
|
|
|
3 |
FROM package_versions pv, packages pkg, deployment_manager.os_contents osc,
|
|
|
4 |
deployment_manager.operating_systems os,
|
|
|
5 |
deployment_manager.network_nodes nn, deployment_manager.bom_contents bc,
|
|
|
6 |
deployment_manager.boms b, deployment_manager.bom_names bn,
|
|
|
7 |
deployment_manager.branches br, deployment_manager.dm_projects proj
|
|
|
8 |
WHERE pv.pkg_id = pkg.pkg_id
|
|
|
9 |
AND osc.prod_id = pv.pv_id
|
|
|
10 |
AND os.os_id = osc.os_id
|
|
|
11 |
AND nn.node_id = os.node_id
|
|
|
12 |
AND bc.node_id = nn.node_id
|
|
|
13 |
AND b.bom_id = bc.bom_id
|
|
|
14 |
AND bn.bom_name_id = b.bom_name_id
|
|
|
15 |
AND br.branch_id = b.branch_id
|
|
|
16 |
AND proj.proj_id = br.proj_id
|
|
|
17 |
AND br.is_hidden IS NULL
|
|
|
18 |
AND pv.pv_id = :PV_ID
|
|
|
19 |
ORDER BY b.bom_id
|