Subversion Repositories DevTools

Rev

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

Rev Author Line No. Line
13 rsolanki 1 
/* Network Nodes 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 
  FROM BOM_CONTENTS bc,
9 
       NETWORK_NODES nn,
10 
	   BRANCHES br,
11 
	   BOMS b
12 
 WHERE bc.NODE_ID = nn.NODE_ID
13 
   AND bc.BOM_ID = :BOM_ID
14 
   AND br.BRANCH_ID = b.BRANCH_ID
15 
   AND b.BOM_ID = bc.BOM_ID