Subversion Repositories DevTools

Rev

Go to most recent revision | Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
13 rsolanki 1 
/* Paste Product List*/
2 
SELECT osc.PROD_ID AS ITEM_ID,
3 
	   pkg.PKG_NAME ||' '|| pv.PKG_VERSION AS ITEM_NAME,
4 
	   'i_product.gif' AS ITEM_ICON
5 
  FROM OS_CONTENTS osc,
6 
  	   PACKAGES pkg,
7 
	   PACKAGE_VERSIONS pv
8 
 WHERE osc.OS_ID = :FROM_ID
9 
   AND pv.PKG_ID = pkg.PKG_ID
10 
   AND osc.PROD_ID = pv.PV_ID
11 
   AND osc.PROD_ID IN (
12 
					   SELECT *
13 
				   	     FROM THE ( SELECT CAST( IN_LIST_NUMBER( :ITEM_ID_LIST ) AS DEPMGR_NUMBER_TAB_t ) FROM dual )
14 
   	   			   	   )
15 
 ORDER BY UPPER(pkg.PKG_NAME)