Subversion Repositories DevTools

Rev

Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
23 rsolanki 1 
 
2 
SELECT pv.PV_ID AS PROD_ID,
3 
	   pkg.PKG_NAME,
4 
	   pv.PKG_VERSION,
5 
	   DECODE( prc.PROD_ID,
6 
	   		   NULL, '', 'disabled') AS USED,
7 
	   DECODE( pv.DLOCKED,
8 
	   		   'Y', 'LIMG_PRODUCT',
9 
			   'LIMG_PRODUCT_UNPACKAGED' ) AS ICON,
10 
	   pp.PROC_ID
11 
  FROM RELEASE_CONTENT rc,
12 
	   PACKAGES pkg,
13 
	   PACKAGE_VERSIONS pv,
14 
	   RELEASE_MANAGER.PACKAGE_PROCESSES pp,
15 
	   (
16 
	   	SELECT osc.PROD_ID, osc.OS_ID
17 
		  FROM OS_CONTENTS osc
18 
		 WHERE osc.OS_ID = 14637
19 
	   ) osc,
20 
	   (
21 
	   SELECT prc.PROD_ID, prc.PROC_ID
22 
	   	 FROM PROCESSES_CONFIG prc
23 
		 WHERE prc.OS_ID = 14637
24 
	   ) prc
25 
 WHERE rc.RTAG_ID = 3761
26 
   AND pv.PKG_ID = pkg.PKG_ID
27 
   AND rc.PV_ID = PV.PV_ID
28 
   AND rc.BASE_VIEW_ID = 5
29 
   AND osc.PROD_ID (+) = rc.PV_ID
30 
   AND pp.PV_ID = osc.PROD_ID
31 
   AND prc.PROC_ID (+) = pp.PROC_ID
32 
 ORDER BY UPPER(pkg.PKG_NAME), UPPER(pv.PKG_VERSION)