Добро пожаловать в форум, Guest  >>   Войти | Регистрация | Поиск | Правила | В избранное | Подписаться
Все форумы / Oracle Новый топик    Ответить
Топик располагается на нескольких страницах: [1] 2   вперед  Ctrl      все
 Избавится от HASH JOIN  [new]
mayton
Member

Откуда: loopback
Сообщений: 49738
Добрый день!

Следующая вьюшка присутствует внутри другой вьюшки, которая постоянно висит в Top CPU by Elapsed time.

CREATE OR REPLACE VIEW v_unitfunc_shadow (
   code,
   unitcode,
   name,
   numb,
   standard )
AS
select
UF.CODE,
UF.UNITCODE,
nvl(LR.TEXT, UF.NAME),
UF.NUMB,
UF.STANDARD
from
UNITFUNC UF,
DMSRESLOCALES LR
where
UF.RES_ID     = LR.PRN(+) and
LR.LANG_ID(+) = GET_NLS_LANGUAGE
/


SYS@TEST> explain plan for select * from V_UNITFUNC_SHADOW;

Объяснено.

SYS@TEST> @?/rdbms/admin/utlxpls;
Plan hash value: 3404428332

------------------------------------------------------------------------------------
| Id  | Operation          | Name          | Rows  | Bytes | Cost (%CPU)| Time     |
------------------------------------------------------------------------------------
|   0 | SELECT STATEMENT   |               |  4281 |   635K|    77   (8)| 00:00:01 |
|*  1 |  HASH JOIN OUTER   |               |  4281 |   635K|    77   (8)| 00:00:01 |
|   2 |   TABLE ACCESS FULL| UNITFUNC      |  4281 |   376K|    16   (0)| 00:00:01 |
|*  3 |   TABLE ACCESS FULL| DMSRESLOCALES | 15677 |   949K|    61  (10)| 00:00:01 |
------------------------------------------------------------------------------------

Predicate Information (identified by operation id):
---------------------------------------------------

   1 - access("UF"."RES_ID"="LR"."PRN"(+))
   3 - filter("LR"."LANG_ID"(+)="GET_NLS_LANGUAGE"())

16 строк выбрано.

Оптимизирную. Никак не могу избавится от HASH JOIN. Статистику собрал. Индексы по полям RES_ID и PRN построены.
13 фев 09, 12:20    [6816455]     Ответить | Цитировать Сообщить модератору
 Re: Избавится от HASH JOIN  [new]
wurdu
Member

Откуда: Владивосток
Сообщений: 4441
mayton
Никак не могу избавится от HASH JOIN
А избавляться то зачем. План и так оптимален. Я так понимаю, что хочется оптимизировать какой-то другой запрос, который использует эту VIEW. Ну так на него и надо смотреть. По частям такие вещи не делаются. Ну и то, что запрос висит в топе какой-то статистики не означает что его надо оптимизировать. Там всегда что-то будет висеть.
13 фев 09, 12:38    [6816593]     Ответить | Цитировать Сообщить модератору
 Re: Избавится от HASH JOIN  [new]
ScareCrow
Member

Откуда: Белый город
Сообщений: 17089
План и так оптимален
TABLE ACCESS FULL
 TABLE ACCESS FULL
хм..
13 фев 09, 12:41    [6816610]     Ответить | Цитировать Сообщить модератору
 Re: Избавится от HASH JOIN  [new]
mayton
Member

Откуда: loopback
Сообщений: 49738
Я подумал, что INDEX RANGE SCAN поможет мне понизить Cost (%CPU) и как следствие - решить мою проблему.
13 фев 09, 12:45    [6816643]     Ответить | Цитировать Сообщить модератору
 Re: Избавится от HASH JOIN  [new]
wurdu
Member

Откуда: Владивосток
Сообщений: 4441
mayton
Я подумал, что INDEX RANGE SCAN поможет мне понизить Cost (%CPU) и как следствие - решить мою проблему.
Для начала, желательно озвучить проблему. То, что запрос фигурирует в каком-то рейтинге не означает что есть проблема. В данном случае доступ по индексу менее эффективен, поэтому cost выше и оптимизатор отбрасывает этот не оптимальный план. Если же проблема действительно существует, например в случае если есть запрос к этой view с селективным условием по индексированному полю, то надо рассматривать именно его.
13 фев 09, 12:52    [6816678]     Ответить | Цитировать Сообщить модератору
 Re: Избавится от HASH JOIN  [new]
mayton
Member

Откуда: loopback
Сообщений: 49738
Проблема такая. Комплекс бухгалтерии укладывает на лопатки узел кластера (4х головый Itanium64). Загрузка CPU Idle=3%. Смотрю отчёты AWR за последние сутки. Следующий запрос постоянни висит в top by CPU.

SELECT   sunitcode, sfunccode, sfuncname, sfuncnumb, naccess
    FROM v_rolepriv2func
   WHERE sunitcode = :1
     AND nroleid = :2
     AND ncompany = :3
     AND (   (:4 IS NULL AND ncatalog IS NULL)
          OR (:5 IS NOT NULL AND ncatalog = :6)
         )
     AND (   (:7 IS NULL AND njur_pers IS NULL)
          OR (:8 IS NOT NULL AND njur_pers = :9)
         )
UNION
SELECT   sunitcode, sfunccode, sfuncname, sfuncnumb, naccess
    FROM v_rolepriv2notfunc
   WHERE sunitcode = :10
     AND nroleid = :11
     AND ncompany = :12
     AND (   (:13 IS NULL AND ncatalog IS NULL)
          OR (:14 IS NOT NULL AND ncatalog = :15)
         )
     AND (   (:16 IS NULL AND njur_pers IS NULL)
          OR (:17 IS NOT NULL AND njur_pers = :18)
         )
ORDER BY sfuncnumb

План - необычайно запутанный и длинный. (Приаттачу чуть позже) Хинты RULE я уже убрал но косты - не показываются. Начинаю оптимизировать с вложенных views для которых cost по крайней мере я вижу.

Вместе с бухгалтерией на узле крутится биллинг, но его нагрузка стабильна и им занимается другой DBA.
13 фев 09, 13:05    [6816781]     Ответить | Цитировать Сообщить модератору
 Re: Избавится от HASH JOIN  [new]
wurdu
Member

Откуда: Владивосток
Сообщений: 4441
mayton
Проблема такая. Комплекс бухгалтерии укладывает на лопатки узел кластера
Ну если этот запрос заваливает узел кластера (кстати, это приводит к массовым тормозам?), то наверняка сессии, которые его выполняют, больше всех страдают от его неоптимизированности и их можно оттрассировать и посмотреть уже глубже на проблему. Я так понимаю что комплекс неожиданно стал заваливать узел. В этом случае можно сравнить два AWR отчета, за период когда все было хорошо, и сейчас.
13 фев 09, 13:29    [6816945]     Ответить | Цитировать Сообщить модератору
 Re: Избавится от HASH JOIN  [new]
ScareCrow
Member

Откуда: Белый город
Сообщений: 17089
автор
Хинты RULE я уже убрал но косты - не показываются

трассировка спасет отца русской демократии.
13 фев 09, 14:03    [6817253]     Ответить | Цитировать Сообщить модератору
 Re: Избавится от HASH JOIN  [new]
Cartesian
Member

Откуда:
Сообщений: 28
mayton
Хинты RULE я уже убрал но косты - не показываются.

Статистику собирать не пробовал ?
13 фев 09, 14:24    [6817447]     Ответить | Цитировать Сообщить модератору
 Re: Избавится от HASH JOIN  [new]
Alterling
Member

Откуда:
Сообщений: 180
mayton, GET_NLS_LANGUAGE - это функция? в таком случае у вас не будет доступа по индексу.
Откажитесь от использования этой вьюшки, вызовите функцию в PL/SQL блоке, а в запросе используйте байнд-параметр.
13 фев 09, 15:34    [6817997]     Ответить | Цитировать Сообщить модератору
 Re: Избавится от HASH JOIN  [new]
Alterling
Member

Откуда:
Сообщений: 180
mayton, да, и отсутствие хинта RULE не гарантирует использование CBO.
А вообще - структуру таблиц, индексы и статистику (свеже собранную) по ним - в студию!
13 фев 09, 15:38    [6818032]     Ответить | Цитировать Сообщить модератору
 Re: Избавится от HASH JOIN  [new]
mayton
Member

Откуда: loopback
Сообщений: 49738
Cartesian
mayton
Хинты RULE я уже убрал но косты - не показываются.

Статистику собирать не пробовал ?

Собрал.
13 фев 09, 17:06    [6818714]     Ответить | Цитировать Сообщить модератору
 Re: Избавится от HASH JOIN  [new]
mayton
Member

Откуда: loopback
Сообщений: 49738
Alterling
mayton, GET_NLS_LANGUAGE - это функция? в таком случае у вас не будет доступа по индексу.
Откажитесь от использования этой вьюшки, вызовите функцию в PL/SQL блоке, а в запросе используйте байнд-параметр.

Недавно переписали эту функцию. Добавили директиву deterministic.
13 фев 09, 17:07    [6818720]     Ответить | Цитировать Сообщить модератору
 Re: Избавится от HASH JOIN  [new]
mayton
Member

Откуда: loopback
Сообщений: 49738
SYS@TEST> exec dbms_stats.gather_table_stats('PARUS','COMPANIES',cascade=>true);

Процедура PL/SQL успешно завершена.

Затрач.время: 00:00:00.14
SYS@TEST> exec dbms_stats.gather_table_stats('PARUS','COMPVERLIST',cascade=>true);

Процедура PL/SQL успешно завершена.

Затрач.время: 00:00:00.14
SYS@TEST> exec dbms_stats.gather_table_stats('PARUS','UNITLIST',cascade=>true);

Процедура PL/SQL успешно завершена.

Затрач.время: 00:00:00.67
SYS@TEST> exec dbms_stats.gather_table_stats('PARUS','UNITPRIV',cascade=>true);

Процедура PL/SQL успешно завершена.

Затрач.время: 00:00:29.71
SYS@TEST> exec dbms_stats.gather_table_stats('PARUS','USERPRIV',cascade=>true);

Процедура PL/SQL успешно завершена.

Затрач.время: 00:00:28.17
SYS@TEST> exec dbms_stats.gather_table_stats('PARUS','USERROLES',cascade=>true);

Процедура PL/SQL успешно завершена.

Затрач.время: 00:00:00.43
SYS@TEST> exec dbms_stats.gather_table_stats('PARUS','UNITFUNC',cascade=>true);

Процедура PL/SQL успешно завершена.

Затрач.время: 00:00:00.64
SYS@TEST> exec dbms_stats.gather_table_stats('PARUS','DMSRESLOCALES',cascade=>true);

Процедура PL/SQL успешно завершена.

Затрач.время: 00:00:01.45
13 фев 09, 17:26    [6818816]     Ответить | Цитировать Сообщить модератору
 Re: Избавится от HASH JOIN  [new]
mayton
Member

Откуда: loopback
Сообщений: 49738
Вот такой вот план.
SYS@TEST> 
SYS@TEST> explain plan for select sUNITCODE, sFUNCCODE, sFUNCNAME, sFUNCNUMB, nACCESS from V_ROLEPRIV2FUNC where sUNITCODE=:1 and nROLEID=:2 and nCOMPANY=:3 and ((:4 is null and nCATALOG is null) or (:5 is not null and nCATALOG=:6)) and ((:7 is null and nJUR_PERS is null) or (:8 is not null and nJUR_PERS=:9)) union select sUNITCODE, sFUNCCODE, sFUNCNAME, sFUNCNUMB, nACCESS from V_ROLEPRIV2NOTFUNC where sUNITCODE=:10 and nROLEID=:11 and nCOMPANY=:12 and ((:13 is null and nCATALOG is null) or (:14 is not null and nCATALOG=:15)) and ((:16 is null and nJUR_PERS is null) or (:17 is not null and nJUR_PERS=:18)) order by sFUNCNUMB;

Объяснено.

Затрач.время: 00:00:01.09
SYS@TEST> @?/rdbms/admin/utlxpls;
Plan hash value: 3632856134                                                                                                           
                                                                                                                                      
