| 25 |
rsolanki |
1 |
SELECT distinct pkg.pkg_name, pv.pkg_version, proj.proj_name, b.bom_id, nn.node_name, os.os_name, os.os_id,
|
|
|
2 |
br.branch_name, bn.bom_name, b.BOM_VERSION ||'.'|| b.BOM_LIFECYCLE AS VERSION, pv.pv_id
|
|
|
3 |
FROM package_versions pv, packages pkg, os_contents osc, operating_systems os,
|
|
|
4 |
network_nodes nn, bom_contents bc, boms b, bom_names bn,
|
|
|
5 |
branches br, dm_projects proj
|
|
|
6 |
WHERE pv.pkg_id = pkg.pkg_id
|
|
|
7 |
AND osc.prod_id = pv.pv_id
|
|
|
8 |
AND os.os_id = osc.os_id
|
|
|
9 |
AND nn.node_id = os.node_id
|
|
|
10 |
AND bc.node_id = nn.node_id
|
|
|
11 |
AND b.bom_id = bc.bom_id
|
|
|
12 |
AND bn.bom_name_id = b.bom_name_id
|
|
|
13 |
AND br.branch_id = b.branch_id
|
|
|
14 |
AND proj.proj_id = br.proj_id
|
|
|
15 |
AND br.is_hidden IS NULL
|
|
|
16 |
AND LOWER(pkg.pkg_name) LIKE LOWER('/*PKG_NAME*/')
|
|
|
17 |
AND NVL(LOWER(pv.v_ext),'LINK_A_NULL') LIKE NVL(LOWER('/*V_EXT*/'),'LINK_A_NULL')
|
|
|
18 |
ORDER BY UPPER(pv.pkg_version), proj.proj_name, br.branch_name, bn.bom_name, version, nn.node_name, os.os_name
|