Subversion Repositories DevTools

/* Node List */
SELECT nt.NODE_ICON,
       nn.NODE_ID,
           nn.NODE_NAME,
           nn.NODE_COMMENTS,
           nn.NODE_VERSION,
           nn.NODE_LIFE_CYCLE
  FROM BOM_CONTENTS bc,
           NETWORK_NODES nn,
           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 bc.SEQ_NUM, UPPER(nn.NODE_NAME)