Subversion Repositories DevTools

Rev

Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
13 rsolanki 1 
/* Node List */
2 
SELECT nt.NODE_ICON,
3 
       nn.NODE_ID,
4 
	   nn.NODE_NAME,
5 
	   nn.NODE_COMMENTS,
6 
	   nn.NODE_VERSION,
7 
	   nn.NODE_LIFE_CYCLE
8 
  FROM BOM_CONTENTS bc,
9 
  	   NETWORK_NODES nn,
10 
	   NODE_TYPES nt
11 
 WHERE bc.NODE_ID = nn.NODE_ID
12 
   AND nn.NODE_TYPE_ID = nt.NODE_TYPE_ID
13 
   AND bc.BOM_ID = :BOM_ID
14 
 ORDER BY bc.SEQ_NUM, UPPER(nn.NODE_NAME)