Subversion Repositories DevTools

Rev

Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
64 jtweddle 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,
7 
	   b.BOM_VERSION ||'.'|| b.BOM_LIFECYCLE AS VERSION,
8 
	   os.NODE_SPEC_FILE,
9 
	   os.OS_NAME,
10 
	   bm.BOM_NAME,
11 
	   dp.PROJ_NAME,
12 
	   os.OS_ID
13 
  FROM BOM_CONTENTS bc,
14 
       NETWORK_NODES nn,
15 
	   BRANCHES br,
16 
	   BOMS b,
17 
	   OPERATING_SYSTEMS os,
18 
	   BOM_NAMES bm,
19 
	   DM_PROJECTS dp
20 
 WHERE bc.NODE_ID = nn.NODE_ID
21 
   AND bc.BOM_ID = :BOM_ID
22 
   AND br.BRANCH_ID = b.BRANCH_ID
23 
   AND b.BOM_ID = bc.BOM_ID
24 
   AND os.NODE_ID = nn.NODE_ID
25 
   AND os.NODE_SPEC_FILE IS NOT NULL
26 
   AND bm.BOM_NAME_ID = b.BOM_NAME_ID
27 
   AND dp.PROJ_ID = br.PROJ_ID
28 
 
29