---------------------------------------------------------------------------------                                                     
| Id  | Operation                                     | Name                    |                                                     
---------------------------------------------------------------------------------                                                     
|   0 | SELECT STATEMENT                              |                         |                                                     
|   1 |  SORT UNIQUE                                  |                         |                                                     
|   2 |   UNION-ALL                                   |                         |                                                     
|   3 |    VIEW                                       | V_ROLEPRIV2FUNC         |                                                     
|   4 |     UNION-ALL                                 |                         |                                                     
|   5 |      SORT UNIQUE                              |                         |                                                     
|   6 |       UNION-ALL                               |                         |                                                     
|*  7 |        FILTER                                 |                         |                                                     
|*  8 |         FILTER                                |                         |                                                     
|   9 |          MERGE JOIN OUTER                     |                         |                                                     
|  10 |           SORT JOIN                           |                         |                                                     
|  11 |            NESTED LOOPS                       |                         |                                                     
|  12 |             NESTED LOOPS                      |                         |                                                     
|  13 |              NESTED LOOPS                     |                         |                                                     
|  14 |               NESTED LOOPS OUTER              |                         |                                                     
|  15 |                NESTED LOOPS                   |                         |                                                     
|* 16 |                 INDEX UNIQUE SCAN             | C_COMPANIES_PK          |                                                     
|  17 |                 TABLE ACCESS BY INDEX ROWID   | UNITFUNC                |                                                     
|* 18 |                  INDEX RANGE SCAN             | I_UNITFUNC_UC_FK        |                                                     
|  19 |                TABLE ACCESS BY INDEX ROWID    | DMSRESLOCALES           |                                                     
|* 20 |                 INDEX UNIQUE SCAN             | C_DMSRESLOCALES_UK      |                                                     
|  21 |               TABLE ACCESS BY INDEX ROWID     | UNITPRIV                |                                                     
|* 22 |                INDEX RANGE SCAN               | I_UNITPRIV_FUNC_FK      |                                                     
|* 23 |              TABLE ACCESS BY INDEX ROWID      | USERPRIV                |                                                     
|* 24 |               INDEX UNIQUE SCAN               | C_USERPRIV_RN_PK        |                                                     
|* 25 |             TABLE ACCESS BY INDEX ROWID       | UNITLIST                |                                                     
|* 26 |              INDEX UNIQUE SCAN                | C_UNITLIST_PK           |                                                     
|* 27 |           SORT JOIN                           |                         |                                                     
|  28 |            TABLE ACCESS FULL                  | COMPVERLIST             |                                                     
|  29 |         NESTED LOOPS                          |                         |                                                     
|  30 |          TABLE ACCESS BY INDEX ROWID          | USERPRIV                |                                                     
|* 31 |           INDEX RANGE SCAN                    | I_USERPRIV_UNITCODE_FK  |                                                     
|* 32 |          INDEX UNIQUE SCAN                    | C_USERROLES_ROLEAUTH_PK |                                                     
|* 33 |        FILTER                                 |                         |                                                     
|  34 |         NESTED LOOPS                          |                         |                                                     
|  35 |          NESTED LOOPS                         |                         |                                                     
|  36 |           NESTED LOOPS                        |                         |                                                     
|  37 |            NESTED LOOPS OUTER                 |                         |                                                     
|  38 |             TABLE ACCESS BY INDEX ROWID       | UNITFUNC                |                                                     
|* 39 |              INDEX RANGE SCAN                 | I_UNITFUNC_UC_FK        |                                                     
|  40 |             TABLE ACCESS BY INDEX ROWID       | DMSRESLOCALES           |                                                     
|* 41 |              INDEX UNIQUE SCAN                | C_DMSRESLOCALES_UK      |                                                     
|  42 |            TABLE ACCESS BY INDEX ROWID        | UNITPRIV                |                                                     
|* 43 |             INDEX RANGE SCAN                  | I_UNITPRIV_FUNC_FK      |                                                     
|* 44 |           TABLE ACCESS BY INDEX ROWID         | USERPRIV                |                                                     
|* 45 |            INDEX UNIQUE SCAN                  | C_USERPRIV_RN_PK        |                                                     
|* 46 |          TABLE ACCESS BY INDEX ROWID          | UNITLIST                |                                                     
|* 47 |           INDEX UNIQUE SCAN                   | C_UNITLIST_PK           |                                                     
|  48 |         NESTED LOOPS                          |                         |                                                     
|  49 |          TABLE ACCESS BY INDEX ROWID          | USERPRIV                |                                                     
|* 50 |           INDEX RANGE SCAN                    | I_USERPRIV_UNITCODE_FK  |                                                     
|* 51 |          INDEX UNIQUE SCAN                    | C_USERROLES_ROLEAUTH_PK |                                                     
|* 52 |      FILTER                                   |                         |                                                     
|* 53 |       FILTER                                  |                         |                                                     
|  54 |        MERGE JOIN OUTER                       |                         |                                                     
|  55 |         SORT JOIN                             |                         |                                                     
|  56 |          NESTED LOOPS                         |                         |                                                     
|  57 |           NESTED LOOPS                        |                         |                                                     
|  58 |            NESTED LOOPS                       |                         |                                                     
|  59 |             NESTED LOOPS OUTER                |                         |                                                     
|  60 |              NESTED LOOPS                     |                         |                                                     
|* 61 |               INDEX UNIQUE SCAN               | C_COMPANIES_PK          |                                                     
|  62 |               TABLE ACCESS BY INDEX ROWID     | UNITFUNC                |                                                     
|* 63 |                INDEX RANGE SCAN               | I_UNITFUNC_UC_FK        |                                                     
|  64 |              TABLE ACCESS BY INDEX ROWID      | DMSRESLOCALES           |                                                     
|* 65 |               INDEX UNIQUE SCAN               | C_DMSRESLOCALES_UK      |                                                     
|  66 |             TABLE ACCESS BY INDEX ROWID       | UNITPRIV                |                                                     
|* 67 |              INDEX RANGE SCAN                 | I_UNITPRIV_FUNC_FK      |                                                     
|* 68 |            TABLE ACCESS BY INDEX ROWID        | USERPRIV                |                                                     
|* 69 |             INDEX UNIQUE SCAN                 | C_USERPRIV_RN_PK        |                                                     
|* 70 |           TABLE ACCESS BY INDEX ROWID         | UNITLIST                |                                                     
|* 71 |            INDEX UNIQUE SCAN                  | C_UNITLIST_PK           |                                                     
|* 72 |         SORT JOIN                             |                         |                                                     
|  73 |          TABLE ACCESS FULL                    | COMPVERLIST             |                                                     
|  74 |       NESTED LOOPS                            |                         |                                                     
|  75 |        TABLE ACCESS BY INDEX ROWID            | USERPRIV                |                                                     
|* 76 |         INDEX RANGE SCAN                      | I_USERPRIV_UNITCODE_FK  |                                                     
|* 77 |        INDEX UNIQUE SCAN                      | C_USERROLES_ROLEAUTH_PK |                                                     
|* 78 |      FILTER                                   |                         |                                                     
|  79 |       NESTED LOOPS                            |                         |                                                     
|  80 |        NESTED LOOPS                           |                         |                                                     
|  81 |         NESTED LOOPS                          |                         |                                                     
|  82 |          NESTED LOOPS OUTER                   |                         |                                                     
|  83 |           TABLE ACCESS BY INDEX ROWID         | UNITFUNC                |                                                     
|* 84 |            INDEX RANGE SCAN                   | I_UNITFUNC_UC_FK        |                                                     
|  85 |           TABLE ACCESS BY INDEX ROWID         | DMSRESLOCALES           |                                                     
|* 86 |            INDEX UNIQUE SCAN                  | C_DMSRESLOCALES_UK      |                                                     
|  87 |          TABLE ACCESS BY INDEX ROWID          | UNITPRIV                |                                                     
|* 88 |           INDEX RANGE SCAN                    | I_UNITPRIV_FUNC_FK      |                                                     
|* 89 |         TABLE ACCESS BY INDEX ROWID           | USERPRIV                |                                                     
|* 90 |          INDEX UNIQUE SCAN                    | C_USERPRIV_RN_PK        |                                                     
|* 91 |        TABLE ACCESS BY INDEX ROWID            | UNITLIST                |                                                     
|* 92 |         INDEX UNIQUE SCAN                     | C_UNITLIST_PK           |                                                     
|  93 |       NESTED LOOPS                            |                         |                                                     
|  94 |        TABLE ACCESS BY INDEX ROWID            | USERPRIV                |                                                     
|* 95 |         INDEX RANGE SCAN                      | I_USERPRIV_UNITCODE_FK  |                                                     
|* 96 |        INDEX UNIQUE SCAN                      | C_USERROLES_ROLEAUTH_PK |                                                     
|* 97 |      FILTER                                   |                         |                                                     
|  98 |       NESTED LOOPS                            |                         |                                                     
|  99 |        NESTED LOOPS                           |                         |                                                     
| 100 |         NESTED LOOPS                          |                         |                                                     
| 101 |          NESTED LOOPS OUTER                   |                         |                                                     
| 102 |           TABLE ACCESS BY INDEX ROWID         | UNITFUNC                |                                                     
|*103 |            INDEX RANGE SCAN                   | I_UNITFUNC_UC_FK        |                                                     
| 104 |           TABLE ACCESS BY INDEX ROWID         | DMSRESLOCALES           |                                                     
|*105 |            INDEX UNIQUE SCAN                  | C_DMSRESLOCALES_UK      |                                                     
| 106 |          TABLE ACCESS BY INDEX ROWID          | UNITPRIV                |                                                     
|*107 |           INDEX RANGE SCAN                    | I_UNITPRIV_FUNC_FK      |                                                     
|*108 |         TABLE ACCESS BY INDEX ROWID           | USERPRIV                |                                                     
|*109 |          INDEX UNIQUE SCAN                    | C_USERPRIV_RN_PK        |                                                     
|*110 |        TABLE ACCESS BY INDEX ROWID            | UNITLIST                |                                                     
|*111 |         INDEX UNIQUE SCAN                     | C_UNITLIST_PK           |                                                     
| 112 |       NESTED LOOPS                            |                         |                                                     
| 113 |        TABLE ACCESS BY INDEX ROWID            | USERPRIV                |                                                     
|*114 |         INDEX RANGE SCAN                      | I_USERPRIV_UNITCODE_FK  |                                                     
|*115 |        INDEX UNIQUE SCAN                      | C_USERROLES_ROLEAUTH_PK |                                                     
| 116 |    VIEW                                       | V_ROLEPRIV2NOTFUNC      |                                                     
| 117 |     UNION-ALL                                 |                         |                                                     
|*118 |      FILTER                                   |                         |                                                     
|*119 |       FILTER                                  |                         |                                                     
| 120 |        NESTED LOOPS OUTER                     |                         |                                                     
| 121 |         NESTED LOOPS                          |                         |                                                     
| 122 |          NESTED LOOPS                         |                         |                                                     
| 123 |           NESTED LOOPS                        |                         |                                                     
|*124 |            INDEX UNIQUE SCAN                  | C_COMPANIES_PK          |                                                     
|*125 |            INDEX UNIQUE SCAN                  | C_ROLES_PK              |                                                     
| 126 |           TABLE ACCESS BY INDEX ROWID         | UNITFUNC                |                                                     
|*127 |            INDEX RANGE SCAN                   | I_UNITFUNC_UC_FK        |                                                     
|*128 |          TABLE ACCESS BY INDEX ROWID          | UNITLIST                |                                                     
|*129 |           INDEX UNIQUE SCAN                   | C_UNITLIST_PK           |                                                     
| 130 |         TABLE ACCESS BY INDEX ROWID           | DMSRESLOCALES           |                                                     
|*131 |          INDEX UNIQUE SCAN                    | C_DMSRESLOCALES_UK      |                                                     
| 132 |        NESTED LOOPS                           |                         |                                                     
| 133 |         TABLE ACCESS BY INDEX ROWID           | USERPRIV                |                                                     
|*134 |          INDEX RANGE SCAN                     | I_USERPRIV_UNITCODE_FK  |                                                     
|*135 |         INDEX UNIQUE SCAN                     | C_USERROLES_ROLEAUTH_PK |                                                     
| 136 |       VIEW                                    | V_ROLEPRIV2FUNC         |                                                     
| 137 |        UNION-ALL                              |                         |                                                     
| 138 |         SORT UNIQUE                           |                         |                                                     
| 139 |          UNION-ALL                            |                         |                                                     
|*140 |           FILTER                              |                         |                                                     
|*141 |            FILTER                             |                         |                                                     
| 142 |             MERGE JOIN OUTER                  |                         |                                                     
| 143 |              SORT JOIN                        |                         |                                                     
| 144 |               NESTED LOOPS                    |                         |                                                     
| 145 |                NESTED LOOPS                   |                         |                                                     
| 146 |                 NESTED LOOPS                  |                         |                                                     
| 147 |                  NESTED LOOPS OUTER           |                         |                                                     
| 148 |                   NESTED LOOPS                |                         |                                                     
|*149 |                    INDEX UNIQUE SCAN          | C_COMPANIES_PK          |                                                     
|*150 |                    TABLE ACCESS BY INDEX ROWID| UNITFUNC                |                                                     
|*151 |                     INDEX UNIQUE SCAN         | C_UNITFUNC_PK           |                                                     
| 152 |                   TABLE ACCESS BY INDEX ROWID | DMSRESLOCALES           |                                                     
|*153 |                    INDEX UNIQUE SCAN          | C_DMSRESLOCALES_UK      |                                                     
| 154 |                  TABLE ACCESS BY INDEX ROWID  | UNITPRIV                |                                                     
|*155 |                   INDEX RANGE SCAN            | I_UNITPRIV_FUNC_FK      |                                                     
|*156 |                 TABLE ACCESS BY INDEX ROWID   | USERPRIV                |                                                     
|*157 |                  INDEX UNIQUE SCAN            | C_USERPRIV_RN_PK        |                                                     
|*158 |                TABLE ACCESS BY INDEX ROWID    | UNITLIST                |                                                     
|*159 |                 INDEX UNIQUE SCAN             | C_UNITLIST_PK           |                                                     
|*160 |              SORT JOIN                        |                         |                                                     
| 161 |               TABLE ACCESS FULL               | COMPVERLIST             |                                                     
| 162 |            NESTED LOOPS                       |                         |                                                     
| 163 |             TABLE ACCESS BY INDEX ROWID       | USERPRIV                |                                                     
|*164 |              INDEX RANGE SCAN                 | I_USERPRIV_UNITCODE_FK  |                                                     
|*165 |             INDEX UNIQUE SCAN                 | C_USERROLES_ROLEAUTH_PK |                                                     
|*166 |           FILTER                              |                         |                                                     
| 167 |            NESTED LOOPS                       |                         |                                                     
| 168 |             NESTED LOOPS                      |                         |                                                     
| 169 |              NESTED LOOPS                     |                         |                                                     
| 170 |               NESTED LOOPS OUTER              |                         |                                                     
|*171 |                TABLE ACCESS BY INDEX ROWID    | UNITFUNC                |                                                     
|*172 |                 INDEX UNIQUE SCAN             | C_UNITFUNC_PK           |                                                     
| 173 |                TABLE ACCESS BY INDEX ROWID    | DMSRESLOCALES           |                                                     
|*174 |                 INDEX UNIQUE SCAN             | C_DMSRESLOCALES_UK      |                                                     
| 175 |               TABLE ACCESS BY INDEX ROWID     | UNITPRIV                |                                                     
|*176 |                INDEX RANGE SCAN               | I_UNITPRIV_FUNC_FK      |                                                     
|*177 |              TABLE ACCESS BY INDEX ROWID      | USERPRIV                |                                                     
|*178 |               INDEX UNIQUE SCAN               | C_USERPRIV_RN_PK        |                                                     
|*179 |             TABLE ACCESS BY INDEX ROWID       | UNITLIST                |                                                     
|*180 |              INDEX UNIQUE SCAN                | C_UNITLIST_PK           |                                                     
| 181 |            NESTED LOOPS                       |                         |                                                     
| 182 |             TABLE ACCESS BY INDEX ROWID       | USERPRIV                |                                                     
|*183 |              INDEX RANGE SCAN                 | I_USERPRIV_UNITCODE_FK  |                                                     
|*184 |             INDEX UNIQUE SCAN                 | C_USERROLES_ROLEAUTH_PK |                                                     
|*185 |         FILTER                                |                         |                                                     
|*186 |          FILTER                               |                         |                                                     
| 187 |           MERGE JOIN OUTER                    |                         |                                                     
| 188 |            SORT JOIN                          |                         |                                                     
| 189 |             NESTED LOOPS                      |                         |                                                     
| 190 |              NESTED LOOPS                     |                         |                                                     
| 191 |               NESTED LOOPS                    |                         |                                                     
| 192 |                NESTED LOOPS OUTER             |                         |                                                     
| 193 |                 NESTED LOOPS                  |                         |                                                     
|*194 |                  INDEX UNIQUE SCAN            | C_COMPANIES_PK          |                                                     
|*195 |                  TABLE ACCESS BY INDEX ROWID  | UNITFUNC                |                                                     
|*196 |                   INDEX UNIQUE SCAN           | C_UNITFUNC_PK           |                                                     
| 197 |                 TABLE ACCESS BY INDEX ROWID   | DMSRESLOCALES           |                                                     
|*198 |                  INDEX UNIQUE SCAN            | C_DMSRESLOCALES_UK      |                                                     
| 199 |                TABLE ACCESS BY INDEX ROWID    | UNITPRIV                |                                                     
|*200 |                 INDEX RANGE SCAN              | I_UNITPRIV_FUNC_FK      |                                                     
|*201 |               TABLE ACCESS BY INDEX ROWID     | USERPRIV                |                                                     
|*202 |                INDEX UNIQUE SCAN              | C_USERPRIV_RN_PK        |                                                     
|*203 |              TABLE ACCESS BY INDEX ROWID      | UNITLIST                |                                                     
|*204 |               INDEX UNIQUE SCAN               | C_UNITLIST_PK           |                                                     
|*205 |            SORT JOIN                          |                         |                                                     
| 206 |             TABLE ACCESS FULL                 | COMPVERLIST             |                                                     
| 207 |          NESTED LOOPS                         |                         |                                                     
| 208 |           TABLE ACCESS BY INDEX ROWID         | USERPRIV                |                                                     
|*209 |            INDEX RANGE SCAN                   | I_USERPRIV_UNITCODE_FK  |                                                     
|*210 |           INDEX UNIQUE SCAN                   | C_USERROLES_ROLEAUTH_PK |                                                     
|*211 |         FILTER                                |                         |                                                     
| 212 |          NESTED LOOPS                         |                         |                                                     
| 213 |           NESTED LOOPS                        |                         |                                                     
| 214 |            NESTED LOOPS                       |                         |                                                     
| 215 |             NESTED LOOPS OUTER                |                         |                                                     
|*216 |              TABLE ACCESS BY INDEX ROWID      | UNITFUNC                |                                                     
|*217 |               INDEX UNIQUE SCAN               | C_UNITFUNC_PK           |                                                     
| 218 |              TABLE ACCESS BY INDEX ROWID      | DMSRESLOCALES           |                                                     
|*219 |               INDEX UNIQUE SCAN               | C_DMSRESLOCALES_UK      |                                                     
| 220 |             TABLE ACCESS BY INDEX ROWID       | UNITPRIV                |                                                     
|*221 |              INDEX RANGE SCAN                 | I_UNITPRIV_FUNC_FK      |                                                     
|*222 |            TABLE ACCESS BY INDEX ROWID        | USERPRIV                |                                                     
|*223 |             INDEX UNIQUE SCAN                 | C_USERPRIV_RN_PK        |                                                     
|*224 |           TABLE ACCESS BY INDEX ROWID         | UNITLIST                |                                                     
|*225 |            INDEX UNIQUE SCAN                  | C_UNITLIST_PK           |                                                     
| 226 |          NESTED LOOPS                         |                         |                                                     
| 227 |           TABLE ACCESS BY INDEX ROWID         | USERPRIV                |                                                     
|*228 |            INDEX RANGE SCAN                   | I_USERPRIV_UNITCODE_FK  |                                                     
|*229 |           INDEX UNIQUE SCAN                   | C_USERROLES_ROLEAUTH_PK |                                                     
|*230 |         FILTER                                |                         |                                                     
| 231 |          NESTED LOOPS                         |                         |                                                     
| 232 |           NESTED LOOPS                        |                         |                                                     
| 233 |            NESTED LOOPS                       |                         |                                                     
| 234 |             NESTED LOOPS OUTER                |                         |                                                     
|*235 |              TABLE ACCESS BY INDEX ROWID      | UNITFUNC                |                                                     
|*236 |               INDEX UNIQUE SCAN               | C_UNITFUNC_PK           |                                                     
| 237 |              TABLE ACCESS BY INDEX ROWID      | DMSRESLOCALES           |                                                     
|*238 |               INDEX UNIQUE SCAN               | C_DMSRESLOCALES_UK      |                                                     
| 239 |             TABLE ACCESS BY INDEX ROWID       | UNITPRIV                |                                                     
|*240 |              INDEX RANGE SCAN                 | I_UNITPRIV_FUNC_FK      |                                                     
|*241 |            TABLE ACCESS BY INDEX ROWID        | USERPRIV                |                                                     
|*242 |             INDEX UNIQUE SCAN                 | C_USERPRIV_RN_PK        |                                                     
|*243 |           TABLE ACCESS BY INDEX ROWID         | UNITLIST                |                                                     
|*244 |            INDEX UNIQUE SCAN                  | C_UNITLIST_PK           |                                                     
| 245 |          NESTED LOOPS                         |                         |                                                     
| 246 |           TABLE ACCESS BY INDEX ROWID         | USERPRIV                |                                                     
|*247 |            INDEX RANGE SCAN                   | I_USERPRIV_UNITCODE_FK  |                                                     
|*248 |           INDEX UNIQUE SCAN                   | C_USERROLES_ROLEAUTH_PK |                                                     
|*249 |      FILTER                                   |                         |                                                     
|*250 |       FILTER                                  |                         |                                                     
| 251 |        NESTED LOOPS OUTER                     |                         |                                                     
| 252 |         NESTED LOOPS                          |                         |                                                     
| 253 |          NESTED LOOPS                         |                         |                                                     
|*254 |           INDEX UNIQUE SCAN                   | C_ROLES_PK              |                                                     
| 255 |           TABLE ACCESS BY INDEX ROWID         | UNITFUNC                |                                                     
|*256 |            INDEX RANGE SCAN                   | I_UNITFUNC_UC_FK        |                                                     
|*257 |          TABLE ACCESS BY INDEX ROWID          | UNITLIST                |                                                     
|*258 |           INDEX UNIQUE SCAN                   | C_UNITLIST_PK           |                                                     
| 259 |         TABLE ACCESS BY INDEX ROWID           | DMSRESLOCALES           |                                                     
|*260 |          INDEX UNIQUE SCAN                    | C_DMSRESLOCALES_UK      |                                                     
| 261 |        NESTED LOOPS                           |                         |                                                     
| 262 |         TABLE ACCESS BY INDEX ROWID           | USERPRIV                |                                                     
|*263 |          INDEX RANGE SCAN                     | I_USERPRIV_UNITCODE_FK  |                                                     
|*264 |         INDEX UNIQUE SCAN                     | C_USERROLES_ROLEAUTH_PK |                                                     
| 265 |       VIEW                                    | V_ROLEPRIV2FUNC         |                                                     
| 266 |        UNION-ALL                              |                         |                                                     
| 267 |         SORT UNIQUE                           |                         |                                                     
| 268 |          UNION-ALL                            |                         |                                                     
|*269 |           FILTER                              |                         |                                                     
|*270 |            FILTER                             |                         |                                                     
| 271 |             MERGE JOIN OUTER                  |                         |                                                     
| 272 |              SORT JOIN                        |                         |                                                     
| 273 |               NESTED LOOPS                    |                         |                                                     
| 274 |                NESTED LOOPS                   |                         |                                                     
| 275 |                 NESTED LOOPS                  |                         |                                                     
| 276 |                  NESTED LOOPS OUTER           |                         |                                                     
| 277 |                   NESTED LOOPS                |                         |                                                     
|*278 |                    INDEX UNIQUE SCAN          | C_COMPANIES_PK          |                                                     
|*279 |                    TABLE ACCESS BY INDEX ROWID| UNITFUNC                |                                                     
|*280 |                     INDEX UNIQUE SCAN         | C_UNITFUNC_PK           |                                                     
| 281 |                   TABLE ACCESS BY INDEX ROWID | DMSRESLOCALES           |                                                     
|*282 |                    INDEX UNIQUE SCAN          | C_DMSRESLOCALES_UK      |                                                     
| 283 |                  TABLE ACCESS BY INDEX ROWID  | UNITPRIV                |                                                     
|*284 |                   INDEX RANGE SCAN            | I_UNITPRIV_FUNC_FK      |                                                     
|*285 |                 TABLE ACCESS BY INDEX ROWID   | USERPRIV                |                                                     
|*286 |                  INDEX UNIQUE SCAN            | C_USERPRIV_RN_PK        |                                                     
|*287 |                TABLE ACCESS BY INDEX ROWID    | UNITLIST                |                                                     
|*288 |                 INDEX UNIQUE SCAN             | C_UNITLIST_PK           |                                                     
|*289 |              SORT JOIN                        |                         |                                                     
| 290 |               TABLE ACCESS FULL               | COMPVERLIST             |                                                     
| 291 |            NESTED LOOPS                       |                         |                                                     
| 292 |             TABLE ACCESS BY INDEX ROWID       | USERPRIV                |                                                     
|*293 |              INDEX RANGE SCAN                 | I_USERPRIV_UNITCODE_FK  |                                                     
|*294 |             INDEX UNIQUE SCAN                 | C_USERROLES_ROLEAUTH_PK |                                                     
|*295 |           FILTER                              |                         |                                                     
| 296 |            NESTED LOOPS                       |                         |                                                     
| 297 |             NESTED LOOPS                      |                         |                                                     
| 298 |              NESTED LOOPS                     |                         |                                                     
| 299 |               NESTED LOOPS OUTER              |                         |                                                     
|*300 |                TABLE ACCESS BY INDEX ROWID    | UNITFUNC                |                                                     
|*301 |                 INDEX UNIQUE SCAN             | C_UNITFUNC_PK           |                                                     
| 302 |                TABLE ACCESS BY INDEX ROWID    | DMSRESLOCALES           |                                                     
|*303 |                 INDEX UNIQUE SCAN             | C_DMSRESLOCALES_UK      |                                                     
| 304 |               TABLE ACCESS BY INDEX ROWID     | UNITPRIV                |                                                     
|*305 |                INDEX RANGE SCAN               | I_UNITPRIV_FUNC_FK      |                                                     
|*306 |              TABLE ACCESS BY INDEX ROWID      | USERPRIV                |                                                     
|*307 |               INDEX UNIQUE SCAN               | C_USERPRIV_RN_PK        |                                                     
|*308 |             TABLE ACCESS BY INDEX ROWID       | UNITLIST                |                                                     
|*309 |              INDEX UNIQUE SCAN                | C_UNITLIST_PK           |                                                     
| 310 |            NESTED LOOPS                       |                         |                                                     
| 311 |             TABLE ACCESS BY INDEX ROWID       | USERPRIV                |                                                     
|*312 |              INDEX RANGE SCAN                 | I_USERPRIV_UNITCODE_FK  |                                                     
|*313 |             INDEX UNIQUE SCAN                 | C_USERROLES_ROLEAUTH_PK |                                                     
|*314 |         FILTER                                |                         |                                                     
|*315 |          FILTER                               |                         |                                                     
| 316 |           MERGE JOIN OUTER                    |                         |                                                     
| 317 |            SORT JOIN                          |                         |                                                     
| 318 |             NESTED LOOPS                      |                         |                                                     
| 319 |              NESTED LOOPS                     |                         |                                                     
| 320 |               NESTED LOOPS                    |                         |                                                     
| 321 |                NESTED LOOPS OUTER             |                         |                                                     
| 322 |                 NESTED LOOPS                  |                         |                                                     
|*323 |                  INDEX UNIQUE SCAN            | C_COMPANIES_PK          |                                                     
|*324 |                  TABLE ACCESS BY INDEX ROWID  | UNITFUNC                |                                                     
|*325 |                   INDEX UNIQUE SCAN           | C_UNITFUNC_PK           |                                                     
| 326 |                 TABLE ACCESS BY INDEX ROWID   | DMSRESLOCALES           |                                                     
|*327 |                  INDEX UNIQUE SCAN            | C_DMSRESLOCALES_UK      |                                                     
| 328 |                TABLE ACCESS BY INDEX ROWID    | UNITPRIV                |                                                     
|*329 |                 INDEX RANGE SCAN              | I_UNITPRIV_FUNC_FK      |                                                     
|*330 |               TABLE ACCESS BY INDEX ROWID     | USERPRIV                |                                                     
|*331 |                INDEX UNIQUE SCAN              | C_USERPRIV_RN_PK        |                                                     
|*332 |              TABLE ACCESS BY INDEX ROWID      | UNITLIST                |                                                     
|*333 |               INDEX UNIQUE SCAN               | C_UNITLIST_PK           |                                                     
|*334 |            SORT JOIN                          |                         |                                                     
| 335 |             TABLE ACCESS FULL                 | COMPVERLIST             |                                                     
| 336 |          NESTED LOOPS                         |                         |                                                     
| 337 |           TABLE ACCESS BY INDEX ROWID         | USERPRIV                |                                                     
|*338 |            INDEX RANGE SCAN                   | I_USERPRIV_UNITCODE_FK  |                                                     
|*339 |           INDEX UNIQUE SCAN                   | C_USERROLES_ROLEAUTH_PK |                                                     
|*340 |         FILTER                                |                         |                                                     
| 341 |          NESTED LOOPS                         |                         |                                                     
| 342 |           NESTED LOOPS                        |                         |                                                     
| 343 |            NESTED LOOPS                       |                         |                                                     
| 344 |             NESTED LOOPS OUTER                |                         |                                                     
|*345 |              TABLE ACCESS BY INDEX ROWID      | UNITFUNC                |                                                     
|*346 |               INDEX UNIQUE SCAN               | C_UNITFUNC_PK           |                                                     
| 347 |              TABLE ACCESS BY INDEX ROWID      | DMSRESLOCALES           |                                                     
|*348 |               INDEX UNIQUE SCAN               | C_DMSRESLOCALES_UK      |                                                     
| 349 |             TABLE ACCESS BY INDEX ROWID       | UNITPRIV                |                                                     
|*350 |              INDEX RANGE SCAN                 | I_UNITPRIV_FUNC_FK      |                                                     
|*351 |            TABLE ACCESS BY INDEX ROWID        | USERPRIV                |                                                     
|*352 |             INDEX UNIQUE SCAN                 | C_USERPRIV_RN_PK        |                                                     
|*353 |           TABLE ACCESS BY INDEX ROWID         | UNITLIST                |                                                     
|*354 |            INDEX UNIQUE SCAN                  | C_UNITLIST_PK           |                                                     
| 355 |          NESTED LOOPS                         |                         |                                                     
| 356 |           TABLE ACCESS BY INDEX ROWID         | USERPRIV                |                                                     
|*357 |            INDEX RANGE SCAN                   | I_USERPRIV_UNITCODE_FK  |                                                     
|*358 |           INDEX UNIQUE SCAN                   | C_USERROLES_ROLEAUTH_PK |                                                     
|*359 |         FILTER                                |                         |                                                     
| 360 |          NESTED LOOPS                         |                         |                                                     
| 361 |           NESTED LOOPS                        |                         |                                                     
| 362 |            NESTED LOOPS                       |                         |                                                     
| 363 |             NESTED LOOPS OUTER                |                         |                                                     
|*364 |              TABLE ACCESS BY INDEX ROWID      | UNITFUNC                |                                                     
|*365 |               INDEX UNIQUE SCAN               | C_UNITFUNC_PK           |                                                     
| 366 |              TABLE ACCESS BY INDEX ROWID      | DMSRESLOCALES           |                                                     
|*367 |               INDEX UNIQUE SCAN               | C_DMSRESLOCALES_UK      |                                                     
| 368 |             TABLE ACCESS BY INDEX ROWID       | UNITPRIV                |                                                     
|*369 |              INDEX RANGE SCAN                 | I_UNITPRIV_FUNC_FK      |                                                     
|*370 |            TABLE ACCESS BY INDEX ROWID        | USERPRIV                |                                                     
|*371 |             INDEX UNIQUE SCAN                 | C_USERPRIV_RN_PK        |                                                     
|*372 |           TABLE ACCESS BY INDEX ROWID         | UNITLIST                |                                                     
|*373 |            INDEX UNIQUE SCAN                  | C_UNITLIST_PK           |                                                     
| 374 |          NESTED LOOPS                         |                         |                                                     
| 375 |           TABLE ACCESS BY INDEX ROWID         | USERPRIV                |                                                     
|*376 |            INDEX RANGE SCAN                   | I_USERPRIV_UNITCODE_FK  |                                                     
|*377 |           INDEX UNIQUE SCAN                   | C_USERROLES_ROLEAUTH_PK |                                                     
|*378 |      FILTER                                   |                         |                                                     
|*379 |       FILTER                                  |                         |                                                     
| 380 |        NESTED LOOPS OUTER                     |                         |                                                     
| 381 |         NESTED LOOPS                          |                         |                                                     
| 382 |          NESTED LOOPS                         |                         |                                                     
| 383 |           NESTED LOOPS                        |                         |                                                     
| 384 |            NESTED LOOPS                       |                         |                                                     
|*385 |             INDEX UNIQUE SCAN                 | C_ACATALOG_PK           |                                                     
|*386 |             INDEX UNIQUE SCAN                 | C_COMPANIES_PK          |                                                     
|*387 |            INDEX UNIQUE SCAN                  | C_ROLES_PK              |                                                     
| 388 |           TABLE ACCESS BY INDEX ROWID         | UNITFUNC                |                                                     
|*389 |            INDEX RANGE SCAN                   | I_UNITFUNC_UC_FK        |                                                     
|*390 |          TABLE ACCESS BY INDEX ROWID          | UNITLIST                |                                                     
|*391 |           INDEX UNIQUE SCAN                   | C_UNITLIST_PK           |                                                     
| 392 |         TABLE ACCESS BY INDEX ROWID           | DMSRESLOCALES           |                                                     
|*393 |          INDEX UNIQUE SCAN                    | C_DMSRESLOCALES_UK      |                                                     
| 394 |        NESTED LOOPS                           |                         |                                                     
| 395 |         TABLE ACCESS BY INDEX ROWID           | USERPRIV                |                                                     
|*396 |          INDEX RANGE SCAN                     | I_USERPRIV_UNITCODE_FK  |                                                     
|*397 |         INDEX UNIQUE SCAN                     | C_USERROLES_ROLEAUTH_PK |                                                     
| 398 |       VIEW                                    | V_ROLEPRIV2FUNC         |                                                     
| 399 |        UNION-ALL                              |                         |                                                     
| 400 |         SORT UNIQUE                           |                         |                                                     
| 401 |          UNION-ALL                            |                         |                                                     
|*402 |           FILTER                              |                         |                                                     
|*403 |            FILTER                             |                         |                                                     
| 404 |             MERGE JOIN OUTER                  |                         |                                                     
| 405 |              SORT JOIN                        |                         |                                                     
| 406 |               NESTED LOOPS                    |                         |                                                     
| 407 |                NESTED LOOPS                   |                         |                                                     
| 408 |                 NESTED LOOPS                  |                         |                                                     
| 409 |                  NESTED LOOPS OUTER           |                         |                                                     
| 410 |                   NESTED LOOPS                |                         |                                                     
|*411 |                    INDEX UNIQUE SCAN          | C_COMPANIES_PK          |                                                     
|*412 |                    TABLE ACCESS BY INDEX ROWID| UNITFUNC                |                                                     
|*413 |                     INDEX UNIQUE SCAN         | C_UNITFUNC_PK           |                                                     
| 414 |                   TABLE ACCESS BY INDEX ROWID | DMSRESLOCALES           |                                                     
|*415 |                    INDEX UNIQUE SCAN          | C_DMSRESLOCALES_UK      |                                                     
| 416 |                  TABLE ACCESS BY INDEX ROWID  | UNITPRIV                |                                                     
|*417 |                   INDEX RANGE SCAN            | I_UNITPRIV_FUNC_FK      |                                                     
|*418 |                 TABLE ACCESS BY INDEX ROWID   | USERPRIV                |                                                     
|*419 |                  INDEX UNIQUE SCAN            | C_USERPRIV_RN_PK        |                                                     
|*420 |                TABLE ACCESS BY INDEX ROWID    | UNITLIST                |                                                     
|*421 |                 INDEX UNIQUE SCAN             | C_UNITLIST_PK           |                                                     
|*422 |              SORT JOIN                        |                         |                                                     
| 423 |               TABLE ACCESS FULL               | COMPVERLIST             |                                                     
| 424 |            NESTED LOOPS                       |                         |                                                     
| 425 |             TABLE ACCESS BY INDEX ROWID       | USERPRIV                |                                                     
|*426 |              INDEX RANGE SCAN                 | I_USERPRIV_UNITCODE_FK  |                                                     
|*427 |             INDEX UNIQUE SCAN                 | C_USERROLES_ROLEAUTH_PK |                                                     
|*428 |           FILTER                              |                         |                                                     
| 429 |            NESTED LOOPS                       |                         |                                                     
| 430 |             NESTED LOOPS                      |                         |                                                     
| 431 |              NESTED LOOPS                     |                         |                                                     
| 432 |               NESTED LOOPS OUTER              |                         |                                                     
|*433 |                TABLE ACCESS BY INDEX ROWID    | UNITFUNC                |                                                     
|*434 |                 INDEX UNIQUE SCAN             | C_UNITFUNC_PK           |                                                     
| 435 |                TABLE ACCESS BY INDEX ROWID    | DMSRESLOCALES           |                                                     
|*436 |                 INDEX UNIQUE SCAN             | C_DMSRESLOCALES_UK      |                                                     
| 437 |               TABLE ACCESS BY INDEX ROWID     | UNITPRIV                |                                                     
|*438 |                INDEX RANGE SCAN               | I_UNITPRIV_FUNC_FK      |                                                     
|*439 |              TABLE ACCESS BY INDEX ROWID      | USERPRIV                |                                                     
|*440 |               INDEX UNIQUE SCAN               | C_USERPRIV_RN_PK        |                                                     
|*441 |             TABLE ACCESS BY INDEX ROWID       | UNITLIST                |                                                     
|*442 |              INDEX UNIQUE SCAN                | C_UNITLIST_PK           |                                                     
| 443 |            NESTED LOOPS                       |                         |                                                     
| 444 |             TABLE ACCESS BY INDEX ROWID       | USERPRIV                |                                                     
|*445 |              INDEX RANGE SCAN                 | I_USERPRIV_UNITCODE_FK  |                                                     
|*446 |             INDEX UNIQUE SCAN                 | C_USERROLES_ROLEAUTH_PK |                                                     
|*447 |         FILTER                                |                         |                                                     
|*448 |          FILTER                               |                         |                                                     
| 449 |           MERGE JOIN OUTER                    |                         |                                                     
| 450 |            SORT JOIN                          |                         |                                                     
| 451 |             NESTED LOOPS                      |                         |                                                     
| 452 |              NESTED LOOPS                     |                         |                                                     
| 453 |               NESTED LOOPS                    |                         |                                                     
| 454 |                NESTED LOOPS OUTER             |                         |                                                     
| 455 |                 NESTED LOOPS                  |                         |                                                     
|*456 |                  INDEX UNIQUE SCAN            | C_COMPANIES_PK          |                                                     
|*457 |                  TABLE ACCESS BY INDEX ROWID  | UNITFUNC                |                                                     
|*458 |                   INDEX UNIQUE SCAN           | C_UNITFUNC_PK           |                                                     
| 459 |                 TABLE ACCESS BY INDEX ROWID   | DMSRESLOCALES           |                                                     
|*460 |                  INDEX UNIQUE SCAN            | C_DMSRESLOCALES_UK      |                                                     
| 461 |                TABLE ACCESS BY INDEX ROWID    | USERPRIV                |                                                     
| 462 |                 AND-EQUAL                     |                         |                                                     
|*463 |                  INDEX RANGE SCAN             | I_USERPRIV_ROLEID_FK    |                                                     
|*464 |                  INDEX RANGE SCAN             | I_USERPRIV_CATALOG_FK   |                                                     
|*465 |               TABLE ACCESS BY INDEX ROWID     | UNITLIST                |                                                     
|*466 |                INDEX UNIQUE SCAN              | C_UNITLIST_PK           |                                                     
|*467 |              INDEX UNIQUE SCAN                | C_UNITPRIV_UK           |                                                     
|*468 |            SORT JOIN                          |                         |                                                     
| 469 |             TABLE ACCESS FULL                 | COMPVERLIST             |                                                     
| 470 |          NESTED LOOPS                         |                         |                                                     
| 471 |           TABLE ACCESS BY INDEX ROWID         | USERPRIV                |                                                     
|*472 |            INDEX RANGE SCAN                   | I_USERPRIV_UNITCODE_FK  |                                                     
|*473 |           INDEX UNIQUE SCAN                   | C_USERROLES_ROLEAUTH_PK |                                                     
|*474 |         FILTER                                |                         |                                                     
| 475 |          NESTED LOOPS                         |                         |                                                     
| 476 |           NESTED LOOPS                        |                         |                                                     
| 477 |            NESTED LOOPS                       |                         |                                                     
| 478 |             NESTED LOOPS OUTER                |                         |                                                     
|*479 |              TABLE ACCESS BY INDEX ROWID      | UNITFUNC                |                                                     
|*480 |               INDEX UNIQUE SCAN               | C_UNITFUNC_PK           |                                                     
| 481 |              TABLE ACCESS BY INDEX ROWID      | DMSRESLOCALES           |                                                     
|*482 |               INDEX UNIQUE SCAN               | C_DMSRESLOCALES_UK      |                                                     
|*483 |             TABLE ACCESS BY INDEX ROWID       | USERPRIV                |                                                     
| 484 |              AND-EQUAL                        |                         |                                                     
|*485 |               INDEX RANGE SCAN                | I_USERPRIV_ROLEID_FK    |                                                     
|*486 |               INDEX RANGE SCAN                | I_USERPRIV_CATALOG_FK   |                                                     
|*487 |            TABLE ACCESS BY INDEX ROWID        | UNITLIST                |                                                     
|*488 |             INDEX UNIQUE SCAN                 | C_UNITLIST_PK           |                                                     
|*489 |           INDEX UNIQUE SCAN                   | C_UNITPRIV_UK           |                                                     
| 490 |          NESTED LOOPS                         |                         |                                                     
| 491 |           TABLE ACCESS BY INDEX ROWID         | USERPRIV                |                                                     
|*492 |            INDEX RANGE SCAN                   | I_USERPRIV_UNITCODE_FK  |                                                     
|*493 |           INDEX UNIQUE SCAN                   | C_USERROLES_ROLEAUTH_PK |                                                     
|*494 |         FILTER                                |                         |                                                     
| 495 |          NESTED LOOPS                         |                         |                                                     
| 496 |           NESTED LOOPS                        |                         |                                                     
| 497 |            NESTED LOOPS                       |                         |                                                     
| 498 |             NESTED LOOPS OUTER                |                         |                                                     
|*499 |              TABLE ACCESS BY INDEX ROWID      | UNITFUNC                |                                                     
|*500 |               INDEX UNIQUE SCAN               | C_UNITFUNC_PK           |                                                     
| 501 |              TABLE ACCESS BY INDEX ROWID      | DMSRESLOCALES           |                                                     
|*502 |               INDEX UNIQUE SCAN               | C_DMSRESLOCALES_UK      |                                                     
| 503 |             TABLE ACCESS BY INDEX ROWID       | UNITPRIV                |                                                     
|*504 |              INDEX RANGE SCAN                 | I_UNITPRIV_FUNC_FK      |                                                     
|*505 |            TABLE ACCESS BY INDEX ROWID        | USERPRIV                |                                                     
|*506 |             INDEX UNIQUE SCAN                 | C_USERPRIV_RN_PK        |                                                     
|*507 |           TABLE ACCESS BY INDEX ROWID         | UNITLIST                |                                                     
|*508 |            INDEX UNIQUE SCAN                  | C_UNITLIST_PK           |                                                     
| 509 |          NESTED LOOPS                         |                         |                                                     
| 510 |           TABLE ACCESS BY INDEX ROWID         | USERPRIV                |                                                     
|*511 |            INDEX RANGE SCAN                   | I_USERPRIV_UNITCODE_FK  |                                                     
|*512 |           INDEX UNIQUE SCAN                   | C_USERROLES_ROLEAUTH_PK |                                                     
|*513 |      FILTER                                   |                         |                                                     
|*514 |       FILTER                                  |                         |                                                     
| 515 |        NESTED LOOPS OUTER                     |                         |                                                     
| 516 |         NESTED LOOPS                          |                         |                                                     
| 517 |          NESTED LOOPS                         |                         |                                                     
| 518 |           NESTED LOOPS                        |                         |                                                     
|*519 |            INDEX UNIQUE SCAN                  | C_ACATALOG_PK           |                                                     
|*520 |            INDEX UNIQUE SCAN                  | C_ROLES_PK              |                                                     
| 521 |           TABLE ACCESS BY INDEX ROWID         | UNITFUNC                |                                                     
|*522 |            INDEX RANGE SCAN                   | I_UNITFUNC_UC_FK        |                                                     
|*523 |          TABLE ACCESS BY INDEX ROWID          | UNITLIST                |                                                     
|*524 |           INDEX UNIQUE SCAN                   | C_UNITLIST_PK           |                                                     
| 525 |         TABLE ACCESS BY INDEX ROWID           | DMSRESLOCALES           |                                                     
|*526 |          INDEX UNIQUE SCAN                    | C_DMSRESLOCALES_UK      |                                                     
| 527 |        NESTED LOOPS                           |                         |                                                     
| 528 |         TABLE ACCESS BY INDEX ROWID           | USERPRIV                |                                                     
|*529 |          INDEX RANGE SCAN                     | I_USERPRIV_UNITCODE_FK  |                                                     
|*530 |         INDEX UNIQUE SCAN                     | C_USERROLES_ROLEAUTH_PK |                                                     
| 531 |       VIEW                                    | V_ROLEPRIV2FUNC         |                                                     
| 532 |        UNION-ALL                              |                         |                                                     
| 533 |         SORT UNIQUE                           |                         |                                                     
| 534 |          UNION-ALL                            |                         |                                                     
|*535 |           FILTER                              |                         |                                                     
|*536 |            FILTER                             |                         |                                                     
| 537 |             MERGE JOIN OUTER                  |                         |                                                     
| 538 |              SORT JOIN                        |                         |                                                     
| 539 |               NESTED LOOPS                    |                         |                                                     
| 540 |                NESTED LOOPS                   |                         |                                                     
| 541 |                 NESTED LOOPS                  |                         |                                                     
| 542 |                  NESTED LOOPS OUTER           |                         |                                                     
| 543 |                   NESTED LOOPS                |                         |                                                     
|*544 |                    INDEX UNIQUE SCAN          | C_COMPANIES_PK          |                                                     
|*545 |                    TABLE ACCESS BY INDEX ROWID| UNITFUNC                |                                                     
|*546 |                     INDEX UNIQUE SCAN         | C_UNITFUNC_PK           |                                                     
| 547 |                   TABLE ACCESS BY INDEX ROWID | DMSRESLOCALES           |                                                     
|*548 |                    INDEX UNIQUE SCAN          | C_DMSRESLOCALES_UK      |                                                     
| 549 |                  TABLE ACCESS BY INDEX ROWID  | UNITPRIV                |                                                     
|*550 |                   INDEX RANGE SCAN            | I_UNITPRIV_FUNC_FK      |                                                     
|*551 |                 TABLE ACCESS BY INDEX ROWID   | USERPRIV                |                                                     
|*552 |                  INDEX UNIQUE SCAN            | C_USERPRIV_RN_PK        |                                                     
|*553 |                TABLE ACCESS BY INDEX ROWID    | UNITLIST                |                                                     
|*554 |                 INDEX UNIQUE SCAN             | C_UNITLIST_PK           |                                                     
|*555 |              SORT JOIN                        |                         |                                                     
| 556 |               TABLE ACCESS FULL               | COMPVERLIST             |                                                     
| 557 |            NESTED LOOPS                       |                         |                                                     
| 558 |             TABLE ACCESS BY INDEX ROWID       | USERPRIV                |                                                     
|*559 |              INDEX RANGE SCAN                 | I_USERPRIV_UNITCODE_FK  |                                                     
|*560 |             INDEX UNIQUE SCAN                 | C_USERROLES_ROLEAUTH_PK |                                                     
|*561 |           FILTER                              |                         |                                                     
| 562 |            NESTED LOOPS                       |                         |                                                     
| 563 |             NESTED LOOPS                      |                         |                                                     
| 564 |              NESTED LOOPS                     |                         |                                                     
| 565 |               NESTED LOOPS OUTER              |                         |                                                     
|*566 |                TABLE ACCESS BY INDEX ROWID    | UNITFUNC                |                                                     
|*567 |                 INDEX UNIQUE SCAN             | C_UNITFUNC_PK           |                                                     
| 568 |                TABLE ACCESS BY INDEX ROWID    | DMSRESLOCALES           |                                                     
|*569 |                 INDEX UNIQUE SCAN             | C_DMSRESLOCALES_UK      |                                                     
| 570 |               TABLE ACCESS BY INDEX ROWID     | UNITPRIV                |                                                     
|*571 |                INDEX RANGE SCAN               | I_UNITPRIV_FUNC_FK      |                                                     
|*572 |              TABLE ACCESS BY INDEX ROWID      | USERPRIV                |                                                     
|*573 |               INDEX UNIQUE SCAN               | C_USERPRIV_RN_PK        |                                                     
|*574 |             TABLE ACCESS BY INDEX ROWID       | UNITLIST                |                                                     
|*575 |              INDEX UNIQUE SCAN                | C_UNITLIST_PK           |                                                     
| 576 |            NESTED LOOPS                       |                         |                                                     
| 577 |             TABLE ACCESS BY INDEX ROWID       | USERPRIV                |                                                     
|*578 |              INDEX RANGE SCAN                 | I_USERPRIV_UNITCODE_FK  |                                                     
|*579 |             INDEX UNIQUE SCAN                 | C_USERROLES_ROLEAUTH_PK |                                                     
|*580 |         FILTER                                |                         |                                                     
|*581 |          FILTER                               |                         |                                                     
| 582 |           MERGE JOIN OUTER                    |                         |                                                     
| 583 |            SORT JOIN                          |                         |                                                     
| 584 |             NESTED LOOPS                      |                         |                                                     
| 585 |              NESTED LOOPS                     |                         |                                                     
| 586 |               NESTED LOOPS                    |                         |                                                     
| 587 |                NESTED LOOPS OUTER             |                         |                                                     
| 588 |                 NESTED LOOPS                  |                         |                                                     
|*589 |                  INDEX UNIQUE SCAN            | C_COMPANIES_PK          |                                                     
|*590 |                  TABLE ACCESS BY INDEX ROWID  | UNITFUNC                |                                                     
|*591 |                   INDEX UNIQUE SCAN           | C_UNITFUNC_PK           |                                                     
| 592 |                 TABLE ACCESS BY INDEX ROWID   | DMSRESLOCALES           |                                                     
|*593 |                  INDEX UNIQUE SCAN            | C_DMSRESLOCALES_UK      |                                                     
| 594 |                TABLE ACCESS BY INDEX ROWID    | USERPRIV                |                                                     
| 595 |                 AND-EQUAL                     |                         |                                                     
|*596 |                  INDEX RANGE SCAN             | I_USERPRIV_ROLEID_FK    |                                                     
|*597 |                  INDEX RANGE SCAN             | I_USERPRIV_CATALOG_FK   |                                                     
|*598 |               TABLE ACCESS BY INDEX ROWID     | UNITLIST                |                                                     
|*599 |                INDEX UNIQUE SCAN              | C_UNITLIST_PK           |                                                     
|*600 |              INDEX UNIQUE SCAN                | C_UNITPRIV_UK           |                                                     
|*601 |            SORT JOIN                          |                         |                                                     
| 602 |             TABLE ACCESS FULL                 | COMPVERLIST             |                                                     
| 603 |          NESTED LOOPS                         |                         |                                                     
| 604 |           TABLE ACCESS BY INDEX ROWID         | USERPRIV                |                                                     
|*605 |            INDEX RANGE SCAN                   | I_USERPRIV_UNITCODE_FK  |                                                     
|*606 |           INDEX UNIQUE SCAN                   | C_USERROLES_ROLEAUTH_PK |                                                     
|*607 |         FILTER                                |                         |                                                     
| 608 |          NESTED LOOPS                         |                         |                                                     
| 609 |           NESTED LOOPS                        |                         |                                                     
| 610 |            NESTED LOOPS                       |                         |                                                     
| 611 |             NESTED LOOPS OUTER                |                         |                                                     
|*612 |              TABLE ACCESS BY INDEX ROWID      | UNITFUNC                |                                                     
|*613 |               INDEX UNIQUE SCAN               | C_UNITFUNC_PK           |                                                     
| 614 |              TABLE ACCESS BY INDEX ROWID      | DMSRESLOCALES           |                                                     
|*615 |               INDEX UNIQUE SCAN               | C_DMSRESLOCALES_UK      |                                                     
|*616 |             TABLE ACCESS BY INDEX ROWID       | USERPRIV                |                                                     
| 617 |              AND-EQUAL                        |                         |                                                     
|*618 |               INDEX RANGE SCAN                | I_USERPRIV_ROLEID_FK    |                                                     
|*619 |               INDEX RANGE SCAN                | I_USERPRIV_CATALOG_FK   |                                                     
|*620 |            TABLE ACCESS BY INDEX ROWID        | UNITLIST                |                                                     
|*621 |             INDEX UNIQUE SCAN                 | C_UNITLIST_PK           |                                                     
|*622 |           INDEX UNIQUE SCAN                   | C_UNITPRIV_UK           |                                                     
| 623 |          NESTED LOOPS                         |                         |                                                     
| 624 |           TABLE ACCESS BY INDEX ROWID         | USERPRIV                |                                                     
|*625 |            INDEX RANGE SCAN                   | I_USERPRIV_UNITCODE_FK  |                                                     
|*626 |           INDEX UNIQUE SCAN                   | C_USERROLES_ROLEAUTH_PK |                                                     
|*627 |         FILTER                                |                         |                                                     
| 628 |          NESTED LOOPS                         |                         |                                                     
| 629 |           NESTED LOOPS                        |                         |                                                     
| 630 |            NESTED LOOPS                       |                         |                                                     
| 631 |             NESTED LOOPS OUTER                |                         |                                                     
|*632 |              TABLE ACCESS BY INDEX ROWID      | UNITFUNC                |                                                     
|*633 |               INDEX UNIQUE SCAN               | C_UNITFUNC_PK           |                                                     
| 634 |              TABLE ACCESS BY INDEX ROWID      | DMSRESLOCALES           |                                                     
|*635 |               INDEX UNIQUE SCAN               | C_DMSRESLOCALES_UK      |                                                     
| 636 |             TABLE ACCESS BY INDEX ROWID       | UNITPRIV                |                                                     
|*637 |              INDEX RANGE SCAN                 | I_UNITPRIV_FUNC_FK      |                                                     
|*638 |            TABLE ACCESS BY INDEX ROWID        | USERPRIV                |                                                     
|*639 |             INDEX UNIQUE SCAN                 | C_USERPRIV_RN_PK        |                                                     
|*640 |           TABLE ACCESS BY INDEX ROWID         | UNITLIST                |                                                     
|*641 |            INDEX UNIQUE SCAN                  | C_UNITLIST_PK           |                                                     
| 642 |          NESTED LOOPS                         |                         |                                                     
| 643 |           TABLE ACCESS BY INDEX ROWID         | USERPRIV                |                                                     
|*644 |            INDEX RANGE SCAN                   | I_USERPRIV_UNITCODE_FK  |                                                     
|*645 |           INDEX UNIQUE SCAN                   | C_USERROLES_ROLEAUTH_PK |                                                     
|*646 |      FILTER                                   |                         |                                                     
|*647 |       FILTER                                  |                         |                                                     
| 648 |        NESTED LOOPS OUTER                     |                         |                                                     
| 649 |         NESTED LOOPS                          |                         |                                                     
| 650 |          NESTED LOOPS                         |                         |                                                     
| 651 |           NESTED LOOPS                        |                         |                                                     
| 652 |            NESTED LOOPS                       |                         |                                                     
|*653 |             INDEX UNIQUE SCAN                 | C_JURPERSONS_PK         |                                                     
|*654 |             INDEX UNIQUE SCAN                 | C_COMPANIES_PK          |                                                     
|*655 |            INDEX UNIQUE SCAN                  | C_ROLES_PK              |                                                     
| 656 |           TABLE ACCESS BY INDEX ROWID         | UNITFUNC                |                                                     
|*657 |            INDEX RANGE SCAN                   | I_UNITFUNC_UC_FK        |                                                     
|*658 |          TABLE ACCESS BY INDEX ROWID          | UNITLIST                |                                                     
|*659 |           INDEX UNIQUE SCAN                   | C_UNITLIST_PK           |                                                     
| 660 |         TABLE ACCESS BY INDEX ROWID           | DMSRESLOCALES           |                                                     
|*661 |          INDEX UNIQUE SCAN                    | C_DMSRESLOCALES_UK      |                                                     
| 662 |        NESTED LOOPS                           |                         |                                                     
| 663 |         TABLE ACCESS BY INDEX ROWID           | USERPRIV                |                                                     
|*664 |          INDEX RANGE SCAN                     | I_USERPRIV_UNITCODE_FK  |                                                     
|*665 |         INDEX UNIQUE SCAN                     | C_USERROLES_ROLEAUTH_PK |                                                     
| 666 |       VIEW                                    | V_ROLEPRIV2FUNC         |                                                     
| 667 |        UNION-ALL                              |                         |                                                     
| 668 |         SORT UNIQUE                           |                         |                                                     
| 669 |          UNION-ALL                            |                         |                                                     
|*670 |           FILTER                              |                         |                                                     
|*671 |            FILTER                             |                         |                                                     
| 672 |             MERGE JOIN OUTER                  |                         |                                                     
| 673 |              SORT JOIN                        |                         |                                                     
| 674 |               NESTED LOOPS                    |                         |                                                     
| 675 |                NESTED LOOPS                   |                         |                                                     
| 676 |                 NESTED LOOPS                  |                         |                                                     
| 677 |                  NESTED LOOPS OUTER           |                         |                                                     
| 678 |                   NESTED LOOPS                |                         |                                                     
|*679 |                    INDEX UNIQUE SCAN          | C_COMPANIES_PK          |                                                     
|*680 |                    TABLE ACCESS BY INDEX ROWID| UNITFUNC                |                                                     
|*681 |                     INDEX UNIQUE SCAN         | C_UNITFUNC_PK           |                                                     
| 682 |                   TABLE ACCESS BY INDEX ROWID | DMSRESLOCALES           |                                                     
|*683 |                    INDEX UNIQUE SCAN          | C_DMSRESLOCALES_UK      |                                                     
| 684 |                  TABLE ACCESS BY INDEX ROWID  | UNITPRIV                |                                                     
|*685 |                   INDEX RANGE SCAN            | I_UNITPRIV_FUNC_FK      |                                                     
|*686 |                 TABLE ACCESS BY INDEX ROWID   | USERPRIV                |                                                     
|*687 |                  INDEX UNIQUE SCAN            | C_USERPRIV_RN_PK        |                                                     
|*688 |                TABLE ACCESS BY INDEX ROWID    | UNITLIST                |                                                     
|*689 |                 INDEX UNIQUE SCAN             | C_UNITLIST_PK           |                                                     
|*690 |              SORT JOIN                        |                         |                                                     
| 691 |               TABLE ACCESS FULL               | COMPVERLIST             |                                                     
| 692 |            NESTED LOOPS                       |                         |                                                     
| 693 |             TABLE ACCESS BY INDEX ROWID       | USERPRIV                |                                                     
|*694 |              INDEX RANGE SCAN                 | I_USERPRIV_UNITCODE_FK  |                                                     
|*695 |             INDEX UNIQUE SCAN                 | C_USERROLES_ROLEAUTH_PK |                                                     
|*696 |           FILTER                              |                         |                                                     
| 697 |            NESTED LOOPS                       |                         |                                                     
| 698 |             NESTED LOOPS                      |                         |                                                     
| 699 |              NESTED LOOPS                     |                         |                                                     
| 700 |               NESTED LOOPS OUTER              |                         |                                                     
|*701 |                TABLE ACCESS BY INDEX ROWID    | UNITFUNC                |                                                     
|*702 |                 INDEX UNIQUE SCAN             | C_UNITFUNC_PK           |                                                     
| 703 |                TABLE ACCESS BY INDEX ROWID    | DMSRESLOCALES           |                                                     
|*704 |                 INDEX UNIQUE SCAN             | C_DMSRESLOCALES_UK      |                                                     
| 705 |               TABLE ACCESS BY INDEX ROWID     | UNITPRIV                |                                                     
|*706 |                INDEX RANGE SCAN               | I_UNITPRIV_FUNC_FK      |                                                     
|*707 |              TABLE ACCESS BY INDEX ROWID      | USERPRIV                |                                                     
|*708 |               INDEX UNIQUE SCAN               | C_USERPRIV_RN_PK        |                                                     
|*709 |             TABLE ACCESS BY INDEX ROWID       | UNITLIST                |                                                     
|*710 |              INDEX UNIQUE SCAN                | C_UNITLIST_PK           |                                                     
| 711 |            NESTED LOOPS                       |                         |                                                     
| 712 |             TABLE ACCESS BY INDEX ROWID       | USERPRIV                |                                                     
|*713 |              INDEX RANGE SCAN                 | I_USERPRIV_UNITCODE_FK  |                                                     
|*714 |             INDEX UNIQUE SCAN                 | C_USERROLES_ROLEAUTH_PK |                                                     
|*715 |         FILTER                                |                         |                                                     
|*716 |          FILTER                               |                         |                                                     
| 717 |           MERGE JOIN OUTER                    |                         |                                                     
| 718 |            SORT JOIN                          |                         |                                                     
| 719 |             NESTED LOOPS                      |                         |                                                     
| 720 |              NESTED LOOPS                     |                         |                                                     
| 721 |               NESTED LOOPS                    |                         |                                                     
| 722 |                NESTED LOOPS OUTER             |                         |                                                     
| 723 |                 NESTED LOOPS                  |                         |                                                     
|*724 |                  INDEX UNIQUE SCAN            | C_COMPANIES_PK          |                                                     
|*725 |                  TABLE ACCESS BY INDEX ROWID  | UNITFUNC                |                                                     
|*726 |                   INDEX UNIQUE SCAN           | C_UNITFUNC_PK           |                                                     
| 727 |                 TABLE ACCESS BY INDEX ROWID   | DMSRESLOCALES           |                                                     
|*728 |                  INDEX UNIQUE SCAN            | C_DMSRESLOCALES_UK      |                                                     
| 729 |                TABLE ACCESS BY INDEX ROWID    | UNITPRIV                |                                                     
|*730 |                 INDEX RANGE SCAN              | I_UNITPRIV_FUNC_FK      |                                                     
|*731 |               TABLE ACCESS BY INDEX ROWID     | USERPRIV                |                                                     
|*732 |                INDEX UNIQUE SCAN              | C_USERPRIV_RN_PK        |                                                     
|*733 |              TABLE ACCESS BY INDEX ROWID      | UNITLIST                |                                                     
|*734 |               INDEX UNIQUE SCAN               | C_UNITLIST_PK           |                                                     
|*735 |            SORT JOIN                          |                         |                                                     
| 736 |             TABLE ACCESS FULL                 | COMPVERLIST             |                                                     
| 737 |          NESTED LOOPS                         |                         |                                                     
| 738 |           TABLE ACCESS BY INDEX ROWID         | USERPRIV                |                                                     
|*739 |            INDEX RANGE SCAN                   | I_USERPRIV_UNITCODE_FK  |                                                     
|*740 |           INDEX UNIQUE SCAN                   | C_USERROLES_ROLEAUTH_PK |                                                     
|*741 |         FILTER                                |                         |                                                     
| 742 |          NESTED LOOPS                         |                         |                                                     
| 743 |           NESTED LOOPS                        |                         |                                                     
| 744 |            NESTED LOOPS                       |                         |                                                     
| 745 |             NESTED LOOPS OUTER                |                         |                                                     
|*746 |              TABLE ACCESS BY INDEX ROWID      | UNITFUNC                |                                                     
|*747 |               INDEX UNIQUE SCAN               | C_UNITFUNC_PK           |                                                     
| 748 |              TABLE ACCESS BY INDEX ROWID      | DMSRESLOCALES           |                                                     
|*749 |               INDEX UNIQUE SCAN               | C_DMSRESLOCALES_UK      |                                                     
| 750 |             TABLE ACCESS BY INDEX ROWID       | UNITPRIV                |                                                     
|*751 |              INDEX RANGE SCAN                 | I_UNITPRIV_FUNC_FK      |                                                     
|*752 |            TABLE ACCESS BY INDEX ROWID        | USERPRIV                |                                                     
|*753 |             INDEX UNIQUE SCAN                 | C_USERPRIV_RN_PK        |                                                     
|*754 |           TABLE ACCESS BY INDEX ROWID         | UNITLIST                |                                                     
|*755 |            INDEX UNIQUE SCAN                  | C_UNITLIST_PK           |                                                     
| 756 |          NESTED LOOPS                         |                         |                                                     
| 757 |           TABLE ACCESS BY INDEX ROWID         | USERPRIV                |                                                     
|*758 |            INDEX RANGE SCAN                   | I_USERPRIV_UNITCODE_FK  |                                                     
|*759 |           INDEX UNIQUE SCAN                   | C_USERROLES_ROLEAUTH_PK |                                                     
|*760 |         FILTER                                |                         |                                                     
| 761 |          NESTED LOOPS                         |                         |                                                     
| 762 |           NESTED LOOPS                        |                         |                                                     
| 763 |            NESTED LOOPS                       |                         |                                                     
| 764 |             NESTED LOOPS OUTER                |                         |                                                     
|*765 |              TABLE ACCESS BY INDEX ROWID      | UNITFUNC                |                                                     
|*766 |               INDEX UNIQUE SCAN               | C_UNITFUNC_PK           |                                                     
| 767 |              TABLE ACCESS BY INDEX ROWID      | DMSRESLOCALES           |                                                     
|*768 |               INDEX UNIQUE SCAN               | C_DMSRESLOCALES_UK      |                                                     
| 769 |             TABLE ACCESS BY INDEX ROWID       | UNITPRIV                |                                                     
|*770 |              INDEX RANGE SCAN                 | I_UNITPRIV_FUNC_FK      |                                                     
|*771 |            TABLE ACCESS BY INDEX ROWID        | USERPRIV                |                                                     
|*772 |             INDEX UNIQUE SCAN                 | C_USERPRIV_RN_PK        |                                                     
|*773 |           TABLE ACCESS BY INDEX ROWID         | UNITLIST                |                                                     
|*774 |            INDEX UNIQUE SCAN                  | C_UNITLIST_PK           |                                                     
| 775 |          NESTED LOOPS                         |                         |                                                     
| 776 |           TABLE ACCESS BY INDEX ROWID         | USERPRIV                |                                                     
|*777 |            INDEX RANGE SCAN                   | I_USERPRIV_UNITCODE_FK  |                                                     
|*778 |           INDEX UNIQUE SCAN                   | C_USERROLES_ROLEAUTH_PK |                                                     
---------------------------------------------------------------------------------                                                     
                                                                                                                                      
