Subversion Repositories DevTools

/* 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)