Subversion Repositories DevTools

/* Table Filter Settings */
SELECT rdt./*REF_COLUMN*/ AS ref_col,
           rdt./*DISPLAY_COLUMN*/ AS display_col,
           perm_active.perm_id AS active_id,
           perm_active.perm_value AS active_value,
           perm_visible.perm_id AS visible_id,
           perm_visible.perm_value AS visible_value
  FROM
           (
           
                SELECT dt./*REF_COLUMN*/,
                           dt./*DISPLAY_COLUMN*/
                  FROM /*TABLE_NAME*/ dt
                  
           ) rdt,
           (
           
                SELECT dp.*
                  FROM DATA_PERMISSIONS dp
                 WHERE dp.dt_id = :DT_ID
                   AND dp.role_id = :ROLE_ID
                   AND dp.perm_id = 1   /* Visible */  
                   
           ) perm_visible,
           (
           
                SELECT dp.*
                  FROM DATA_PERMISSIONS dp
                 WHERE dp.dt_id = :DT_ID
                   AND dp.role_id = :ROLE_ID
                   AND dp.perm_id = 2  /* Active */
                   
           ) perm_active
 WHERE perm_active.ref_column_val (+) = rdt./*REF_COLUMN*/
   AND perm_visible.ref_column_val (+) = rdt./*REF_COLUMN*/
ORDER BY UPPER(display_col)