Subversion Repositories DevTools

Rev

Rev 64 | Blame | Compare with Previous | Last modification | View Log | RSS feed 

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