Subversion Repositories DevTools

/* Paste Node List */
SELECT nn.NODE_ID AS ITEM_ID,
           nn.NODE_NAME AS ITEM_NAME,
           nt.NODE_ICON AS ITEM_ICON
  FROM BOM_CONTENTS bc,
           NETWORK_NODES nn,
           NODE_TYPES nt
 WHERE nn.NODE_TYPE_ID = nt.NODE_TYPE_ID
   AND bc.NODE_ID = nn.NODE_ID
   AND bc.BOM_ID = :FROM_ID
   AND nn.NODE_ID IN (
                                          SELECT *
                                            FROM THE ( SELECT CAST( IN_LIST_NUMBER( :ITEM_ID_LIST ) AS DEPMGR_NUMBER_TAB_t ) FROM dual ) 
                                         )      
 ORDER BY UPPER(nn.NODE_NAME)