Subversion Repositories DevTools

Rev

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

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