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