/* Network Node List */
SELECT nn.NODE_ID,
	   nt.NODE_ICON,
	   nn.NODE_NAME
  FROM NETWORK_NODES nn,
  	   BOM_CONTENTS bc,
	   NODE_TYPES nt
 WHERE bc.NODE_ID = nn.NODE_ID
   AND nn.NODE_TYPE_ID = nt.NODE_TYPE_ID
   AND bc.BOM_ID = :BOM_ID
ORDER BY UPPER(nn.NODE_NAME)   