Subversion Repositories DevTools

Rev

Rev 13 | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 13 Rev 15
Line 1... Line 1...
1 
/* Export Os Product List */
 1 
/* Export Os Product List */
2 
SELECT osc.PROD_ID,
 2 
SELECT osc.PROD_ID,
3 
	   pkg.PKG_NAME,
 3 
	   pkg.PKG_NAME,
- 
 
 4 
	   pkg.SUNOS_ELECTRONIC_NAME,
- 
 
 5 
	   pkg.WIN_ELECTRONIC_NAME,
4 
	   pv.PKG_VERSION,
 6 
	   pv.PKG_VERSION,
5 
	   pv.PV_DESCRIPTION,
 7 
	   pv.PV_DESCRIPTION,
6 
	   pv.V_EXT
 8 
	   pv.V_EXT
7 
  FROM OS_CONTENTS osc,
 9 
  FROM OS_CONTENTS osc,
8 
  	   PACKAGE_VERSIONS pv,
 10 
  	   PACKAGE_VERSIONS pv,
9 
	   PACKAGES pkg
 11 
	   PACKAGES pkg
10 
 WHERE osc.OS_ID = :OS_ID
12 
 WHERE osc.OS_ID = :OS_ID
11 
   AND osc.PROD_ID = pv.PV_ID
 13 
   AND osc.PROD_ID = pv.PV_ID
12 
   AND pv.PKG_ID = pkg.PKG_ID
14 
   AND pv.PKG_ID = pkg.PKG_ID
- 
 
 15 
   AND osc.IS_NODE_SPEC IS NOT NULL
13 
 ORDER BY UPPER(pkg.PKG_NAME)
16 
 ORDER BY UPPER(pkg.PKG_NAME)