Subversion Repositories DevTools

Rev

Details | Last modification | View Log | RSS feed

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