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,
15 rsolanki 7 
	   bn.BOM_NAME ||''|| b.BOM_VERSION ||'.'|| b.BOM_LIFECYCLE AS VERSION
13 rsolanki 8 
  FROM BOM_CONTENTS bc,
9 
       NETWORK_NODES nn,
10 
	   BRANCHES br,
15 rsolanki 11 
	   BOMS b,
12 
	   BOM_NAMES bn
13 rsolanki 13 
 WHERE bc.NODE_ID = nn.NODE_ID
14 
   AND bc.BOM_ID = :BOM_ID
15 
   AND br.BRANCH_ID = b.BRANCH_ID
15 rsolanki 16 
   AND b.BOM_ID = bc.BOM_ID
17 
   AND bn.BOM_NAME_ID = b.BOM_NAME_ID