| 13 |
rsolanki |
1 |
SELECT prj.PROJ_NAME, nn.NODE_NAME, nn.NODE_VERSION,
|
|
|
2 |
br.BRANCH_NAME, br.BRANCH_ID, b.BOM_ID, bc.NODE_ID,
|
|
|
3 |
os.OS_ID, osc.PROD_ID, pv.PV_ID, p.PKG_NAME, pv.PKG_VERSION
|
|
|
4 |
FROM NETWORK_NODES nn, PROJECTS prj, BRANCHES br,
|
|
|
5 |
BOMS b, BOM_CONTENTS bc, OPERATING_SYSTEMS os,
|
|
|
6 |
OS_CONTENTS osc, PACKAGE_VERSIONS pv, PACKAGES p
|
|
|
7 |
WHERE nn.NODE_NAME = :NODE_NAME
|
|
|
8 |
AND prj.PROJ_NAME = :PROJ_NAME
|
|
|
9 |
AND prj.PROJ_ID = br.PROJ_ID
|
|
|
10 |
AND br.BRANCH_NAME = :BRANCH_NAME
|
|
|
11 |
AND b.BOM_VERSION = :BOM_VERSION
|
|
|
12 |
AND b.BOM_LIFECYCLE = :BOM_LIFECYCLE
|
|
|
13 |
AND bc.BOM_ID = b.BOM_ID
|
|
|
14 |
AND nn.NODE_ID = bc.NODE_ID
|
|
|
15 |
AND os.OS_NAME = :OS_NAME
|
|
|
16 |
AND os.NODE_ID = nn.NODE_ID
|
|
|
17 |
AND os.OS_ID = osc.OS_ID
|
|
|
18 |
AND pv.PV_ID = osc.PROD_ID
|
|
|
19 |
AND pv.IS_PATCH = 'Y'
|
|
|
20 |
AND p.PKG_ID = pv.PKG_ID
|
|
|
21 |
ORDER BY osc.SEQ_NUM
|