Subversion Repositories DevTools

Rev

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

Rev Author Line No. Line
2 rsolanki 1 
/* Data Tables */
2 
SELECT dt.DT_ID,
3 
	   dt.TABLE_NAME,
4 
	   dt.REF_COLUMN_NAME,
5 
	   dt.DISPLAY_COLUMN_NAME,
6 
	   DECODE ( filter_setting.FILTER_COUNT,
7 
	   		  	NULL, 'LIMG_DATA_TABLE_OFF',
8 
				'LIMG_DATA_TABLE' ) AS FILTER_SETTINGS
9 
 
10 
  FROM DATA_TABLES dt,
11 
  	   (
12 
 
13 
	    /* Get filter setting for this control */
14 
		SELECT dt.DT_ID,
15 
			   Count(*) AS FILTER_COUNT
16 
		  FROM DATA_TABLES dt,
17 
		  	   DATA_PERMISSIONS dp
18 
		 WHERE dp.DT_ID = dt.DT_ID
19 
		   AND dt.OBJ_ID = :OBJ_ID
20 
		   AND dp.ROLE_ID = :ROLE_ID
21 
		   AND dp.REF_COLUMN_VAL != 0
22 
		 GROUP BY dt.DT_ID
23 
 
24 
 
25 
		) filter_setting
26 
 
27 
 WHERE dt.OBJ_ID = :OBJ_ID
28 
   AND filter_setting.DT_ID (+) = dt.DT_ID
29 
ORDER BY UPPER(dt.TABLE_NAME)