Details |
Last modification |
View Log
| RSS feed
| Rev |
Author |
Line No. |
Line |
| 64 |
jtweddle |
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)
|