Predicate Information (identified by operation id):                                                                                   
---------------------------------------------------                                                                                   
                                                                                                                                      
   7 - filter(:7 IS NULL AND :4 IS NULL AND  EXISTS (SELECT 0 FROM                                                                    
              PARUS."USERPRIV" "USERPRIV",PARUS."USERROLES" "UR" WHERE                                                                
              "UR"."AUTHID"=USER@! AND "ROLEID"="UR"."ROLEID" AND                                                                     
              "UNITCODE"='RolePrivs'))                                                                                                
   8 - filter("PR"."COMPANY"="CO"."RN" OR "CV"."COMPANY"="CO"."RN")                                                                   
  16 - access("CO"."RN"=TO_NUMBER(:3))                                                                                                
  18 - access("UF"."UNITCODE"=:1)                                                                                                     
  20 - access("UF"."RES_ID"="LR"."PRN"(+) AND                                                                                         
              "LR"."LANG_ID"(+)="GET_NLS_LANGUAGE"())                                                                                 
  22 - access("PRF"."FUNC"="UF"."CODE")                                                                                               
  23 - filter("PR"."ROLEID"=TO_NUMBER(:2))                                                                                            
  24 - access("PR"."RN"="PRF"."PRN")                                                                                                  
  25 - filter("UL"."SIGN_JURPERS"=0 AND "UL"."SIGN_HIER"=0 AND                                                                        
              "UL"."SIGN_SHARE"=1)                                                                                                    
  26 - access("PR"."UNITCODE"="UL"."UNITCODE")                                                                                        
  27 - access("PR"."VERSION"="CV"."VERSION"(+))                                                                                       
       filter("PR"."VERSION"="CV"."VERSION"(+))                                                                                       
  31 - access("UNITCODE"='RolePrivs')                                                                                                 
  32 - access("ROLEID"="UR"."ROLEID" AND "UR"."AUTHID"=USER@!)                                                                        
  33 - filter(:7 IS NULL AND :4 IS NULL AND 0=TO_NUMBER(:3) AND  EXISTS                                                               
              (SELECT 0 FROM PARUS."USERPRIV" "USERPRIV",PARUS."USERROLES" "UR" WHERE                                                 
              "UR"."AUTHID"=USER@! AND "ROLEID"="UR"."ROLEID" AND                                                                     
              "UNITCODE"='RolePrivs'))                                                                                                
  39 - access("UF"."UNITCODE"=:1)                                                                                                     
  41 - access("UF"."RES_ID"="LR"."PRN"(+) AND                                                                                         
              "LR"."LANG_ID"(+)="GET_NLS_LANGUAGE"())                                                                                 
  43 - access("PRF"."FUNC"="UF"."CODE")                                                                                               
  44 - filter("PR"."ROLEID"=TO_NUMBER(:2) AND "PR"."VERSION" IS NULL AND                                                              
              "PR"."COMPANY" IS NULL)                                                                                                 
  45 - access("PR"."RN"="PRF"."PRN")                                                                                                  
  46 - filter("UL"."SIGN_JURPERS"=0 AND "UL"."SIGN_HIER"=0 AND                                                                        
              "UL"."SIGN_SHARE"=0)                                                                                                    
  47 - access("PR"."UNITCODE"="UL"."UNITCODE")                                                                                        
  50 - access("UNITCODE"='RolePrivs')                                                                                                 
  51 - access("ROLEID"="UR"."ROLEID" AND "UR"."AUTHID"=USER@!)                                                                        
  52 - filter(:7 IS NULL AND  EXISTS (SELECT 0 FROM PARUS."USERPRIV"                                                                  
              "USERPRIV",PARUS."USERROLES" "UR" WHERE "UR"."AUTHID"=USER@! AND                                                        
              "ROLEID"="UR"."ROLEID" AND "UNITCODE"='RolePrivs'))                                                                     
  53 - filter("PR"."COMPANY"="CO"."RN" OR "CV"."COMPANY"="CO"."RN")                                                                   
  61 - access("CO"."RN"=TO_NUMBER(:3))                                                                                                
  63 - access("UF"."UNITCODE"=:1)                                                                                                     
  65 - access("UF"."RES_ID"="LR"."PRN"(+) AND                                                                                         
              "LR"."LANG_ID"(+)="GET_NLS_LANGUAGE"())                                                                                 
  67 - access("PRF"."FUNC"="UF"."CODE")                                                                                               
  68 - filter((:4 IS NULL AND "PR"."CATALOG" IS NULL OR :5 IS NOT NULL                                                                
              AND "PR"."CATALOG"=TO_NUMBER(:6)) AND "PR"."ROLEID"=TO_NUMBER(:2))                                                      
  69 - access("PR"."RN"="PRF"."PRN")                                                                                                  
  70 - filter("UL"."SIGN_HIER"=1 AND "UL"."SIGN_SHARE"=1)                                                                             
  71 - access("PR"."UNITCODE"="UL"."UNITCODE")                                                                                        
  72 - access("PR"."VERSION"="CV"."VERSION"(+))                                                                                       
       filter("PR"."VERSION"="CV"."VERSION"(+))                                                                                       
  76 - access("UNITCODE"='RolePrivs')                                                                                                 
  77 - access("ROLEID"="UR"."ROLEID" AND "UR"."AUTHID"=USER@!)                                                                        
  78 - filter(:7 IS NULL AND 0=TO_NUMBER(:3) AND  EXISTS (SELECT 0 FROM                                                               
              PARUS."USERPRIV" "USERPRIV",PARUS."USERROLES" "UR" WHERE                                                                
              "UR"."AUTHID"=USER@! AND "ROLEID"="UR"."ROLEID" AND                                                                     
              "UNITCODE"='RolePrivs'))                                                                                                
  84 - access("UF"."UNITCODE"=:1)                                                                                                     
  86 - access("UF"."RES_ID"="LR"."PRN"(+) AND                                                                                         
              "LR"."LANG_ID"(+)="GET_NLS_LANGUAGE"())                                                                                 
  88 - access("PRF"."FUNC"="UF"."CODE")                                                                                               
  89 - filter((:4 IS NULL AND "PR"."CATALOG" IS NULL OR :5 IS NOT NULL                                                                
              AND "PR"."CATALOG"=TO_NUMBER(:6)) AND "PR"."ROLEID"=TO_NUMBER(:2) AND                                                   
              "PR"."VERSION" IS NULL AND "PR"."COMPANY" IS NULL)                                                                      
  90 - access("PR"."RN"="PRF"."PRN")                                                                                                  
  91 - filter("UL"."SIGN_HIER"=1 AND "UL"."SIGN_SHARE"=0)                                                                             
  92 - access("PR"."UNITCODE"="UL"."UNITCODE")                                                                                        
  95 - access("UNITCODE"='RolePrivs')                                                                                                 
  96 - access("ROLEID"="UR"."ROLEID" AND "UR"."AUTHID"=USER@!)                                                                        
  97 - filter(:4 IS NULL AND  EXISTS (SELECT 0 FROM PARUS."USERPRIV"                                                                  
              "USERPRIV",PARUS."USERROLES" "UR" WHERE "UR"."AUTHID"=USER@! AND                                                        
              "ROLEID"="UR"."ROLEID" AND "UNITCODE"='RolePrivs'))                                                                     
 103 - access("UF"."UNITCODE"=:1)                                                                                                     
 105 - access("UF"."RES_ID"="LR"."PRN"(+) AND                                                                                         
              "LR"."LANG_ID"(+)="GET_NLS_LANGUAGE"())                                                                                 
 107 - access("PRF"."FUNC"="UF"."CODE")                                                                                               
 108 - filter((:7 IS NULL AND "PR"."JUR_PERS" IS NULL OR :8 IS NOT NULL                                                               
              AND "PR"."JUR_PERS"=TO_NUMBER(:9)) AND "PR"."COMPANY"=TO_NUMBER(:3) AND                                                 
              "PR"."ROLEID"=TO_NUMBER(:2))                                                                                            
 109 - access("PR"."RN"="PRF"."PRN")                                                                                                  
 110 - filter("UL"."SIGN_JURPERS"=1 AND "UL"."SIGN_ACCREG"=1 AND                                                                      
              "UL"."SIGN_SHARE"=1)                                                                                                    
 111 - access("PR"."UNITCODE"="UL"."UNITCODE")                                                                                        
 114 - access("UNITCODE"='RolePrivs')                                                                                                 
 115 - access("ROLEID"="UR"."ROLEID" AND "UR"."AUTHID"=USER@!)                                                                        
 118 - filter( NOT EXISTS (SELECT 0 FROM  ( (SELECT 1                                                                                 
              "NACCESS","PR"."ROLEID" "NROLEID","CO"."RN" "NCOMPANY","UF"."UNITCODE"                                                  
              "SUNITCODE",TO_NUMBER(NULL) "NCATALOG",TO_NUMBER(NULL)                                                                  
              "NJUR_PERS","UF"."CODE" "SFUNCCODE",NVL("LR"."TEXT","UF"."NAME")                                                        
              "SFUNCNAME","UF"."NUMB" "SFUNCNUMB" FROM PARUS."UNITLIST"                                                               
              "UL",PARUS."COMPVERLIST" "CV",PARUS."COMPANIES"                                                                         
              "CO",PARUS."DMSRESLOCALES" "LR",PARUS."UNITFUNC" "UF",PARUS."UNITPRIV"                                                  
              "PRF",PARUS."USERPRIV" "PR" WHERE  EXISTS (SELECT 0 FROM                                                                
              PARUS."USERPRIV" "USERPRIV",PARUS."USERROLES" "UR" WHERE                                                                
              "UR"."AUTHID"=USER@! AND "ROLEID"="UR"."ROLEID" AND                                                                     
              "UNITCODE"='RolePrivs') AND "PR"."RN"="PRF"."PRN" AND "PR"."ROLEID"=:B1                                                 
              AND "PRF"."FUNC"="UF"."CODE" AND "UF"."CODE"=:B2 AND "UF"."UNITCODE"=:B3                                                
              AND "LR"."LANG_ID"(+)="GET_NLS_LANGUAGE"() AND                                                                          
              "UF"."RES_ID"="LR"."PRN"(+) AND "CO"."RN"=:B4 AND                                                                       
              "PR"."VERSION"="CV"."VERSION"(+) AND ("PR"."COMPANY"="CO"."RN" OR                                                       
              "CV"."COMPANY"="CO"."RN") AND "PR"."UNITCODE"="UL"."UNITCODE" AND                                                       
              "UL"."SIGN_JURPERS"=0 AND "UL"."SIGN_HIER"=0 AND                                                                        
              "UL"."SIGN_SHARE"=1)UNION (SELECT 1 "NACCESS","PR"."ROLEID" "NROLEID",0                                                 
              "NCOMPANY","UF"."UNITCODE" "SUNITCODE",TO_NUMBER(NULL)                                                                  
              "NCATALOG",TO_NUMBER(NULL) "NJUR_PERS","UF"."CODE"                                                                      
              "SFUNCCODE",NVL("LR"."TEXT","UF"."NAME") "SFUNCNAME","UF"."NUMB"                                                        
              "SFUNCNUMB" FROM PARUS."UNITLIST" "UL",PARUS."DMSRESLOCALES"                                                            
              "LR",PARUS."UNITFUNC" "UF",PARUS."UNITPRIV" "PRF",PARUS."USERPRIV" "PR"                                                 
              WHERE 0=:B5 AND  EXISTS (SELECT 0 FROM PARUS."USERPRIV"                                                                 
              "USERPRIV",PARUS."USERROLES" "UR" WHERE "UR"."AUTHID"=USER@! AND                                                        
              "ROLEID"="UR"."ROLEID" AND "UNITCODE"='RolePrivs') AND                                                                  
              "PR"."RN"="PRF"."PRN" AND "PR"."ROLEID"=:B6 AND "PR"."VERSION" IS NULL                                                  
              AND "PR"."COMPANY" IS NULL AND "PRF"."FUNC"="UF"."CODE" AND                                                             
              "UF"."CODE"=:B7 AND "UF"."UNITCODE"=:B8 AND                                                                             
              "LR"."LANG_ID"(+)="GET_NLS_LANGUAGE"() AND "UF"."RES_ID"="LR"."PRN"(+)                                                  
              AND "PR"."UNITCODE"="UL"."UNITCODE" AND "UL"."SIGN_JURPERS"=0 AND                                                       
              "UL"."SIGN_HIER"=0 AND "UL"."SIGN_SHARE"=0) UNION ALL  (SELECT 1                                                        
              "NACCESS","PR"."ROLEID" "NROLEID","CO"."RN" "NCOMPANY","UF"."UNITCODE"                                                  
              "SUNITCODE","PR"."CATALOG" "NCATALOG",TO_NUMBER(NULL)                                                                   
              "NJUR_PERS","UF"."CODE" "SFUNCCODE",NVL("LR"."TEXT","UF"."NAME")                                                        
              "SFUNCNAME","UF"."NUMB" "SFUNCNUMB" FROM PARUS."UNITLIST"                                                               
              "UL",PARUS."COMPVERLIST" "CV",PARUS."COMPANIES"                                                                         
              "CO",PARUS."DMSRESLOCALES" "LR",PARUS."UNITFUNC" "UF",PARUS."UNITPRIV"                                                  
              "PRF",PARUS."USERPRIV" "PR" WHERE  EXISTS (SELECT 0 FROM                                                                
              PARUS."USERPRIV" "USERPRIV",PARUS."USERROLES" "UR" WHERE                                                                
              "UR"."AUTHID"=USER@! AND "ROLEID"="UR"."ROLEID" AND                                                                     
              "UNITCODE"='RolePrivs') AND "PR"."RN"="PRF"."PRN" AND "PR"."CATALOG" IS                                                 
              NULL AND "PR"."ROLEID"=:B9 AND "PRF"."FUNC"="UF"."CODE" AND                                                             
              "UF"."CODE"=:B10 AND "UF"."UNITCODE"=:B11 AND                                                                           
              "LR"."LANG_ID"(+)="GET_NLS_LANGUAGE"() AND "UF"."RES_ID"="LR"."PRN"(+)                                                  
              AND "CO"."RN"=:B12 AND "PR"."VERSION"="CV"."VERSION"(+) AND                                                             
              ("PR"."COMPANY"="CO"."RN" OR "CV"."COMPANY"="CO"."RN") AND                                                              
              "PR"."UNITCODE"="UL"."UNITCODE" AND "UL"."SIGN_HIER"=1 AND                                                              
              "UL"."SIGN_SHARE"=1) UNION ALL  (SELECT 1 "NACCESS","PR"."ROLEID"                                                       
              "NROLEID",0 "NCOMPANY","UF"."UNITCODE" "SUNITCODE","PR"."CATALOG"                                                       
              "NCATALOG",TO_NUMBER(NULL) "NJUR_PERS","UF"."CODE"                                                                      
              "SFUNCCODE",NVL("LR"."TEXT","UF"."NAME") "SFUNCNAME","UF"."NUMB"                                                        
              "SFUNCNUMB" FROM PARUS."UNITLIST" "UL",PARUS."DMSRESLOCALES"                                                            
              "LR",PARUS."UNITFUNC" "UF",PARUS."UNITPRIV" "PRF",PARUS."USERPRIV" "PR"                                                 
              WHERE 0=:B13 AND  EXISTS (SELECT 0 FROM PARUS."USERPRIV"                                                                
              "USERPRIV",PARUS."USERROLES" "UR" WHERE "UR"."AUTHID"=USER@! AND                                                        
              "ROLEID"="UR"."ROLEID" AND "UNITCODE"='RolePrivs') AND                                                                  
              "PR"."RN"="PRF"."PRN" AND "PR"."CATALOG" IS NULL AND "PR"."ROLEID"=:B14                                                 
              AND "PR"."VERSION" IS NULL AND "PR"."COMPANY" IS NULL AND                                                               
              "PRF"."FUNC"="UF"."CODE" AND "UF"."CODE"=:B15 AND "UF"."UNITCODE"=:B16                                                  
              AND "LR"."LANG_ID"(+)="GET_NLS_LANGUAGE"() AND                                                                          
              "UF"."RES_ID"="LR"."PRN"(+) AND "PR"."UNITCODE"="UL"."UNITCODE" AND                                                     
              "UL"."SIGN_HIER"=1 AND "UL"."SIGN_SHARE"=0) UNION ALL  (SELECT 1                                                        
              "NACCESS","PR"."ROLEID" "NROLEID","PR"."COMPANY"                                                                        
              "NCOMPANY","UF"."UNITCODE" "SUNITCODE",TO_NUMBER(NULL)                                                                  
              "NCATALOG","PR"."JUR_PERS" "NJUR_PERS","UF"."CODE" "SFUNCCODE",NVL("LR)                                                 
 119 - filter(:16 IS NULL AND :13 IS NULL AND  EXISTS (SELECT 0 FROM                                                                  
              PARUS."USERPRIV" "USERPRIV",PARUS."USERROLES" "UR" WHERE                                                                
              "UR"."AUTHID"=USER@! AND "ROLEID"="UR"."ROLEID" AND                                                                     
              "UNITCODE"='RolePrivs'))                                                                                                
 124 - access("CO"."RN"=TO_NUMBER(:12))                                                                                               
 125 - access("RL"."RN"=TO_NUMBER(:11))                                                                                               
 127 - access("UF"."UNITCODE"=:10)                                                                                                    
 128 - filter("UL"."SIGN_JURPERS"=0 AND "UL"."SIGN_HIER"=0 AND                                                                        
              "UL"."SIGN_SHARE"=1)                                                                                                    
 129 - access("UF"."UNITCODE"="UL"."UNITCODE")                                                                                        
 131 - access("UF"."RES_ID"="LR"."PRN"(+) AND                                                                                         
              "LR"."LANG_ID"(+)="GET_NLS_LANGUAGE"())                                                                                 
 134 - access("UNITCODE"='RolePrivs')                                                                                                 
 135 - access("ROLEID"="UR"."ROLEID" AND "UR"."AUTHID"=USER@!)                                                                        
 140 - filter( EXISTS (SELECT 0 FROM PARUS."USERPRIV"                                                                                 
              "USERPRIV",PARUS."USERROLES" "UR" WHERE "UR"."AUTHID"=USER@! AND                                                        
              "ROLEID"="UR"."ROLEID" AND "UNITCODE"='RolePrivs'))                                                                     
 141 - filter("PR"."COMPANY"="CO"."RN" OR "CV"."COMPANY"="CO"."RN")                                                                   
 149 - access("CO"."RN"=:B1)                                                                                                          
 150 - filter("UF"."UNITCODE"=:B1)                                                                                                    
 151 - access("UF"."CODE"=:B1)                                                                                                        
 153 - access("UF"."RES_ID"="LR"."PRN"(+) AND                                                                                         
              "LR"."LANG_ID"(+)="GET_NLS_LANGUAGE"())                                                                                 
 155 - access("PRF"."FUNC"="UF"."CODE")                                                                                               
 156 - filter("PR"."ROLEID"=:B1)                                                                                                      
 157 - access("PR"."RN"="PRF"."PRN")                                                                                                  
 158 - filter("UL"."SIGN_JURPERS"=0 AND "UL"."SIGN_HIER"=0 AND                                                                        
              "UL"."SIGN_SHARE"=1)                                                                                                    
 159 - access("PR"."UNITCODE"="UL"."UNITCODE")                                                                                        
 160 - access("PR"."VERSION"="CV"."VERSION"(+))                                                                                       
       filter("PR"."VERSION"="CV"."VERSION"(+))                                                                                       
 164 - access("UNITCODE"='RolePrivs')                                                                                                 
 165 - access("ROLEID"="UR"."ROLEID" AND "UR"."AUTHID"=USER@!)                                                                        
 166 - filter(0=:B1 AND  EXISTS (SELECT 0 FROM PARUS."USERPRIV"                                                                       
              "USERPRIV",PARUS."USERROLES" "UR" WHERE "UR"."AUTHID"=USER@! AND                                                        
              "ROLEID"="UR"."ROLEID" AND "UNITCODE"='RolePrivs'))                                                                     
 171 - filter("UF"."UNITCODE"=:B1)                                                                                                    
 172 - access("UF"."CODE"=:B1)                                                                                                        
 174 - access("UF"."RES_ID"="LR"."PRN"(+) AND                                                                                         
              "LR"."LANG_ID"(+)="GET_NLS_LANGUAGE"())                                                                                 
 176 - access("PRF"."FUNC"="UF"."CODE")                                                                                               
 177 - filter("PR"."ROLEID"=:B1 AND "PR"."VERSION" IS NULL AND                                                                        
              "PR"."COMPANY" IS NULL)                                                                                                 
 178 - access("PR"."RN"="PRF"."PRN")                                                                                                  
 179 - filter("UL"."SIGN_JURPERS"=0 AND "UL"."SIGN_HIER"=0 AND                                                                        
              "UL"."SIGN_SHARE"=0)                                                                                                    
 180 - access("PR"."UNITCODE"="UL"."UNITCODE")                                                                                        
 183 - access("UNITCODE"='RolePrivs')                                                                                                 
 184 - access("ROLEID"="UR"."ROLEID" AND "UR"."AUTHID"=USER@!)                                                                        
 185 - filter( EXISTS (SELECT 0 FROM PARUS."USERPRIV"                                                                                 
              "USERPRIV",PARUS."USERROLES" "UR" WHERE "UR"."AUTHID"=USER@! AND                                                        
              "ROLEID"="UR"."ROLEID" AND "UNITCODE"='RolePrivs'))                                                                     
 186 - filter("PR"."COMPANY"="CO"."RN" OR "CV"."COMPANY"="CO"."RN")                                                                   
 194 - access("CO"."RN"=:B1)                                                                                                          
 195 - filter("UF"."UNITCODE"=:B1)                                                                                                    
 196 - access("UF"."CODE"=:B1)                                                                                                        
 198 - access("UF"."RES_ID"="LR"."PRN"(+) AND                                                                                         
              "LR"."LANG_ID"(+)="GET_NLS_LANGUAGE"())                                                                                 
 200 - access("PRF"."FUNC"="UF"."CODE")                                                                                               
 201 - filter("PR"."CATALOG" IS NULL AND "PR"."ROLEID"=:B1)                                                                           
 202 - access("PR"."RN"="PRF"."PRN")                                                                                                  
 203 - filter("UL"."SIGN_HIER"=1 AND "UL"."SIGN_SHARE"=1)                                                                             
 204 - access("PR"."UNITCODE"="UL"."UNITCODE")                                                                                        
 205 - access("PR"."VERSION"="CV"."VERSION"(+))                                                                                       
       filter("PR"."VERSION"="CV"."VERSION"(+))                                                                                       
 209 - access("UNITCODE"='RolePrivs')                                                                                                 
 210 - access("ROLEID"="UR"."ROLEID" AND "UR"."AUTHID"=USER@!)                                                                        
 211 - filter(0=:B1 AND  EXISTS (SELECT 0 FROM PARUS."USERPRIV"                                                                       
              "USERPRIV",PARUS."USERROLES" "UR" WHERE "UR"."AUTHID"=USER@! AND                                                        
              "ROLEID"="UR"."ROLEID" AND "UNITCODE"='RolePrivs'))                                                                     
 216 - filter("UF"."UNITCODE"=:B1)                                                                                                    
 217 - access("UF"."CODE"=:B1)                                                                                                        
 219 - access("UF"."RES_ID"="LR"."PRN"(+) AND                                                                                         
              "LR"."LANG_ID"(+)="GET_NLS_LANGUAGE"())                                                                                 
 221 - access("PRF"."FUNC"="UF"."CODE")                                                                                               
 222 - filter("PR"."CATALOG" IS NULL AND "PR"."ROLEID"=:B1 AND                                                                        
              "PR"."VERSION" IS NULL AND "PR"."COMPANY" IS NULL)                                                                      
 223 - access("PR"."RN"="PRF"."PRN")                                                                                                  
 224 - filter("UL"."SIGN_HIER"=1 AND "UL"."SIGN_SHARE"=0)                                                                             
 225 - access("PR"."UNITCODE"="UL"."UNITCODE")                                                                                        
 228 - access("UNITCODE"='RolePrivs')                                                                                                 
 229 - access("ROLEID"="UR"."ROLEID" AND "UR"."AUTHID"=USER@!)                                                                        
 230 - filter( EXISTS (SELECT 0 FROM PARUS."USERPRIV"                                                                                 
              "USERPRIV",PARUS."USERROLES" "UR" WHERE "UR"."AUTHID"=USER@! AND                                                        
              "ROLEID"="UR"."ROLEID" AND "UNITCODE"='RolePrivs'))                                                                     
 235 - filter("UF"."UNITCODE"=:B1)                                                                                                    
 236 - access("UF"."CODE"=:B1)                                                                                                        
 238 - access("UF"."RES_ID"="LR"."PRN"(+) AND                                                                                         
              "LR"."LANG_ID"(+)="GET_NLS_LANGUAGE"())                                                                                 
 240 - access("PRF"."FUNC"="UF"."CODE")                                                                                               
 241 - filter("PR"."JUR_PERS" IS NULL AND "PR"."COMPANY"=:B1 AND                                                                      
              "PR"."ROLEID"=:B2)                                                                                                      
 242 - access("PR"."RN"="PRF"."PRN")                                                                                                  
 243 - filter("UL"."SIGN_JURPERS"=1 AND "UL"."SIGN_ACCREG"=1 AND                                                                      
              "UL"."SIGN_SHARE"=1)                                                                                                    
 244 - access("PR"."UNITCODE"="UL"."UNITCODE")                                                                                        
 247 - access("UNITCODE"='RolePrivs')                                                                                                 
 248 - access("ROLEID"="UR"."ROLEID" AND "UR"."AUTHID"=USER@!)                                                                        
 249 - filter( NOT EXISTS (SELECT 0 FROM  ( (SELECT 1                                                                                 
              "NACCESS","PR"."ROLEID" "NROLEID","CO"."RN" "NCOMPANY","UF"."UNITCODE"                                                  
              "SUNITCODE",TO_NUMBER(NULL) "NCATALOG",TO_NUMBER(NULL)                                                                  
              "NJUR_PERS","UF"."CODE" "SFUNCCODE",NVL("LR"."TEXT","UF"."NAME")                                                        
              "SFUNCNAME","UF"."NUMB" "SFUNCNUMB" FROM PARUS."UNITLIST"                                                               
              "UL",PARUS."COMPVERLIST" "CV",PARUS."COMPANIES"                                                                         
              "CO",PARUS."DMSRESLOCALES" "LR",PARUS."UNITFUNC" "UF",PARUS."UNITPRIV"                                                  
              "PRF",PARUS."USERPRIV" "PR" WHERE  EXISTS (SELECT 0 FROM                                                                
              PARUS."USERPRIV" "USERPRIV",PARUS."USERROLES" "UR" WHERE                                                                
              "UR"."AUTHID"=USER@! AND "ROLEID"="UR"."ROLEID" AND                                                                     
              "UNITCODE"='RolePrivs') AND "PR"."RN"="PRF"."PRN" AND "PR"."ROLEID"=:B1                                                 
              AND "PRF"."FUNC"="UF"."CODE" AND "UF"."CODE"=:B2 AND "UF"."UNITCODE"=:B3                                                
              AND "LR"."LANG_ID"(+)="GET_NLS_LANGUAGE"() AND                                                                          
              "UF"."RES_ID"="LR"."PRN"(+) AND "CO"."RN"=0 AND                                                                         
              "PR"."VERSION"="CV"."VERSION"(+) AND ("PR"."COMPANY"="CO"."RN" OR                                                       
              "CV"."COMPANY"="CO"."RN") AND "PR"."UNITCODE"="UL"."UNITCODE" AND                                                       
              "UL"."SIGN_JURPERS"=0 AND "UL"."SIGN_HIER"=0 AND                                                                        
              "UL"."SIGN_SHARE"=1)UNION (SELECT 1 "NACCESS","PR"."ROLEID" "NROLEID",0                                                 
              "NCOMPANY","UF"."UNITCODE" "SUNITCODE",TO_NUMBER(NULL)                                                                  
              "NCATALOG",TO_NUMBER(NULL) "NJUR_PERS","UF"."CODE"                                                                      
              "SFUNCCODE",NVL("LR"."TEXT","UF"."NAME") "SFUNCNAME","UF"."NUMB"                                                        
              "SFUNCNUMB" FROM PARUS."UNITLIST" "UL",PARUS."DMSRESLOCALES"                                                            
              "LR",PARUS."UNITFUNC" "UF",PARUS."UNITPRIV" "PRF",PARUS."USERPRIV" "PR"                                                 
              WHERE  EXISTS (SELECT 0 FROM PARUS."USERPRIV"                                                                           
              "USERPRIV",PARUS."USERROLES" "UR" WHERE "UR"."AUTHID"=USER@! AND                                                        
              "ROLEID"="UR"."ROLEID" AND "UNITCODE"='RolePrivs') AND                                                                  
              "PR"."RN"="PRF"."PRN" AND "PR"."ROLEID"=:B4 AND "PR"."VERSION" IS NULL                                                  
              AND "PR"."COMPANY" IS NULL AND "PRF"."FUNC"="UF"."CODE" AND                                                             
              "UF"."CODE"=:B5 AND "UF"."UNITCODE"=:B6 AND                                                                             
              "LR"."LANG_ID"(+)="GET_NLS_LANGUAGE"() AND "UF"."RES_ID"="LR"."PRN"(+)                                                  
              AND "PR"."UNITCODE"="UL"."UNITCODE" AND "UL"."SIGN_JURPERS"=0 AND                                                       
              "UL"."SIGN_HIER"=0 AND "UL"."SIGN_SHARE"=0) UNION ALL  (SELECT 1                                                        
              "NACCESS","PR"."ROLEID" "NROLEID","CO"."RN" "NCOMPANY","UF"."UNITCODE"                                                  
              "SUNITCODE","PR"."CATALOG" "NCATALOG",TO_NUMBER(NULL)                                                                   
              "NJUR_PERS","UF"."CODE" "SFUNCCODE",NVL("LR"."TEXT","UF"."NAME")                                                        
              "SFUNCNAME","UF"."NUMB" "SFUNCNUMB" FROM PARUS."UNITLIST"                                                               
              "UL",PARUS."COMPVERLIST" "CV",PARUS."COMPANIES"                                                                         
              "CO",PARUS."DMSRESLOCALES" "LR",PARUS."UNITFUNC" "UF",PARUS."UNITPRIV"                                                  
              "PRF",PARUS."USERPRIV" "PR" WHERE  EXISTS (SELECT 0 FROM                                                                
              PARUS."USERPRIV" "USERPRIV",PARUS."USERROLES" "UR" WHERE                                                                
              "UR"."AUTHID"=USER@! AND "ROLEID"="UR"."ROLEID" AND                                                                     
              "UNITCODE"='RolePrivs') AND "PR"."RN"="PRF"."PRN" AND "PR"."CATALOG" IS                                                 
              NULL AND "PR"."ROLEID"=:B7 AND "PRF"."FUNC"="UF"."CODE" AND                                                             
              "UF"."CODE"=:B8 AND "UF"."UNITCODE"=:B9 AND                                                                             
              "LR"."LANG_ID"(+)="GET_NLS_LANGUAGE"() AND "UF"."RES_ID"="LR"."PRN"(+)                                                  
              AND "CO"."RN"=0 AND "PR"."VERSION"="CV"."VERSION"(+) AND                                                                
              ("PR"."COMPANY"="CO"."RN" OR "CV"."COMPANY"="CO"."RN") AND                                                              
              "PR"."UNITCODE"="UL"."UNITCODE" AND "UL"."SIGN_HIER"=1 AND                                                              
              "UL"."SIGN_SHARE"=1) UNION ALL  (SELECT 1 "NACCESS","PR"."ROLEID"                                                       
              "NROLEID",0 "NCOMPANY","UF"."UNITCODE" "SUNITCODE","PR"."CATALOG"                                                       
              "NCATALOG",TO_NUMBER(NULL) "NJUR_PERS","UF"."CODE"                                                                      
              "SFUNCCODE",NVL("LR"."TEXT","UF"."NAME") "SFUNCNAME","UF"."NUMB"                                                        
              "SFUNCNUMB" FROM PARUS."UNITLIST" "UL",PARUS."DMSRESLOCALES"                                                            
              "LR",PARUS."UNITFUNC" "UF",PARUS."UNITPRIV" "PRF",PARUS."USERPRIV" "PR"                                                 
              WHERE  EXISTS (SELECT 0 FROM PARUS."USERPRIV"                                                                           
              "USERPRIV",PARUS."USERROLES" "UR" WHERE "UR"."AUTHID"=USER@! AND                                                        
              "ROLEID"="UR"."ROLEID" AND "UNITCODE"='RolePrivs') AND                                                                  
              "PR"."RN"="PRF"."PRN" AND "PR"."CATALOG" IS NULL AND "PR"."ROLEID"=:B10                                                 
              AND "PR"."VERSION" IS NULL AND "PR"."COMPANY" IS NULL AND                                                               
              "PRF"."FUNC"="UF"."CODE" AND "UF"."CODE"=:B11 AND "UF"."UNITCODE"=:B12                                                  
              AND "LR"."LANG_ID"(+)="GET_NLS_LANGUAGE"() AND                                                                          
              "UF"."RES_ID"="LR"."PRN"(+) AND "PR"."UNITCODE"="UL"."UNITCODE" AND                                                     
              "UL"."SIGN_HIER"=1 AND "UL"."SIGN_SHARE"=0) UNION ALL  (SELECT 1                                                        
              "NACCESS","PR"."ROLEID" "NROLEID","PR"."COMPANY"                                                                        
              "NCOMPANY","UF"."UNITCODE" "SUNITCODE",TO_NUMBER(NULL)                                                                  
              "NCATALOG","PR"."JUR_PERS" "NJUR_PERS","UF"."CODE"                                                                      
              "SFUNCCODE",NVL("LR"."TEXT","UF"."NAME") "SFUNC)                                                                        
 250 - filter(:16 IS NULL AND :13 IS NULL AND 0=TO_NUMBER(:12) AND                                                                    
              EXISTS (SELECT 0 FROM PARUS."USERPRIV" "USERPRIV",PARUS."USERROLES" "UR"                                                
              WHERE "UR"."AUTHID"=USER@! AND "ROLEID"="UR"."ROLEID" AND                                                               
              "UNITCODE"='RolePrivs'))                                                                                                
 254 - access("RL"."RN"=TO_NUMBER(:11))                                                                                               
 256 - access("UF"."UNITCODE"=:10)                                                                                                    
 257 - filter("UL"."SIGN_JURPERS"=0 AND "UL"."SIGN_HIER"=0 AND                                                                        
              "UL"."SIGN_SHARE"=0)                                                                                                    
 258 - access("UF"."UNITCODE"="UL"."UNITCODE")                                                                                        
 260 - access("UF"."RES_ID"="LR"."PRN"(+) AND                                                                                         
              "LR"."LANG_ID"(+)="GET_NLS_LANGUAGE"())                                                                                 
 263 - access("UNITCODE"='RolePrivs')                                                                                                 
 264 - access("ROLEID"="UR"."ROLEID" AND "UR"."AUTHID"=USER@!)                                                                        
 269 - filter( EXISTS (SELECT 0 FROM PARUS."USERPRIV"                                                                                 
              "USERPRIV",PARUS."USERROLES" "UR" WHERE "UR"."AUTHID"=USER@! AND                                                        
              "ROLEID"="UR"."ROLEID" AND "UNITCODE"='RolePrivs'))                                                                     
 270 - filter("PR"."COMPANY"="CO"."RN" OR "CV"."COMPANY"="CO"."RN")                                                                   
 278 - access("CO"."RN"=0)                                                                                                            
 279 - filter("UF"."UNITCODE"=:B1)                                                                                                    
 280 - access("UF"."CODE"=:B1)                                                                                                        
 282 - access("UF"."RES_ID"="LR"."PRN"(+) AND                                                                                         
              "LR"."LANG_ID"(+)="GET_NLS_LANGUAGE"())                                                                                 
 284 - access("PRF"."FUNC"="UF"."CODE")                                                                                               
 285 - filter("PR"."ROLEID"=:B1)                                                                                                      
 286 - access("PR"."RN"="PRF"."PRN")                                                                                                  
 287 - filter("UL"."SIGN_JURPERS"=0 AND "UL"."SIGN_HIER"=0 AND                                                                        
              "UL"."SIGN_SHARE"=1)                                                                                                    
 288 - access("PR"."UNITCODE"="UL"."UNITCODE")                                                                                        
 289 - access("PR"."VERSION"="CV"."VERSION"(+))                                                                                       
       filter("PR"."VERSION"="CV"."VERSION"(+))                                                                                       
 293 - access("UNITCODE"='RolePrivs')                                                                                                 
 294 - access("ROLEID"="UR"."ROLEID" AND "UR"."AUTHID"=USER@!)                                                                        
 295 - filter( EXISTS (SELECT 0 FROM PARUS."USERPRIV"                                                                                 
              "USERPRIV",PARUS."USERROLES" "UR" WHERE "UR"."AUTHID"=USER@! AND                                                        
              "ROLEID"="UR"."ROLEID" AND "UNITCODE"='RolePrivs'))                                                                     
 300 - filter("UF"."UNITCODE"=:B1)                                                                                                    
 301 - access("UF"."CODE"=:B1)                                                                                                        
 303 - access("UF"."RES_ID"="LR"."PRN"(+) AND                                                                                         
              "LR"."LANG_ID"(+)="GET_NLS_LANGUAGE"())                                                                                 
 305 - access("PRF"."FUNC"="UF"."CODE")                                                                                               
 306 - filter("PR"."ROLEID"=:B1 AND "PR"."VERSION" IS NULL AND                                                                        
              "PR"."COMPANY" IS NULL)                                                                                                 
 307 - access("PR"."RN"="PRF"."PRN")                                                                                                  
 308 - filter("UL"."SIGN_JURPERS"=0 AND "UL"."SIGN_HIER"=0 AND                                                                        
              "UL"."SIGN_SHARE"=0)                                                                                                    
 309 - access("PR"."UNITCODE"="UL"."UNITCODE")                                                                                        
 312 - access("UNITCODE"='RolePrivs')                                                                                                 
 313 - access("ROLEID"="UR"."ROLEID" AND "UR"."AUTHID"=USER@!)                                                                        
 314 - filter( EXISTS (SELECT 0 FROM PARUS."USERPRIV"                                                                                 
              "USERPRIV",PARUS."USERROLES" "UR" WHERE "UR"."AUTHID"=USER@! AND                                                        
              "ROLEID"="UR"."ROLEID" AND "UNITCODE"='RolePrivs'))                                                                     
 315 - filter("PR"."COMPANY"="CO"."RN" OR "CV"."COMPANY"="CO"."RN")                                                                   
 323 - access("CO"."RN"=0)                                                                                                            
 324 - filter("UF"."UNITCODE"=:B1)                                                                                                    
 325 - access("UF"."CODE"=:B1)                                                                                                        
 327 - access("UF"."RES_ID"="LR"."PRN"(+) AND                                                                                         
              "LR"."LANG_ID"(+)="GET_NLS_LANGUAGE"())                                                                                 
 329 - access("PRF"."FUNC"="UF"."CODE")                                                                                               
 330 - filter("PR"."CATALOG" IS NULL AND "PR"."ROLEID"=:B1)                                                                           
 331 - access("PR"."RN"="PRF"."PRN")                                                                                                  
 332 - filter("UL"."SIGN_HIER"=1 AND "UL"."SIGN_SHARE"=1)                                                                             
 333 - access("PR"."UNITCODE"="UL"."UNITCODE")                                                                                        
 334 - access("PR"."VERSION"="CV"."VERSION"(+))                                                                                       
       filter("PR"."VERSION"="CV"."VERSION"(+))                                                                                       
 338 - access("UNITCODE"='RolePrivs')                                                                                                 
 339 - access("ROLEID"="UR"."ROLEID" AND "UR"."AUTHID"=USER@!)                                                                        
 340 - filter( EXISTS (SELECT 0 FROM PARUS."USERPRIV"                                                                                 
              "USERPRIV",PARUS."USERROLES" "UR" WHERE "UR"."AUTHID"=USER@! AND                                                        
              "ROLEID"="UR"."ROLEID" AND "UNITCODE"='RolePrivs'))                                                                     
 345 - filter("UF"."UNITCODE"=:B1)                                                                                                    
 346 - access("UF"."CODE"=:B1)                                                                                                        
 348 - access("UF"."RES_ID"="LR"."PRN"(+) AND                                                                                         
              "LR"."LANG_ID"(+)="GET_NLS_LANGUAGE"())                                                                                 
 350 - access("PRF"."FUNC"="UF"."CODE")                                                                                               
 351 - filter("PR"."CATALOG" IS NULL AND "PR"."ROLEID"=:B1 AND                                                                        
              "PR"."VERSION" IS NULL AND "PR"."COMPANY" IS NULL)                                                                      
 352 - access("PR"."RN"="PRF"."PRN")                                                                                                  
 353 - filter("UL"."SIGN_HIER"=1 AND "UL"."SIGN_SHARE"=0)                                                                             
 354 - access("PR"."UNITCODE"="UL"."UNITCODE")                                                                                        
 357 - access("UNITCODE"='RolePrivs')                                                                                                 
 358 - access("ROLEID"="UR"."ROLEID" AND "UR"."AUTHID"=USER@!)                                                                        
 359 - filter( EXISTS (SELECT 0 FROM PARUS."USERPRIV"                                                                                 
              "USERPRIV",PARUS."USERROLES" "UR" WHERE "UR"."AUTHID"=USER@! AND                                                        
              "ROLEID"="UR"."ROLEID" AND "UNITCODE"='RolePrivs'))                                                                     
 364 - filter("UF"."UNITCODE"=:B1)                                                                                                    
 365 - access("UF"."CODE"=:B1)                                                                                                        
 367 - access("UF"."RES_ID"="LR"."PRN"(+) AND                                                                                         
              "LR"."LANG_ID"(+)="GET_NLS_LANGUAGE"())                                                                                 
 369 - access("PRF"."FUNC"="UF"."CODE")                                                                                               
 370 - filter("PR"."JUR_PERS" IS NULL AND "PR"."COMPANY"=0 AND                                                                        
              "PR"."ROLEID"=:B1)                                                                                                      
 371 - access("PR"."RN"="PRF"."PRN")                                                                                                  
 372 - filter("UL"."SIGN_JURPERS"=1 AND "UL"."SIGN_ACCREG"=1 AND                                                                      
              "UL"."SIGN_SHARE"=1)                                                                                                    
 373 - access("PR"."UNITCODE"="UL"."UNITCODE")                                                                                        
 376 - access("UNITCODE"='RolePrivs')                                                                                                 
 377 - access("ROLEID"="UR"."ROLEID" AND "UR"."AUTHID"=USER@!)                                                                        
 378 - filter( NOT EXISTS (SELECT 0 FROM  ( (SELECT 1                                                                                 
              "NACCESS","PR"."ROLEID" "NROLEID","CO"."RN" "NCOMPANY","UF"."UNITCODE"                                                  
              "SUNITCODE",TO_NUMBER(NULL) "NCATALOG",TO_NUMBER(NULL)                                                                  
              "NJUR_PERS","UF"."CODE" "SFUNCCODE",NVL("LR"."TEXT","UF"."NAME")                                                        
              "SFUNCNAME","UF"."NUMB" "SFUNCNUMB" FROM PARUS."UNITLIST"                                                               
              "UL",PARUS."COMPVERLIST" "CV",PARUS."COMPANIES"                                                                         
              "CO",PARUS."DMSRESLOCALES" "LR",PARUS."UNITFUNC" "UF",PARUS."UNITPRIV"                                                  
              "PRF",PARUS."USERPRIV" "PR" WHERE TO_NUMBER(NULL)=:B1 AND  EXISTS                                                       
              (SELECT 0 FROM PARUS."USERPRIV" "USERPRIV",PARUS."USERROLES" "UR" WHERE                                                 
              "UR"."AUTHID"=USER@! AND "ROLEID"="UR"."ROLEID" AND                                                                     
              "UNITCODE"='RolePrivs') AND "PR"."RN"="PRF"."PRN" AND "PR"."ROLEID"=:B2                                                 
              AND "PRF"."FUNC"="UF"."CODE" AND "UF"."CODE"=:B3 AND "UF"."UNITCODE"=:B4                                                
              AND "LR"."LANG_ID"(+)="GET_NLS_LANGUAGE"() AND                                                                          
              "UF"."RES_ID"="LR"."PRN"(+) AND "CO"."RN"=:B5 AND                                                                       
              "PR"."VERSION"="CV"."VERSION"(+) AND ("PR"."COMPANY"="CO"."RN" OR                                                       
              "CV"."COMPANY"="CO"."RN") AND "PR"."UNITCODE"="UL"."UNITCODE" AND                                                       
              "UL"."SIGN_JURPERS"=0 AND "UL"."SIGN_HIER"=0 AND                                                                        
              "UL"."SIGN_SHARE"=1)UNION (SELECT 1 "NACCESS","PR"."ROLEID" "NROLEID",0                                                 
              "NCOMPANY","UF"."UNITCODE" "SUNITCODE",TO_NUMBER(NULL)                                                                  
              "NCATALOG",TO_NUMBER(NULL) "NJUR_PERS","UF"."CODE"                                                                      
              "SFUNCCODE",NVL("LR"."TEXT","UF"."NAME") "SFUNCNAME","UF"."NUMB"                                                        
              "SFUNCNUMB" FROM PARUS."UNITLIST" "UL",PARUS."DMSRESLOCALES"                                                            
              "LR",PARUS."UNITFUNC" "UF",PARUS."UNITPRIV" "PRF",PARUS."USERPRIV" "PR"                                                 
              WHERE TO_NUMBER(NULL)=:B6 AND 0=:B7 AND  EXISTS (SELECT 0 FROM                                                          
              PARUS."USERPRIV" "USERPRIV",PARUS."USERROLES" "UR" WHERE                                                                
              "UR"."AUTHID"=USER@! AND "ROLEID"="UR"."ROLEID" AND                                                                     
              "UNITCODE"='RolePrivs') AND "PR"."RN"="PRF"."PRN" AND "PR"."ROLEID"=:B8                                                 
              AND "PR"."VERSION" IS NULL AND "PR"."COMPANY" IS NULL AND                                                               
              "PRF"."FUNC"="UF"."CODE" AND "UF"."CODE"=:B9 AND "UF"."UNITCODE"=:B10                                                   
              AND "LR"."LANG_ID"(+)="GET_NLS_LANGUAGE"() AND                                                                          
              "UF"."RES_ID"="LR"."PRN"(+) AND "PR"."UNITCODE"="UL"."UNITCODE" AND                                                     
              "UL"."SIGN_JURPERS"=0 AND "UL"."SIGN_HIER"=0 AND "UL"."SIGN_SHARE"=0)                                                   
              UNION ALL  (SELECT 1 "NACCESS","PR"."ROLEID" "NROLEID","CO"."RN"                                                        
              "NCOMPANY","UF"."UNITCODE" "SUNITCODE","PR"."CATALOG"                                                                   
              "NCATALOG",TO_NUMBER(NULL) "NJUR_PERS","UF"."CODE"                                                                      
              "SFUNCCODE",NVL("LR"."TEXT","UF"."NAME") "SFUNCNAME","UF"."NUMB"                                                        
              "SFUNCNUMB" FROM PARUS."UNITLIST" "UL",PARUS."COMPVERLIST"                                                              
              "CV",PARUS."COMPANIES" "CO",PARUS."DMSRESLOCALES" "LR",PARUS."UNITFUNC"                                                 
              "UF",PARUS."UNITPRIV" "PRF",PARUS."USERPRIV" "PR" WHERE  EXISTS (SELECT                                                 
              0 FROM PARUS."USERPRIV" "USERPRIV",PARUS."USERROLES" "UR" WHERE                                                         
              "UR"."AUTHID"=USER@! AND "ROLEID"="UR"."ROLEID" AND                                                                     
              "UNITCODE"='RolePrivs') AND "PR"."CATALOG"=:B11 AND "PR"."ROLEID"=:B12                                                  
              AND "PRF"."FUNC"="UF"."CODE" AND "PR"."RN"="PRF"."PRN" AND                                                              
              "UF"."CODE"=:B13 AND "UF"."UNITCODE"=:B14 AND                                                                           
              "LR"."LANG_ID"(+)="GET_NLS_LANGUAGE"() AND "UF"."RES_ID"="LR"."PRN"(+)                                                  
              AND "CO"."RN"=:B15 AND "PR"."VERSION"="CV"."VERSION"(+) AND                                                             
              ("PR"."COMPANY"="CO"."RN" OR "CV"."COMPANY"="CO"."RN") AND                                                              
              "PR"."UNITCODE"="UL"."UNITCODE" AND "UL"."SIGN_HIER"=1 AND                                                              
              "UL"."SIGN_SHARE"=1) UNION ALL  (SELECT 1 "NACCESS","PR"."ROLEID"                                                       
              "NROLEID",0 "NCOMPANY","UF"."UNITCODE" "SUNITCODE","PR"."CATALOG"                                                       
              "NCATALOG",TO_NUMBER(NULL) "NJUR_PERS","UF"."CODE"                                                                      
              "SFUNCCODE",NVL("LR"."TEXT","UF"."NAME") "SFUNCNAME","UF"."NUMB"                                                        
              "SFUNCNUMB" FROM PARUS."UNITLIST" "UL",PARUS."DMSRESLOCALES"                                                            
              "LR",PARUS."UNITFUNC" "UF",PARUS."UNITPRIV" "PRF",PARUS."USERPRIV" "PR"                                                 
              WHERE 0=:B16 AND  EXISTS (SELECT 0 FROM PARUS."USERPRIV"                                                                
              "USERPRIV",PARUS."USERROLES" "UR" WHERE "UR"."AUTHID"=USER@! AND                                                        
              "ROLEID"="UR"."ROLEID" AND "UNITCODE"='RolePrivs') AND                                                                  
              "PR"."CATALOG"=:B17 AND "PR"."ROLEID"=:B18 AND "PR"."VERSION" IS NULL                                                   
              AND "PR"."COMPANY" IS NULL AND "PRF"."FUNC"="UF"."CODE" AND                                                             
              "PR"."RN"="PRF"."PRN" AND "UF"."CODE"=:B19 AND "UF"."UNITCODE"=:B20 AND                                                 
              "LR"."LANG_ID"(+)="GET_NLS_LANGUAGE"() AND "UF"."RES_ID"="LR"."PRN"(+)                                                  
              AND "PR"."UNITCODE"="UL"."UNITCODE" AND "UL"."SIGN_HIER"=1 AND                                                          
              "UL"."SIGN_SHARE"=0) UNION ALL  (SELECT 1 "NACCESS","PR"."ROLEID"                                                       
              "NROLEID","PR"."COMPANY" "NCOMPANY","UF"."UNITCODE"                                                                     
              "SUNITCODE",TO_NUMBER(NULL) "NCATALOG","PR"."JUR_PERS")                                                                 
 379 - filter(:16 IS NULL AND :14 IS NOT NULL AND  EXISTS (SELECT 0 FROM                                                              
              PARUS."USERPRIV" "USERPRIV",PARUS."USERROLES" "UR" WHERE                                                                
              "UR"."AUTHID"=USER@! AND "ROLEID"="UR"."ROLEID" AND                                                                     
              "UNITCODE"='RolePrivs'))                                                                                                
 385 - access("CT"."RN"=TO_NUMBER(:15))                                                                                               
 386 - access("CO"."RN"=TO_NUMBER(:12))                                                                                               
 387 - access("RL"."RN"=TO_NUMBER(:11))                                                                                               
 389 - access("UF"."UNITCODE"=:10)                                                                                                    
 390 - filter("UL"."SIGN_HIER"=1 AND "UL"."SIGN_SHARE"=1)                                                                             
 391 - access("UF"."UNITCODE"="UL"."UNITCODE")                                                                                        
 393 - access("UF"."RES_ID"="LR"."PRN"(+) AND                                                                                         
              "LR"."LANG_ID"(+)="GET_NLS_LANGUAGE"())                                                                                 
 396 - access("UNITCODE"='RolePrivs')                                                                                                 
 397 - access("ROLEID"="UR"."ROLEID" AND "UR"."AUTHID"=USER@!)                                                                        
 402 - filter(TO_NUMBER(NULL)=:B1 AND  EXISTS (SELECT 0 FROM                                                                          
              PARUS."USERPRIV" "USERPRIV",PARUS."USERROLES" "UR" WHERE                                                                
              "UR"."AUTHID"=USER@! AND "ROLEID"="UR"."ROLEID" AND                                                                     
              "UNITCODE"='RolePrivs'))                                                                                                
 403 - filter("PR"."COMPANY"="CO"."RN" OR "CV"."COMPANY"="CO"."RN")                                                                   
 411 - access("CO"."RN"=:B1)                                                                                                          
 412 - filter("UF"."UNITCODE"=:B1)                                                                                                    
 413 - access("UF"."CODE"=:B1)                                                                                                        
 415 - access("UF"."RES_ID"="LR"."PRN"(+) AND                                                                                         
              "LR"."LANG_ID"(+)="GET_NLS_LANGUAGE"())                                                                                 
 417 - access("PRF"."FUNC"="UF"."CODE")                                                                                               
 418 - filter("PR"."ROLEID"=:B1)                                                                                                      
 419 - access("PR"."RN"="PRF"."PRN")                                                                                                  
 420 - filter("UL"."SIGN_JURPERS"=0 AND "UL"."SIGN_HIER"=0 AND                                                                        
              "UL"."SIGN_SHARE"=1)                                                                                                    
 421 - access("PR"."UNITCODE"="UL"."UNITCODE")                                                                                        
 422 - access("PR"."VERSION"="CV"."VERSION"(+))                                                                                       
       filter("PR"."VERSION"="CV"."VERSION"(+))                                                                                       
 426 - access("UNITCODE"='RolePrivs')                                                                                                 
 427 - access("ROLEID"="UR"."ROLEID" AND "UR"."AUTHID"=USER@!)                                                                        
 428 - filter(TO_NUMBER(NULL)=:B1 AND 0=:B2 AND  EXISTS (SELECT 0 FROM                                                                
              PARUS."USERPRIV" "USERPRIV",PARUS."USERROLES" "UR" WHERE                                                                
              "UR"."AUTHID"=USER@! AND "ROLEID"="UR"."ROLEID" AND                                                                     
              "UNITCODE"='RolePrivs'))                                                                                                
 433 - filter("UF"."UNITCODE"=:B1)                                                                                                    
 434 - access("UF"."CODE"=:B1)                                                                                                        
 436 - access("UF"."RES_ID"="LR"."PRN"(+) AND                                                                                         
              "LR"."LANG_ID"(+)="GET_NLS_LANGUAGE"())                                                                                 
 438 - access("PRF"."FUNC"="UF"."CODE")                                                                                               
 439 - filter("PR"."ROLEID"=:B1 AND "PR"."VERSION" IS NULL AND                                                                        
              "PR"."COMPANY" IS NULL)                                                                                                 
 440 - access("PR"."RN"="PRF"."PRN")                                                                                                  
 441 - filter("UL"."SIGN_JURPERS"=0 AND "UL"."SIGN_HIER"=0 AND                                                                        
              "UL"."SIGN_SHARE"=0)                                                                                                    
 442 - access("PR"."UNITCODE"="UL"."UNITCODE")                                                                                        
 445 - access("UNITCODE"='RolePrivs')                                                                                                 
 446 - access("ROLEID"="UR"."ROLEID" AND "UR"."AUTHID"=USER@!)                                                                        
 447 - filter( EXISTS (SELECT 0 FROM PARUS."USERPRIV"                                                                                 
              "USERPRIV",PARUS."USERROLES" "UR" WHERE "UR"."AUTHID"=USER@! AND                                                        
              "ROLEID"="UR"."ROLEID" AND "UNITCODE"='RolePrivs'))                                                                     
 448 - filter("PR"."COMPANY"="CO"."RN" OR "CV"."COMPANY"="CO"."RN")                                                                   
 456 - access("CO"."RN"=:B1)                                                                                                          
 457 - filter("UF"."UNITCODE"=:B1)                                                                                                    
 458 - access("UF"."CODE"=:B1)                                                                                                        
 460 - access("UF"."RES_ID"="LR"."PRN"(+) AND                                                                                         
              "LR"."LANG_ID"(+)="GET_NLS_LANGUAGE"())                                                                                 
 463 - access("PR"."ROLEID"=:B1)                                                                                                      
 464 - access("PR"."CATALOG"=:B1)                                                                                                     
 465 - filter("UL"."SIGN_HIER"=1 AND "UL"."SIGN_SHARE"=1)                                                                             
 466 - access("PR"."UNITCODE"="UL"."UNITCODE")                                                                                        
 467 - access("PR"."RN"="PRF"."PRN" AND "PRF"."FUNC"="UF"."CODE")                                                                     
 468 - access("PR"."VERSION"="CV"."VERSION"(+))                                                                                       
       filter("PR"."VERSION"="CV"."VERSION"(+))                                                                                       
 472 - access("UNITCODE"='RolePrivs')                                                                                                 
 473 - access("ROLEID"="UR"."ROLEID" AND "UR"."AUTHID"=USER@!)                                                                        
 474 - filter(0=:B1 AND  EXISTS (SELECT 0 FROM PARUS."USERPRIV"                                                                       
              "USERPRIV",PARUS."USERROLES" "UR" WHERE "UR"."AUTHID"=USER@! AND                                                        
              "ROLEID"="UR"."ROLEID" AND "UNITCODE"='RolePrivs'))                                                                     
 479 - filter("UF"."UNITCODE"=:B1)                                                                                                    
 480 - access("UF"."CODE"=:B1)                                                                                                        
 482 - access("UF"."RES_ID"="LR"."PRN"(+) AND                                                                                         
              "LR"."LANG_ID"(+)="GET_NLS_LANGUAGE"())                                                                                 
 483 - filter("PR"."VERSION" IS NULL AND "PR"."COMPANY" IS NULL)                                                                      
 485 - access("PR"."ROLEID"=:B1)                                                                                                      
 486 - access("PR"."CATALOG"=:B1)                                                                                                     
 487 - filter("UL"."SIGN_HIER"=1 AND "UL"."SIGN_SHARE"=0)                                                                             
 488 - access("PR"."UNITCODE"="UL"."UNITCODE")                                                                                        
 489 - access("PR"."RN"="PRF"."PRN" AND "PRF"."FUNC"="UF"."CODE")                                                                     
 492 - access("UNITCODE"='RolePrivs')                                                                                                 
 493 - access("ROLEID"="UR"."ROLEID" AND "UR"."AUTHID"=USER@!)                                                                        
 494 - filter(TO_NUMBER(NULL)=:B1 AND  EXISTS (SELECT 0 FROM                                                                          
              PARUS."USERPRIV" "USERPRIV",PARUS."USERROLES" "UR" WHERE                                                                
              "UR"."AUTHID"=USER@! AND "ROLEID"="UR"."ROLEID" AND                                                                     
              "UNITCODE"='RolePrivs'))                                                                                                
 499 - filter("UF"."UNITCODE"=:B1)                                                                                                    
 500 - access("UF"."CODE"=:B1)                                                                                                        
 502 - access("UF"."RES_ID"="LR"."PRN"(+) AND                                                                                         
              "LR"."LANG_ID"(+)="GET_NLS_LANGUAGE"())                                                                                 
 504 - access("PRF"."FUNC"="UF"."CODE")                                                                                               
 505 - filter("PR"."JUR_PERS" IS NULL AND "PR"."COMPANY"=:B1 AND                                                                      
              "PR"."ROLEID"=:B2)                                                                                                      
 506 - access("PR"."RN"="PRF"."PRN")                                                                                                  
 507 - filter("UL"."SIGN_JURPERS"=1 AND "UL"."SIGN_ACCREG"=1 AND                                                                      
              "UL"."SIGN_SHARE"=1)                                                                                                    
 508 - access("PR"."UNITCODE"="UL"."UNITCODE")                                                                                        
 511 - access("UNITCODE"='RolePrivs')                                                                                                 
 512 - access("ROLEID"="UR"."ROLEID" AND "UR"."AUTHID"=USER@!)                                                                        
 513 - filter( NOT EXISTS (SELECT 0 FROM  ( (SELECT 1                                                                                 
              "NACCESS","PR"."ROLEID" "NROLEID","CO"."RN" "NCOMPANY","UF"."UNITCODE"                                                  
              "SUNITCODE",TO_NUMBER(NULL) "NCATALOG",TO_NUMBER(NULL)                                                                  
              "NJUR_PERS","UF"."CODE" "SFUNCCODE",NVL("LR"."TEXT","UF"."NAME")                                                        
              "SFUNCNAME","UF"."NUMB" "SFUNCNUMB" FROM PARUS."UNITLIST"                                                               
              "UL",PARUS."COMPVERLIST" "CV",PARUS."COMPANIES"                                                                         
              "CO",PARUS."DMSRESLOCALES" "LR",PARUS."UNITFUNC" "UF",PARUS."UNITPRIV"                                                  
              "PRF",PARUS."USERPRIV" "PR" WHERE TO_NUMBER(NULL)=:B1 AND  EXISTS                                                       
              (SELECT 0 FROM PARUS."USERPRIV" "USERPRIV",PARUS."USERROLES" "UR" WHERE                                                 
              "UR"."AUTHID"=USER@! AND "ROLEID"="UR"."ROLEID" AND                                                                     
              "UNITCODE"='RolePrivs') AND "PR"."RN"="PRF"."PRN" AND "PR"."ROLEID"=:B2                                                 
              AND "PRF"."FUNC"="UF"."CODE" AND "UF"."CODE"=:B3 AND "UF"."UNITCODE"=:B4                                                
              AND "LR"."LANG_ID"(+)="GET_NLS_LANGUAGE"() AND                                                                          
              "UF"."RES_ID"="LR"."PRN"(+) AND "CO"."RN"=0 AND                                                                         
              "PR"."VERSION"="CV"."VERSION"(+) AND ("PR"."COMPANY"="CO"."RN" OR                                                       
              "CV"."COMPANY"="CO"."RN") AND "PR"."UNITCODE"="UL"."UNITCODE" AND                                                       
              "UL"."SIGN_JURPERS"=0 AND "UL"."SIGN_HIER"=0 AND                                                                        
              "UL"."SIGN_SHARE"=1)UNION (SELECT 1 "NACCESS","PR"."ROLEID" "NROLEID",0                                                 
              "NCOMPANY","UF"."UNITCODE" "SUNITCODE",TO_NUMBER(NULL)                                                                  
              "NCATALOG",TO_NUMBER(NULL) "NJUR_PERS","UF"."CODE"                                                                      
              "SFUNCCODE",NVL("LR"."TEXT","UF"."NAME") "SFUNCNAME","UF"."NUMB"                                                        
              "SFUNCNUMB" FROM PARUS."UNITLIST" "UL",PARUS."DMSRESLOCALES"                                                            
              "LR",PARUS."UNITFUNC" "UF",PARUS."UNITPRIV" "PRF",PARUS."USERPRIV" "PR"                                                 
              WHERE TO_NUMBER(NULL)=:B5 AND  EXISTS (SELECT 0 FROM PARUS."USERPRIV"                                                   
              "USERPRIV",PARUS."USERROLES" "UR" WHERE "UR"."AUTHID"=USER@! AND                                                        
              "ROLEID"="UR"."ROLEID" AND "UNITCODE"='RolePrivs') AND                                                                  
              "PR"."RN"="PRF"."PRN" AND "PR"."ROLEID"=:B6 AND "PR"."VERSION" IS NULL                                                  
              AND "PR"."COMPANY" IS NULL AND "PRF"."FUNC"="UF"."CODE" AND                                                             
              "UF"."CODE"=:B7 AND "UF"."UNITCODE"=:B8 AND                                                                             
              "LR"."LANG_ID"(+)="GET_NLS_LANGUAGE"() AND "UF"."RES_ID"="LR"."PRN"(+)                                                  
              AND "PR"."UNITCODE"="UL"."UNITCODE" AND "UL"."SIGN_JURPERS"=0 AND                                                       
              "UL"."SIGN_HIER"=0 AND "UL"."SIGN_SHARE"=0) UNION ALL  (SELECT 1                                                        
              "NACCESS","PR"."ROLEID" "NROLEID","CO"."RN" "NCOMPANY","UF"."UNITCODE"                                                  
              "SUNITCODE","PR"."CATALOG" "NCATALOG",TO_NUMBER(NULL)                                                                   
              "NJUR_PERS","UF"."CODE" "SFUNCCODE",NVL("LR"."TEXT","UF"."NAME")                                                        
              "SFUNCNAME","UF"."NUMB" "SFUNCNUMB" FROM PARUS."UNITLIST"                                                               
              "UL",PARUS."COMPVERLIST" "CV",PARUS."COMPANIES"                                                                         
              "CO",PARUS."DMSRESLOCALES" "LR",PARUS."UNITFUNC" "UF",PARUS."UNITPRIV"                                                  
              "PRF",PARUS."USERPRIV" "PR" WHERE  EXISTS (SELECT 0 FROM                                                                
              PARUS."USERPRIV" "USERPRIV",PARUS."USERROLES" "UR" WHERE                                                                
              "UR"."AUTHID"=USER@! AND "ROLEID"="UR"."ROLEID" AND                                                                     
              "UNITCODE"='RolePrivs') AND "PR"."CATALOG"=:B9 AND "PR"."ROLEID"=:B10                                                   
              AND "PRF"."FUNC"="UF"."CODE" AND "PR"."RN"="PRF"."PRN" AND                                                              
              "UF"."CODE"=:B11 AND "UF"."UNITCODE"=:B12 AND                                                                           
              "LR"."LANG_ID"(+)="GET_NLS_LANGUAGE"() AND "UF"."RES_ID"="LR"."PRN"(+)                                                  
              AND "CO"."RN"=0 AND "PR"."VERSION"="CV"."VERSION"(+) AND                                                                
              ("PR"."COMPANY"="CO"."RN" OR "CV"."COMPANY"="CO"."RN") AND                                                              
              "PR"."UNITCODE"="UL"."UNITCODE" AND "UL"."SIGN_HIER"=1 AND                                                              
              "UL"."SIGN_SHARE"=1) UNION ALL  (SELECT 1 "NACCESS","PR"."ROLEID"                                                       
              "NROLEID",0 "NCOMPANY","UF"."UNITCODE" "SUNITCODE","PR"."CATALOG"                                                       
              "NCATALOG",TO_NUMBER(NULL) "NJUR_PERS","UF"."CODE"                                                                      
              "SFUNCCODE",NVL("LR"."TEXT","UF"."NAME") "SFUNCNAME","UF"."NUMB"                                                        
              "SFUNCNUMB" FROM PARUS."UNITLIST" "UL",PARUS."DMSRESLOCALES"                                                            
              "LR",PARUS."UNITFUNC" "UF",PARUS."UNITPRIV" "PRF",PARUS."USERPRIV" "PR"                                                 
              WHERE  EXISTS (SELECT 0 FROM PARUS."USERPRIV"                                                                           
              "USERPRIV",PARUS."USERROLES" "UR" WHERE "UR"."AUTHID"=USER@! AND                                                        
              "ROLEID"="UR"."ROLEID" AND "UNITCODE"='RolePrivs') AND                                                                  
              "PR"."CATALOG"=:B13 AND "PR"."ROLEID"=:B14 AND "PR"."VERSION" IS NULL                                                   
              AND "PR"."COMPANY" IS NULL AND "PRF"."FUNC"="UF"."CODE" AND                                                             
              "PR"."RN"="PRF"."PRN" AND "UF"."CODE"=:B15 AND "UF"."UNITCODE"=:B16 AND                                                 
              "LR"."LANG_ID"(+)="GET_NLS_LANGUAGE"() AND "UF"."RES_ID"="LR"."PRN"(+)                                                  
              AND "PR"."UNITCODE"="UL"."UNITCODE" AND "UL"."SIGN_HIER"=1 AND                                                          
              "UL"."SIGN_SHARE"=0) UNION ALL  (SELECT 1 "NACCESS","PR"."ROLEID"                                                       
              "NROLEID","PR"."COMPANY" "NCOMPANY","UF"."UNITCODE"                                                                     
              "SUNITCODE",TO_NUMBER(NULL) "NCATALOG","PR"."JUR_PERS"                                                                  
              "NJUR_PERS","UF"."CODE" "SF)                                                                                            
 514 - filter(:16 IS NULL AND :14 IS NOT NULL AND 0=TO_NUMBER(:12) AND                                                                
              EXISTS (SELECT 0 FROM PARUS."USERPRIV" "USERPRIV",PARUS."USERROLES" "UR"                                                
              WHERE "UR"."AUTHID"=USER@! AND "ROLEID"="UR"."ROLEID" AND                                                               
              "UNITCODE"='RolePrivs'))                                                                                                
 519 - access("CT"."RN"=TO_NUMBER(:15))                                                                                               
 520 - access("RL"."RN"=TO_NUMBER(:11))                                                                                               
 522 - access("UF"."UNITCODE"=:10)                                                                                                    
 523 - filter("UL"."SIGN_HIER"=1 AND "UL"."SIGN_SHARE"=0)                                                                             
 524 - access("UF"."UNITCODE"="UL"."UNITCODE")                                                                                        
 526 - access("UF"."RES_ID"="LR"."PRN"(+) AND                                                                                         
              "LR"."LANG_ID"(+)="GET_NLS_LANGUAGE"())                                                                                 
 529 - access("UNITCODE"='RolePrivs')                                                                                                 
 530 - access("ROLEID"="UR"."ROLEID" AND "UR"."AUTHID"=USER@!)                                                                        
 535 - filter(TO_NUMBER(NULL)=:B1 AND  EXISTS (SELECT 0 FROM                                                                          
              PARUS."USERPRIV" "USERPRIV",PARUS."USERROLES" "UR" WHERE                                                                
              "UR"."AUTHID"=USER@! AND "ROLEID"="UR"."ROLEID" AND                                                                     
              "UNITCODE"='RolePrivs'))                                                                                                
 536 - filter("PR"."COMPANY"="CO"."RN" OR "CV"."COMPANY"="CO"."RN")                                                                   
 544 - access("CO"."RN"=0)                                                                                                            
 545 - filter("UF"."UNITCODE"=:B1)                                                                                                    
 546 - access("UF"."CODE"=:B1)                                                                                                        
 548 - access("UF"."RES_ID"="LR"."PRN"(+) AND                                                                                         
              "LR"."LANG_ID"(+)="GET_NLS_LANGUAGE"())                                                                                 
 550 - access("PRF"."FUNC"="UF"."CODE")                                                                                               
 551 - filter("PR"."ROLEID"=:B1)                                                                                                      
 552 - access("PR"."RN"="PRF"."PRN")                                                                                                  
 553 - filter("UL"."SIGN_JURPERS"=0 AND "UL"."SIGN_HIER"=0 AND                                                                        
              "UL"."SIGN_SHARE"=1)                                                                                                    
 554 - access("PR"."UNITCODE"="UL"."UNITCODE")                                                                                        
 555 - access("PR"."VERSION"="CV"."VERSION"(+))                                                                                       
       filter("PR"."VERSION"="CV"."VERSION"(+))                                                                                       
 559 - access("UNITCODE"='RolePrivs')                                                                                                 
 560 - access("ROLEID"="UR"."ROLEID" AND "UR"."AUTHID"=USER@!)                                                                        
 561 - filter(TO_NUMBER(NULL)=:B1 AND  EXISTS (SELECT 0 FROM                                                                          
              PARUS."USERPRIV" "USERPRIV",PARUS."USERROLES" "UR" WHERE                                                                
              "UR"."AUTHID"=USER@! AND "ROLEID"="UR"."ROLEID" AND                                                                     
              "UNITCODE"='RolePrivs'))                                                                                                
 566 - filter("UF"."UNITCODE"=:B1)                                                                                                    
 567 - access("UF"."CODE"=:B1)                                                                                                        
 569 - access("UF"."RES_ID"="LR"."PRN"(+) AND                                                                                         
              "LR"."LANG_ID"(+)="GET_NLS_LANGUAGE"())                                                                                 
 571 - access("PRF"."FUNC"="UF"."CODE")                                                                                               
 572 - filter("PR"."ROLEID"=:B1 AND "PR"."VERSION" IS NULL AND                                                                        
              "PR"."COMPANY" IS NULL)                                                                                                 
 573 - access("PR"."RN"="PRF"."PRN")                                                                                                  
 574 - filter("UL"."SIGN_JURPERS"=0 AND "UL"."SIGN_HIER"=0 AND                                                                        
              "UL"."SIGN_SHARE"=0)                                                                                                    
 575 - access("PR"."UNITCODE"="UL"."UNITCODE")                                                                                        
 578 - access("UNITCODE"='RolePrivs')                                                                                                 
 579 - access("ROLEID"="UR"."ROLEID" AND "UR"."AUTHID"=USER@!)                                                                        
 580 - filter( EXISTS (SELECT 0 FROM PARUS."USERPRIV"                                                                                 
              "USERPRIV",PARUS."USERROLES" "UR" WHERE "UR"."AUTHID"=USER@! AND                                                        
              "ROLEID"="UR"."ROLEID" AND "UNITCODE"='RolePrivs'))                                                                     
 581 - filter("PR"."COMPANY"="CO"."RN" OR "CV"."COMPANY"="CO"."RN")                                                                   
 589 - access("CO"."RN"=0)                                                                                                            
 590 - filter("UF"."UNITCODE"=:B1)                                                                                                    
 591 - access("UF"."CODE"=:B1)                                                                                                        
 593 - access("UF"."RES_ID"="LR"."PRN"(+) AND                                                                                         
              "LR"."LANG_ID"(+)="GET_NLS_LANGUAGE"())                                                                                 
 596 - access("PR"."ROLEID"=:B1)                                                                                                      
 597 - access("PR"."CATALOG"=:B1)                                                                                                     
 598 - filter("UL"."SIGN_HIER"=1 AND "UL"."SIGN_SHARE"=1)                                                                             
 599 - access("PR"."UNITCODE"="UL"."UNITCODE")                                                                                        
 600 - access("PR"."RN"="PRF"."PRN" AND "PRF"."FUNC"="UF"."CODE")                                                                     
 601 - access("PR"."VERSION"="CV"."VERSION"(+))                                                                                       
       filter("PR"."VERSION"="CV"."VERSION"(+))                                                                                       
 605 - access("UNITCODE"='RolePrivs')                                                                                                 
 606 - access("ROLEID"="UR"."ROLEID" AND "UR"."AUTHID"=USER@!)                                                                        
 607 - filter( EXISTS (SELECT 0 FROM PARUS."USERPRIV"                                                                                 
              "USERPRIV",PARUS."USERROLES" "UR" WHERE "UR"."AUTHID"=USER@! AND                                                        
              "ROLEID"="UR"."ROLEID" AND "UNITCODE"='RolePrivs'))                                                                     
 612 - filter("UF"."UNITCODE"=:B1)                                                                                                    
 613 - access("UF"."CODE"=:B1)                                                                                                        
 615 - access("UF"."RES_ID"="LR"."PRN"(+) AND                                                                                         
              "LR"."LANG_ID"(+)="GET_NLS_LANGUAGE"())                                                                                 
 616 - filter("PR"."VERSION" IS NULL AND "PR"."COMPANY" IS NULL)                                                                      
 618 - access("PR"."ROLEID"=:B1)                                                                                                      
 619 - access("PR"."CATALOG"=:B1)                                                                                                     
 620 - filter("UL"."SIGN_HIER"=1 AND "UL"."SIGN_SHARE"=0)                                                                             
 621 - access("PR"."UNITCODE"="UL"."UNITCODE")                                                                                        
 622 - access("PR"."RN"="PRF"."PRN" AND "PRF"."FUNC"="UF"."CODE")                                                                     
 625 - access("UNITCODE"='RolePrivs')                                                                                                 
 626 - access("ROLEID"="UR"."ROLEID" AND "UR"."AUTHID"=USER@!)                                                                        
 627 - filter(TO_NUMBER(NULL)=:B1 AND  EXISTS (SELECT 0 FROM                                                                          
              PARUS."USERPRIV" "USERPRIV",PARUS."USERROLES" "UR" WHERE                                                                
              "UR"."AUTHID"=USER@! AND "ROLEID"="UR"."ROLEID" AND                                                                     
              "UNITCODE"='RolePrivs'))                                                                                                
 632 - filter("UF"."UNITCODE"=:B1)                                                                                                    
 633 - access("UF"."CODE"=:B1)                                                                                                        
 635 - access("UF"."RES_ID"="LR"."PRN"(+) AND                                                                                         
              "LR"."LANG_ID"(+)="GET_NLS_LANGUAGE"())                                                                                 
 637 - access("PRF"."FUNC"="UF"."CODE")                                                                                               
 638 - filter("PR"."JUR_PERS" IS NULL AND "PR"."COMPANY"=0 AND                                                                        
              "PR"."ROLEID"=:B1)                                                                                                      
 639 - access("PR"."RN"="PRF"."PRN")                                                                                                  
 640 - filter("UL"."SIGN_JURPERS"=1 AND "UL"."SIGN_ACCREG"=1 AND                                                                      
              "UL"."SIGN_SHARE"=1)                                                                                                    
 641 - access("PR"."UNITCODE"="UL"."UNITCODE")                                                                                        
 644 - access("UNITCODE"='RolePrivs')                                                                                                 
 645 - access("ROLEID"="UR"."ROLEID" AND "UR"."AUTHID"=USER@!)                                                                        
 646 - filter( NOT EXISTS (SELECT 0 FROM  ( (SELECT 1                                                                                 
              "NACCESS","PR"."ROLEID" "NROLEID","CO"."RN" "NCOMPANY","UF"."UNITCODE"                                                  
              "SUNITCODE",TO_NUMBER(NULL) "NCATALOG",TO_NUMBER(NULL)                                                                  
              "NJUR_PERS","UF"."CODE" "SFUNCCODE",NVL("LR"."TEXT","UF"."NAME")                                                        
              "SFUNCNAME","UF"."NUMB" "SFUNCNUMB" FROM PARUS."UNITLIST"                                                               
              "UL",PARUS."COMPVERLIST" "CV",PARUS."COMPANIES"                                                                         
              "CO",PARUS."DMSRESLOCALES" "LR",PARUS."UNITFUNC" "UF",PARUS."UNITPRIV"                                                  
              "PRF",PARUS."USERPRIV" "PR" WHERE TO_NUMBER(NULL)=:B1 AND  EXISTS                                                       
              (SELECT 0 FROM PARUS."USERPRIV" "USERPRIV",PARUS."USERROLES" "UR" WHERE                                                 
              "UR"."AUTHID"=USER@! AND "ROLEID"="UR"."ROLEID" AND                                                                     
              "UNITCODE"='RolePrivs') AND "PR"."RN"="PRF"."PRN" AND "PR"."ROLEID"=:B2                                                 
              AND "PRF"."FUNC"="UF"."CODE" AND "UF"."CODE"=:B3 AND "UF"."UNITCODE"=:B4                                                
              AND "LR"."LANG_ID"(+)="GET_NLS_LANGUAGE"() AND                                                                          
              "UF"."RES_ID"="LR"."PRN"(+) AND "CO"."RN"=:B5 AND                                                                       
              "PR"."VERSION"="CV"."VERSION"(+) AND ("PR"."COMPANY"="CO"."RN" OR                                                       
              "CV"."COMPANY"="CO"."RN") AND "PR"."UNITCODE"="UL"."UNITCODE" AND                                                       
              "UL"."SIGN_JURPERS"=0 AND "UL"."SIGN_HIER"=0 AND                                                                        
              "UL"."SIGN_SHARE"=1)UNION (SELECT 1 "NACCESS","PR"."ROLEID" "NROLEID",0                                                 
              "NCOMPANY","UF"."UNITCODE" "SUNITCODE",TO_NUMBER(NULL)                                                                  
              "NCATALOG",TO_NUMBER(NULL) "NJUR_PERS","UF"."CODE"                                                                      
              "SFUNCCODE",NVL("LR"."TEXT","UF"."NAME") "SFUNCNAME","UF"."NUMB"                                                        
              "SFUNCNUMB" FROM PARUS."UNITLIST" "UL",PARUS."DMSRESLOCALES"                                                            
              "LR",PARUS."UNITFUNC" "UF",PARUS."UNITPRIV" "PRF",PARUS."USERPRIV" "PR"                                                 
              WHERE TO_NUMBER(NULL)=:B6 AND 0=:B7 AND  EXISTS (SELECT 0 FROM                                                          
              PARUS."USERPRIV" "USERPRIV",PARUS."USERROLES" "UR" WHERE                                                                
              "UR"."AUTHID"=USER@! AND "ROLEID"="UR"."ROLEID" AND                                                                     
              "UNITCODE"='RolePrivs') AND "PR"."RN"="PRF"."PRN" AND "PR"."ROLEID"=:B8                                                 
              AND "PR"."VERSION" IS NULL AND "PR"."COMPANY" IS NULL AND                                                               
              "PRF"."FUNC"="UF"."CODE" AND "UF"."CODE"=:B9 AND "UF"."UNITCODE"=:B10                                                   
              AND "LR"."LANG_ID"(+)="GET_NLS_LANGUAGE"() AND                                                                          
              "UF"."RES_ID"="LR"."PRN"(+) AND "PR"."UNITCODE"="UL"."UNITCODE" AND                                                     
              "UL"."SIGN_JURPERS"=0 AND "UL"."SIGN_HIER"=0 AND "UL"."SIGN_SHARE"=0)                                                   
              UNION ALL  (SELECT 1 "NACCESS","PR"."ROLEID" "NROLEID","CO"."RN"                                                        
              "NCOMPANY","UF"."UNITCODE" "SUNITCODE","PR"."CATALOG"                                                                   
              "NCATALOG",TO_NUMBER(NULL) "NJUR_PERS","UF"."CODE"                                                                      
              "SFUNCCODE",NVL("LR"."TEXT","UF"."NAME") "SFUNCNAME","UF"."NUMB"                                                        
              "SFUNCNUMB" FROM PARUS."UNITLIST" "UL",PARUS."COMPVERLIST"                                                              
              "CV",PARUS."COMPANIES" "CO",PARUS."DMSRESLOCALES" "LR",PARUS."UNITFUNC"                                                 
              "UF",PARUS."UNITPRIV" "PRF",PARUS."USERPRIV" "PR" WHERE                                                                 
              TO_NUMBER(NULL)=:B11 AND  EXISTS (SELECT 0 FROM PARUS."USERPRIV"                                                        
              "USERPRIV",PARUS."USERROLES" "UR" WHERE "UR"."AUTHID"=USER@! AND                                                        
              "ROLEID"="UR"."ROLEID" AND "UNITCODE"='RolePrivs') AND                                                                  
              "PR"."RN"="PRF"."PRN" AND "PR"."CATALOG" IS NULL AND "PR"."ROLEID"=:B12                                                 
              AND "PRF"."FUNC"="UF"."CODE" AND "UF"."CODE"=:B13 AND                                                                   
              "UF"."UNITCODE"=:B14 AND "LR"."LANG_ID"(+)="GET_NLS_LANGUAGE"() AND                                                     
              "UF"."RES_ID"="LR"."PRN"(+) AND "CO"."RN"=:B15 AND                                                                      
              "PR"."VERSION"="CV"."VERSION"(+) AND ("PR"."COMPANY"="CO"."RN" OR                                                       
              "CV"."COMPANY"="CO"."RN") AND "PR"."UNITCODE"="UL"."UNITCODE" AND                                                       
              "UL"."SIGN_HIER"=1 AND "UL"."SIGN_SHARE"=1) UNION ALL  (SELECT 1                                                        
              "NACCESS","PR"."ROLEID" "NROLEID",0 "NCOMPANY","UF"."UNITCODE"                                                          
              "SUNITCODE","PR"."CATALOG" "NCATALOG",TO_NUMBER(NULL)                                                                   
              "NJUR_PERS","UF"."CODE" "SFUNCCODE",NVL("LR"."TEXT","UF"."NAME")                                                        
              "SFUNCNAME","UF"."NUMB" "SFUNCNUMB" FROM PARUS."UNITLIST"                                                               
              "UL",PARUS."DMSRESLOCALES" "LR",PARUS."UNITFUNC" "UF",PARUS."UNITPRIV"                                                  
              "PRF",PARUS."USERPRIV" "PR" WHERE TO_NUMBER(NULL)=:B16 AND 0=:B17 AND                                                   
              EXISTS (SELECT 0 FROM PARUS."USERPRIV" "USERPRIV",PARUS."USERROLES" "UR"                                                
              WHERE "UR"."AUTHID"=USER@! AND "ROLEID"="UR"."ROLEID" AND                                                               
              "UNITCODE"='RolePrivs') AND "PR"."RN"="PRF"."PRN" AND "PR"."CATALOG" IS                                                 
              NULL AND "PR"."ROLEID"=:B18 AND "PR"."VERSION" IS NULL AND                                                              
              "PR"."COMPANY" IS NULL AND "PRF"."FUNC"="UF"."CODE" AND "UF"."CODE"=:B19                                                
              AND "UF"."UNITCODE"=:B20 AND "LR"."LANG_ID"(+)="GET_NLS_LANGUAGE"() AND                                                 
              "UF"."RES_ID"="LR"."PRN"(+) AND "PR"."UNITCODE"="UL"."UNITCODE" AND                                                     
              "UL"."SIGN_HIER"=1 AND "UL"."SIGN_SHARE"=0) UNION ALL  (SELECT 1                                                        
              "NACCESS","PR"."ROLEID" "NROLEID","PR"."COMPANY"                                                                        
              "NCOMPANY","UF"."UNITCODE)                                                                                              
 647 - filter(:17 IS NOT NULL AND :13 IS NULL AND  EXISTS (SELECT 0 FROM                                                              
              PARUS."USERPRIV" "USERPRIV",PARUS."USERROLES" "UR" WHERE                                                                
              "UR"."AUTHID"=USER@! AND "ROLEID"="UR"."ROLEID" AND                                                                     
              "UNITCODE"='RolePrivs'))                                                                                                
 653 - access("JP"."RN"=TO_NUMBER(:18))                                                                                               
 654 - access("CO"."RN"=TO_NUMBER(:12))                                                                                               
 655 - access("RL"."RN"=TO_NUMBER(:11))                                                                                               
 657 - access("UF"."UNITCODE"=:10)                                                                                                    
 658 - filter("UL"."SIGN_JURPERS"=1 AND "UL"."SIGN_ACCREG"=1 AND                                                                      
              "UL"."SIGN_SHARE"=1)                                                                                                    
 659 - access("UF"."UNITCODE"="UL"."UNITCODE")                                                                                        
 661 - access("UF"."RES_ID"="LR"."PRN"(+) AND                                                                                         
              "LR"."LANG_ID"(+)="GET_NLS_LANGUAGE"())                                                                                 
 664 - access("UNITCODE"='RolePrivs')                                                                                                 
 665 - access("ROLEID"="UR"."ROLEID" AND "UR"."AUTHID"=USER@!)                                                                        
 670 - filter(TO_NUMBER(NULL)=:B1 AND  EXISTS (SELECT 0 FROM                                                                          
              PARUS."USERPRIV" "USERPRIV",PARUS."USERROLES" "UR" WHERE                                                                
              "UR"."AUTHID"=USER@! AND "ROLEID"="UR"."ROLEID" AND                                                                     
              "UNITCODE"='RolePrivs'))                                                                                                
 671 - filter("PR"."COMPANY"="CO"."RN" OR "CV"."COMPANY"="CO"."RN")                                                                   
 679 - access("CO"."RN"=:B1)                                                                                                          
 680 - filter("UF"."UNITCODE"=:B1)                                                                                                    
 681 - access("UF"."CODE"=:B1)                                                                                                        
 683 - access("UF"."RES_ID"="LR"."PRN"(+) AND                                                                                         
              "LR"."LANG_ID"(+)="GET_NLS_LANGUAGE"())                                                                                 
 685 - access("PRF"."FUNC"="UF"."CODE")                                                                                               
 686 - filter("PR"."ROLEID"=:B1)                                                                                                      
 687 - access("PR"."RN"="PRF"."PRN")                                                                                                  
 688 - filter("UL"."SIGN_JURPERS"=0 AND "UL"."SIGN_HIER"=0 AND                                                                        
              "UL"."SIGN_SHARE"=1)                                                                                                    
 689 - access("PR"."UNITCODE"="UL"."UNITCODE")                                                                                        
 690 - access("PR"."VERSION"="CV"."VERSION"(+))                                                                                       
       filter("PR"."VERSION"="CV"."VERSION"(+))                                                                                       
 694 - access("UNITCODE"='RolePrivs')                                                                                                 
 695 - access("ROLEID"="UR"."ROLEID" AND "UR"."AUTHID"=USER@!)                                                                        
 696 - filter(TO_NUMBER(NULL)=:B1 AND 0=:B2 AND  EXISTS (SELECT 0 FROM                                                                
              PARUS."USERPRIV" "USERPRIV",PARUS."USERROLES" "UR" WHERE                                                                
              "UR"."AUTHID"=USER@! AND "ROLEID"="UR"."ROLEID" AND                                                                     
              "UNITCODE"='RolePrivs'))                                                                                                
 701 - filter("UF"."UNITCODE"=:B1)                                                                                                    
 702 - access("UF"."CODE"=:B1)                                                                                                        
 704 - access("UF"."RES_ID"="LR"."PRN"(+) AND                                                                                         
              "LR"."LANG_ID"(+)="GET_NLS_LANGUAGE"())                                                                                 
 706 - access("PRF"."FUNC"="UF"."CODE")                                                                                               
 707 - filter("PR"."ROLEID"=:B1 AND "PR"."VERSION" IS NULL AND                                                                        
              "PR"."COMPANY" IS NULL)                                                                                                 
 708 - access("PR"."RN"="PRF"."PRN")                                                                                                  
 709 - filter("UL"."SIGN_JURPERS"=0 AND "UL"."SIGN_HIER"=0 AND                                                                        
              "UL"."SIGN_SHARE"=0)                                                                                                    
 710 - access("PR"."UNITCODE"="UL"."UNITCODE")                                                                                        
 713 - access("UNITCODE"='RolePrivs')                                                                                                 
 714 - access("ROLEID"="UR"."ROLEID" AND "UR"."AUTHID"=USER@!)                                                                        
 715 - filter(TO_NUMBER(NULL)=:B1 AND  EXISTS (SELECT 0 FROM                                                                          
              PARUS."USERPRIV" "USERPRIV",PARUS."USERROLES" "UR" WHERE                                                                
              "UR"."AUTHID"=USER@! AND "ROLEID"="UR"."ROLEID" AND                                                                     
              "UNITCODE"='RolePrivs'))                                                                                                
 716 - filter("PR"."COMPANY"="CO"."RN" OR "CV"."COMPANY"="CO"."RN")                                                                   
 724 - access("CO"."RN"=:B1)                                                                                                          
 725 - filter("UF"."UNITCODE"=:B1)                                                                                                    
 726 - access("UF"."CODE"=:B1)                                                                                                        
 728 - access("UF"."RES_ID"="LR"."PRN"(+) AND                                                                                         
              "LR"."LANG_ID"(+)="GET_NLS_LANGUAGE"())                                                                                 
 730 - access("PRF"."FUNC"="UF"."CODE")                                                                                               
 731 - filter("PR"."CATALOG" IS NULL AND "PR"."ROLEID"=:B1)                                                                           
 732 - access("PR"."RN"="PRF"."PRN")                                                                                                  
 733 - filter("UL"."SIGN_HIER"=1 AND "UL"."SIGN_SHARE"=1)                                                                             
 734 - access("PR"."UNITCODE"="UL"."UNITCODE")                                                                                        
 735 - access("PR"."VERSION"="CV"."VERSION"(+))                                                                                       
       filter("PR"."VERSION"="CV"."VERSION"(+))                                                                                       
 739 - access("UNITCODE"='RolePrivs')                                                                                                 
 740 - access("ROLEID"="UR"."ROLEID" AND "UR"."AUTHID"=USER@!)                                                                        
 741 - filter(TO_NUMBER(NULL)=:B1 AND 0=:B2 AND  EXISTS (SELECT 0 FROM                                                                
              PARUS."USERPRIV" "USERPRIV",PARUS."USERROLES" "UR" WHERE                                                                
              "UR"."AUTHID"=USER@! AND "ROLEID"="UR"."ROLEID" AND                                                                     
              "UNITCODE"='RolePrivs'))                                                                                                
 746 - filter("UF"."UNITCODE"=:B1)                                                                                                    
 747 - access("UF"."CODE"=:B1)                                                                                                        
 749 - access("UF"."RES_ID"="LR"."PRN"(+) AND                                                                                         
              "LR"."LANG_ID"(+)="GET_NLS_LANGUAGE"())                                                                                 
 751 - access("PRF"."FUNC"="UF"."CODE")                                                                                               
 752 - filter("PR"."CATALOG" IS NULL AND "PR"."ROLEID"=:B1 AND                                                                        
              "PR"."VERSION" IS NULL AND "PR"."COMPANY" IS NULL)                                                                      
 753 - access("PR"."RN"="PRF"."PRN")                                                                                                  
 754 - filter("UL"."SIGN_HIER"=1 AND "UL"."SIGN_SHARE"=0)                                                                             
 755 - access("PR"."UNITCODE"="UL"."UNITCODE")                                                                                        
 758 - access("UNITCODE"='RolePrivs')                                                                                                 
 759 - access("ROLEID"="UR"."ROLEID" AND "UR"."AUTHID"=USER@!)                                                                        
 760 - filter( EXISTS (SELECT 0 FROM PARUS."USERPRIV"                                                                                 
              "USERPRIV",PARUS."USERROLES" "UR" WHERE "UR"."AUTHID"=USER@! AND                                                        
              "ROLEID"="UR"."ROLEID" AND "UNITCODE"='RolePrivs'))                                                                     
 765 - filter("UF"."UNITCODE"=:B1)                                                                                                    
 766 - access("UF"."CODE"=:B1)                                                                                                        
 768 - access("UF"."RES_ID"="LR"."PRN"(+) AND                                                                                         
              "LR"."LANG_ID"(+)="GET_NLS_LANGUAGE"())                                                                                 
 770 - access("PRF"."FUNC"="UF"."CODE")                                                                                               
 771 - filter("PR"."JUR_PERS"=:B1 AND "PR"."COMPANY"=:B2 AND                                                                          
              "PR"."ROLEID"=:B3)                                                                                                      
 772 - access("PR"."RN"="PRF"."PRN")                                                                                                  
 773 - filter("UL"."SIGN_JURPERS"=1 AND "UL"."SIGN_ACCREG"=1 AND                                                                      
              "UL"."SIGN_SHARE"=1)                                                                                                    
 774 - access("PR"."UNITCODE"="UL"."UNITCODE")                                                                                        
 777 - access("UNITCODE"='RolePrivs')                                                                                                 
 778 - access("ROLEID"="UR"."ROLEID" AND "UR"."AUTHID"=USER@!)                                                                        
                                                                                                                                      
Note                                                                                                                                  
-----                                                                                                                                 
   - rule based optimizer used (consider using cbo)                                                                                   

1706 строк выбрано.

Затрач.время: 00:00:03.67
SYS@TEST> spool off

13 фев 09, 17:42    [6818897]     Ответить | Цитировать Сообщить модератору
 Re: Избавится от HASH JOIN  [new]
ScareCrow
Member

Откуда: Белый город
Сообщений: 17089
Note                                                                                                                                  
-----                                                                                                                                 
   - rule based optimizer used (consider using cbo)    
смеялсо.
13 фев 09, 17:46    [6818909]     Ответить | Цитировать Сообщить модератору
 Re: Избавится от HASH JOIN  [new]
SQL*Plus
Member

Откуда: Россия, Москва
Сообщений: 8131
mayton
Вот такой вот план.
1706 строк выбрано.
Такое анализировать?
Только за деньги!
13 фев 09, 18:02    [6818999]     Ответить | Цитировать Сообщить модератору
 Re: Избавится от HASH JOIN  [new]
ScareCrow
Member

Откуда: Белый город
Сообщений: 17089
парус не перестаёт радовать. боюсь что одним хеш джойном тут не отделаешься.
13 фев 09, 18:03    [6819001]     Ответить | Цитировать Сообщить модератору
 Re: Избавится от HASH JOIN  [new]
mayton
Member

Откуда: loopback
Сообщений: 49738
Я уже насмеялся вдоволь. Сейчас - сарказм. Дайте совет что делать?
13 фев 09, 18:06    [6819010]     Ответить | Цитировать Сообщить модератору
 Re: Избавится от HASH JOIN  [new]
mayton
Member

Откуда: loopback
Сообщений: 49738
Вот параметры оптимизатора

SYS@TEST> show parameter optimizer
optimizer_dynamic_sampling           integer     2
optimizer_features_enable            string      10.2.0.3
optimizer_index_caching              integer     50
optimizer_index_cost_adj             integer     100
optimizer_mode                       string      ALL_ROWS
optimizer_secure_view_merging        boolean     TRUE
13 фев 09, 18:08    [6819020]     Ответить | Цитировать Сообщить модератору
 Re: Избавится от HASH JOIN  [new]
ScareCrow
Member

Откуда: Белый город
Сообщений: 17089
mayton
Я уже насмеялся вдоволь. Сейчас - сарказм. Дайте совет что делать?

пинать парусников на предмет того что они написали.. пусть переписывают.
13 фев 09, 18:08    [6819021]     Ответить | Цитировать Сообщить модератору
 Re: Избавится от HASH JOIN  [new]
ScareCrow
Member

Откуда: Белый город
Сообщений: 17089
( NOT EXISTS (SELECT 0 FROM  ( (SELECT 1      
такие вещи реально доставляют.
13 фев 09, 18:11    [6819042]     Ответить | Цитировать Сообщить модератору
 Re: Избавится от HASH JOIN  [new]
Alterling
Member

Откуда:
Сообщений: 180
mayton
Недавно переписали эту функцию. Добавили директиву deterministic.

Ну это как бы не очень панацея.

Рассмотрите вариант запихнуть ваши вьюхи в материализованные представления (если ф-ция не зависит от параметров сессии) или во временные таблицы, которые заполнять перед началом мега-запроса.
13 фев 09, 18:14    [6819059]     Ответить | Цитировать Сообщить модератору
 Re: Избавится от HASH JOIN  [new]
mayton
Member

Откуда: loopback
Сообщений: 49738
Alterling
mayton
Недавно переписали эту функцию. Добавили директиву deterministic.

Ну это как бы не очень панацея.

Рассмотрите вариант запихнуть ваши вьюхи в материализованные представления (если ф-ция не зависит от параметров сессии)

Это уже сделано. Забили пакет с переменными, которые инициализируются в начале сесии и функция возвращаяет значение этих переменных.
13 фев 09, 18:21    [6819083]     Ответить | Цитировать Сообщить модератору
 Re: Избавится от HASH JOIN  [new]
mayton
Member

Откуда: loopback
Сообщений: 49738
Alterling
mayton
Недавно переписали эту функцию. Добавили директиву deterministic.

или во временные таблицы, которые заполнять перед началом мега-запроса.

Это мысль. Но такие вещи достигаются путём длительных переговоров с поддержкой. И фиксируются неделями. А у меня - целый филиал бухгалтеров, красных от злобы. Так-что срок - 1-2 дня.
13 фев 09, 18:24    [6819093]     Ответить | Цитировать Сообщить модератору
Топик располагается на нескольких страницах: [1] 2   вперед  Ctrl      все
Все форумы / Oracle Ответить