Subversion Repositories DevTools

Rev

Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
119 ghuddy 1 
/* Process Name Search */
2 
 
3 
SELECT DISTINCT
4 
	   qry.proc_id,
5 
	   qry.proc_name,
6 
                 qry.run_as,
7 
	   qry.pkg_owner,
8 
   	   qry.is_interface,
9 
	   MIN(qry.display_order) OVER (PARTITION BY qry.proc_name) AS display_min,
10 
	   DECODE( qry.proc_name,
11 
	   		   ':PROCESS_NAME', 'checked' ) AS checked
12 
  FROM (
13 
		/* Show Process with exact match */
14 
		SELECT prc.proc_id,
15 
			   prc.proc_name,
16 
			   prc.run_as,
17 
			   prc.pkg_owner,
18 
			   prc.is_interface,
19 
			   1 AS display_order
20 
		  FROM PROCESSES prc
21 
		 WHERE prc.PROC_NAME = ':PROCESS_NAME'
22 
 
23 
		UNION
24 
 
25 
		/* Show Process with exact match (case ignored) */
26 
		SELECT prc.proc_id,
27 
			   prc.proc_name,
28 
			   prc.run_as,
29 
			   prc.pkg_owner,
30 
			   prc.is_interface,
31 
			   2 AS display_order
32 
		  FROM PROCESSES prc
33 
		 WHERE UPPER(prc.PROC_NAME) = UPPER(':PROCESS_NAME')
34 
 
35 
		UNION
36 
 
37 
		/* Show Process starting with name  */
38 
		SELECT prc.proc_id,
39 
			   prc.proc_name,
40 
			   prc.run_as,
41 
			   prc.pkg_owner,
42 
			   prc.is_interface,
43 
			   3 AS display_order
44 
		  FROM PROCESSES prc
45 
		 WHERE UPPER(prc.PROC_NAME) LIKE UPPER(':PROCESS_NAME%')
46 
 
47 
 
48 
		UNION
49 
 
50 
		/* Show Process with name   */
51 
		SELECT prc.proc_id,
52 
			   prc.proc_name,
53 
			   prc.run_as,
54 
			   prc.pkg_owner,
55 
			   prc.is_interface,
56 
			   4 AS display_order
57 
		  FROM PROCESSES prc
58 
		 WHERE UPPER(prc.PROC_NAME) LIKE UPPER('%:PROCESS_NAME%')
59 
  	   ) qry
60 
ORDER BY display_min