Subversion Repositories DevTools

Rev

Rev 13 | Details | Compare with Previous | Last modification | View Log | RSS feed

Rev Author Line No. Line
13 rsolanki 1 
/* Product Versions List */
2 
SELECT pv.pv_id,
3 
	   pv.pkg_version,
4 
	   DECODE ( pv.pv_id,
5 
	   		  	:OLD_PROD_ID, 'selected',
6 
				NULL ) AS selected
7 
  FROM PACKAGE_VERSIONS pv
8 
 WHERE pv.pkg_id = :PKG_ID
9 
   AND NVL( pv.V_EXT, 'LINK_NULL' ) = NVL ( :V_EXT, 'LINK_NULL')
10 
ORDER BY UPPER(pv.pkg_version)
11 
 
12