Subversion Repositories DevTools

Rev

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

Rev Author Line No. Line
13 rsolanki 1 
/* ReleaseManager Products View */
2 
SELECT pv.PV_ID AS PROD_ID,
3 
	   pkg.PKG_NAME,
4 
	   pv.PKG_VERSION,
5 
	   DECODE( osc.PROD_ID,
6 
	   		   NULL, '', 'disabled') AS USED,
7 
	   DECODE( pv.DLOCKED,
8 
	   		   'Y', 'LIMG_PRODUCT',
9 
			   'LIMG_PRODUCT_UNPACKAGED' ) AS ICON
10 
  FROM RELEASE_CONTENT rc,
11 
	   PACKAGES pkg,
12 
	   PACKAGE_VERSIONS pv,
13 
	   (
14 
	   	SELECT osc.PROD_ID
15 
		  FROM OS_CONTENTS osc
16 
		 WHERE osc.OS_ID = :OS_ID
17 
	   ) osc
18 
 WHERE rc.RTAG_ID = :RTAG_ID_FK
19 
   AND pv.PKG_ID = pkg.PKG_ID
20 
   AND rc.PV_ID = PV.PV_ID
23 rsolanki 21 
   AND (
22 
   	   	rc.BASE_VIEW_ID = :enumPRODUCTS_BASE_VIEW_ID
23 
		OR
24 
	 	rc.BASE_VIEW_ID = :enumAUTOPRODUCTS_BASE_VIEW_ID
25 
 	   )
13 rsolanki 26 
   AND osc.PROD_ID (+) = rc.PV_ID
27 
 ORDER BY UPPER(pkg.PKG_NAME), UPPER(pv.PKG_VERSION)