Subversion Repositories DevTools

Rev

Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
13 rsolanki 1 
SELECT
2 
	   prj.PROJ_NAME, br.BRANCH_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 
FROM
9 
	   BOMS b,
10 
	   BRANCHES br,
11 
	   DM_PROJECTS prj,
12 
	   OPERATING_SYSTEMS os,
13 
	   NETWORK_NODES nn
14 
WHERE
15 
	   b.BOM_ID = :BOM_ID
16 
AND    os.OS_ID = :OS_IDA
17 
AND    b.BRANCH_ID = br.BRANCH_ID
18 
AND    br.PROJ_ID = prj.PROJ_ID
19 
AND    os.NODE_ID = nn.NODE_ID
20 
 
21 
 
22 
 
23