Subversion Repositories DevTools

Rev

Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
64 jtweddle 1 
SELECT
2 
	   prj.PROJ_NAME, br.BRANCH_NAME, bn.BOM_NAME,
3 
	   b.BOM_VERSION ||'.'|| b.BOM_LIFECYCLE AS SBOM_VERSION,
4 
	   b.BOM_VERSION,
5 
	   b.BOM_LIFECYCLE,
6 
	   nn.NODE_NAME,
7 
	   os.OS_NAME,
8 
	   os.NODE_SPEC_FILE
9 
FROM
10 
	   BOMS b,
11 
	   BRANCHES br,
12 
	   DM_PROJECTS prj,
13 
	   OPERATING_SYSTEMS os,
14 
	   NETWORK_NODES nn,
15 
	   BOM_CONTENTS bc,
16 
	   BOM_NAMES bn
17 
WHERE
18 
	   os.OS_ID = :OS_ID
19 
AND    b.BRANCH_ID = br.BRANCH_ID
20 
AND    br.PROJ_ID = prj.PROJ_ID
21 
AND    os.NODE_ID = nn.NODE_ID
22 
AND    bc.NODE_ID = nn.NODE_ID
23 
AND    bc.BOM_ID = b.BOM_ID
24 
AND    bn.BOM_NAME_ID = b.BOM_NAME_ID
25 
 
26 
 
27 
 
28