Subversion Repositories DevTools

Rev

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

Rev Author Line No. Line
13 rsolanki 1 
/* OS Processes */
2 
SELECT prc.PROC_ID,
3 
	   prc.PV_ID AS PROD_ID,
4 
	   prc.PROC_NAME,
5 
	   prc.PROC_DESCRIPTION,
6 
	   prc.RUN_AS,
7 
	   pc.PKG_HEALTH_TAG,
8 
	   pc.CMD_INTERFACE,
9 
	   pkg.PKG_NAME,
10 
	   pv.PKG_VERSION
11 
  FROM PROCESSES prc,
12 
  	   OS_CONTENTS osc,
13 
	   (
14 
	   	SELECT pc.*
15 
		  FROM PROCESSES_CONFIG pc
16 
		 WHERE pc.OS_ID = :OS_ID
17 
	   ) pc,
18 
	   PACKAGES pkg,
19 
	   PACKAGE_VERSIONS pv
20 
 WHERE prc.PV_ID = osc.PROD_ID
21 
   AND pc.PROC_ID (+)= prc.PROC_ID
22 
   AND osc.OS_ID = :OS_ID
23 
   AND pv.PKG_ID = pkg.PKG_ID
24 
   AND prc.PV_ID = pv.PV_ID
25 
ORDER BY UPPER(pkg.pkg_name), UPPER(pv.PKG_VERSION), UPPER(prc.proc_name)
26