Subversion Repositories DevTools

Rev

Rev 15 | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 15 Rev 19
Line 2... Line 2...
2 
SELECT nn.NODE_ID,
 2 
SELECT nn.NODE_ID,
3 
	   nn.NODE_NAME,
 3 
	   nn.NODE_NAME,
4 
	   nn.NODE_VERSION,
 4 
	   nn.NODE_VERSION,
5 
	   nn.NODE_LIFE_CYCLE,
 5 
	   nn.NODE_LIFE_CYCLE,
6 
	   br.BRANCH_NAME,
 6 
	   br.BRANCH_NAME,
7 
	   b.BOM_VERSION ||'.'|| b.BOM_LIFECYCLE AS VERSION,
 7 
	   bm.BOM_NAME ||''|| b.BOM_VERSION ||'.'|| b.BOM_LIFECYCLE AS VERSION,
8 
	   os.NODE_SPEC_FILE,
 8 
	   os.NODE_SPEC_FILE,
9 
	   os.OS_NAME,
 9 
	   os.OS_NAME,
10 
	   bm.BOM_NAME,
 10 
	   bm.BOM_NAME,
11 
	   dp.PROJ_NAME,
 11 
	   dp.PROJ_NAME,
12 
	   os.OS_ID
 12 
	   os.OS_ID,
- 
 
 13 
	   b.BOM_VERSION ||'.'|| b.BOM_LIFECYCLE AS SBOM_VERSION
13 
  FROM BOM_CONTENTS bc,
 14 
  FROM BOM_CONTENTS bc,
14 
       NETWORK_NODES nn,
 15 
       NETWORK_NODES nn,
15 
	   BRANCHES br,
 16 
	   BRANCHES br,
16 
	   BOMS b,
 17 
	   BOMS b,
17 
	   OPERATING_SYSTEMS os,
 18 
	   OPERATING_SYSTEMS os,