Subversion Repositories DevTools

Rev

Go to most recent revision | Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
15 rsolanki 1 
/* Network Nodes Spec Files List */
2 
SELECT nn.NODE_ID,
3 
	   nn.NODE_NAME,
4 
	   nn.NODE_VERSION,
5 
	   nn.NODE_LIFE_CYCLE,
6 
	   br.BRANCH_NAME,
19 rsolanki 7 
	   bm.BOM_NAME ||''|| b.BOM_VERSION ||'.'|| b.BOM_LIFECYCLE AS VERSION,
15 rsolanki 8 
	   os.NODE_SPEC_FILE,
9 
	   os.OS_NAME,
10 
	   bm.BOM_NAME,
11 
	   dp.PROJ_NAME,
19 rsolanki 12 
	   os.OS_ID,
13 
	   b.BOM_VERSION ||'.'|| b.BOM_LIFECYCLE AS SBOM_VERSION
15 rsolanki 14 
  FROM BOM_CONTENTS bc,
15 
       NETWORK_NODES nn,
16 
	   BRANCHES br,
17 
	   BOMS b,
18 
	   OPERATING_SYSTEMS os,
19 
	   BOM_NAMES bm,
20 
	   DM_PROJECTS dp
21 
 WHERE bc.NODE_ID = nn.NODE_ID
22 
   AND bc.BOM_ID = :BOM_ID
23 
   AND br.BRANCH_ID = b.BRANCH_ID
24 
   AND b.BOM_ID = bc.BOM_ID
25 
   AND os.NODE_ID = nn.NODE_ID
26 
   AND os.NODE_SPEC_FILE IS NOT NULL
27 
   AND bm.BOM_NAME_ID = b.BOM_NAME_ID
28 
   AND dp.PROJ_ID = br.PROJ_ID
29 
 
30