/* Paste Product List*/
SELECT osc.PROD_ID AS ITEM_ID,
	   pkg.PKG_NAME ||' '|| pv.PKG_VERSION AS ITEM_NAME,
	   'i_product.gif' AS ITEM_ICON 
  FROM OS_CONTENTS osc,
  	   PACKAGES pkg,
	   PACKAGE_VERSIONS pv
 WHERE osc.OS_ID = :FROM_ID
   AND pv.PKG_ID = pkg.PKG_ID
   AND osc.PROD_ID = pv.PV_ID
   AND osc.PROD_ID IN (
					   SELECT *
				   	     FROM THE ( SELECT CAST( IN_LIST_NUMBER( :ITEM_ID_LIST ) AS DEPMGR_NUMBER_TAB_t ) FROM dual ) 
   	   			   	   )
 ORDER BY UPPER(pkg.PKG_NAME)