20240307-记一次最离谱的SQL执行计划

在这里插入图片描述

说明:

记得2017年看过一个离谱的Oracle数据库的SQL执行计划,至今仍记忆犹新。
相关数据已脱敏:

问题现象:

同事反馈前台某个功能点击查询很长时间不出结果,咨询是否是数据库的问题;

问题分析:

通过vsession,vsession,vsession,vsql等关联查询到如下SQL运行缓慢,运行时长以及条件等和同事描述一致:

select /*+ 120 query  */  * from TEMQ_3558355815e2ce625b9 where rownum<36661 and  1 = 1

其中TEMQ_3558355815e2ce625b9为程序运行过程中自动创建的临时视图,基表关联多张大表。
通过sql_id查看SQL执行计划,看着长长的执行计划,陷入了沉思:

先截取执行计划部分信息:

7-------------------------------------------------------------------------------------------------------------------------------------------------
8| Id  | Operation                                                    | Name                     | Rows  | Bytes |TempSpc| Cost (%CPU)| Time     |
9-------------------------------------------------------------------------------------------------------------------------------------------------
10|   0 | SELECT STATEMENT                                             |                          |       |       |       |  2971M(100)|          |
11|*  1 |  COUNT STOPKEY                                               |                          |       |       |       |            |          |
12|   2 |   VIEW                                                       | TEMQ_3558355815E2CE625B9 |  5166G|  1837T|       |  2971M (98)|999:59:59 |
13|*  3 |    SORT GROUP BY STOPKEY                                     |                          |  5166G|    10P|       |  2971M (98)|999:59:59 |
14|   4 |     VIEW                                                     |                          |  5166G|    10P|       |   105M (35)|352:30:27 |
15|   5 |      UNION-ALL                                               |                          |       |       |       |            |          |
16|*  6 |       FILTER                                                 |                          |       |       |       |            |          |
17|*  7 |        HASH JOIN RIGHT OUTER                                 |                          |  5166G|    11P|    99M| 30002   (2)| 00:06:01 |

其中: Rows=5166G,Bytes=1837T,Bytes=10P?

看着这些执行计划中少见的单位GB,TB,PB?

如果服务器能开口说话,可能会说:“兄弟,哥何德何能能配得上您这个执行计划呀?”

解决方案:

差不多是从这个SQL执行计划开始,新增了我另一个解决问题的思路:
当你发现你的问题很难解决时,不妨试试能否解决掉提出问题的人!
之前遇到类似的问题,处理过程大概是这样的:
问清楚问题现象,分析原因,找到解决方案,执行方案,解决问题。
但是通过SQL执行计划来看,在不需要其他人员配合的情况下,优化这条SQL,显示是有一定难度的,至少表的数据量太大,关联数量也太多。
做数据库运维时,不能总是被动的接收问题,还要适当的提出问题:
1.这条慢SQL是什么操作触发的?
2.这个操作是否合理?查询条件、范围是否合适?
3.因为你的这个操作已经导致整个数据库性能出现严重问题,能否先中断查询,释放资源,对业务是否有影响,等评估完执行必要性、查询范围、资源消耗等再考虑是否执行,什么时间执行?

得到的答复是:
在临时出一个统计报表,为了图省事没怎么加限制条件,可以中断查询,这个报表不是必须执行的,只是好奇想看一下数据,以后不会再执行类似查询了。

最终的解决方案:
1.中断正在运行的这条慢SQL,释放资源;
2.和相关同事沟通,限制报表查询的数据量,不重要的报表类查询时间超过一定阈值自动中断。

最后看下完整的执行计划:

1SQL_ID  7sf2b262cdhj7, child number 0
2-------------------------------------
3select /*+ 120 query  */  * from TEMQ_3558355815e2ce625b9 where rownum<30001 and  1 = 1
4 
5Plan hash value: 3569079297
6 
7-------------------------------------------------------------------------------------------------------------------------------------------------
8| Id  | Operation                                                    | Name                     | Rows  | Bytes |TempSpc| Cost (%CPU)| Time     |
9-------------------------------------------------------------------------------------------------------------------------------------------------
10|   0 | SELECT STATEMENT                                             |                          |       |       |       |  2971M(100)|          |
11|*  1 |  COUNT STOPKEY                                               |                          |       |       |       |            |          |
12|   2 |   VIEW                                                       | TEMQ_3558355815E2CE625B9 |  5166G|  1837T|       |  2971M (98)|999:59:59 |
13|*  3 |    SORT GROUP BY STOPKEY                                     |                          |  5166G|    10P|       |  2971M (98)|999:59:59 |
14|   4 |     VIEW                                                     |                          |  5166G|    10P|       |   105M (35)|352:30:27 |
15|   5 |      UNION-ALL                                               |                          |       |       |       |            |          |
16|*  6 |       FILTER                                                 |                          |       |       |       |            |          |
17|*  7 |        HASH JOIN RIGHT OUTER                                 |                          |  5166G|    11P|    99M| 30002   (2)| 00:06:01 |
18|   8 |         VIEW                                                 |                          |   615K|    92M|       | 24996   (2)| 00:05:00 |
19|   9 |          HASH GROUP BY                                       |                          |   615K|    70M|   152M| 24996   (2)| 00:05:00 |
20|* 10 |           HASH JOIN                                          |                          |   615K|    70M|       |  8274   (3)| 00:01:40 |
21|* 11 |            HASH JOIN                                         |                          |  7988 |   733K|       |   139   (6)| 00:00:02 |
22|* 12 |             TABLE ACCESS FULL                                | BD_CUBASDOC              |  6364 |   285K|       |    53   (8)| 00:00:01 |
23|* 13 |             TABLE ACCESS FULL                                | GT_YFINVOICE_H           |  7889 |   369K|       |    86   (4)| 00:00:02 |
24|  14 |            TABLE ACCESS FULL                                 | GT_YFINVOICE_B           |   614K|    15M|       |  8116   (3)| 00:01:38 |
25|  15 |         VIEW                                                 |                          |   311 |   370K|       |     1   (0)| 00:00:01 |
26|  16 |          UNION-ALL                                           |                          |       |       |       |            |          |
27|* 17 |           HASH JOIN RIGHT OUTER                              |                          |    53G|    59T|       |    52M (34)|173:33:50 |
28|  18 |            VIEW                                              |                          |  1221 |   162K|       |  1456   (1)| 00:00:18 |
29|  19 |             HASH GROUP BY                                    |                          |  1221 |   225K|       |  1456   (1)| 00:00:18 |
30|  20 |              NESTED LOOPS                                    |                          |  1221 |   225K|       |  1454   (1)| 00:00:18 |
31|  21 |               NESTED LOOPS                                   |                          |  1221 |   195K|       |   475   (2)| 00:00:06 |
32|  22 |                NESTED LOOPS                                  |                          |   127 | 15113 |       |   271   (3)| 00:00:04 |
33|* 23 |                 TABLE ACCESS FULL                            | PO_INVOICE               |   127 | 10287 |       |   220   (3)| 00:00:03 |
34|  24 |                 TABLE ACCESS BY INDEX ROWID                  | BD_CUBASDOC              |     1 |    38 |       |     1   (0)| 00:00:01 |
35|* 25 |                  INDEX UNIQUE SCAN                           | PK_BD_CUBASDOC           |     1 |       |       |     1   (0)| 00:00:01 |
36|* 26 |                TABLE ACCESS BY INDEX ROWID                   | PO_INVOICE_B             |    10 |   450 |       |     2   (0)| 00:00:01 |
37|* 27 |                 INDEX RANGE SCAN                             | I_PO_INVOICE_B_5         |    14 |       |       |     1   (0)| 00:00:01 |
38|  28 |               TABLE ACCESS BY INDEX ROWID                    | PO_ORDER_B               |     1 |    25 |       |     1   (0)| 00:00:01 |
39|* 29 |                INDEX UNIQUE SCAN                             | PK_PO_ORDER_B            |     1 |       |       |     1   (0)| 00:00:01 |
40|  30 |            VIEW                                              |                          |    53G|    52T|       |    50M (32)|168:21:50 |
41|  31 |             UNION-ALL                                        |                          |       |       |       |            |          |
42|* 32 |              HASH JOIN RIGHT OUTER                           |                          |    53G|    52T|       |    25M (32)| 84:13:20 |
43|  33 |               VIEW                                           |                          |   203 | 58058 |       |     9  (12)| 00:00:01 |
44|  34 |                HASH GROUP BY                                 |                          |   203 | 10759 |       |     9  (12)| 00:00:01 |
45|* 35 |                 TABLE ACCESS FULL                            | GT_QCYE                  |   203 | 10759 |       |     8   (0)| 00:00:01 |
46|  36 |               VIEW                                           |                          |    52G|    38T|       |    23M (27)| 79:01:37 |
47|  37 |                UNION-ALL                                     |                          |       |       |       |            |          |
48|* 38 |                 HASH JOIN RIGHT OUTER                        |                          |    52G|    38T|       |    11M (27)| 39:30:54 |
49|  39 |                  VIEW                                        |                          |  1221 |   162K|       |   770   (4)| 00:00:10 |
50|  40 |                   HASH GROUP BY                              |                          |  1221 |   225K|       |   770   (4)| 00:00:10 |
51|* 41 |                    HASH JOIN                                 |                          |  1221 |   225K|       |   769   (4)| 00:00:10 |
52|* 42 |                     TABLE ACCESS BY INDEX ROWID              | PO_INVOICE_B             |    10 |   460 |       |     2   (0)| 00:00:01 |
53|  43 |                      NESTED LOOPS                            |                          |  1221 |   200K|       |   475   (2)| 00:00:06 |
54|  44 |                       NESTED LOOPS                           |                          |   127 | 15494 |       |   271   (3)| 00:00:04 |
55|* 45 |                        TABLE ACCESS FULL                     | PO_INVOICE               |   127 | 10668 |       |   220   (3)| 00:00:03 |
56|  46 |                        TABLE ACCESS BY INDEX ROWID           | BD_CUBASDOC              |     1 |    38 |       |     1   (0)| 00:00:01 |
57|* 47 |                         INDEX UNIQUE SCAN                    | PK_BD_CUBASDOC           |     1 |       |       |     1   (0)| 00:00:01 |
58|* 48 |                       INDEX RANGE SCAN                       | I_PO_INVOICE_B_5         |    14 |       |       |     1   (0)| 00:00:01 |
59|  49 |                     INDEX FAST FULL SCAN                     | PK_PO_ORDER_B            |   227K|  4673K|       |   287   (4)| 00:00:04 |
60|  50 |                  VIEW                                        |                          |    52G|    31T|       |    10M (16)| 34:23:39 |
61|  51 |                   UNION-ALL                                  |                          |       |       |       |            |          |
62|* 52 |                    HASH JOIN RIGHT OUTER                     |                          |    52G|    31T|   202M|  9173K (18)| 30:34:41 |
63|  53 |                     VIEW                                     |                          |  1251K|   188M|       | 74342   (3)| 00:14:53 |
64|  54 |                      HASH GROUP BY                           |                          |  1251K|   177M|   407M| 74342   (3)| 00:14:53 |
65|* 55 |                       HASH JOIN                              |                          |  1251K|   177M|       | 32704   (4)| 00:06:33 |
66|* 56 |                        TABLE ACCESS BY INDEX ROWID           | ARAP_DJZB                | 25033 |  1344K|       |  1366   (1)| 00:00:17 |
67|* 57 |                         INDEX RANGE SCAN                     | I_ARAP_DJZB_004          | 24211 |       |       |    85   (2)| 00:00:02 |
68|* 58 |                        HASH JOIN                             |                          |  1176K|   105M|       | 31300   (4)| 00:06:16 |
69|* 59 |                         TABLE ACCESS FULL                    | BD_CUBASDOC              |  6336 |   284K|       |    66  (26)| 00:00:01 |
70|* 60 |                         TABLE ACCESS FULL                    | ARAP_DJFB                |  1178K|    53M|       | 31199   (4)| 00:06:15 |
71|  61 |                     VIEW                                     |                          |   267M|   124G|       |  1056K  (3)| 03:31:22 |
72|  62 |                      UNION-ALL                               |                          |       |       |       |            |          |
73|* 63 |                       HASH JOIN OUTER                        |                          |   262M|   121G|    55M|   616K  (3)| 02:03:21 |
74|  64 |                        VIEW                                  |                          |   166K|    53M|       |   133K  (4)| 00:26:41 |
75|  65 |                         UNION-ALL                            |                          |       |       |       |            |          |
76|* 66 |                          HASH JOIN OUTER                     |                          | 21756 |  6713K|       | 66505   (4)| 00:13:19 |
77|  67 |                           VIEW                               |                          |   931 |   143K|       | 26545   (4)| 00:05:19 |
78|  68 |                            HASH GROUP BY                     |                          |   931 |   119K|       | 26545   (4)| 00:05:19 |
79|* 69 |                             HASH JOIN                        |                          |   931 |   119K|       | 26544   (4)| 00:05:19 |
80|* 70 |                              HASH JOIN                       |                          |   928 | 78880 |       | 26492   (4)| 00:05:18 |
81|* 71 |                               TABLE ACCESS FULL              | GT_MEASURE_H             |  2510 |   139K|       | 26138   (4)| 00:05:14 |
82|* 72 |                               TABLE ACCESS FULL              | GT_POORDER_H             | 19479 |   532K|       |   353   (3)| 00:00:05 |
83|  73 |                              TABLE ACCESS FULL               | BD_CUBASDOC              |  6366 |   285K|       |    52   (6)| 00:00:01 |
84|  74 |                           VIEW                               |                          |   148K|    22M|       | 39955   (3)| 00:08:00 |
85|  75 |                            HASH GROUP BY                     |                          |   148K|    27M|    59M| 39955   (3)| 00:08:00 |
86|* 76 |                             HASH JOIN                        |                          |   148K|    27M|       | 33542   (4)| 00:06:43 |
87|* 77 |                              TABLE ACCESS FULL               | BD_CUBASDOC              |  6365 |   285K|       |    52   (6)| 00:00:01 |
88|* 78 |                              HASH JOIN                       |                          |   148K|    21M|  2304K| 33484   (4)| 00:06:42 |
89|* 79 |                               TABLE ACCESS FULL              | BD_CUMANDOC              | 43648 |  1790K|       |   360   (7)| 00:00:05 |
90|* 80 |                               HASH JOIN                      |                          |   146K|    15M|  3824K| 32165   (4)| 00:06:26 |
91|* 81 |                                TABLE ACCESS FULL             | GT_GENERAL_H             | 68684 |  3018K|       |  1414   (3)| 00:00:17 |
92|* 82 |                                HASH JOIN RIGHT ANTI          |                          |   165K|     9M|    32M| 29964   (4)| 00:06:00 |
93|* 83 |                                 TABLE ACCESS FULL            | GT_INVOICE_B             |  1152K|    19M|       | 13080   (4)| 00:02:37 |
94|* 84 |                                 TABLE ACCESS FULL            | GT_GENERAL_B             |  1163K|    49M|       | 11983   (4)| 00:02:24 |
95|  85 |                          HASH GROUP BY                       |                          |   144K|    29M|    62M| 66898   (4)| 00:13:23 |
96|* 86 |                           HASH JOIN RIGHT ANTI               |                          |   144K|    29M|       | 60039   (4)| 00:12:01 |
97|  87 |                            VIEW                              | VW_SQ_1                  |   931 | 19551 |       | 26493   (4)| 00:05:18 |
98|  88 |                             NESTED LOOPS                     |                          |   931 | 91238 |       | 26493   (4)| 00:05:18 |
99|* 89 |                              HASH JOIN                       |                          |   928 | 71456 |       | 26492   (4)| 00:05:18 |
100|* 90 |                               TABLE ACCESS FULL              | GT_MEASURE_H             |  2510 |   129K|       | 26138   (4)| 00:05:14 |
101|* 91 |                               TABLE ACCESS FULL              | GT_POORDER_H             | 19479 |   456K|       |   353   (3)| 00:00:05 |
102|* 92 |                              INDEX UNIQUE SCAN               | PK_BD_CUBASDOC           |     1 |    21 |       |     1   (0)| 00:00:01 |
103|* 93 |                            HASH JOIN                         |                          |   148K|    27M|       | 33542   (4)| 00:06:43 |
104|* 94 |                             TABLE ACCESS FULL                | BD_CUBASDOC              |  6365 |   285K|       |    52   (6)| 00:00:01 |
105|* 95 |                             HASH JOIN                        |                          |   148K|    21M|  2304K| 33484   (4)| 00:06:42 |
106|  96 |                              TABLE ACCESS FULL               | BD_CUMANDOC              | 43648 |  1790K|       |   360   (7)| 00:00:05 |
107|* 97 |                              HASH JOIN                       |                          |   146K|    15M|  3824K| 32165   (4)| 00:06:26 |
108|* 98 |                               TABLE ACCESS FULL              | GT_GENERAL_H             | 68684 |  3018K|       |  1414   (3)| 00:00:17 |
109|* 99 |                               HASH JOIN RIGHT ANTI           |                          |   165K|     9M|    32M| 29964   (4)| 00:06:00 |
110|*100 |                                TABLE ACCESS FULL             | GT_INVOICE_B             |  1152K|    19M|       | 13080   (4)| 00:02:37 |
111|*101 |                                TABLE ACCESS FULL             | GT_GENERAL_B             |  1163K|    49M|       | 11983   (4)| 00:02:24 |
112| 102 |                        VIEW                                  |                          |    10M|  1515M|       |   391K  (2)| 01:18:18 |
113| 103 |                         HASH GROUP BY                        |                          |    10M|  1611M|  3492M|   391K  (2)| 01:18:18 |
114|*104 |                          HASH JOIN                           |                          |    10M|  1611M|  3168K| 16451   (6)| 00:03:18 |
115|*105 |                           HASH JOIN                          |                          | 21603 |  2911K|       |   728   (6)| 00:00:09 |
116|*106 |                            TABLE ACCESS FULL                 | BD_CUBASDOC              |  6365 |   285K|       |    52   (6)| 00:00:01 |
117|*107 |                            HASH JOIN                         |                          | 21606 |  1941K|       |   674   (5)| 00:00:09 |
118|*108 |                             TABLE ACCESS FULL                | GT_INVOICE_H             | 21430 |  1004K|       |   311   (3)| 00:00:04 |
119|*109 |                             TABLE ACCESS FULL                | BD_CUMANDOC              | 43648 |  1875K|       |   361   (7)| 00:00:05 |
120|*110 |                           TABLE ACCESS FULL                  | GT_INVOICE_B             |  1086K|    31M|       | 13080   (4)| 00:02:37 |
121| 111 |                       HASH GROUP BY                          |                          |  5206K|   943M|  2981M|   440K  (3)| 01:28:02 |
122|*112 |                        HASH JOIN                             |                          |    10M|  1822M|  3632K|   149K  (4)| 00:29:59 |
123|*113 |                         HASH JOIN                            |                          | 21598 |  3374K|       |   134K  (4)| 00:26:50 |
124|*114 |                          TABLE ACCESS FULL                   | GT_INVOICE_H             | 21430 |  1004K|       |   311   (3)| 00:00:04 |
125|*115 |                          HASH JOIN                           |                          | 43630 |  4772K|       |   133K  (4)| 00:26:46 |
126|*116 |                           HASH JOIN ANTI                     |                          |  6364 |   422K|       |   133K  (4)| 00:26:42 |
127|*117 |                            TABLE ACCESS FULL                 | BD_CUBASDOC              |  6365 |   285K|       |    52   (6)| 00:00:01 |
128| 118 |                            VIEW                              |                          |   166K|  3571K|       |   133K  (4)| 00:26:41 |
129| 119 |                             UNION-ALL                        |                          |       |       |       |            |          |
130|*120 |                              HASH JOIN OUTER                 |                          | 21756 |  6713K|       | 66505   (4)| 00:13:19 |
131| 121 |                               VIEW                           |                          |   931 |   143K|       | 26545   (4)| 00:05:19 |
132| 122 |                                HASH GROUP BY                 |                          |   931 |   119K|       | 26545   (4)| 00:05:19 |
133|*123 |                                 HASH JOIN                    |                          |   931 |   119K|       | 26544   (4)| 00:05:19 |
134|*124 |                                  HASH JOIN                   |                          |   928 | 78880 |       | 26492   (4)| 00:05:18 |
135|*125 |                                   TABLE ACCESS FULL          | GT_MEASURE_H             |  2510 |   139K|       | 26138   (4)| 00:05:14 |
136|*126 |                                   TABLE ACCESS FULL          | GT_POORDER_H             | 19479 |   532K|       |   353   (3)| 00:00:05 |
137| 127 |                                  TABLE ACCESS FULL           | BD_CUBASDOC              |  6366 |   285K|       |    52   (6)| 00:00:01 |
138| 128 |                               VIEW                           |                          |   148K|    22M|       | 39955   (3)| 00:08:00 |
139| 129 |                                HASH GROUP BY                 |                          |   148K|    27M|    59M| 39955   (3)| 00:08:00 |
140|*130 |                                 HASH JOIN                    |                          |   148K|    27M|       | 33542   (4)| 00:06:43 |
141|*131 |                                  TABLE ACCESS FULL           | BD_CUBASDOC              |  6365 |   285K|       |    52   (6)| 00:00:01 |
142|*132 |                                  HASH JOIN                   |                          |   148K|    21M|  2304K| 33484   (4)| 00:06:42 |
143| 133 |                                   TABLE ACCESS FULL          | BD_CUMANDOC              | 43648 |  1790K|       |   360   (7)| 00:00:05 |
144|*134 |                                   HASH JOIN                  |                          |   146K|    15M|  3824K| 32165   (4)| 00:06:26 |
145|*135 |                                    TABLE ACCESS FULL         | GT_GENERAL_H             | 68684 |  3018K|       |  1414   (3)| 00:00:17 |
146|*136 |                                    HASH JOIN RIGHT ANTI      |                          |   165K|     9M|    32M| 29964   (4)| 00:06:00 |
147|*137 |                                     TABLE ACCESS FULL        | GT_INVOICE_B             |  1152K|    19M|       | 13080   (4)| 00:02:37 |
148|*138 |                                     TABLE ACCESS FULL        | GT_GENERAL_B             |  1163K|    49M|       | 11983   (4)| 00:02:24 |
149| 139 |                              HASH GROUP BY                   |                          |   144K|    29M|    62M| 66898   (4)| 00:13:23 |
150|*140 |                               HASH JOIN RIGHT ANTI           |                          |   144K|    29M|       | 60039   (4)| 00:12:01 |
151| 141 |                                VIEW                          | VW_SQ_2                  |   931 | 19551 |       | 26493   (4)| 00:05:18 |
152| 142 |                                 NESTED LOOPS                 |                          |   931 | 91238 |       | 26493   (4)| 00:05:18 |
153|*143 |                                  HASH JOIN                   |                          |   928 | 71456 |       | 26492   (4)| 00:05:18 |
154|*144 |                                   TABLE ACCESS FULL          | GT_MEASURE_H             |  2510 |   129K|       | 26138   (4)| 00:05:14 |
155|*145 |                                   TABLE ACCESS FULL          | GT_POORDER_H             | 19479 |   456K|       |   353   (3)| 00:00:05 |
156|*146 |                                  INDEX UNIQUE SCAN           | PK_BD_CUBASDOC           |     1 |    21 |       |     1   (0)| 00:00:01 |
157|*147 |                                HASH JOIN                     |                          |   148K|    27M|       | 33542   (4)| 00:06:43 |
158|*148 |                                 TABLE ACCESS FULL            | BD_CUBASDOC              |  6365 |   285K|       |    52   (6)| 00:00:01 |
159|*149 |                                 HASH JOIN                    |                          |   148K|    21M|  2304K| 33484   (4)| 00:06:42 |
160| 150 |                                  TABLE ACCESS FULL           | BD_CUMANDOC              | 43648 |  1790K|       |   360   (7)| 00:00:05 |
161|*151 |                                  HASH JOIN                   |                          |   146K|    15M|  3824K| 32165   (4)| 00:06:26 |
162|*152 |                                   TABLE ACCESS FULL          | GT_GENERAL_H             | 68684 |  3018K|       |  1414   (3)| 00:00:17 |
163|*153 |                                   HASH JOIN RIGHT ANTI       |                          |   165K|     9M|    32M| 29964   (4)| 00:06:00 |
164|*154 |                                    TABLE ACCESS FULL         | GT_INVOICE_B             |  1152K|    19M|       | 13080   (4)| 00:02:37 |
165|*155 |                                    TABLE ACCESS FULL         | GT_GENERAL_B             |  1163K|    49M|       | 11983   (4)| 00:02:24 |
166|*156 |                           TABLE ACCESS FULL                  | BD_CUMANDOC              | 43644 |  1875K|       |   361   (7)| 00:00:05 |
167|*157 |                         TABLE ACCESS FULL                    | GT_INVOICE_B             |  1086K|    31M|       | 13080   (4)| 00:02:37 |
168| 158 |                    HASH GROUP BY                             |                          |  1251K|   204M|   454M|  1144K  (4)| 03:48:58 |
169|*159 |                     HASH JOIN                                |                          |  1251K|   204M|       |  1097K  (4)| 03:39:28 |
170|*160 |                      TABLE ACCESS BY INDEX ROWID             | ARAP_DJZB                | 25033 |  1344K|       |  1366   (1)| 00:00:17 |
171|*161 |                       INDEX RANGE SCAN                       | I_ARAP_DJZB_004          | 24211 |       |       |    85   (2)| 00:00:02 |
172|*162 |                      HASH JOIN                               |                          |  1176K|   130M|       |  1095K  (4)| 03:39:11 |
173|*163 |                       HASH JOIN ANTI                         |                          |  6335 |   420K|       |  1064K  (4)| 03:32:56 |
174|*164 |                        TABLE ACCESS FULL                     | BD_CUBASDOC              |  6336 |   284K|       |    66  (26)| 00:00:01 |
175| 165 |                        VIEW                                  |                          |   267M|  5620M|       |  1056K  (3)| 03:31:21 |
176| 166 |                         UNION-ALL                            |                          |       |       |       |            |          |
177|*167 |                          HASH JOIN OUTER                     |                          |   262M|   121G|    55M|   616K  (3)| 02:03:20 |
178| 168 |                           VIEW                               |                          |   166K|    53M|       |   133K  (4)| 00:26:41 |
179| 169 |                            UNION-ALL                         |                          |       |       |       |            |          |
180|*170 |                             HASH JOIN OUTER                  |                          | 21756 |  6713K|       | 66505   (4)| 00:13:19 |
181| 171 |                              VIEW                            |                          |   931 |   143K|       | 26545   (4)| 00:05:19 |
182| 172 |                               HASH GROUP BY                  |                          |   931 |   119K|       | 26545   (4)| 00:05:19 |
183|*173 |                                HASH JOIN                     |                          |   931 |   119K|       | 26544   (4)| 00:05:19 |
184|*174 |                                 HASH JOIN                    |                          |   928 | 78880 |       | 26492   (4)| 00:05:18 |
185|*175 |                                  TABLE ACCESS FULL           | GT_MEASURE_H             |  2510 |   139K|       | 26138   (4)| 00:05:14 |
186|*176 |                                  TABLE ACCESS FULL           | GT_POORDER_H             | 19479 |   532K|       |   353   (3)| 00:00:05 |
187| 177 |                                 TABLE ACCESS FULL            | BD_CUBASDOC              |  6366 |   285K|       |    52   (6)| 00:00:01 |
188| 178 |                              VIEW                            |                          |   148K|    22M|       | 39955   (3)| 00:08:00 |
189| 179 |                               HASH GROUP BY                  |                          |   148K|    27M|    59M| 39955   (3)| 00:08:00 |
190|*180 |                                HASH JOIN                     |                          |   148K|    27M|       | 33542   (4)| 00:06:43 |
191|*181 |                                 TABLE ACCESS FULL            | BD_CUBASDOC              |  6365 |   285K|       |    52   (6)| 00:00:01 |
192|*182 |                                 HASH JOIN                    |                          |   148K|    21M|  2304K| 33484   (4)| 00:06:42 |
193| 183 |                                  TABLE ACCESS FULL           | BD_CUMANDOC              | 43648 |  1790K|       |   360   (7)| 00:00:05 |
194|*184 |                                  HASH JOIN                   |                          |   146K|    15M|  3824K| 32165   (4)| 00:06:26 |
195|*185 |                                   TABLE ACCESS FULL          | GT_GENERAL_H             | 68684 |  3018K|       |  1414   (3)| 00:00:17 |
196|*186 |                                   HASH JOIN RIGHT ANTI       |                          |   165K|     9M|    32M| 29964   (4)| 00:06:00 |
197|*187 |                                    TABLE ACCESS FULL         | GT_INVOICE_B             |  1152K|    19M|       | 13080   (4)| 00:02:37 |
198|*188 |                                    TABLE ACCESS FULL         | GT_GENERAL_B             |  1163K|    49M|       | 11983   (4)| 00:02:24 |
199| 189 |                             HASH GROUP BY                    |                          |   144K|    29M|    62M| 66898   (4)| 00:13:23 |
200|*190 |                              HASH JOIN RIGHT ANTI            |                          |   144K|    29M|       | 60039   (4)| 00:12:01 |
201| 191 |                               VIEW                           | VW_SQ_3                  |   931 | 19551 |       | 26493   (4)| 00:05:18 |
202| 192 |                                NESTED LOOPS                  |                          |   931 | 91238 |       | 26493   (4)| 00:05:18 |
203|*193 |                                 HASH JOIN                    |                          |   928 | 71456 |       | 26492   (4)| 00:05:18 |
204|*194 |                                  TABLE ACCESS FULL           | GT_MEASURE_H             |  2510 |   129K|       | 26138   (4)| 00:05:14 |
205|*195 |                                  TABLE ACCESS FULL           | GT_POORDER_H             | 19479 |   456K|       |   353   (3)| 00:00:05 |
206|*196 |                                 INDEX UNIQUE SCAN            | PK_BD_CUBASDOC           |     1 |    21 |       |     1   (0)| 00:00:01 |
207|*197 |                               HASH JOIN                      |                          |   148K|    27M|       | 33542   (4)| 00:06:43 |
208|*198 |                                TABLE ACCESS FULL             | BD_CUBASDOC              |  6365 |   285K|       |    52   (6)| 00:00:01 |
209|*199 |                                HASH JOIN                     |                          |   148K|    21M|  2304K| 33484   (4)| 00:06:42 |
210| 200 |                                 TABLE ACCESS FULL            | BD_CUMANDOC              | 43648 |  1790K|       |   360   (7)| 00:00:05 |
211|*201 |                                 HASH JOIN                    |                          |   146K|    15M|  3824K| 32165   (4)| 00:06:26 |
212|*202 |                                  TABLE ACCESS FULL           | GT_GENERAL_H             | 68684 |  3018K|       |  1414   (3)| 00:00:17 |
213|*203 |                                  HASH JOIN RIGHT ANTI        |                          |   165K|     9M|    32M| 29964   (4)| 00:06:00 |
214|*204 |                                   TABLE ACCESS FULL          | GT_INVOICE_B             |  1152K|    19M|       | 13080   (4)| 00:02:37 |
215|*205 |                                   TABLE ACCESS FULL          | GT_GENERAL_B             |  1163K|    49M|       | 11983   (4)| 00:02:24 |
216| 206 |                           VIEW                               |                          |    10M|  1515M|       |   391K  (2)| 01:18:18 |
217| 207 |                            HASH GROUP BY                     |                          |    10M|  1611M|  3492M|   391K  (2)| 01:18:18 |
218|*208 |                             HASH JOIN                        |                          |    10M|  1611M|  3168K| 16451   (6)| 00:03:18 |
219|*209 |                              HASH JOIN                       |                          | 21601 |  2911K|       |   728   (6)| 00:00:09 |
220|*210 |                               TABLE ACCESS FULL              | BD_CUBASDOC              |  6365 |   285K|       |    52   (6)| 00:00:01 |
221|*211 |                               HASH JOIN                      |                          | 21605 |  1941K|       |   674   (5)| 00:00:09 |
222|*212 |                                TABLE ACCESS FULL             | GT_INVOICE_H             | 21430 |  1004K|       |   311   (3)| 00:00:04 |
223|*213 |                                TABLE ACCESS FULL             | BD_CUMANDOC              | 43644 |  1875K|       |   361   (7)| 00:00:05 |
224|*214 |                              TABLE ACCESS FULL               | GT_INVOICE_B             |  1086K|    31M|       | 13080   (4)| 00:02:37 |
225| 215 |                          HASH GROUP BY                       |                          |  5206K|   943M|  2981M|   440K  (3)| 01:28:02 |
226|*216 |                           HASH JOIN                          |                          |    10M|  1822M|  3632K|   149K  (4)| 00:29:59 |
227|*217 |                            HASH JOIN                         |                          | 21598 |  3374K|       |   134K  (4)| 00:26:50 |
228|*218 |                             TABLE ACCESS FULL                | GT_INVOICE_H             | 21430 |  1004K|       |   311   (3)| 00:00:04 |
229|*219 |                             HASH JOIN                        |                          | 43630 |  4772K|       |   133K  (4)| 00:26:46 |
230|*220 |                              HASH JOIN ANTI                  |                          |  6364 |   422K|       |   133K  (4)| 00:26:42 |
231|*221 |                               TABLE ACCESS FULL              | BD_CUBASDOC              |  6365 |   285K|       |    52   (6)| 00:00:01 |
232| 222 |                               VIEW                           |                          |   166K|  3571K|       |   133K  (4)| 00:26:41 |
233| 223 |                                UNION-ALL                     |                          |       |       |       |            |          |
234|*224 |                                 HASH JOIN OUTER              |                          | 21756 |  6713K|       | 66505   (4)| 00:13:19 |
235| 225 |                                  VIEW                        |                          |   931 |   143K|       | 26545   (4)| 00:05:19 |
236| 226 |                                   HASH GROUP BY              |                          |   931 |   119K|       | 26545   (4)| 00:05:19 |
237|*227 |                                    HASH JOIN                 |                          |   931 |   119K|       | 26544   (4)| 00:05:19 |
238|*228 |                                     HASH JOIN                |                          |   928 | 78880 |       | 26492   (4)| 00:05:18 |
239|*229 |                                      TABLE ACCESS FULL       | GT_MEASURE_H             |  2510 |   139K|       | 26138   (4)| 00:05:14 |
240|*230 |                                      TABLE ACCESS FULL       | GT_POORDER_H             | 19479 |   532K|       |   353   (3)| 00:00:05 |
241| 231 |                                     TABLE ACCESS FULL        | BD_CUBASDOC              |  6366 |   285K|       |    52   (6)| 00:00:01 |
242| 232 |                                  VIEW                        |                          |   148K|    22M|       | 39955   (3)| 00:08:00 |
243| 233 |                                   HASH GROUP BY              |                          |   148K|    27M|    59M| 39955   (3)| 00:08:00 |
244|*234 |                                    HASH JOIN                 |                          |   148K|    27M|       | 33542   (4)| 00:06:43 |
245|*235 |                                     TABLE ACCESS FULL        | BD_CUBASDOC              |  6365 |   285K|       |    52   (6)| 00:00:01 |
246|*236 |                                     HASH JOIN                |                          |   148K|    21M|  2304K| 33484   (4)| 00:06:42 |
247| 237 |                                      TABLE ACCESS FULL       | BD_CUMANDOC              | 43648 |  1790K|       |   360   (7)| 00:00:05 |
248|*238 |                                      HASH JOIN               |                          |   146K|    15M|  3824K| 32165   (4)| 00:06:26 |
249|*239 |                                       TABLE ACCESS FULL      | GT_GENERAL_H             | 68684 |  3018K|       |  1414   (3)| 00:00:17 |
250|*240 |                                       HASH JOIN RIGHT ANTI   |                          |   165K|     9M|    32M| 29964   (4)| 00:06:00 |
251|*241 |                                        TABLE ACCESS FULL     | GT_INVOICE_B             |  1152K|    19M|       | 13080   (4)| 00:02:37 |
252|*242 |                                        TABLE ACCESS FULL     | GT_GENERAL_B             |  1163K|    49M|       | 11983   (4)| 00:02:24 |
253| 243 |                                 HASH GROUP BY                |                          |   144K|    29M|    62M| 66898   (4)| 00:13:23 |
254|*244 |                                  HASH JOIN RIGHT ANTI        |                          |   144K|    29M|       | 60039   (4)| 00:12:01 |
255| 245 |                                   VIEW                       | VW_SQ_4                  |   931 | 19551 |       | 26493   (4)| 00:05:18 |
256| 246 |                                    NESTED LOOPS              |                          |   931 | 91238 |       | 26493   (4)| 00:05:18 |
257|*247 |                                     HASH JOIN                |                          |   928 | 71456 |       | 26492   (4)| 00:05:18 |
258|*248 |                                      TABLE ACCESS FULL       | GT_MEASURE_H             |  2510 |   129K|       | 26138   (4)| 00:05:14 |
259|*249 |                                      TABLE ACCESS FULL       | GT_POORDER_H             | 19479 |   456K|       |   353   (3)| 00:00:05 |
260|*250 |                                     INDEX UNIQUE SCAN        | PK_BD_CUBASDOC           |     1 |    21 |       |     1   (0)| 00:00:01 |
261|*251 |                                   HASH JOIN                  |                          |   148K|    27M|       | 33542   (4)| 00:06:43 |
262|*252 |                                    TABLE ACCESS FULL         | BD_CUBASDOC              |  6365 |   285K|       |    52   (6)| 00:00:01 |
263|*253 |                                    HASH JOIN                 |                          |   148K|    21M|  2304K| 33484   (4)| 00:06:42 |
264| 254 |                                     TABLE ACCESS FULL        | BD_CUMANDOC              | 43648 |  1790K|       |   360   (7)| 00:00:05 |
265|*255 |                                     HASH JOIN                |                          |   146K|    15M|  3824K| 32165   (4)| 00:06:26 |
266|*256 |                                      TABLE ACCESS FULL       | GT_GENERAL_H             | 68684 |  3018K|       |  1414   (3)| 00:00:17 |
267|*257 |                                      HASH JOIN RIGHT ANTI    |                          |   165K|     9M|    32M| 29964   (4)| 00:06:00 |
268|*258 |                                       TABLE ACCESS FULL      | GT_INVOICE_B             |  1152K|    19M|       | 13080   (4)| 00:02:37 |
269|*259 |                                       TABLE ACCESS FULL      | GT_GENERAL_B             |  1163K|    49M|       | 11983   (4)| 00:02:24 |
270|*260 |                              TABLE ACCESS FULL               | BD_CUMANDOC              | 43644 |  1875K|       |   361   (7)| 00:00:05 |
271|*261 |                            TABLE ACCESS FULL                 | GT_INVOICE_B             |  1086K|    31M|       | 13080   (4)| 00:02:37 |
272|*262 |                       TABLE ACCESS FULL                      | ARAP_DJFB                |  1178K|    53M|       | 31199   (4)| 00:06:15 |
273| 263 |                 HASH GROUP BY                                |                          |  1221 |   251K|       |    11M (27)| 39:30:43 |
274|*264 |                  HASH JOIN                                   |                          |  1221 |   251K|       |    11M (27)| 39:30:43 |
275|*265 |                   TABLE ACCESS BY INDEX ROWID                | PO_INVOICE_B             |    10 |   460 |       |     2   (0)| 00:00:01 |
276| 266 |                    NESTED LOOPS                              |                          |  1221 |   226K|       |    11M (27)| 39:30:40 |
277|*267 |                     HASH JOIN ANTI                           |                          |   127 | 18288 |       |    11M (27)| 39:30:37 |
278| 268 |                      NESTED LOOPS                            |                          |   127 | 15494 |       |   271   (3)| 00:00:04 |
279|*269 |                       TABLE ACCESS FULL                      | PO_INVOICE               |   127 | 10668 |       |   220   (3)| 00:00:03 |
280| 270 |                       TABLE ACCESS BY INDEX ROWID            | BD_CUBASDOC              |     1 |    38 |       |     1   (0)| 00:00:01 |
281|*271 |                        INDEX UNIQUE SCAN                     | PK_BD_CUBASDOC           |     1 |       |       |     1   (0)| 00:00:01 |
282| 272 |                      VIEW                                    |                          |    52G|  1079G|       |    10M (16)| 34:23:30 |
283| 273 |                       UNION-ALL                              |                          |       |       |       |            |          |
284|*274 |                        HASH JOIN RIGHT OUTER                 |                          |    52G|    31T|   202M|  9172K (18)| 30:34:32 |
285| 275 |                         VIEW                                 |                          |  1251K|   188M|       | 74342   (3)| 00:14:53 |
286| 276 |                          HASH GROUP BY                       |                          |  1251K|   177M|   407M| 74342   (3)| 00:14:53 |
287|*277 |                           HASH JOIN                          |                          |  1251K|   177M|       | 32704   (4)| 00:06:33 |
288|*278 |                            TABLE ACCESS BY INDEX ROWID       | ARAP_DJZB                | 25033 |  1344K|       |  1366   (1)| 00:00:17 |
289|*279 |                             INDEX RANGE SCAN                 | I_ARAP_DJZB_004          | 24211 |       |       |    85   (2)| 00:00:02 |
290|*280 |                            HASH JOIN                         |                          |  1176K|   105M|       | 31300   (4)| 00:06:16 |
291|*281 |                             TABLE ACCESS FULL                | BD_CUBASDOC              |  6336 |   284K|       |    66  (26)| 00:00:01 |
292|*282 |                             TABLE ACCESS FULL                | ARAP_DJFB                |  1178K|    53M|       | 31199   (4)| 00:06:15 |
293| 283 |                         VIEW                                 |                          |   267M|   124G|       |  1056K  (3)| 03:31:21 |
294| 284 |                          UNION-ALL                           |                          |       |       |       |            |          |
295|*285 |                           HASH JOIN OUTER                    |                          |   262M|   121G|    55M|   616K  (3)| 02:03:20 |
296| 286 |                            VIEW                              |                          |   166K|    53M|       |   133K  (4)| 00:26:41 |
297| 287 |                             UNION-ALL                        |                          |       |       |       |            |          |
298|*288 |                              HASH JOIN OUTER                 |                          | 21756 |  6713K|       | 66505   (4)| 00:13:19 |
299| 289 |                               VIEW                           |                          |   931 |   143K|       | 26545   (4)| 00:05:19 |
300| 290 |                                HASH GROUP BY                 |                          |   931 |   119K|       | 26545   (4)| 00:05:19 |
301|*291 |                                 HASH JOIN                    |                          |   931 |   119K|       | 26544   (4)| 00:05:19 |
302|*292 |                                  HASH JOIN                   |                          |   928 | 78880 |       | 26492   (4)| 00:05:18 |
303|*293 |                                   TABLE ACCESS FULL          | GT_MEASURE_H             |  2510 |   139K|       | 26138   (4)| 00:05:14 |
304|*294 |                                   TABLE ACCESS FULL          | GT_POORDER_H             | 19479 |   532K|       |   353   (3)| 00:00:05 |
305| 295 |                                  TABLE ACCESS FULL           | BD_CUBASDOC              |  6366 |   285K|       |    52   (6)| 00:00:01 |
306| 296 |                               VIEW                           |                          |   148K|    22M|       | 39955   (3)| 00:08:00 |
307| 297 |                                HASH GROUP BY                 |                          |   148K|    27M|    59M| 39955   (3)| 00:08:00 |
308|*298 |                                 HASH JOIN                    |                          |   148K|    27M|       | 33542   (4)| 00:06:43 |
309|*299 |                                  TABLE ACCESS FULL           | BD_CUBASDOC              |  6365 |   285K|       |    52   (6)| 00:00:01 |
310|*300 |                                  HASH JOIN                   |                          |   148K|    21M|  2304K| 33484   (4)| 00:06:42 |
311| 301 |                                   TABLE ACCESS FULL          | BD_CUMANDOC              | 43648 |  1790K|       |   360   (7)| 00:00:05 |
312|*302 |                                   HASH JOIN                  |                          |   146K|    15M|  3824K| 32165   (4)| 00:06:26 |
313|*303 |                                    TABLE ACCESS FULL         | GT_GENERAL_H             | 68684 |  3018K|       |  1414   (3)| 00:00:17 |
314|*304 |                                    HASH JOIN RIGHT ANTI      |                          |   165K|     9M|    32M| 29964   (4)| 00:06:00 |
315|*305 |                                     TABLE ACCESS FULL        | GT_INVOICE_B             |  1152K|    19M|       | 13080   (4)| 00:02:37 |
316|*306 |                                     TABLE ACCESS FULL        | GT_GENERAL_B             |  1163K|    49M|       | 11983   (4)| 00:02:24 |
317| 307 |                              HASH GROUP BY                   |                          |   144K|    29M|    62M| 66898   (4)| 00:13:23 |
318|*308 |                               HASH JOIN RIGHT ANTI           |                          |   144K|    29M|       | 60039   (4)| 00:12:01 |
319| 309 |                                VIEW                          | VW_SQ_5                  |   931 | 19551 |       | 26493   (4)| 00:05:18 |
320| 310 |                                 NESTED LOOPS                 |                          |   931 | 91238 |       | 26493   (4)| 00:05:18 |
321|*311 |                                  HASH JOIN                   |                          |   928 | 71456 |       | 26492   (4)| 00:05:18 |
322|*312 |                                   TABLE ACCESS FULL          | GT_MEASURE_H             |  2510 |   129K|       | 26138   (4)| 00:05:14 |
323|*313 |                                   TABLE ACCESS FULL          | GT_POORDER_H             | 19479 |   456K|       |   353   (3)| 00:00:05 |
324|*314 |                                  INDEX UNIQUE SCAN           | PK_BD_CUBASDOC           |     1 |    21 |       |     1   (0)| 00:00:01 |
325|*315 |                                HASH JOIN                     |                          |   148K|    27M|       | 33542   (4)| 00:06:43 |
326|*316 |                                 TABLE ACCESS FULL            | BD_CUBASDOC              |  6365 |   285K|       |    52   (6)| 00:00:01 |
327|*317 |                                 HASH JOIN                    |                          |   148K|    21M|  2304K| 33484   (4)| 00:06:42 |
328| 318 |                                  TABLE ACCESS FULL           | BD_CUMANDOC              | 43648 |  1790K|       |   360   (7)| 00:00:05 |
329|*319 |                                  HASH JOIN                   |                          |   146K|    15M|  3824K| 32165   (4)| 00:06:26 |
330|*320 |                                   TABLE ACCESS FULL          | GT_GENERAL_H             | 68684 |  3018K|       |  1414   (3)| 00:00:17 |
331|*321 |                                   HASH JOIN RIGHT ANTI       |                          |   165K|     9M|    32M| 29964   (4)| 00:06:00 |
332|*322 |                                    TABLE ACCESS FULL         | GT_INVOICE_B             |  1152K|    19M|       | 13080   (4)| 00:02:37 |
333|*323 |                                    TABLE ACCESS FULL         | GT_GENERAL_B             |  1163K|    49M|       | 11983   (4)| 00:02:24 |
334| 324 |                            VIEW                              |                          |    10M|  1515M|       |   391K  (2)| 01:18:18 |
335| 325 |                             HASH GROUP BY                    |                          |    10M|  1611M|  3492M|   391K  (2)| 01:18:18 |
336|*326 |                              HASH JOIN                       |                          |    10M|  1611M|  3168K| 16451   (6)| 00:03:18 |
337|*327 |                               HASH JOIN                      |                          | 21601 |  2911K|       |   728   (6)| 00:00:09 |
338|*328 |                                TABLE ACCESS FULL             | BD_CUBASDOC              |  6365 |   285K|       |    52   (6)| 00:00:01 |
339|*329 |                                HASH JOIN                     |                          | 21605 |  1941K|       |   674   (5)| 00:00:09 |
340|*330 |                                 TABLE ACCESS FULL            | GT_INVOICE_H             | 21430 |  1004K|       |   311   (3)| 00:00:04 |
341|*331 |                                 TABLE ACCESS FULL            | BD_CUMANDOC              | 43644 |  1875K|       |   361   (7)| 00:00:05 |
342|*332 |                               TABLE ACCESS FULL              | GT_INVOICE_B             |  1086K|    31M|       | 13080   (4)| 00:02:37 |
343| 333 |                           HASH GROUP BY                      |                          |  5206K|   943M|  2981M|   440K  (3)| 01:28:02 |
344|*334 |                            HASH JOIN                         |                          |    10M|  1822M|  3632K|   149K  (4)| 00:29:59 |
345|*335 |                             HASH JOIN                        |                          | 21598 |  3374K|       |   134K  (4)| 00:26:50 |
346|*336 |                              TABLE ACCESS FULL               | GT_INVOICE_H             | 21430 |  1004K|       |   311   (3)| 00:00:04 |
347|*337 |                              HASH JOIN                       |                          | 43630 |  4772K|       |   133K  (4)| 00:26:46 |
348|*338 |                               HASH JOIN ANTI                 |                          |  6364 |   422K|       |   133K  (4)| 00:26:42 |
349|*339 |                                TABLE ACCESS FULL             | BD_CUBASDOC              |  6365 |   285K|       |    52   (6)| 00:00:01 |
350| 340 |                                VIEW                          |                          |   166K|  3571K|       |   133K  (4)| 00:26:41 |
351| 341 |                                 UNION-ALL                    |                          |       |       |       |            |          |
352|*342 |                                  HASH JOIN OUTER             |                          | 21756 |  6713K|       | 66505   (4)| 00:13:19 |
353| 343 |                                   VIEW                       |                          |   931 |   143K|       | 26545   (4)| 00:05:19 |
354| 344 |                                    HASH GROUP BY             |                          |   931 |   119K|       | 26545   (4)| 00:05:19 |
355|*345 |                                     HASH JOIN                |                          |   931 |   119K|       | 26544   (4)| 00:05:19 |
356|*346 |                                      HASH JOIN               |                          |   928 | 78880 |       | 26492   (4)| 00:05:18 |
357|*347 |                                       TABLE ACCESS FULL      | GT_MEASURE_H             |  2510 |   139K|       | 26138   (4)| 00:05:14 |
358|*348 |                                       TABLE ACCESS FULL      | GT_POORDER_H             | 19479 |   532K|       |   353   (3)| 00:00:05 |
359| 349 |                                      TABLE ACCESS FULL       | BD_CUBASDOC              |  6366 |   285K|       |    52   (6)| 00:00:01 |
360| 350 |                                   VIEW                       |                          |   148K|    22M|       | 39955   (3)| 00:08:00 |
361| 351 |                                    HASH GROUP BY             |                          |   148K|    27M|    59M| 39955   (3)| 00:08:00 |
362|*352 |                                     HASH JOIN                |                          |   148K|    27M|       | 33542   (4)| 00:06:43 |
363|*353 |                                      TABLE ACCESS FULL       | BD_CUBASDOC              |  6365 |   285K|       |    52   (6)| 00:00:01 |
364|*354 |                                      HASH JOIN               |                          |   148K|    21M|  2304K| 33484   (4)| 00:06:42 |
365| 355 |                                       TABLE ACCESS FULL      | BD_CUMANDOC              | 43648 |  1790K|       |   360   (7)| 00:00:05 |
366|*356 |                                       HASH JOIN              |                          |   146K|    15M|  3824K| 32165   (4)| 00:06:26 |
367|*357 |                                        TABLE ACCESS FULL     | GT_GENERAL_H             | 68684 |  3018K|       |  1414   (3)| 00:00:17 |
368|*358 |                                        HASH JOIN RIGHT ANTI  |                          |   165K|     9M|    32M| 29964   (4)| 00:06:00 |
369|*359 |                                         TABLE ACCESS FULL    | GT_INVOICE_B             |  1152K|    19M|       | 13080   (4)| 00:02:37 |
370|*360 |                                         TABLE ACCESS FULL    | GT_GENERAL_B             |  1163K|    49M|       | 11983   (4)| 00:02:24 |
371| 361 |                                  HASH GROUP BY               |                          |   144K|    29M|    62M| 66898   (4)| 00:13:23 |
372|*362 |                                   HASH JOIN RIGHT ANTI       |                          |   144K|    29M|       | 60039   (4)| 00:12:01 |
373| 363 |                                    VIEW                      | VW_SQ_6                  |   931 | 19551 |       | 26493   (4)| 00:05:18 |
374| 364 |                                     NESTED LOOPS             |                          |   931 | 91238 |       | 26493   (4)| 00:05:18 |
375|*365 |                                      HASH JOIN               |                          |   928 | 71456 |       | 26492   (4)| 00:05:18 |
376|*366 |                                       TABLE ACCESS FULL      | GT_MEASURE_H             |  2510 |   129K|       | 26138   (4)| 00:05:14 |
377|*367 |                                       TABLE ACCESS FULL      | GT_POORDER_H             | 19479 |   456K|       |   353   (3)| 00:00:05 |
378|*368 |                                      INDEX UNIQUE SCAN       | PK_BD_CUBASDOC           |     1 |    21 |       |     1   (0)| 00:00:01 |
379|*369 |                                    HASH JOIN                 |                          |   148K|    27M|       | 33542   (4)| 00:06:43 |
380|*370 |                                     TABLE ACCESS FULL        | BD_CUBASDOC              |  6365 |   285K|       |    52   (6)| 00:00:01 |
381|*371 |                                     HASH JOIN                |                          |   148K|    21M|  2304K| 33484   (4)| 00:06:42 |
382| 372 |                                      TABLE ACCESS FULL       | BD_CUMANDOC              | 43648 |  1790K|       |   360   (7)| 00:00:05 |
383|*373 |                                      HASH JOIN               |                          |   146K|    15M|  3824K| 32165   (4)| 00:06:26 |
384|*374 |                                       TABLE ACCESS FULL      | GT_GENERAL_H             | 68684 |  3018K|       |  1414   (3)| 00:00:17 |
385|*375 |                                       HASH JOIN RIGHT ANTI   |                          |   165K|     9M|    32M| 29964   (4)| 00:06:00 |
386|*376 |                                        TABLE ACCESS FULL     | GT_INVOICE_B             |  1152K|    19M|       | 13080   (4)| 00:02:37 |
387|*377 |                                        TABLE ACCESS FULL     | GT_GENERAL_B             |  1163K|    49M|       | 11983   (4)| 00:02:24 |
388|*378 |                               TABLE ACCESS FULL              | BD_CUMANDOC              | 43644 |  1875K|       |   361   (7)| 00:00:05 |
389|*379 |                             TABLE ACCESS FULL                | GT_INVOICE_B             |  1086K|    31M|       | 13080   (4)| 00:02:37 |
390| 380 |                        HASH GROUP BY                         |                          |  1251K|   204M|   454M|  1144K  (4)| 03:48:58 |
391|*381 |                         HASH JOIN                            |                          |  1251K|   204M|       |  1097K  (4)| 03:39:28 |
392|*382 |                          TABLE ACCESS BY INDEX ROWID         | ARAP_DJZB                | 25033 |  1344K|       |  1366   (1)| 00:00:17 |
393|*383 |                           INDEX RANGE SCAN                   | I_ARAP_DJZB_004          | 24211 |       |       |    85   (2)| 00:00:02 |
394|*384 |                          HASH JOIN                           |                          |  1176K|   130M|       |  1095K  (4)| 03:39:11 |
395|*385 |                           HASH JOIN ANTI                     |                          |  6335 |   420K|       |  1064K  (4)| 03:32:56 |
396|*386 |                            TABLE ACCESS FULL                 | BD_CUBASDOC              |  6336 |   284K|       |    66  (26)| 00:00:01 |
397| 387 |                            VIEW                              |                          |   267M|  5620M|       |  1056K  (3)| 03:31:21 |
398| 388 |                             UNION-ALL                        |                          |       |       |       |            |          |
399|*389 |                              HASH JOIN OUTER                 |                          |   262M|   121G|    55M|   616K  (3)| 02:03:20 |
400| 390 |                               VIEW                           |                          |   166K|    53M|       |   133K  (4)| 00:26:41 |
401| 391 |                                UNION-ALL                     |                          |       |       |       |            |          |
402|*392 |                                 HASH JOIN OUTER              |                          | 21756 |  6713K|       | 66505   (4)| 00:13:19 |
403| 393 |                                  VIEW                        |                          |   931 |   143K|       | 26545   (4)| 00:05:19 |
404| 394 |                                   HASH GROUP BY              |                          |   931 |   119K|       | 26545   (4)| 00:05:19 |
405|*395 |                                    HASH JOIN                 |                          |   931 |   119K|       | 26544   (4)| 00:05:19 |
406|*396 |                                     HASH JOIN                |                          |   928 | 78880 |       | 26492   (4)| 00:05:18 |
407|*397 |                                      TABLE ACCESS FULL       | GT_MEASURE_H             |  2510 |   139K|       | 26138   (4)| 00:05:14 |
408|*398 |                                      TABLE ACCESS FULL       | GT_POORDER_H             | 19479 |   532K|       |   353   (3)| 00:00:05 |
409| 399 |                                     TABLE ACCESS FULL        | BD_CUBASDOC              |  6366 |   285K|       |    52   (6)| 00:00:01 |
410| 400 |                                  VIEW                        |                          |   148K|    22M|       | 39955   (3)| 00:08:00 |
411| 401 |                                   HASH GROUP BY              |                          |   148K|    27M|    59M| 39955   (3)| 00:08:00 |
412|*402 |                                    HASH JOIN                 |                          |   148K|    27M|       | 33542   (4)| 00:06:43 |
413|*403 |                                     TABLE ACCESS FULL        | BD_CUBASDOC              |  6365 |   285K|       |    52   (6)| 00:00:01 |
414|*404 |                                     HASH JOIN                |                          |   148K|    21M|  2304K| 33484   (4)| 00:06:42 |
415| 405 |                                      TABLE ACCESS FULL       | BD_CUMANDOC              | 43648 |  1790K|       |   360   (7)| 00:00:05 |
416|*406 |                                      HASH JOIN               |                          |   146K|    15M|  3824K| 32165   (4)| 00:06:26 |
417|*407 |                                       TABLE ACCESS FULL      | GT_GENERAL_H             | 68684 |  3018K|       |  1414   (3)| 00:00:17 |
418|*408 |                                       HASH JOIN RIGHT ANTI   |                          |   165K|     9M|    32M| 29964   (4)| 00:06:00 |
419|*409 |                                        TABLE ACCESS FULL     | GT_INVOICE_B             |  1152K|    19M|       | 13080   (4)| 00:02:37 |
420|*410 |                                        TABLE ACCESS FULL     | GT_GENERAL_B             |  1163K|    49M|       | 11983   (4)| 00:02:24 |
421| 411 |                                 HASH GROUP BY                |                          |   144K|    29M|    62M| 66898   (4)| 00:13:23 |
422|*412 |                                  HASH JOIN RIGHT ANTI        |                          |   144K|    29M|       | 60039   (4)| 00:12:01 |
423| 413 |                                   VIEW                       | VW_SQ_7                  |   931 | 19551 |       | 26493   (4)| 00:05:18 |
424| 414 |                                    NESTED LOOPS              |                          |   931 | 91238 |       | 26493   (4)| 00:05:18 |
425|*415 |                                     HASH JOIN                |                          |   928 | 71456 |       | 26492   (4)| 00:05:18 |
426|*416 |                                      TABLE ACCESS FULL       | GT_MEASURE_H             |  2510 |   129K|       | 26138   (4)| 00:05:14 |
427|*417 |                                      TABLE ACCESS FULL       | GT_POORDER_H             | 19479 |   456K|       |   353   (3)| 00:00:05 |
428|*418 |                                     INDEX UNIQUE SCAN        | PK_BD_CUBASDOC           |     1 |    21 |       |     1   (0)| 00:00:01 |
429|*419 |                                   HASH JOIN                  |                          |   148K|    27M|       | 33542   (4)| 00:06:43 |
430|*420 |                                    TABLE ACCESS FULL         | BD_CUBASDOC              |  6365 |   285K|       |    52   (6)| 00:00:01 |
431|*421 |                                    HASH JOIN                 |                          |   148K|    21M|  2304K| 33484   (4)| 00:06:42 |
432| 422 |                                     TABLE ACCESS FULL        | BD_CUMANDOC              | 43648 |  1790K|       |   360   (7)| 00:00:05 |
433|*423 |                                     HASH JOIN                |                          |   146K|    15M|  3824K| 32165   (4)| 00:06:26 |
434|*424 |                                      TABLE ACCESS FULL       | GT_GENERAL_H             | 68684 |  3018K|       |  1414   (3)| 00:00:17 |
435|*425 |                                      HASH JOIN RIGHT ANTI    |                          |   165K|     9M|    32M| 29964   (4)| 00:06:00 |
436|*426 |                                       TABLE ACCESS FULL      | GT_INVOICE_B             |  1152K|    19M|       | 13080   (4)| 00:02:37 |
437|*427 |                                       TABLE ACCESS FULL      | GT_GENERAL_B             |  1163K|    49M|       | 11983   (4)| 00:02:24 |
438| 428 |                               VIEW                           |                          |    10M|  1515M|       |   391K  (2)| 01:18:18 |
439| 429 |                                HASH GROUP BY                 |                          |    10M|  1611M|  3492M|   391K  (2)| 01:18:18 |
440|*430 |                                 HASH JOIN                    |                          |    10M|  1611M|  3168K| 16451   (6)| 00:03:18 |
441|*431 |                                  HASH JOIN                   |                          | 21601 |  2911K|       |   728   (6)| 00:00:09 |
442|*432 |                                   TABLE ACCESS FULL          | BD_CUBASDOC              |  6365 |   285K|       |    52   (6)| 00:00:01 |
443|*433 |                                   HASH JOIN                  |                          | 21605 |  1941K|       |   674   (5)| 00:00:09 |
444|*434 |                                    TABLE ACCESS FULL         | GT_INVOICE_H             | 21430 |  1004K|       |   311   (3)| 00:00:04 |
445|*435 |                                    TABLE ACCESS FULL         | BD_CUMANDOC              | 43644 |  1875K|       |   361   (7)| 00:00:05 |
446|*436 |                                  TABLE ACCESS FULL           | GT_INVOICE_B             |  1086K|    31M|       | 13080   (4)| 00:02:37 |
447| 437 |                              HASH GROUP BY                   |                          |  5206K|   943M|  2981M|   440K  (3)| 01:28:02 |
448|*438 |                               HASH JOIN                      |                          |    10M|  1822M|  3632K|   149K  (4)| 00:29:59 |
449|*439 |                                HASH JOIN                     |                          | 21598 |  3374K|       |   134K  (4)| 00:26:50 |
450|*440 |                                 TABLE ACCESS FULL            | GT_INVOICE_H             | 21430 |  1004K|       |   311   (3)| 00:00:04 |
451|*441 |                                 HASH JOIN                    |                          | 43630 |  4772K|       |   133K  (4)| 00:26:46 |
452|*442 |                                  HASH JOIN ANTI              |                          |  6364 |   422K|       |   133K  (4)| 00:26:42 |
453|*443 |                                   TABLE ACCESS FULL          | BD_CUBASDOC              |  6365 |   285K|       |    52   (6)| 00:00:01 |
454| 444 |                                   VIEW                       |                          |   166K|  3571K|       |   133K  (4)| 00:26:41 |
455| 445 |                                    UNION-ALL                 |                          |       |       |       |            |          |
456|*446 |                                     HASH JOIN OUTER          |                          | 21756 |  6713K|       | 66505   (4)| 00:13:19 |
457| 447 |                                      VIEW                    |                          |   931 |   143K|       | 26545   (4)| 00:05:19 |
458| 448 |                                       HASH GROUP BY          |                          |   931 |   119K|       | 26545   (4)| 00:05:19 |
459|*449 |                                        HASH JOIN             |                          |   931 |   119K|       | 26544   (4)| 00:05:19 |
460|*450 |                                         HASH JOIN            |                          |   928 | 78880 |       | 26492   (4)| 00:05:18 |
461|*451 |                                          TABLE ACCESS FULL   | GT_MEASURE_H             |  2510 |   139K|       | 26138   (4)| 00:05:14 |
462|*452 |                                          TABLE ACCESS FULL   | GT_POORDER_H             | 19479 |   532K|       |   353   (3)| 00:00:05 |
463| 453 |                                         TABLE ACCESS FULL    | BD_CUBASDOC              |  6366 |   285K|       |    52   (6)| 00:00:01 |
464| 454 |                                      VIEW                    |                          |   148K|    22M|       | 39955   (3)| 00:08:00 |
465| 455 |                                       HASH GROUP BY          |                          |   148K|    27M|    59M| 39955   (3)| 00:08:00 |
466|*456 |                                        HASH JOIN             |                          |   148K|    27M|       | 33542   (4)| 00:06:43 |
467|*457 |                                         TABLE ACCESS FULL    | BD_CUBASDOC              |  6365 |   285K|       |    52   (6)| 00:00:01 |
468|*458 |                                         HASH JOIN            |                          |   148K|    21M|  2304K| 33484   (4)| 00:06:42 |
469| 459 |                                          TABLE ACCESS FULL   | BD_CUMANDOC              | 43648 |  1790K|       |   360   (7)| 00:00:05 |
470|*460 |                                          HASH JOIN           |                          |   146K|    15M|  3824K| 32165   (4)| 00:06:26 |
471|*461 |                                           TABLE ACCESS FULL  | GT_GENERAL_H             | 68684 |  3018K|       |  1414   (3)| 00:00:17 |
472|*462 | TI                                        HASH JOIN RIGHT AN |                          |   165K|     9M|    32M| 29964   (4)| 00:06:00 |
473|*463 |                                            TABLE ACCESS FULL | GT_INVOICE_B             |  1152K|    19M|       | 13080   (4)| 00:02:37 |
474|*464 |                                            TABLE ACCESS FULL | GT_GENERAL_B             |  1163K|    49M|       | 11983   (4)| 00:02:24 |
475| 465 |                                     HASH GROUP BY            |                          |   144K|    29M|    62M| 66898   (4)| 00:13:23 |
476|*466 |                                      HASH JOIN RIGHT ANTI    |                          |   144K|    29M|       | 60039   (4)| 00:12:01 |
477| 467 |                                       VIEW                   | VW_SQ_8                  |   931 | 19551 |       | 26493   (4)| 00:05:18 |
478| 468 |                                        NESTED LOOPS          |                          |   931 | 91238 |       | 26493   (4)| 00:05:18 |
479|*469 |                                         HASH JOIN            |                          |   928 | 71456 |       | 26492   (4)| 00:05:18 |
480|*470 |                                          TABLE ACCESS FULL   | GT_MEASURE_H             |  2510 |   129K|       | 26138   (4)| 00:05:14 |
481|*471 |                                          TABLE ACCESS FULL   | GT_POORDER_H             | 19479 |   456K|       |   353   (3)| 00:00:05 |
482|*472 |                                         INDEX UNIQUE SCAN    | PK_BD_CUBASDOC           |     1 |    21 |       |     1   (0)| 00:00:01 |
483|*473 |                                       HASH JOIN              |                          |   148K|    27M|       | 33542   (4)| 00:06:43 |
484|*474 |                                        TABLE ACCESS FULL     | BD_CUBASDOC              |  6365 |   285K|       |    52   (6)| 00:00:01 |
485|*475 |                                        HASH JOIN             |                          |   148K|    21M|  2304K| 33484   (4)| 00:06:42 |
486| 476 |                                         TABLE ACCESS FULL    | BD_CUMANDOC              | 43648 |  1790K|       |   360   (7)| 00:00:05 |
487|*477 |                                         HASH JOIN            |                          |   146K|    15M|  3824K| 32165   (4)| 00:06:26 |
488|*478 |                                          TABLE ACCESS FULL   | GT_GENERAL_H             | 68684 |  3018K|       |  1414   (3)| 00:00:17 |
489|*479 | I                                        HASH JOIN RIGHT ANT |                          |   165K|     9M|    32M| 29964   (4)| 00:06:00 |
490|*480 |                                           TABLE ACCESS FULL  | GT_INVOICE_B             |  1152K|    19M|       | 13080   (4)| 00:02:37 |
491|*481 |                                           TABLE ACCESS FULL  | GT_GENERAL_B             |  1163K|    49M|       | 11983   (4)| 00:02:24 |
492|*482 |                                  TABLE ACCESS FULL           | BD_CUMANDOC              | 43644 |  1875K|       |   361   (7)| 00:00:05 |
493|*483 |                                TABLE ACCESS FULL             | GT_INVOICE_B             |  1086K|    31M|       | 13080   (4)| 00:02:37 |
494|*484 |                           TABLE ACCESS FULL                  | ARAP_DJFB                |  1178K|    53M|       | 31199   (4)| 00:06:15 |
495|*485 |                     INDEX RANGE SCAN                         | I_PO_INVOICE_B_5         |    14 |       |       |     1   (0)| 00:00:01 |
496| 486 |                   INDEX FAST FULL SCAN                       | PK_PO_ORDER_B            |   227K|  4673K|       |   287   (4)| 00:00:04 |
497| 487 |              HASH GROUP BY                                   |                          |   202 | 15150 |       |    25M (32)| 84:08:31 |
498|*488 |               HASH JOIN ANTI                                 |                          |   202 | 15150 |       |    25M (32)| 84:08:31 |
499|*489 |                TABLE ACCESS FULL                             | GT_QCYE                  |   203 | 10759 |       |     8   (0)| 00:00:01 |
500| 490 |                VIEW                                          |                          |    52G|  1079G|       |    23M (27)| 79:01:26 |
501| 491 |                 UNION-ALL                                    |                          |       |       |       |            |          |
502|*492 |                  HASH JOIN RIGHT OUTER                       |                          |    52G|    38T|       |    11M (27)| 39:30:43 |
503| 493 |                   VIEW                                       |                          |  1221 |   162K|       |   770   (4)| 00:00:10 |
504| 494 |                    HASH GROUP BY                             |                          |  1221 |   225K|       |   770   (4)| 00:00:10 |
505|*495 |                     HASH JOIN                                |                          |  1221 |   225K|       |   769   (4)| 00:00:10 |
506|*496 |                      TABLE ACCESS BY INDEX ROWID             | PO_INVOICE_B             |    10 |   460 |       |     2   (0)| 00:00:01 |
507| 497 |                       NESTED LOOPS                           |                          |  1221 |   200K|       |   475   (2)| 00:00:06 |
508| 498 |                        NESTED LOOPS                          |                          |   127 | 15494 |       |   271   (3)| 00:00:04 |
509|*499 |                         TABLE ACCESS FULL                    | PO_INVOICE               |   127 | 10668 |       |   220   (3)| 00:00:03 |
510| 500 |                         TABLE ACCESS BY INDEX ROWID          | BD_CUBASDOC              |     1 |    38 |       |     1   (0)| 00:00:01 |
511|*501 |                          INDEX UNIQUE SCAN                   | PK_BD_CUBASDOC           |     1 |       |       |     1   (0)| 00:00:01 |
512|*502 |                        INDEX RANGE SCAN                      | I_PO_INVOICE_B_5         |    14 |       |       |     1   (0)| 00:00:01 |
513| 503 |                      INDEX FAST FULL SCAN                    | PK_PO_ORDER_B            |   227K|  4673K|       |   287   (4)| 00:00:04 |
514| 504 |                   VIEW                                       |                          |    52G|    31T|       |    10M (16)| 34:23:30 |
515| 505 |                    UNION-ALL                                 |                          |       |       |       |            |          |
516|*506 |                     HASH JOIN RIGHT OUTER                    |                          |    52G|    31T|   202M|  9172K (18)| 30:34:32 |
517| 507 |                      VIEW                                    |                          |  1251K|   188M|       | 74342   (3)| 00:14:53 |
518| 508 |                       HASH GROUP BY                          |                          |  1251K|   177M|   407M| 74342   (3)| 00:14:53 |
519|*509 |                        HASH JOIN                             |                          |  1251K|   177M|       | 32704   (4)| 00:06:33 |
520|*510 |                         TABLE ACCESS BY INDEX ROWID          | ARAP_DJZB                | 25033 |  1344K|       |  1366   (1)| 00:00:17 |
521|*511 |                          INDEX RANGE SCAN                    | I_ARAP_DJZB_004          | 24211 |       |       |    85   (2)| 00:00:02 |
522|*512 |                         HASH JOIN                            |                          |  1176K|   105M|       | 31300   (4)| 00:06:16 |
523|*513 |                          TABLE ACCESS FULL                   | BD_CUBASDOC              |  6336 |   284K|       |    66  (26)| 00:00:01 |
524|*514 |                          TABLE ACCESS FULL                   | ARAP_DJFB                |  1178K|    53M|       | 31199   (4)| 00:06:15 |
525| 515 |                      VIEW                                    |                          |   267M|   124G|       |  1056K  (3)| 03:31:21 |
526| 516 |                       UNION-ALL                              |                          |       |       |       |            |          |
527|*517 |                        HASH JOIN OUTER                       |                          |   262M|   121G|    55M|   616K  (3)| 02:03:20 |
528| 518 |                         VIEW                                 |                          |   166K|    53M|       |   133K  (4)| 00:26:41 |
529| 519 |                          UNION-ALL                           |                          |       |       |       |            |          |
530|*520 |                           HASH JOIN OUTER                    |                          | 21756 |  6713K|       | 66505   (4)| 00:13:19 |
531| 521 |                            VIEW                              |                          |   931 |   143K|       | 26545   (4)| 00:05:19 |
532| 522 |                             HASH GROUP BY                    |                          |   931 |   119K|       | 26545   (4)| 00:05:19 |
533|*523 |                              HASH JOIN                       |                          |   931 |   119K|       | 26544   (4)| 00:05:19 |
534|*524 |                               HASH JOIN                      |                          |   928 | 78880 |       | 26492   (4)| 00:05:18 |
535|*525 |                                TABLE ACCESS FULL             | GT_MEASURE_H             |  2510 |   139K|       | 26138   (4)| 00:05:14 |
536|*526 |                                TABLE ACCESS FULL             | GT_POORDER_H             | 19479 |   532K|       |   353   (3)| 00:00:05 |
537| 527 |                               TABLE ACCESS FULL              | BD_CUBASDOC              |  6366 |   285K|       |    52   (6)| 00:00:01 |
538| 528 |                            VIEW                              |                          |   148K|    22M|       | 39955   (3)| 00:08:00 |
539| 529 |                             HASH GROUP BY                    |                          |   148K|    27M|    59M| 39955   (3)| 00:08:00 |
540|*530 |                              HASH JOIN                       |                          |   148K|    27M|       | 33542   (4)| 00:06:43 |
541|*531 |                               TABLE ACCESS FULL              | BD_CUBASDOC              |  6365 |   285K|       |    52   (6)| 00:00:01 |
542|*532 |                               HASH JOIN                      |                          |   148K|    21M|  2304K| 33484   (4)| 00:06:42 |
543| 533 |                                TABLE ACCESS FULL             | BD_CUMANDOC              | 43648 |  1790K|       |   360   (7)| 00:00:05 |
544|*534 |                                HASH JOIN                     |                          |   146K|    15M|  3824K| 32165   (4)| 00:06:26 |
545|*535 |                                 TABLE ACCESS FULL            | GT_GENERAL_H             | 68684 |  3018K|       |  1414   (3)| 00:00:17 |
546|*536 |                                 HASH JOIN RIGHT ANTI         |                          |   165K|     9M|    32M| 29964   (4)| 00:06:00 |
547|*537 |                                  TABLE ACCESS FULL           | GT_INVOICE_B             |  1152K|    19M|       | 13080   (4)| 00:02:37 |
548|*538 |                                  TABLE ACCESS FULL           | GT_GENERAL_B             |  1163K|    49M|       | 11983   (4)| 00:02:24 |
549| 539 |                           HASH GROUP BY                      |                          |   144K|    29M|    62M| 66898   (4)| 00:13:23 |
550|*540 |                            HASH JOIN RIGHT ANTI              |                          |   144K|    29M|       | 60039   (4)| 00:12:01 |
551| 541 |                             VIEW                             | VW_SQ_9                  |   931 | 19551 |       | 26493   (4)| 00:05:18 |
552| 542 |                              NESTED LOOPS                    |                          |   931 | 91238 |       | 26493   (4)| 00:05:18 |
553|*543 |                               HASH JOIN                      |                          |   928 | 71456 |       | 26492   (4)| 00:05:18 |
554|*544 |                                TABLE ACCESS FULL             | GT_MEASURE_H             |  2510 |   129K|       | 26138   (4)| 00:05:14 |
555|*545 |                                TABLE ACCESS FULL             | GT_POORDER_H             | 19479 |   456K|       |   353   (3)| 00:00:05 |
556|*546 |                               INDEX UNIQUE SCAN              | PK_BD_CUBASDOC           |     1 |    21 |       |     1   (0)| 00:00:01 |
557|*547 |                             HASH JOIN                        |                          |   148K|    27M|       | 33542   (4)| 00:06:43 |
558|*548 |                              TABLE ACCESS FULL               | BD_CUBASDOC              |  6365 |   285K|       |    52   (6)| 00:00:01 |
559|*549 |                              HASH JOIN                       |                          |   148K|    21M|  2304K| 33484   (4)| 00:06:42 |
560| 550 |                               TABLE ACCESS FULL              | BD_CUMANDOC              | 43648 |  1790K|       |   360   (7)| 00:00:05 |
561|*551 |                               HASH JOIN                      |                          |   146K|    15M|  3824K| 32165   (4)| 00:06:26 |
562|*552 |                                TABLE ACCESS FULL             | GT_GENERAL_H             | 68684 |  3018K|       |  1414   (3)| 00:00:17 |
563|*553 |                                HASH JOIN RIGHT ANTI          |                          |   165K|     9M|    32M| 29964   (4)| 00:06:00 |
564|*554 |                                 TABLE ACCESS FULL            | GT_INVOICE_B             |  1152K|    19M|       | 13080   (4)| 00:02:37 |
565|*555 |                                 TABLE ACCESS FULL            | GT_GENERAL_B             |  1163K|    49M|       | 11983   (4)| 00:02:24 |
566| 556 |                         VIEW                                 |                          |    10M|  1515M|       |   391K  (2)| 01:18:18 |
567| 557 |                          HASH GROUP BY                       |                          |    10M|  1611M|  3492M|   391K  (2)| 01:18:18 |
568|*558 |                           HASH JOIN                          |                          |    10M|  1611M|  3168K| 16451   (6)| 00:03:18 |
569|*559 |                            HASH JOIN                         |                          | 21601 |  2911K|       |   728   (6)| 00:00:09 |
570|*560 |                             TABLE ACCESS FULL                | BD_CUBASDOC              |  6365 |   285K|       |    52   (6)| 00:00:01 |
571|*561 |                             HASH JOIN                        |                          | 21605 |  1941K|       |   674   (5)| 00:00:09 |
572|*562 |                              TABLE ACCESS FULL               | GT_INVOICE_H             | 21430 |  1004K|       |   311   (3)| 00:00:04 |
573|*563 |                              TABLE ACCESS FULL               | BD_CUMANDOC              | 43644 |  1875K|       |   361   (7)| 00:00:05 |
574|*564 |                            TABLE ACCESS FULL                 | GT_INVOICE_B             |  1086K|    31M|       | 13080   (4)| 00:02:37 |
575| 565 |                        HASH GROUP BY                         |                          |  5206K|   943M|  2981M|   440K  (3)| 01:28:02 |
576|*566 |                         HASH JOIN                            |                          |    10M|  1822M|  3632K|   149K  (4)| 00:29:59 |
577|*567 |                          HASH JOIN                           |                          | 21598 |  3374K|       |   134K  (4)| 00:26:50 |
578|*568 |                           TABLE ACCESS FULL                  | GT_INVOICE_H             | 21430 |  1004K|       |   311   (3)| 00:00:04 |
579|*569 |                           HASH JOIN                          |                          | 43630 |  4772K|       |   133K  (4)| 00:26:46 |
580|*570 |                            HASH JOIN ANTI                    |                          |  6364 |   422K|       |   133K  (4)| 00:26:42 |
581|*571 |                             TABLE ACCESS FULL                | BD_CUBASDOC              |  6365 |   285K|       |    52   (6)| 00:00:01 |
582| 572 |                             VIEW                             |                          |   166K|  3571K|       |   133K  (4)| 00:26:41 |
583| 573 |                              UNION-ALL                       |                          |       |       |       |            |          |
584|*574 |                               HASH JOIN OUTER                |                          | 21756 |  6713K|       | 66505   (4)| 00:13:19 |
585| 575 |                                VIEW                          |                          |   931 |   143K|       | 26545   (4)| 00:05:19 |
586| 576 |                                 HASH GROUP BY                |                          |   931 |   119K|       | 26545   (4)| 00:05:19 |
587|*577 |                                  HASH JOIN                   |                          |   931 |   119K|       | 26544   (4)| 00:05:19 |
588|*578 |                                   HASH JOIN                  |                          |   928 | 78880 |       | 26492   (4)| 00:05:18 |
589|*579 |                                    TABLE ACCESS FULL         | GT_MEASURE_H             |  2510 |   139K|       | 26138   (4)| 00:05:14 |
590|*580 |                                    TABLE ACCESS FULL         | GT_POORDER_H             | 19479 |   532K|       |   353   (3)| 00:00:05 |
591| 581 |                                   TABLE ACCESS FULL          | BD_CUBASDOC              |  6366 |   285K|       |    52   (6)| 00:00:01 |
592| 582 |                                VIEW                          |                          |   148K|    22M|       | 39955   (3)| 00:08:00 |
593| 583 |                                 HASH GROUP BY                |                          |   148K|    27M|    59M| 39955   (3)| 00:08:00 |
594|*584 |                                  HASH JOIN                   |                          |   148K|    27M|       | 33542   (4)| 00:06:43 |
595|*585 |                                   TABLE ACCESS FULL          | BD_CUBASDOC              |  6365 |   285K|       |    52   (6)| 00:00:01 |
596|*586 |                                   HASH JOIN                  |                          |   148K|    21M|  2304K| 33484   (4)| 00:06:42 |
597| 587 |                                    TABLE ACCESS FULL         | BD_CUMANDOC              | 43648 |  1790K|       |   360   (7)| 00:00:05 |
598|*588 |                                    HASH JOIN                 |                          |   146K|    15M|  3824K| 32165   (4)| 00:06:26 |
599|*589 |                                     TABLE ACCESS FULL        | GT_GENERAL_H             | 68684 |  3018K|       |  1414   (3)| 00:00:17 |
600|*590 |                                     HASH JOIN RIGHT ANTI     |                          |   165K|     9M|    32M| 29964   (4)| 00:06:00 |
601|*591 |                                      TABLE ACCESS FULL       | GT_INVOICE_B             |  1152K|    19M|       | 13080   (4)| 00:02:37 |
602|*592 |                                      TABLE ACCESS FULL       | GT_GENERAL_B             |  1163K|    49M|       | 11983   (4)| 00:02:24 |
603| 593 |                               HASH GROUP BY                  |                          |   144K|    29M|    62M| 66898   (4)| 00:13:23 |
604|*594 |                                HASH JOIN RIGHT ANTI          |                          |   144K|    29M|       | 60039   (4)| 00:12:01 |
605| 595 |                                 VIEW                         | VW_SQ_10                 |   931 | 19551 |       | 26493   (4)| 00:05:18 |
606| 596 |                                  NESTED LOOPS                |                          |   931 | 91238 |       | 26493   (4)| 00:05:18 |
607|*597 |                                   HASH JOIN                  |                          |   928 | 71456 |       | 26492   (4)| 00:05:18 |
608|*598 |                                    TABLE ACCESS FULL         | GT_MEASURE_H             |  2510 |   129K|       | 26138   (4)| 00:05:14 |
609|*599 |                                    TABLE ACCESS FULL         | GT_POORDER_H             | 19479 |   456K|       |   353   (3)| 00:00:05 |
610|*600 |                                   INDEX UNIQUE SCAN          | PK_BD_CUBASDOC           |     1 |    21 |       |     1   (0)| 00:00:01 |
611|*601 |                                 HASH JOIN                    |                          |   148K|    27M|       | 33542   (4)| 00:06:43 |
612|*602 |                                  TABLE ACCESS FULL           | BD_CUBASDOC              |  6365 |   285K|       |    52   (6)| 00:00:01 |
613|*603 |                                  HASH JOIN                   |                          |   148K|    21M|  2304K| 33484   (4)| 00:06:42 |
614| 604 |                                   TABLE ACCESS FULL          | BD_CUMANDOC              | 43648 |  1790K|       |   360   (7)| 00:00:05 |
615|*605 |                                   HASH JOIN                  |                          |   146K|    15M|  3824K| 32165   (4)| 00:06:26 |
616|*606 |                                    TABLE ACCESS FULL         | GT_GENERAL_H             | 68684 |  3018K|       |  1414   (3)| 00:00:17 |
617|*607 |                                    HASH JOIN RIGHT ANTI      |                          |   165K|     9M|    32M| 29964   (4)| 00:06:00 |
618|*608 |                                     TABLE ACCESS FULL        | GT_INVOICE_B             |  1152K|    19M|       | 13080   (4)| 00:02:37 |
619|*609 |                                     TABLE ACCESS FULL        | GT_GENERAL_B             |  1163K|    49M|       | 11983   (4)| 00:02:24 |
620|*610 |                            TABLE ACCESS FULL                 | BD_CUMANDOC              | 43644 |  1875K|       |   361   (7)| 00:00:05 |
621|*611 |                          TABLE ACCESS FULL                   | GT_INVOICE_B             |  1086K|    31M|       | 13080   (4)| 00:02:37 |
622| 612 |                     HASH GROUP BY                            |                          |  1251K|   204M|   454M|  1144K  (4)| 03:48:58 |
623|*613 |                      HASH JOIN                               |                          |  1251K|   204M|       |  1097K  (4)| 03:39:28 |
624|*614 |                       TABLE ACCESS BY INDEX ROWID            | ARAP_DJZB                | 25033 |  1344K|       |  1366   (1)| 00:00:17 |
625|*615 |                        INDEX RANGE SCAN                      | I_ARAP_DJZB_004          | 24211 |       |       |    85   (2)| 00:00:02 |
626|*616 |                       HASH JOIN                              |                          |  1176K|   130M|       |  1095K  (4)| 03:39:11 |
627|*617 |                        HASH JOIN ANTI                        |                          |  6335 |   420K|       |  1064K  (4)| 03:32:56 |
628|*618 |                         TABLE ACCESS FULL                    | BD_CUBASDOC              |  6336 |   284K|       |    66  (26)| 00:00:01 |
629| 619 |                         VIEW                                 |                          |   267M|  5620M|       |  1056K  (3)| 03:31:21 |
630| 620 |                          UNION-ALL                           |                          |       |       |       |            |          |
631|*621 |                           HASH JOIN OUTER                    |                          |   262M|   121G|    55M|   616K  (3)| 02:03:20 |
632| 622 |                            VIEW                              |                          |   166K|    53M|       |   133K  (4)| 00:26:41 |
633| 623 |                             UNION-ALL                        |                          |       |       |       |            |          |
634|*624 |                              HASH JOIN OUTER                 |                          | 21756 |  6713K|       | 66505   (4)| 00:13:19 |
635| 625 |                               VIEW                           |                          |   931 |   143K|       | 26545   (4)| 00:05:19 |
636| 626 |                                HASH GROUP BY                 |                          |   931 |   119K|       | 26545   (4)| 00:05:19 |
637|*627 |                                 HASH JOIN                    |                          |   931 |   119K|       | 26544   (4)| 00:05:19 |
638|*628 |                                  HASH JOIN                   |                          |   928 | 78880 |       | 26492   (4)| 00:05:18 |
639|*629 |                                   TABLE ACCESS FULL          | GT_MEASURE_H             |  2510 |   139K|       | 26138   (4)| 00:05:14 |
640|*630 |                                   TABLE ACCESS FULL          | GT_POORDER_H             | 19479 |   532K|       |   353   (3)| 00:00:05 |
641| 631 |                                  TABLE ACCESS FULL           | BD_CUBASDOC              |  6366 |   285K|       |    52   (6)| 00:00:01 |
642| 632 |                               VIEW                           |                          |   148K|    22M|       | 39955   (3)| 00:08:00 |
643| 633 |                                HASH GROUP BY                 |                          |   148K|    27M|    59M| 39955   (3)| 00:08:00 |
644|*634 |                                 HASH JOIN                    |                          |   148K|    27M|       | 33542   (4)| 00:06:43 |
645|*635 |                                  TABLE ACCESS FULL           | BD_CUBASDOC              |  6365 |   285K|       |    52   (6)| 00:00:01 |
646|*636 |                                  HASH JOIN                   |                          |   148K|    21M|  2304K| 33484   (4)| 00:06:42 |
647| 637 |                                   TABLE ACCESS FULL          | BD_CUMANDOC              | 43648 |  1790K|       |   360   (7)| 00:00:05 |
648|*638 |                                   HASH JOIN                  |                          |   146K|    15M|  3824K| 32165   (4)| 00:06:26 |
649|*639 |                                    TABLE ACCESS FULL         | GT_GENERAL_H             | 68684 |  3018K|       |  1414   (3)| 00:00:17 |
650|*640 |                                    HASH JOIN RIGHT ANTI      |                          |   165K|     9M|    32M| 29964   (4)| 00:06:00 |
651|*641 |                                     TABLE ACCESS FULL        | GT_INVOICE_B             |  1152K|    19M|       | 13080   (4)| 00:02:37 |
652|*642 |                                     TABLE ACCESS FULL        | GT_GENERAL_B             |  1163K|    49M|       | 11983   (4)| 00:02:24 |
653| 643 |                              HASH GROUP BY                   |                          |   144K|    29M|    62M| 66898   (4)| 00:13:23 |
654|*644 |                               HASH JOIN RIGHT ANTI           |                          |   144K|    29M|       | 60039   (4)| 00:12:01 |
655| 645 |                                VIEW                          | VW_SQ_11                 |   931 | 19551 |       | 26493   (4)| 00:05:18 |
656| 646 |                                 NESTED LOOPS                 |                          |   931 | 91238 |       | 26493   (4)| 00:05:18 |
657|*647 |                                  HASH JOIN                   |                          |   928 | 71456 |       | 26492   (4)| 00:05:18 |
658|*648 |                                   TABLE ACCESS FULL          | GT_MEASURE_H             |  2510 |   129K|       | 26138   (4)| 00:05:14 |
659|*649 |                                   TABLE ACCESS FULL          | GT_POORDER_H             | 19479 |   456K|       |   353   (3)| 00:00:05 |
660|*650 |                                  INDEX UNIQUE SCAN           | PK_BD_CUBASDOC           |     1 |    21 |       |     1   (0)| 00:00:01 |
661|*651 |                                HASH JOIN                     |                          |   148K|    27M|       | 33542   (4)| 00:06:43 |
662|*652 |                                 TABLE ACCESS FULL            | BD_CUBASDOC              |  6365 |   285K|       |    52   (6)| 00:00:01 |
663|*653 |                                 HASH JOIN                    |                          |   148K|    21M|  2304K| 33484   (4)| 00:06:42 |
664| 654 |                                  TABLE ACCESS FULL           | BD_CUMANDOC              | 43648 |  1790K|       |   360   (7)| 00:00:05 |
665|*655 |                                  HASH JOIN                   |                          |   146K|    15M|  3824K| 32165   (4)| 00:06:26 |
666|*656 |                                   TABLE ACCESS FULL          | GT_GENERAL_H             | 68684 |  3018K|       |  1414   (3)| 00:00:17 |
667|*657 |                                   HASH JOIN RIGHT ANTI       |                          |   165K|     9M|    32M| 29964   (4)| 00:06:00 |
668|*658 |                                    TABLE ACCESS FULL         | GT_INVOICE_B             |  1152K|    19M|       | 13080   (4)| 00:02:37 |
669|*659 |                                    TABLE ACCESS FULL         | GT_GENERAL_B             |  1163K|    49M|       | 11983   (4)| 00:02:24 |
670| 660 |                            VIEW                              |                          |    10M|  1515M|       |   391K  (2)| 01:18:18 |
671| 661 |                             HASH GROUP BY                    |                          |    10M|  1611M|  3492M|   391K  (2)| 01:18:18 |
672|*662 |                              HASH JOIN                       |                          |    10M|  1611M|  3168K| 16451   (6)| 00:03:18 |
673|*663 |                               HASH JOIN                      |                          | 21601 |  2911K|       |   728   (6)| 00:00:09 |
674|*664 |                                TABLE ACCESS FULL             | BD_CUBASDOC              |  6365 |   285K|       |    52   (6)| 00:00:01 |
675|*665 |                                HASH JOIN                     |                          | 21605 |  1941K|       |   674   (5)| 00:00:09 |
676|*666 |                                 TABLE ACCESS FULL            | GT_INVOICE_H             | 21430 |  1004K|       |   311   (3)| 00:00:04 |
677|*667 |                                 TABLE ACCESS FULL            | BD_CUMANDOC              | 43644 |  1875K|       |   361   (7)| 00:00:05 |
678|*668 |                               TABLE ACCESS FULL              | GT_INVOICE_B             |  1086K|    31M|       | 13080   (4)| 00:02:37 |
679| 669 |                           HASH GROUP BY                      |                          |  5206K|   943M|  2981M|   440K  (3)| 01:28:02 |
680|*670 |                            HASH JOIN                         |                          |    10M|  1822M|  3632K|   149K  (4)| 00:29:59 |
681|*671 |                             HASH JOIN                        |                          | 21598 |  3374K|       |   134K  (4)| 00:26:50 |
682|*672 |                              TABLE ACCESS FULL               | GT_INVOICE_H             | 21430 |  1004K|       |   311   (3)| 00:00:04 |
683|*673 |                              HASH JOIN                       |                          | 43630 |  4772K|       |   133K  (4)| 00:26:46 |
684|*674 |                               HASH JOIN ANTI                 |                          |  6364 |   422K|       |   133K  (4)| 00:26:42 |
685|*675 |                                TABLE ACCESS FULL             | BD_CUBASDOC              |  6365 |   285K|       |    52   (6)| 00:00:01 |
686| 676 |                                VIEW                          |                          |   166K|  3571K|       |   133K  (4)| 00:26:41 |
687| 677 |                                 UNION-ALL                    |                          |       |       |       |            |          |
688|*678 |                                  HASH JOIN OUTER             |                          | 21756 |  6713K|       | 66505   (4)| 00:13:19 |
689| 679 |                                   VIEW                       |                          |   931 |   143K|       | 26545   (4)| 00:05:19 |
690| 680 |                                    HASH GROUP BY             |                          |   931 |   119K|       | 26545   (4)| 00:05:19 |
691|*681 |                                     HASH JOIN                |                          |   931 |   119K|       | 26544   (4)| 00:05:19 |
692|*682 |                                      HASH JOIN               |                          |   928 | 78880 |       | 26492   (4)| 00:05:18 |
693|*683 |                                       TABLE ACCESS FULL      | GT_MEASURE_H             |  2510 |   139K|       | 26138   (4)| 00:05:14 |
694|*684 |                                       TABLE ACCESS FULL      | GT_POORDER_H             | 19479 |   532K|       |   353   (3)| 00:00:05 |
695| 685 |                                      TABLE ACCESS FULL       | BD_CUBASDOC              |  6366 |   285K|       |    52   (6)| 00:00:01 |
696| 686 |                                   VIEW                       |                          |   148K|    22M|       | 39955   (3)| 00:08:00 |
697| 687 |                                    HASH GROUP BY             |                          |   148K|    27M|    59M| 39955   (3)| 00:08:00 |
698|*688 |                                     HASH JOIN                |                          |   148K|    27M|       | 33542   (4)| 00:06:43 |
699|*689 |                                      TABLE ACCESS FULL       | BD_CUBASDOC              |  6365 |   285K|       |    52   (6)| 00:00:01 |
700|*690 |                                      HASH JOIN               |                          |   148K|    21M|  2304K| 33484   (4)| 00:06:42 |
701| 691 |                                       TABLE ACCESS FULL      | BD_CUMANDOC              | 43648 |  1790K|       |   360   (7)| 00:00:05 |
702|*692 |                                       HASH JOIN              |                          |   146K|    15M|  3824K| 32165   (4)| 00:06:26 |
703|*693 |                                        TABLE ACCESS FULL     | GT_GENERAL_H             | 68684 |  3018K|       |  1414   (3)| 00:00:17 |
704|*694 |                                        HASH JOIN RIGHT ANTI  |                          |   165K|     9M|    32M| 29964   (4)| 00:06:00 |
705|*695 |                                         TABLE ACCESS FULL    | GT_INVOICE_B             |  1152K|    19M|       | 13080   (4)| 00:02:37 |
706|*696 |                                         TABLE ACCESS FULL    | GT_GENERAL_B             |  1163K|    49M|       | 11983   (4)| 00:02:24 |
707| 697 |                                  HASH GROUP BY               |                          |   144K|    29M|    62M| 66898   (4)| 00:13:23 |
708|*698 |                                   HASH JOIN RIGHT ANTI       |                          |   144K|    29M|       | 60039   (4)| 00:12:01 |
709| 699 |                                    VIEW                      | VW_SQ_12                 |   931 | 19551 |       | 26493   (4)| 00:05:18 |
710| 700 |                                     NESTED LOOPS             |                          |   931 | 91238 |       | 26493   (4)| 00:05:18 |
711|*701 |                                      HASH JOIN               |                          |   928 | 71456 |       | 26492   (4)| 00:05:18 |
712|*702 |                                       TABLE ACCESS FULL      | GT_MEASURE_H             |  2510 |   129K|       | 26138   (4)| 00:05:14 |
713|*703 |                                       TABLE ACCESS FULL      | GT_POORDER_H             | 19479 |   456K|       |   353   (3)| 00:00:05 |
714|*704 |                                      INDEX UNIQUE SCAN       | PK_BD_CUBASDOC           |     1 |    21 |       |     1   (0)| 00:00:01 |
715|*705 |                                    HASH JOIN                 |                          |   148K|    27M|       | 33542   (4)| 00:06:43 |
716|*706 |                                     TABLE ACCESS FULL        | BD_CUBASDOC              |  6365 |   285K|       |    52   (6)| 00:00:01 |
717|*707 |                                     HASH JOIN                |                          |   148K|    21M|  2304K| 33484   (4)| 00:06:42 |
718| 708 |                                      TABLE ACCESS FULL       | BD_CUMANDOC              | 43648 |  1790K|       |   360   (7)| 00:00:05 |
719|*709 |                                      HASH JOIN               |                          |   146K|    15M|  3824K| 32165   (4)| 00:06:26 |
720|*710 |                                       TABLE ACCESS FULL      | GT_GENERAL_H             | 68684 |  3018K|       |  1414   (3)| 00:00:17 |
721|*711 |                                       HASH JOIN RIGHT ANTI   |                          |   165K|     9M|    32M| 29964   (4)| 00:06:00 |
722|*712 |                                        TABLE ACCESS FULL     | GT_INVOICE_B             |  1152K|    19M|       | 13080   (4)| 00:02:37 |
723|*713 |                                        TABLE ACCESS FULL     | GT_GENERAL_B             |  1163K|    49M|       | 11983   (4)| 00:02:24 |
724|*714 |                               TABLE ACCESS FULL              | BD_CUMANDOC              | 43644 |  1875K|       |   361   (7)| 00:00:05 |
725|*715 |                             TABLE ACCESS FULL                | GT_INVOICE_B             |  1086K|    31M|       | 13080   (4)| 00:02:37 |
726|*716 |                        TABLE ACCESS FULL                     | ARAP_DJFB                |  1178K|    53M|       | 31199   (4)| 00:06:15 |
727| 717 |                  HASH GROUP BY                               |                          |  1221 |   251K|       |    11M (27)| 39:30:43 |
728|*718 |                   HASH JOIN                                  |                          |  1221 |   251K|       |    11M (27)| 39:30:43 |
729|*719 |                    TABLE ACCESS BY INDEX ROWID               | PO_INVOICE_B             |    10 |   460 |       |     2   (0)| 00:00:01 |
730| 720 |                     NESTED LOOPS                             |                          |  1221 |   226K|       |    11M (27)| 39:30:40 |
731|*721 |                      HASH JOIN ANTI                          |                          |   127 | 18288 |       |    11M (27)| 39:30:37 |
732| 722 |                       NESTED LOOPS                           |                          |   127 | 15494 |       |   271   (3)| 00:00:04 |
733|*723 |                        TABLE ACCESS FULL                     | PO_INVOICE               |   127 | 10668 |       |   220   (3)| 00:00:03 |
734| 724 |                        TABLE ACCESS BY INDEX ROWID           | BD_CUBASDOC              |     1 |    38 |       |     1   (0)| 00:00:01 |
735|*725 |                         INDEX UNIQUE SCAN                    | PK_BD_CUBASDOC           |     1 |       |       |     1   (0)| 00:00:01 |
736| 726 |                       VIEW                                   |                          |    52G|  1079G|       |    10M (16)| 34:23:30 |
737| 727 |                        UNION-ALL                             |                          |       |       |       |            |          |
738|*728 |                         HASH JOIN RIGHT OUTER                |                          |    52G|    31T|   202M|  9172K (18)| 30:34:32 |
739| 729 |                          VIEW                                |                          |  1251K|   188M|       | 74342   (3)| 00:14:53 |
740| 730 |                           HASH GROUP BY                      |                          |  1251K|   177M|   407M| 74342   (3)| 00:14:53 |
741|*731 |                            HASH JOIN                         |                          |  1251K|   177M|       | 32704   (4)| 00:06:33 |
742|*732 |                             TABLE ACCESS BY INDEX ROWID      | ARAP_DJZB                | 25033 |  1344K|       |  1366   (1)| 00:00:17 |
743|*733 |                              INDEX RANGE SCAN                | I_ARAP_DJZB_004          | 24211 |       |       |    85   (2)| 00:00:02 |
744|*734 |                             HASH JOIN                        |                          |  1176K|   105M|       | 31300   (4)| 00:06:16 |
745|*735 |                              TABLE ACCESS FULL               | BD_CUBASDOC              |  6336 |   284K|       |    66  (26)| 00:00:01 |
746|*736 |                              TABLE ACCESS FULL               | ARAP_DJFB                |  1178K|    53M|       | 31199   (4)| 00:06:15 |
747| 737 |                          VIEW                                |                          |   267M|   124G|       |  1056K  (3)| 03:31:21 |
748| 738 |                           UNION-ALL                          |                          |       |       |       |            |          |
749|*739 |                            HASH JOIN OUTER                   |                          |   262M|   121G|    55M|   616K  (3)| 02:03:20 |
750| 740 |                             VIEW                             |                          |   166K|    53M|       |   133K  (4)| 00:26:41 |
751| 741 |                              UNION-ALL                       |                          |       |       |       |            |          |
752|*742 |                               HASH JOIN OUTER                |                          | 21756 |  6713K|       | 66505   (4)| 00:13:19 |
753| 743 |                                VIEW                          |                          |   931 |   143K|       | 26545   (4)| 00:05:19 |
754| 744 |                                 HASH GROUP BY                |                          |   931 |   119K|       | 26545   (4)| 00:05:19 |
755|*745 |                                  HASH JOIN                   |                          |   931 |   119K|       | 26544   (4)| 00:05:19 |
756|*746 |                                   HASH JOIN                  |                          |   928 | 78880 |       | 26492   (4)| 00:05:18 |
757|*747 |                                    TABLE ACCESS FULL         | GT_MEASURE_H             |  2510 |   139K|       | 26138   (4)| 00:05:14 |
758|*748 |                                    TABLE ACCESS FULL         | GT_POORDER_H             | 19479 |   532K|       |   353   (3)| 00:00:05 |
759| 749 |                                   TABLE ACCESS FULL          | BD_CUBASDOC              |  6366 |   285K|       |    52   (6)| 00:00:01 |
760| 750 |                                VIEW                          |                          |   148K|    22M|       | 39955   (3)| 00:08:00 |
761| 751 |                                 HASH GROUP BY                |                          |   148K|    27M|    59M| 39955   (3)| 00:08:00 |
762|*752 |                                  HASH JOIN                   |                          |   148K|    27M|       | 33542   (4)| 00:06:43 |
763|*753 |                                   TABLE ACCESS FULL          | BD_CUBASDOC              |  6365 |   285K|       |    52   (6)| 00:00:01 |
764|*754 |                                   HASH JOIN                  |                          |   148K|    21M|  2304K| 33484   (4)| 00:06:42 |
765| 755 |                                    TABLE ACCESS FULL         | BD_CUMANDOC              | 43648 |  1790K|       |   360   (7)| 00:00:05 |
766|*756 |                                    HASH JOIN                 |                          |   146K|    15M|  3824K| 32165   (4)| 00:06:26 |
767|*757 |                                     TABLE ACCESS FULL        | GT_GENERAL_H             | 68684 |  3018K|       |  1414   (3)| 00:00:17 |
768|*758 |                                     HASH JOIN RIGHT ANTI     |                          |   165K|     9M|    32M| 29964   (4)| 00:06:00 |
769|*759 |                                      TABLE ACCESS FULL       | GT_INVOICE_B             |  1152K|    19M|       | 13080   (4)| 00:02:37 |
770|*760 |                                      TABLE ACCESS FULL       | GT_GENERAL_B             |  1163K|    49M|       | 11983   (4)| 00:02:24 |
771| 761 |                               HASH GROUP BY                  |                          |   144K|    29M|    62M| 66898   (4)| 00:13:23 |
772|*762 |                                HASH JOIN RIGHT ANTI          |                          |   144K|    29M|       | 60039   (4)| 00:12:01 |
773| 763 |                                 VIEW                         | VW_SQ_13                 |   931 | 19551 |       | 26493   (4)| 00:05:18 |
774| 764 |                                  NESTED LOOPS                |                          |   931 | 91238 |       | 26493   (4)| 00:05:18 |
775|*765 |                                   HASH JOIN                  |                          |   928 | 71456 |       | 26492   (4)| 00:05:18 |
776|*766 |                                    TABLE ACCESS FULL         | GT_MEASURE_H             |  2510 |   129K|       | 26138   (4)| 00:05:14 |
777|*767 |                                    TABLE ACCESS FULL         | GT_POORDER_H             | 19479 |   456K|       |   353   (3)| 00:00:05 |
778|*768 |                                   INDEX UNIQUE SCAN          | PK_BD_CUBASDOC           |     1 |    21 |       |     1   (0)| 00:00:01 |
779|*769 |                                 HASH JOIN                    |                          |   148K|    27M|       | 33542   (4)| 00:06:43 |
780|*770 |                                  TABLE ACCESS FULL           | BD_CUBASDOC              |  6365 |   285K|       |    52   (6)| 00:00:01 |
781|*771 |                                  HASH JOIN                   |                          |   148K|    21M|  2304K| 33484   (4)| 00:06:42 |
782| 772 |                                   TABLE ACCESS FULL          | BD_CUMANDOC              | 43648 |  1790K|       |   360   (7)| 00:00:05 |
783|*773 |                                   HASH JOIN                  |                          |   146K|    15M|  3824K| 32165   (4)| 00:06:26 |
784|*774 |                                    TABLE ACCESS FULL         | GT_GENERAL_H             | 68684 |  3018K|       |  1414   (3)| 00:00:17 |
785|*775 |                                    HASH JOIN RIGHT ANTI      |                          |   165K|     9M|    32M| 29964   (4)| 00:06:00 |
786|*776 |                                     TABLE ACCESS FULL        | GT_INVOICE_B             |  1152K|    19M|       | 13080   (4)| 00:02:37 |
787|*777 |                                     TABLE ACCESS FULL        | GT_GENERAL_B             |  1163K|    49M|       | 11983   (4)| 00:02:24 |
788| 778 |                             VIEW                             |                          |    10M|  1515M|       |   391K  (2)| 01:18:18 |
789| 779 |                              HASH GROUP BY                   |                          |    10M|  1611M|  3492M|   391K  (2)| 01:18:18 |
790|*780 |                               HASH JOIN                      |                          |    10M|  1611M|  3168K| 16451   (6)| 00:03:18 |
791|*781 |                                HASH JOIN                     |                          | 21601 |  2911K|       |   728   (6)| 00:00:09 |
792|*782 |                                 TABLE ACCESS FULL            | BD_CUBASDOC              |  6365 |   285K|       |    52   (6)| 00:00:01 |
793|*783 |                                 HASH JOIN                    |                          | 21605 |  1941K|       |   674   (5)| 00:00:09 |
794|*784 |                                  TABLE ACCESS FULL           | GT_INVOICE_H             | 21430 |  1004K|       |   311   (3)| 00:00:04 |
795|*785 |                                  TABLE ACCESS FULL           | BD_CUMANDOC              | 43644 |  1875K|       |   361   (7)| 00:00:05 |
796|*786 |                                TABLE ACCESS FULL             | GT_INVOICE_B             |  1086K|    31M|       | 13080   (4)| 00:02:37 |
797| 787 |                            HASH GROUP BY                     |                          |  5206K|   943M|  2981M|   440K  (3)| 01:28:02 |
798|*788 |                             HASH JOIN                        |                          |    10M|  1822M|  3632K|   149K  (4)| 00:29:59 |
799|*789 |                              HASH JOIN                       |                          | 21598 |  3374K|       |   134K  (4)| 00:26:50 |
800|*790 |                               TABLE ACCESS FULL              | GT_INVOICE_H             | 21430 |  1004K|       |   311   (3)| 00:00:04 |
801|*791 |                               HASH JOIN                      |                          | 43630 |  4772K|       |   133K  (4)| 00:26:46 |
802|*792 |                                HASH JOIN ANTI                |                          |  6364 |   422K|       |   133K  (4)| 00:26:42 |
803|*793 |                                 TABLE ACCESS FULL            | BD_CUBASDOC              |  6365 |   285K|       |    52   (6)| 00:00:01 |
804| 794 |                                 VIEW                         |                          |   166K|  3571K|       |   133K  (4)| 00:26:41 |
805| 795 |                                  UNION-ALL                   |                          |       |       |       |            |          |
806|*796 |                                   HASH JOIN OUTER            |                          | 21756 |  6713K|       | 66505   (4)| 00:13:19 |
807| 797 |                                    VIEW                      |                          |   931 |   143K|       | 26545   (4)| 00:05:19 |
808| 798 |                                     HASH GROUP BY            |                          |   931 |   119K|       | 26545   (4)| 00:05:19 |
809|*799 |                                      HASH JOIN               |                          |   931 |   119K|       | 26544   (4)| 00:05:19 |
810|*800 |                                       HASH JOIN              |                          |   928 | 78880 |       | 26492   (4)| 00:05:18 |
811|*801 |                                        TABLE ACCESS FULL     | GT_MEASURE_H             |  2510 |   139K|       | 26138   (4)| 00:05:14 |
812|*802 |                                        TABLE ACCESS FULL     | GT_POORDER_H             | 19479 |   532K|       |   353   (3)| 00:00:05 |
813| 803 |                                       TABLE ACCESS FULL      | BD_CUBASDOC              |  6366 |   285K|       |    52   (6)| 00:00:01 |
814| 804 |                                    VIEW                      |                          |   148K|    22M|       | 39955   (3)| 00:08:00 |
815| 805 |                                     HASH GROUP BY            |                          |   148K|    27M|    59M| 39955   (3)| 00:08:00 |
816|*806 |                                      HASH JOIN               |                          |   148K|    27M|       | 33542   (4)| 00:06:43 |
817|*807 |                                       TABLE ACCESS FULL      | BD_CUBASDOC              |  6365 |   285K|       |    52   (6)| 00:00:01 |
818|*808 |                                       HASH JOIN              |                          |   148K|    21M|  2304K| 33484   (4)| 00:06:42 |
819| 809 |                                        TABLE ACCESS FULL     | BD_CUMANDOC              | 43648 |  1790K|       |   360   (7)| 00:00:05 |
820|*810 |                                        HASH JOIN             |                          |   146K|    15M|  3824K| 32165   (4)| 00:06:26 |
821|*811 |                                         TABLE ACCESS FULL    | GT_GENERAL_H             | 68684 |  3018K|       |  1414   (3)| 00:00:17 |
822|*812 |                                         HASH JOIN RIGHT ANTI |                          |   165K|     9M|    32M| 29964   (4)| 00:06:00 |
823|*813 |                                          TABLE ACCESS FULL   | GT_INVOICE_B             |  1152K|    19M|       | 13080   (4)| 00:02:37 |
824|*814 |                                          TABLE ACCESS FULL   | GT_GENERAL_B             |  1163K|    49M|       | 11983   (4)| 00:02:24 |
825| 815 |                                   HASH GROUP BY              |                          |   144K|    29M|    62M| 66898   (4)| 00:13:23 |
826|*816 |                                    HASH JOIN RIGHT ANTI      |                          |   144K|    29M|       | 60039   (4)| 00:12:01 |
827| 817 |                                     VIEW                     | VW_SQ_14                 |   931 | 19551 |       | 26493   (4)| 00:05:18 |
828| 818 |                                      NESTED LOOPS            |                          |   931 | 91238 |       | 26493   (4)| 00:05:18 |
829|*819 |                                       HASH JOIN              |                          |   928 | 71456 |       | 26492   (4)| 00:05:18 |
830|*820 |                                        TABLE ACCESS FULL     | GT_MEASURE_H             |  2510 |   129K|       | 26138   (4)| 00:05:14 |
831|*821 |                                        TABLE ACCESS FULL     | GT_POORDER_H             | 19479 |   456K|       |   353   (3)| 00:00:05 |
832|*822 |                                       INDEX UNIQUE SCAN      | PK_BD_CUBASDOC           |     1 |    21 |       |     1   (0)| 00:00:01 |
833|*823 |                                     HASH JOIN                |                          |   148K|    27M|       | 33542   (4)| 00:06:43 |
834|*824 |                                      TABLE ACCESS FULL       | BD_CUBASDOC              |  6365 |   285K|       |    52   (6)| 00:00:01 |
835|*825 |                                      HASH JOIN               |                          |   148K|    21M|  2304K| 33484   (4)| 00:06:42 |
836| 826 |                                       TABLE ACCESS FULL      | BD_CUMANDOC              | 43648 |  1790K|       |   360   (7)| 00:00:05 |
837|*827 |                                       HASH JOIN              |                          |   146K|    15M|  3824K| 32165   (4)| 00:06:26 |
838|*828 |                                        TABLE ACCESS FULL     | GT_GENERAL_H             | 68684 |  3018K|       |  1414   (3)| 00:00:17 |
839|*829 |                                        HASH JOIN RIGHT ANTI  |                          |   165K|     9M|    32M| 29964   (4)| 00:06:00 |
840|*830 |                                         TABLE ACCESS FULL    | GT_INVOICE_B             |  1152K|    19M|       | 13080   (4)| 00:02:37 |
841|*831 |                                         TABLE ACCESS FULL    | GT_GENERAL_B             |  1163K|    49M|       | 11983   (4)| 00:02:24 |
842|*832 |                                TABLE ACCESS FULL             | BD_CUMANDOC              | 43644 |  1875K|       |   361   (7)| 00:00:05 |
843|*833 |                              TABLE ACCESS FULL               | GT_INVOICE_B             |  1086K|    31M|       | 13080   (4)| 00:02:37 |
844| 834 |                         HASH GROUP BY                        |                          |  1251K|   204M|   454M|  1144K  (4)| 03:48:58 |
845|*835 |                          HASH JOIN                           |                          |  1251K|   204M|       |  1097K  (4)| 03:39:28 |
846|*836 |                           TABLE ACCESS BY INDEX ROWID        | ARAP_DJZB                | 25033 |  1344K|       |  1366   (1)| 00:00:17 |
847|*837 |                            INDEX RANGE SCAN                  | I_ARAP_DJZB_004          | 24211 |       |       |    85   (2)| 00:00:02 |
848|*838 |                           HASH JOIN                          |                          |  1176K|   130M|       |  1095K  (4)| 03:39:11 |
849|*839 |                            HASH JOIN ANTI                    |                          |  6335 |   420K|       |  1064K  (4)| 03:32:56 |
850|*840 |                             TABLE ACCESS FULL                | BD_CUBASDOC              |  6336 |   284K|       |    66  (26)| 00:00:01 |
851| 841 |                             VIEW                             |                          |   267M|  5620M|       |  1056K  (3)| 03:31:21 |
852| 842 |                              UNION-ALL                       |                          |       |       |       |            |          |
853|*843 |                               HASH JOIN OUTER                |                          |   262M|   121G|    55M|   616K  (3)| 02:03:20 |
854| 844 |                                VIEW                          |                          |   166K|    53M|       |   133K  (4)| 00:26:41 |
855| 845 |                                 UNION-ALL                    |                          |       |       |       |            |          |
856|*846 |                                  HASH JOIN OUTER             |                          | 21756 |  6713K|       | 66505   (4)| 00:13:19 |
857| 847 |                                   VIEW                       |                          |   931 |   143K|       | 26545   (4)| 00:05:19 |
858| 848 |                                    HASH GROUP BY             |                          |   931 |   119K|       | 26545   (4)| 00:05:19 |
859|*849 |                                     HASH JOIN                |                          |   931 |   119K|       | 26544   (4)| 00:05:19 |
860|*850 |                                      HASH JOIN               |                          |   928 | 78880 |       | 26492   (4)| 00:05:18 |
861|*851 |                                       TABLE ACCESS FULL      | GT_MEASURE_H             |  2510 |   139K|       | 26138   (4)| 00:05:14 |
862|*852 |                                       TABLE ACCESS FULL      | GT_POORDER_H             | 19479 |   532K|       |   353   (3)| 00:00:05 |
863| 853 |                                      TABLE ACCESS FULL       | BD_CUBASDOC              |  6366 |   285K|       |    52   (6)| 00:00:01 |
864| 854 |                                   VIEW                       |                          |   148K|    22M|       | 39955   (3)| 00:08:00 |
865| 855 |                                    HASH GROUP BY             |                          |   148K|    27M|    59M| 39955   (3)| 00:08:00 |
866|*856 |                                     HASH JOIN                |                          |   148K|    27M|       | 33542   (4)| 00:06:43 |
867|*857 |                                      TABLE ACCESS FULL       | BD_CUBASDOC              |  6365 |   285K|       |    52   (6)| 00:00:01 |
868|*858 |                                      HASH JOIN               |                          |   148K|    21M|  2304K| 33484   (4)| 00:06:42 |
869| 859 |                                       TABLE ACCESS FULL      | BD_CUMANDOC              | 43648 |  1790K|       |   360   (7)| 00:00:05 |
870|*860 |                                       HASH JOIN              |                          |   146K|    15M|  3824K| 32165   (4)| 00:06:26 |
871|*861 |                                        TABLE ACCESS FULL     | GT_GENERAL_H             | 68684 |  3018K|       |  1414   (3)| 00:00:17 |
872|*862 |                                        HASH JOIN RIGHT ANTI  |                          |   165K|     9M|    32M| 29964   (4)| 00:06:00 |
873|*863 |                                         TABLE ACCESS FULL    | GT_INVOICE_B             |  1152K|    19M|       | 13080   (4)| 00:02:37 |
874|*864 |                                         TABLE ACCESS FULL    | GT_GENERAL_B             |  1163K|    49M|       | 11983   (4)| 00:02:24 |
875| 865 |                                  HASH GROUP BY               |                          |   144K|    29M|    62M| 66898   (4)| 00:13:23 |
876|*866 |                                   HASH JOIN RIGHT ANTI       |                          |   144K|    29M|       | 60039   (4)| 00:12:01 |
877| 867 |                                    VIEW                      | VW_SQ_15                 |   931 | 19551 |       | 26493   (4)| 00:05:18 |
878| 868 |                                     NESTED LOOPS             |                          |   931 | 91238 |       | 26493   (4)| 00:05:18 |
879|*869 |                                      HASH JOIN               |                          |   928 | 71456 |       | 26492   (4)| 00:05:18 |
880|*870 |                                       TABLE ACCESS FULL      | GT_MEASURE_H             |  2510 |   129K|       | 26138   (4)| 00:05:14 |
881|*871 |                                       TABLE ACCESS FULL      | GT_POORDER_H             | 19479 |   456K|       |   353   (3)| 00:00:05 |
882|*872 |                                      INDEX UNIQUE SCAN       | PK_BD_CUBASDOC           |     1 |    21 |       |     1   (0)| 00:00:01 |
883|*873 |                                    HASH JOIN                 |                          |   148K|    27M|       | 33542   (4)| 00:06:43 |
884|*874 |                                     TABLE ACCESS FULL        | BD_CUBASDOC              |  6365 |   285K|       |    52   (6)| 00:00:01 |
885|*875 |                                     HASH JOIN                |                          |   148K|    21M|  2304K| 33484   (4)| 00:06:42 |
886| 876 |                                      TABLE ACCESS FULL       | BD_CUMANDOC              | 43648 |  1790K|       |   360   (7)| 00:00:05 |
887|*877 |                                      HASH JOIN               |                          |   146K|    15M|  3824K| 32165   (4)| 00:06:26 |
888|*878 |                                       TABLE ACCESS FULL      | GT_GENERAL_H             | 68684 |  3018K|       |  1414   (3)| 00:00:17 |
889|*879 |                                       HASH JOIN RIGHT ANTI   |                          |   165K|     9M|    32M| 29964   (4)| 00:06:00 |
890|*880 |                                        TABLE ACCESS FULL     | GT_INVOICE_B             |  1152K|    19M|       | 13080   (4)| 00:02:37 |
891|*881 |                                        TABLE ACCESS FULL     | GT_GENERAL_B             |  1163K|    49M|       | 11983   (4)| 00:02:24 |
892| 882 |                                VIEW                          |                          |    10M|  1515M|       |   391K  (2)| 01:18:18 |
893| 883 |                                 HASH GROUP BY                |                          |    10M|  1611M|  3492M|   391K  (2)| 01:18:18 |
894|*884 |                                  HASH JOIN                   |                          |    10M|  1611M|  3168K| 16451   (6)| 00:03:18 |
895|*885 |                                   HASH JOIN                  |                          | 21601 |  2911K|       |   728   (6)| 00:00:09 |
896|*886 |                                    TABLE ACCESS FULL         | BD_CUBASDOC              |  6365 |   285K|       |    52   (6)| 00:00:01 |
897|*887 |                                    HASH JOIN                 |                          | 21605 |  1941K|       |   674   (5)| 00:00:09 |
898|*888 |                                     TABLE ACCESS FULL        | GT_INVOICE_H             | 21430 |  1004K|       |   311   (3)| 00:00:04 |
899|*889 |                                     TABLE ACCESS FULL        | BD_CUMANDOC              | 43644 |  1875K|       |   361   (7)| 00:00:05 |
900|*890 |                                   TABLE ACCESS FULL          | GT_INVOICE_B             |  1086K|    31M|       | 13080   (4)| 00:02:37 |
901| 891 |                               HASH GROUP BY                  |                          |  5206K|   943M|  2981M|   440K  (3)| 01:28:02 |
902|*892 |                                HASH JOIN                     |                          |    10M|  1822M|  3632K|   149K  (4)| 00:29:59 |
903|*893 |                                 HASH JOIN                    |                          | 21598 |  3374K|       |   134K  (4)| 00:26:50 |
904|*894 |                                  TABLE ACCESS FULL           | GT_INVOICE_H             | 21430 |  1004K|       |   311   (3)| 00:00:04 |
905|*895 |                                  HASH JOIN                   |                          | 43630 |  4772K|       |   133K  (4)| 00:26:46 |
906|*896 |                                   HASH JOIN ANTI             |                          |  6364 |   422K|       |   133K  (4)| 00:26:42 |
907|*897 |                                    TABLE ACCESS FULL         | BD_CUBASDOC              |  6365 |   285K|       |    52   (6)| 00:00:01 |
908| 898 |                                    VIEW                      |                          |   166K|  3571K|       |   133K  (4)| 00:26:41 |
909| 899 |                                     UNION-ALL                |                          |       |       |       |            |          |
910|*900 |                                      HASH JOIN OUTER         |                          | 21756 |  6713K|       | 66505   (4)| 00:13:19 |
911| 901 |                                       VIEW                   |                          |   931 |   143K|       | 26545   (4)| 00:05:19 |
912| 902 |                                        HASH GROUP BY         |                          |   931 |   119K|       | 26545   (4)| 00:05:19 |
913|*903 |                                         HASH JOIN            |                          |   931 |   119K|       | 26544   (4)| 00:05:19 |
914|*904 |                                          HASH JOIN           |                          |   928 | 78880 |       | 26492   (4)| 00:05:18 |
915|*905 |                                           TABLE ACCESS FULL  | GT_MEASURE_H             |  2510 |   139K|       | 26138   (4)| 00:05:14 |
916|*906 |                                           TABLE ACCESS FULL  | GT_POORDER_H             | 19479 |   532K|       |   353   (3)| 00:00:05 |
917| 907 |                                          TABLE ACCESS FULL   | BD_CUBASDOC              |  6366 |   285K|       |    52   (6)| 00:00:01 |
918| 908 |                                       VIEW                   |                          |   148K|    22M|       | 39955   (3)| 00:08:00 |
919| 909 |                                        HASH GROUP BY         |                          |   148K|    27M|    59M| 39955   (3)| 00:08:00 |
920|*910 |                                         HASH JOIN            |                          |   148K|    27M|       | 33542   (4)| 00:06:43 |
921|*911 |                                          TABLE ACCESS FULL   | BD_CUBASDOC              |  6365 |   285K|       |    52   (6)| 00:00:01 |
922|*912 |                                          HASH JOIN           |                          |   148K|    21M|  2304K| 33484   (4)| 00:06:42 |
923| 913 |                                           TABLE ACCESS FULL  | BD_CUMANDOC              | 43648 |  1790K|       |   360   (7)| 00:00:05 |
924|*914 |                                           HASH JOIN          |                          |   146K|    15M|  3824K| 32165   (4)| 00:06:26 |
925|*915 |                                            TABLE ACCESS FULL | GT_GENERAL_H             | 68684 |  3018K|       |  1414   (3)| 00:00:17 |
926|*916 | NTI                                        HASH JOIN RIGHT A |                          |   165K|     9M|    32M| 29964   (4)| 00:06:00 |
927|*917 | L                                           TABLE ACCESS FUL | GT_INVOICE_B             |  1152K|    19M|       | 13080   (4)| 00:02:37 |
928|*918 | L                                           TABLE ACCESS FUL | GT_GENERAL_B             |  1163K|    49M|       | 11983   (4)| 00:02:24 |
929| 919 |                                      HASH GROUP BY           |                          |   144K|    29M|    62M| 66898   (4)| 00:13:23 |
930|*920 |                                       HASH JOIN RIGHT ANTI   |                          |   144K|    29M|       | 60039   (4)| 00:12:01 |
931| 921 |                                        VIEW                  | VW_SQ_16                 |   931 | 19551 |       | 26493   (4)| 00:05:18 |
932| 922 |                                         NESTED LOOPS         |                          |   931 | 91238 |       | 26493   (4)| 00:05:18 |
933|*923 |                                          HASH JOIN           |                          |   928 | 71456 |       | 26492   (4)| 00:05:18 |
934|*924 |                                           TABLE ACCESS FULL  | GT_MEASURE_H             |  2510 |   129K|       | 26138   (4)| 00:05:14 |
935|*925 |                                           TABLE ACCESS FULL  | GT_POORDER_H             | 19479 |   456K|       |   353   (3)| 00:00:05 |
936|*926 |                                          INDEX UNIQUE SCAN   | PK_BD_CUBASDOC           |     1 |    21 |       |     1   (0)| 00:00:01 |
937|*927 |                                        HASH JOIN             |                          |   148K|    27M|       | 33542   (4)| 00:06:43 |
938|*928 |                                         TABLE ACCESS FULL    | BD_CUBASDOC              |  6365 |   285K|       |    52   (6)| 00:00:01 |
939|*929 |                                         HASH JOIN            |                          |   148K|    21M|  2304K| 33484   (4)| 00:06:42 |
940| 930 |                                          TABLE ACCESS FULL   | BD_CUMANDOC              | 43648 |  1790K|       |   360   (7)| 00:00:05 |
941|*931 |                                          HASH JOIN           |                          |   146K|    15M|  3824K| 32165   (4)| 00:06:26 |
942|*932 |                                           TABLE ACCESS FULL  | GT_GENERAL_H             | 68684 |  3018K|       |  1414   (3)| 00:00:17 |
943|*933 | TI                                        HASH JOIN RIGHT AN |                          |   165K|     9M|    32M| 29964   (4)| 00:06:00 |
944|*934 |                                            TABLE ACCESS FULL | GT_INVOICE_B             |  1152K|    19M|       | 13080   (4)| 00:02:37 |
945|*935 |                                            TABLE ACCESS FULL | GT_GENERAL_B             |  1163K|    49M|       | 11983   (4)| 00:02:24 |
946|*936 |                                   TABLE ACCESS FULL          | BD_CUMANDOC              | 43644 |  1875K|       |   361   (7)| 00:00:05 |
947|*937 |                                 TABLE ACCESS FULL            | GT_INVOICE_B             |  1086K|    31M|       | 13080   (4)| 00:02:37 |
948|*938 |                            TABLE ACCESS FULL                 | ARAP_DJFB                |  1178K|    53M|       | 31199   (4)| 00:06:15 |
949|*939 |                      INDEX RANGE SCAN                        | I_PO_INVOICE_B_5         |    14 |       |       |     1   (0)| 00:00:01 |
950| 940 |                    INDEX FAST FULL SCAN                      | PK_PO_ORDER_B            |   227K|  4673K|       |   287   (4)| 00:00:04 |
951| 941 |           HASH GROUP BY                                      |                          |  1221 |   251K|       |    52M (34)|173:33:36 |
952| 942 |            NESTED LOOPS                                      |                          |  1221 |   251K|       |    52M (34)|173:33:36 |
953| 943 |             NESTED LOOPS                                     |                          |  1221 |   221K|       |    52M (34)|173:33:24 |
954|*944 |              HASH JOIN ANTI                                  |                          |   127 | 17907 |       |    52M (34)|173:33:22 |
955| 945 |               NESTED LOOPS                                   |                          |   127 | 15113 |       |   271   (3)| 00:00:04 |
956|*946 |                TABLE ACCESS FULL                             | PO_INVOICE               |   127 | 10287 |       |   220   (3)| 00:00:03 |
957| 947 |                TABLE ACCESS BY INDEX ROWID                   | BD_CUBASDOC              |     1 |    38 |       |     1   (0)| 00:00:01 |
958|*948 |                 INDEX UNIQUE SCAN                            | PK_BD_CUBASDOC           |     1 |       |       |     1   (0)| 00:00:01 |
959| 949 |               VIEW                                           |                          |    53G|  1095G|       |    50M (32)|168:21:38 |
960| 950 |                UNION-ALL                                     |                          |       |       |       |            |          |
961|*951 |                 HASH JOIN RIGHT OUTER                        |                          |    53G|    52T|       |    25M (32)| 84:13:07 |
962| 952 |                  VIEW                                        |                          |   203 | 58058 |       |     9  (12)| 00:00:01 |
963| 953 |                   HASH GROUP BY                              |                          |   203 | 10759 |       |     9  (12)| 00:00:01 |
964|*954 |                    TABLE ACCESS FULL                         | GT_QCYE                  |   203 | 10759 |       |     8   (0)| 00:00:01 |
965| 955 |                  VIEW                                        |                          |    52G|    38T|       |    23M (27)| 79:01:26 |
966| 956 |                   UNION-ALL                                  |                          |       |       |       |            |          |
967|*957 |                    HASH JOIN RIGHT OUTER                     |                          |    52G|    38T|       |    11M (27)| 39:30:43 |
968| 958 |                     VIEW                                     |                          |  1221 |   162K|       |   770   (4)| 00:00:10 |
969| 959 |                      HASH GROUP BY                           |                          |  1221 |   225K|       |   770   (4)| 00:00:10 |
970|*960 |                       HASH JOIN                              |                          |  1221 |   225K|       |   769   (4)| 00:00:10 |
971|*961 |                        TABLE ACCESS BY INDEX ROWID           | PO_INVOICE_B             |    10 |   460 |       |     2   (0)| 00:00:01 |
972| 962 |                         NESTED LOOPS                         |                          |  1221 |   200K|       |   475   (2)| 00:00:06 |
973| 963 |                          NESTED LOOPS                        |                          |   127 | 15494 |       |   271   (3)| 00:00:04 |
974|*964 |                           TABLE ACCESS FULL                  | PO_INVOICE               |   127 | 10668 |       |   220   (3)| 00:00:03 |
975| 965 |                           TABLE ACCESS BY INDEX ROWID        | BD_CUBASDOC              |     1 |    38 |       |     1   (0)| 00:00:01 |
976|*966 |                            INDEX UNIQUE SCAN                 | PK_BD_CUBASDOC           |     1 |       |       |     1   (0)| 00:00:01 |
977|*967 |                          INDEX RANGE SCAN                    | I_PO_INVOICE_B_5         |    14 |       |       |     1   (0)| 00:00:01 |
978| 968 |                        INDEX FAST FULL SCAN                  | PK_PO_ORDER_B            |   227K|  4673K|       |   287   (4)| 00:00:04 |
979| 969 |                     VIEW                                     |                          |    52G|    31T|       |    10M (16)| 34:23:30 |
980| 970 |                      UNION-ALL                               |                          |       |       |       |            |          |
981|*971 |                       HASH JOIN RIGHT OUTER                  |                          |    52G|    31T|   202M|  9172K (18)| 30:34:32 |
982| 972 |                        VIEW                                  |                          |  1251K|   188M|       | 74342   (3)| 00:14:53 |
983| 973 |                         HASH GROUP BY                        |                          |  1251K|   177M|   407M| 74342   (3)| 00:14:53 |
984|*974 |                          HASH JOIN                           |                          |  1251K|   177M|       | 32704   (4)| 00:06:33 |
985|*975 |                           TABLE ACCESS BY INDEX ROWID        | ARAP_DJZB                | 25033 |  1344K|       |  1366   (1)| 00:00:17 |
986|*976 |                            INDEX RANGE SCAN                  | I_ARAP_DJZB_004          | 24211 |       |       |    85   (2)| 00:00:02 |
987|*977 |                           HASH JOIN                          |                          |  1176K|   105M|       | 31300   (4)| 00:06:16 |
988|*978 |                            TABLE ACCESS FULL                 | BD_CUBASDOC              |  6336 |   284K|       |    66  (26)| 00:00:01 |
989|*979 |                            TABLE ACCESS FULL                 | ARAP_DJFB                |  1178K|    53M|       | 31199   (4)| 00:06:15 |
990| 980 |                        VIEW                                  |                          |   267M|   124G|       |  1056K  (3)| 03:31:21 |
991| 981 |                         UNION-ALL                            |                          |       |       |       |            |          |
992|*982 |                          HASH JOIN OUTER                     |                          |   262M|   121G|    55M|   616K  (3)| 02:03:20 |
993| 983 |                           VIEW                               |                          |   166K|    53M|       |   133K  (4)| 00:26:41 |
994| 984 |                            UNION-ALL                         |                          |       |       |       |            |          |
995|*985 |                             HASH JOIN OUTER                  |                          | 21756 |  6713K|       | 66505   (4)| 00:13:19 |
996| 986 |                              VIEW                            |                          |   931 |   143K|       | 26545   (4)| 00:05:19 |
997| 987 |                               HASH GROUP BY                  |                          |   931 |   119K|       | 26545   (4)| 00:05:19 |
998|*988 |                                HASH JOIN                     |                          |   931 |   119K|       | 26544   (4)| 00:05:19 |
999|*989 |                                 HASH JOIN                    |                          |   928 | 78880 |       | 26492   (4)| 00:05:18 |
1000|*990 |                                  TABLE ACCESS FULL           | GT_MEASURE_H             |  2510 |   139K|       | 26138   (4)| 00:05:14 |
1001|*991 |                                  TABLE ACCESS FULL           | GT_POORDER_H             | 19479 |   532K|       |   353   (3)| 00:00:05 |
1002| 992 |                                 TABLE ACCESS FULL            | BD_CUBASDOC              |  6366 |   285K|       |    52   (6)| 00:00:01 |
1003| 993 |                              VIEW                            |                          |   148K|    22M|       | 39955   (3)| 00:08:00 |
1004| 994 |                               HASH GROUP BY                  |                          |   148K|    27M|    59M| 39955   (3)| 00:08:00 |
1005|*995 |                                HASH JOIN                     |                          |   148K|    27M|       | 33542   (4)| 00:06:43 |
1006|*996 |                                 TABLE ACCESS FULL            | BD_CUBASDOC              |  6365 |   285K|       |    52   (6)| 00:00:01 |
1007|*997 |                                 HASH JOIN                    |                          |   148K|    21M|  2304K| 33484   (4)| 00:06:42 |
1008| 998 |                                  TABLE ACCESS FULL           | BD_CUMANDOC              | 43648 |  1790K|       |   360   (7)| 00:00:05 |
1009|*999 |                                  HASH JOIN                   |                          |   146K|    15M|  3824K| 32165   (4)| 00:06:26 |
1010|1000 |                                   TABLE ACCESS FULL          | GT_GENERAL_H             | 68684 |  3018K|       |  1414   (3)| 00:00:17 |
1011|1001 |                                   HASH JOIN RIGHT ANTI       |                          |   165K|     9M|    32M| 29964   (4)| 00:06:00 |
1012|1002 |                                    TABLE ACCESS FULL         | GT_INVOICE_B             |  1152K|    19M|       | 13080   (4)| 00:02:37 |
1013|1003 |                                    TABLE ACCESS FULL         | GT_GENERAL_B             |  1163K|    49M|       | 11983   (4)| 00:02:24 |
1014|1004 |                             HASH GROUP BY                    |                          |   144K|    29M|    62M| 66898   (4)| 00:13:23 |
1015|1005 |                              HASH JOIN RIGHT ANTI            |                          |   144K|    29M|       | 60039   (4)| 00:12:01 |
1016|1006 |                               VIEW                           | VW_SQ_17                 |   931 | 19551 |       | 26493   (4)| 00:05:18 |
1017|1007 |                                NESTED LOOPS                  |                          |   931 | 91238 |       | 26493   (4)| 00:05:18 |
1018|1008 |                                 HASH JOIN                    |                          |   928 | 71456 |       | 26492   (4)| 00:05:18 |
1019|1009 |                                  TABLE ACCESS FULL           | GT_MEASURE_H             |  2510 |   129K|       | 26138   (4)| 00:05:14 |
1020|1010 |                                  TABLE ACCESS FULL           | GT_POORDER_H             | 19479 |   456K|       |   353   (3)| 00:00:05 |
1021|1011 |                                 INDEX UNIQUE SCAN            | PK_BD_CUBASDOC           |     1 |    21 |       |     1   (0)| 00:00:01 |
1022|1012 |                               HASH JOIN                      |                          |   148K|    27M|       | 33542   (4)| 00:06:43 |
1023|1013 |                                TABLE ACCESS FULL             | BD_CUBASDOC              |  6365 |   285K|       |    52   (6)| 00:00:01 |
1024|1014 |                                HASH JOIN                     |                          |   148K|    21M|  2304K| 33484   (4)| 00:06:42 |
1025|1015 |                                 TABLE ACCESS FULL            | BD_CUMANDOC              | 43648 |  1790K|       |   360   (7)| 00:00:05 |
1026|1016 |                                 HASH JOIN                    |                          |   146K|    15M|  3824K| 32165   (4)| 00:06:26 |
1027|1017 |                                  TABLE ACCESS FULL           | GT_GENERAL_H             | 68684 |  3018K|       |  1414   (3)| 00:00:17 |
1028|1018 |                                  HASH JOIN RIGHT ANTI        |                          |   165K|     9M|    32M| 29964   (4)| 00:06:00 |
1029|1019 |                                   TABLE ACCESS FULL          | GT_INVOICE_B             |  1152K|    19M|       | 13080   (4)| 00:02:37 |
1030|1020 |                                   TABLE ACCESS FULL          | GT_GENERAL_B             |  1163K|    49M|       | 11983   (4)| 00:02:24 |
1031|1021 |                           VIEW                               |                          |    10M|  1515M|       |   391K  (2)| 01:18:18 |
1032|1022 |                            HASH GROUP BY                     |                          |    10M|  1611M|  3492M|   391K  (2)| 01:18:18 |
1033|1023 |                             HASH JOIN                        |                          |    10M|  1611M|  3168K| 16451   (6)| 00:03:18 |
1034|1024 |                              HASH JOIN                       |                          | 21601 |  2911K|       |   728   (6)| 00:00:09 |
1035|1025 |                               TABLE ACCESS FULL              | BD_CUBASDOC              |  6365 |   285K|       |    52   (6)| 00:00:01 |
1036|1026 |                               HASH JOIN                      |                          | 21605 |  1941K|       |   674   (5)| 00:00:09 |
1037|1027 |                                TABLE ACCESS FULL             | GT_INVOICE_H             | 21430 |  1004K|       |   311   (3)| 00:00:04 |
1038|1028 |                                TABLE ACCESS FULL             | BD_CUMANDOC              | 43644 |  1875K|       |   361   (7)| 00:00:05 |
1039|1029 |                              TABLE ACCESS FULL               | GT_INVOICE_B             |  1086K|    31M|       | 13080   (4)| 00:02:37 |
1040|1030 |                          HASH GROUP BY                       |                          |  5206K|   943M|  2981M|   440K  (3)| 01:28:02 |
1041|1031 |                           HASH JOIN                          |                          |    10M|  1822M|  3632K|   149K  (4)| 00:29:59 |
1042|1032 |                            HASH JOIN                         |                          | 21598 |  3374K|       |   134K  (4)| 00:26:50 |
1043|1033 |                             TABLE ACCESS FULL                | GT_INVOICE_H             | 21430 |  1004K|       |   311   (3)| 00:00:04 |
1044|1034 |                             HASH JOIN                        |                          | 43630 |  4772K|       |   133K  (4)| 00:26:46 |
1045|1035 |                              HASH JOIN ANTI                  |                          |  6364 |   422K|       |   133K  (4)| 00:26:42 |
1046|1036 |                               TABLE ACCESS FULL              | BD_CUBASDOC              |  6365 |   285K|       |    52   (6)| 00:00:01 |
1047|1037 |                               VIEW                           |                          |   166K|  3571K|       |   133K  (4)| 00:26:41 |
1048|1038 |                                UNION-ALL                     |                          |       |       |       |            |          |
1049|1039 |                                 HASH JOIN OUTER              |                          | 21756 |  6713K|       | 66505   (4)| 00:13:19 |
1050|1040 |                                  VIEW                        |                          |   931 |   143K|       | 26545   (4)| 00:05:19 |
1051|1041 |                                   HASH GROUP BY              |                          |   931 |   119K|       | 26545   (4)| 00:05:19 |
1052|1042 |                                    HASH JOIN                 |                          |   931 |   119K|       | 26544   (4)| 00:05:19 |
1053|1043 |                                     HASH JOIN                |                          |   928 | 78880 |       | 26492   (4)| 00:05:18 |
1054|1044 |                                      TABLE ACCESS FULL       | GT_MEASURE_H             |  2510 |   139K|       | 26138   (4)| 00:05:14 |
1055|1045 |                                      TABLE ACCESS FULL       | GT_POORDER_H             | 19479 |   532K|       |   353   (3)| 00:00:05 |
1056|1046 |                                     TABLE ACCESS FULL        | BD_CUBASDOC              |  6366 |   285K|       |    52   (6)| 00:00:01 |
1057|1047 |                                  VIEW                        |                          |   148K|    22M|       | 39955   (3)| 00:08:00 |
1058|1048 |                                   HASH GROUP BY              |                          |   148K|    27M|    59M| 39955   (3)| 00:08:00 |
1059|1049 |                                    HASH JOIN                 |                          |   148K|    27M|       | 33542   (4)| 00:06:43 |
1060|1050 |                                     TABLE ACCESS FULL        | BD_CUBASDOC              |  6365 |   285K|       |    52   (6)| 00:00:01 |
1061|1051 |                                     HASH JOIN                |                          |   148K|    21M|  2304K| 33484   (4)| 00:06:42 |
1062|1052 |                                      TABLE ACCESS FULL       | BD_CUMANDOC              | 43648 |  1790K|       |   360   (7)| 00:00:05 |
1063|1053 |                                      HASH JOIN               |                          |   146K|    15M|  3824K| 32165   (4)| 00:06:26 |
1064|1054 |                                       TABLE ACCESS FULL      | GT_GENERAL_H             | 68684 |  3018K|       |  1414   (3)| 00:00:17 |
1065|1055 |                                       HASH JOIN RIGHT ANTI   |                          |   165K|     9M|    32M| 29964   (4)| 00:06:00 |
1066|1056 |                                        TABLE ACCESS FULL     | GT_INVOICE_B             |  1152K|    19M|       | 13080   (4)| 00:02:37 |
1067|1057 |                                        TABLE ACCESS FULL     | GT_GENERAL_B             |  1163K|    49M|       | 11983   (4)| 00:02:24 |
1068|1058 |                                 HASH GROUP BY                |                          |   144K|    29M|    62M| 66898   (4)| 00:13:23 |
1069|1059 |                                  HASH JOIN RIGHT ANTI        |                          |   144K|    29M|       | 60039   (4)| 00:12:01 |
1070|1060 |                                   VIEW                       | VW_SQ_18                 |   931 | 19551 |       | 26493   (4)| 00:05:18 |
1071|1061 |                                    NESTED LOOPS              |                          |   931 | 91238 |       | 26493   (4)| 00:05:18 |
1072|1062 |                                     HASH JOIN                |                          |   928 | 71456 |       | 26492   (4)| 00:05:18 |
1073|1063 |                                      TABLE ACCESS FULL       | GT_MEASURE_H             |  2510 |   129K|       | 26138   (4)| 00:05:14 |
1074|1064 |                                      TABLE ACCESS FULL       | GT_POORDER_H             | 19479 |   456K|       |   353   (3)| 00:00:05 |
1075|1065 |                                     INDEX UNIQUE SCAN        | PK_BD_CUBASDOC           |     1 |    21 |       |     1   (0)| 00:00:01 |
1076|1066 |                                   HASH JOIN                  |                          |   148K|    27M|       | 33542   (4)| 00:06:43 |
1077|1067 |                                    TABLE ACCESS FULL         | BD_CUBASDOC              |  6365 |   285K|       |    52   (6)| 00:00:01 |
1078|1068 |                                    HASH JOIN                 |                          |   148K|    21M|  2304K| 33484   (4)| 00:06:42 |
1079|1069 |                                     TABLE ACCESS FULL        | BD_CUMANDOC              | 43648 |  1790K|       |   360   (7)| 00:00:05 |
1080|1070 |                                     HASH JOIN                |                          |   146K|    15M|  3824K| 32165   (4)| 00:06:26 |
1081|1071 |                                      TABLE ACCESS FULL       | GT_GENERAL_H             | 68684 |  3018K|       |  1414   (3)| 00:00:17 |
1082|1072 |                                      HASH JOIN RIGHT ANTI    |                          |   165K|     9M|    32M| 29964   (4)| 00:06:00 |
1083|1073 |                                       TABLE ACCESS FULL      | GT_INVOICE_B             |  1152K|    19M|       | 13080   (4)| 00:02:37 |
1084|1074 |                                       TABLE ACCESS FULL      | GT_GENERAL_B             |  1163K|    49M|       | 11983   (4)| 00:02:24 |
1085|1075 |                              TABLE ACCESS FULL               | BD_CUMANDOC              | 43644 |  1875K|       |   361   (7)| 00:00:05 |
1086|1076 |                            TABLE ACCESS FULL                 | GT_INVOICE_B             |  1086K|    31M|       | 13080   (4)| 00:02:37 |
1087|1077 |                       HASH GROUP BY                          |                          |  1251K|   204M|   454M|  1144K  (4)| 03:48:58 |
1088|1078 |                        HASH JOIN                             |                          |  1251K|   204M|       |  1097K  (4)| 03:39:28 |
1089|1079 |                         TABLE ACCESS BY INDEX ROWID          | ARAP_DJZB                | 25033 |  1344K|       |  1366   (1)| 00:00:17 |
1090|1080 |                          INDEX RANGE SCAN                    | I_ARAP_DJZB_004          | 24211 |       |       |    85   (2)| 00:00:02 |
1091|1081 |                         HASH JOIN                            |                          |  1176K|   130M|       |  1095K  (4)| 03:39:11 |
1092|1082 |                          HASH JOIN ANTI                      |                          |  6335 |   420K|       |  1064K  (4)| 03:32:56 |
1093|1083 |                           TABLE ACCESS FULL                  | BD_CUBASDOC              |  6336 |   284K|       |    66  (26)| 00:00:01 |
1094|1084 |                           VIEW                               |                          |   267M|  5620M|       |  1056K  (3)| 03:31:21 |
1095|1085 |                            UNION-ALL                         |                          |       |       |       |            |          |
1096|1086 |                             HASH JOIN OUTER                  |                          |   262M|   121G|    55M|   616K  (3)| 02:03:20 |
1097|1087 |                              VIEW                            |                          |   166K|    53M|       |   133K  (4)| 00:26:41 |
1098|1088 |                               UNION-ALL                      |                          |       |       |       |            |          |
1099|1089 |                                HASH JOIN OUTER               |                          | 21756 |  6713K|       | 66505   (4)| 00:13:19 |
1100|1090 |                                 VIEW                         |                          |   931 |   143K|       | 26545   (4)| 00:05:19 |
1101|1091 |                                  HASH GROUP BY               |                          |   931 |   119K|       | 26545   (4)| 00:05:19 |
1102|1092 |                                   HASH JOIN                  |                          |   931 |   119K|       | 26544   (4)| 00:05:19 |
1103|1093 |                                    HASH JOIN                 |                          |   928 | 78880 |       | 26492   (4)| 00:05:18 |
1104|1094 |                                     TABLE ACCESS FULL        | GT_MEASURE_H             |  2510 |   139K|       | 26138   (4)| 00:05:14 |
1105|1095 |                                     TABLE ACCESS FULL        | GT_POORDER_H             | 19479 |   532K|       |   353   (3)| 00:00:05 |
1106|1096 |                                    TABLE ACCESS FULL         | BD_CUBASDOC              |  6366 |   285K|       |    52   (6)| 00:00:01 |
1107|1097 |                                 VIEW                         |                          |   148K|    22M|       | 39955   (3)| 00:08:00 |
1108|1098 |                                  HASH GROUP BY               |                          |   148K|    27M|    59M| 39955   (3)| 00:08:00 |
1109|1099 |                                   HASH JOIN                  |                          |   148K|    27M|       | 33542   (4)| 00:06:43 |
1110|1100 |                                    TABLE ACCESS FULL         | BD_CUBASDOC              |  6365 |   285K|       |    52   (6)| 00:00:01 |
1111|1101 |                                    HASH JOIN                 |                          |   148K|    21M|  2304K| 33484   (4)| 00:06:42 |
1112|1102 |                                     TABLE ACCESS FULL        | BD_CUMANDOC              | 43648 |  1790K|       |   360   (7)| 00:00:05 |
1113|1103 |                                     HASH JOIN                |                          |   146K|    15M|  3824K| 32165   (4)| 00:06:26 |
1114|1104 |                                      TABLE ACCESS FULL       | GT_GENERAL_H             | 68684 |  3018K|       |  1414   (3)| 00:00:17 |
1115|1105 |                                      HASH JOIN RIGHT ANTI    |                          |   165K|     9M|    32M| 29964   (4)| 00:06:00 |
1116|1106 |                                       TABLE ACCESS FULL      | GT_INVOICE_B             |  1152K|    19M|       | 13080   (4)| 00:02:37 |
1117|1107 |                                       TABLE ACCESS FULL      | GT_GENERAL_B             |  1163K|    49M|       | 11983   (4)| 00:02:24 |
1118|1108 |                                HASH GROUP BY                 |                          |   144K|    29M|    62M| 66898   (4)| 00:13:23 |
1119|1109 |                                 HASH JOIN RIGHT ANTI         |                          |   144K|    29M|       | 60039   (4)| 00:12:01 |
1120|1110 |                                  VIEW                        | VW_SQ_19                 |   931 | 19551 |       | 26493   (4)| 00:05:18 |
1121|1111 |                                   NESTED LOOPS               |                          |   931 | 91238 |       | 26493   (4)| 00:05:18 |
1122|1112 |                                    HASH JOIN                 |                          |   928 | 71456 |       | 26492   (4)| 00:05:18 |
1123|1113 |                                     TABLE ACCESS FULL        | GT_MEASURE_H             |  2510 |   129K|       | 26138   (4)| 00:05:14 |
1124|1114 |                                     TABLE ACCESS FULL        | GT_POORDER_H             | 19479 |   456K|       |   353   (3)| 00:00:05 |
1125|1115 |                                    INDEX UNIQUE SCAN         | PK_BD_CUBASDOC           |     1 |    21 |       |     1   (0)| 00:00:01 |
1126|1116 |                                  HASH JOIN                   |                          |   148K|    27M|       | 33542   (4)| 00:06:43 |
1127|1117 |                                   TABLE ACCESS FULL          | BD_CUBASDOC              |  6365 |   285K|       |    52   (6)| 00:00:01 |
1128|1118 |                                   HASH JOIN                  |                          |   148K|    21M|  2304K| 33484   (4)| 00:06:42 |
1129|1119 |                                    TABLE ACCESS FULL         | BD_CUMANDOC              | 43648 |  1790K|       |   360   (7)| 00:00:05 |
1130|1120 |                                    HASH JOIN                 |                          |   146K|    15M|  3824K| 32165   (4)| 00:06:26 |
1131|1121 |                                     TABLE ACCESS FULL        | GT_GENERAL_H             | 68684 |  3018K|       |  1414   (3)| 00:00:17 |
1132|1122 |                                     HASH JOIN RIGHT ANTI     |                          |   165K|     9M|    32M| 29964   (4)| 00:06:00 |
1133|1123 |                                      TABLE ACCESS FULL       | GT_INVOICE_B             |  1152K|    19M|       | 13080   (4)| 00:02:37 |
1134|1124 |                                      TABLE ACCESS FULL       | GT_GENERAL_B             |  1163K|    49M|       | 11983   (4)| 00:02:24 |
1135|1125 |                              VIEW                            |                          |    10M|  1515M|       |   391K  (2)| 01:18:18 |
1136|1126 |                               HASH GROUP BY                  |                          |    10M|  1611M|  3492M|   391K  (2)| 01:18:18 |
1137|1127 |                                HASH JOIN                     |                          |    10M|  1611M|  3168K| 16451   (6)| 00:03:18 |
1138|1128 |                                 HASH JOIN                    |                          | 21601 |  2911K|       |   728   (6)| 00:00:09 |
1139|1129 |                                  TABLE ACCESS FULL           | BD_CUBASDOC              |  6365 |   285K|       |    52   (6)| 00:00:01 |
1140|1130 |                                  HASH JOIN                   |                          | 21605 |  1941K|       |   674   (5)| 00:00:09 |
1141|1131 |                                   TABLE ACCESS FULL          | GT_INVOICE_H             | 21430 |  1004K|       |   311   (3)| 00:00:04 |
1142|1132 |                                   TABLE ACCESS FULL          | BD_CUMANDOC              | 43644 |  1875K|       |   361   (7)| 00:00:05 |
1143|1133 |                                 TABLE ACCESS FULL            | GT_INVOICE_B             |  1086K|    31M|       | 13080   (4)| 00:02:37 |
1144|1134 |                             HASH GROUP BY                    |                          |  5206K|   943M|  2981M|   440K  (3)| 01:28:02 |
1145|1135 |                              HASH JOIN                       |                          |    10M|  1822M|  3632K|   149K  (4)| 00:29:59 |
1146|1136 |                               HASH JOIN                      |                          | 21598 |  3374K|       |   134K  (4)| 00:26:50 |
1147|1137 |                                TABLE ACCESS FULL             | GT_INVOICE_H             | 21430 |  1004K|       |   311   (3)| 00:00:04 |
1148|1138 |                                HASH JOIN                     |                          | 43630 |  4772K|       |   133K  (4)| 00:26:46 |
1149|1139 |                                 HASH JOIN ANTI               |                          |  6364 |   422K|       |   133K  (4)| 00:26:42 |
1150|1140 |                                  TABLE ACCESS FULL           | BD_CUBASDOC              |  6365 |   285K|       |    52   (6)| 00:00:01 |
1151|1141 |                                  VIEW                        |                          |   166K|  3571K|       |   133K  (4)| 00:26:41 |
1152|1142 |                                   UNION-ALL                  |                          |       |       |       |            |          |
1153|1143 |                                    HASH JOIN OUTER           |                          | 21756 |  6713K|       | 66505   (4)| 00:13:19 |
1154|1144 |                                     VIEW                     |                          |   931 |   143K|       | 26545   (4)| 00:05:19 |
1155|1145 |                                      HASH GROUP BY           |                          |   931 |   119K|       | 26545   (4)| 00:05:19 |
1156|1146 |                                       HASH JOIN              |                          |   931 |   119K|       | 26544   (4)| 00:05:19 |
1157|1147 |                                        HASH JOIN             |                          |   928 | 78880 |       | 26492   (4)| 00:05:18 |
1158|1148 |                                         TABLE ACCESS FULL    | GT_MEASURE_H             |  2510 |   139K|       | 26138   (4)| 00:05:14 |
1159|1149 |                                         TABLE ACCESS FULL    | GT_POORDER_H             | 19479 |   532K|       |   353   (3)| 00:00:05 |
1160|1150 |                                        TABLE ACCESS FULL     | BD_CUBASDOC              |  6366 |   285K|       |    52   (6)| 00:00:01 |
1161|1151 |                                     VIEW                     |                          |   148K|    22M|       | 39955   (3)| 00:08:00 |
1162|1152 |                                      HASH GROUP BY           |                          |   148K|    27M|    59M| 39955   (3)| 00:08:00 |
1163|1153 |                                       HASH JOIN              |                          |   148K|    27M|       | 33542   (4)| 00:06:43 |
1164|1154 |                                        TABLE ACCESS FULL     | BD_CUBASDOC              |  6365 |   285K|       |    52   (6)| 00:00:01 |
1165|1155 |                                        HASH JOIN             |                          |   148K|    21M|  2304K| 33484   (4)| 00:06:42 |
1166|1156 |                                         TABLE ACCESS FULL    | BD_CUMANDOC              | 43648 |  1790K|       |   360   (7)| 00:00:05 |
1167|1157 |                                         HASH JOIN            |                          |   146K|    15M|  3824K| 32165   (4)| 00:06:26 |
1168|1158 |                                          TABLE ACCESS FULL   | GT_GENERAL_H             | 68684 |  3018K|       |  1414   (3)| 00:00:17 |
1169|1159 | I                                        HASH JOIN RIGHT ANT |                          |   165K|     9M|    32M| 29964   (4)| 00:06:00 |
1170|1160 |                                           TABLE ACCESS FULL  | GT_INVOICE_B             |  1152K|    19M|       | 13080   (4)| 00:02:37 |
1171|1161 |                                           TABLE ACCESS FULL  | GT_GENERAL_B             |  1163K|    49M|       | 11983   (4)| 00:02:24 |
1172|1162 |                                    HASH GROUP BY             |                          |   144K|    29M|    62M| 66898   (4)| 00:13:23 |
1173|1163 |                                     HASH JOIN RIGHT ANTI     |                          |   144K|    29M|       | 60039   (4)| 00:12:01 |
1174|1164 |                                      VIEW                    | VW_SQ_20                 |   931 | 19551 |       | 26493   (4)| 00:05:18 |
1175|1165 |                                       NESTED LOOPS           |                          |   931 | 91238 |       | 26493   (4)| 00:05:18 |
1176|1166 |                                        HASH JOIN             |                          |   928 | 71456 |       | 26492   (4)| 00:05:18 |
1177|1167 |                                         TABLE ACCESS FULL    | GT_MEASURE_H             |  2510 |   129K|       | 26138   (4)| 00:05:14 |
1178|1168 |                                         TABLE ACCESS FULL    | GT_POORDER_H             | 19479 |   456K|       |   353   (3)| 00:00:05 |
1179|1169 |                                        INDEX UNIQUE SCAN     | PK_BD_CUBASDOC           |     1 |    21 |       |     1   (0)| 00:00:01 |
1180|1170 |                                      HASH JOIN               |                          |   148K|    27M|       | 33542   (4)| 00:06:43 |
1181|1171 |                                       TABLE ACCESS FULL      | BD_CUBASDOC              |  6365 |   285K|       |    52   (6)| 00:00:01 |
1182|1172 |                                       HASH JOIN              |                          |   148K|    21M|  2304K| 33484   (4)| 00:06:42 |
1183|1173 |                                        TABLE ACCESS FULL     | BD_CUMANDOC              | 43648 |  1790K|       |   360   (7)| 00:00:05 |
1184|1174 |                                        HASH JOIN             |                          |   146K|    15M|  3824K| 32165   (4)| 00:06:26 |
1185|1175 |                                         TABLE ACCESS FULL    | GT_GENERAL_H             | 68684 |  3018K|       |  1414   (3)| 00:00:17 |
1186|1176 |                                         HASH JOIN RIGHT ANTI |                          |   165K|     9M|    32M| 29964   (4)| 00:06:00 |
1187|1177 |                                          TABLE ACCESS FULL   | GT_INVOICE_B             |  1152K|    19M|       | 13080   (4)| 00:02:37 |
1188|1178 |                                          TABLE ACCESS FULL   | GT_GENERAL_B             |  1163K|    49M|       | 11983   (4)| 00:02:24 |
1189|1179 |                                 TABLE ACCESS FULL            | BD_CUMANDOC              | 43644 |  1875K|       |   361   (7)| 00:00:05 |
1190|1180 |                               TABLE ACCESS FULL              | GT_INVOICE_B             |  1086K|    31M|       | 13080   (4)| 00:02:37 |
1191|1181 |                          TABLE ACCESS FULL                   | ARAP_DJFB                |  1178K|    53M|       | 31199   (4)| 00:06:15 |
1192|1182 |                    HASH GROUP BY                             |                          |  1221 |   251K|       |    11M (27)| 39:30:43 |
1193|1183 |                     HASH JOIN                                |                          |  1221 |   251K|       |    11M (27)| 39:30:43 |
1194|1184 |                      TABLE ACCESS BY INDEX ROWID             | PO_INVOICE_B             |    10 |   460 |       |     2   (0)| 00:00:01 |
1195|1185 |                       NESTED LOOPS                           |                          |  1221 |   226K|       |    11M (27)| 39:30:40 |
1196|1186 |                        HASH JOIN ANTI                        |                          |   127 | 18288 |       |    11M (27)| 39:30:37 |
1197|1187 |                         NESTED LOOPS                         |                          |   127 | 15494 |       |   271   (3)| 00:00:04 |
1198|1188 |                          TABLE ACCESS FULL                   | PO_INVOICE               |   127 | 10668 |       |   220   (3)| 00:00:03 |
1199|1189 |                          TABLE ACCESS BY INDEX ROWID         | BD_CUBASDOC              |     1 |    38 |       |     1   (0)| 00:00:01 |
1200|1190 |                           INDEX UNIQUE SCAN                  | PK_BD_CUBASDOC           |     1 |       |       |     1   (0)| 00:00:01 |
1201|1191 |                         VIEW                                 |                          |    52G|  1079G|       |    10M (16)| 34:23:30 |
1202|1192 |                          UNION-ALL                           |                          |       |       |       |            |          |
1203|1193 |                           HASH JOIN RIGHT OUTER              |                          |    52G|    31T|   202M|  9172K (18)| 30:34:32 |
1204|1194 |                            VIEW                              |                          |  1251K|   188M|       | 74342   (3)| 00:14:53 |
1205|1195 |                             HASH GROUP BY                    |                          |  1251K|   177M|   407M| 74342   (3)| 00:14:53 |
1206|1196 |                              HASH JOIN                       |                          |  1251K|   177M|       | 32704   (4)| 00:06:33 |
1207|1197 |                               TABLE ACCESS BY INDEX ROWID    | ARAP_DJZB                | 25033 |  1344K|       |  1366   (1)| 00:00:17 |
1208|1198 |                                INDEX RANGE SCAN              | I_ARAP_DJZB_004          | 24211 |       |       |    85   (2)| 00:00:02 |
1209|1199 |                               HASH JOIN                      |                          |  1176K|   105M|       | 31300   (4)| 00:06:16 |
1210|1200 |                                TABLE ACCESS FULL             | BD_CUBASDOC              |  6336 |   284K|       |    66  (26)| 00:00:01 |
1211|1201 |                                TABLE ACCESS FULL             | ARAP_DJFB                |  1178K|    53M|       | 31199   (4)| 00:06:15 |
1212|1202 |                            VIEW                              |                          |   267M|   124G|       |  1056K  (3)| 03:31:21 |
1213|1203 |                             UNION-ALL                        |                          |       |       |       |            |          |
1214|1204 |                              HASH JOIN OUTER                 |                          |   262M|   121G|    55M|   616K  (3)| 02:03:20 |
1215|1205 |                               VIEW                           |                          |   166K|    53M|       |   133K  (4)| 00:26:41 |
1216|1206 |                                UNION-ALL                     |                          |       |       |       |            |          |
1217|1207 |                                 HASH JOIN OUTER              |                          | 21756 |  6713K|       | 66505   (4)| 00:13:19 |
1218|1208 |                                  VIEW                        |                          |   931 |   143K|       | 26545   (4)| 00:05:19 |
1219|1209 |                                   HASH GROUP BY              |                          |   931 |   119K|       | 26545   (4)| 00:05:19 |
1220|1210 |                                    HASH JOIN                 |                          |   931 |   119K|       | 26544   (4)| 00:05:19 |
1221|1211 |                                     HASH JOIN                |                          |   928 | 78880 |       | 26492   (4)| 00:05:18 |
1222|1212 |                                      TABLE ACCESS FULL       | GT_MEASURE_H             |  2510 |   139K|       | 26138   (4)| 00:05:14 |
1223|1213 |                                      TABLE ACCESS FULL       | GT_POORDER_H             | 19479 |   532K|       |   353   (3)| 00:00:05 |
1224|1214 |                                     TABLE ACCESS FULL        | BD_CUBASDOC              |  6366 |   285K|       |    52   (6)| 00:00:01 |
1225|1215 |                                  VIEW                        |                          |   148K|    22M|       | 39955   (3)| 00:08:00 |
1226|1216 |                                   HASH GROUP BY              |                          |   148K|    27M|    59M| 39955   (3)| 00:08:00 |
1227|1217 |                                    HASH JOIN                 |                          |   148K|    27M|       | 33542   (4)| 00:06:43 |
1228|1218 |                                     TABLE ACCESS FULL        | BD_CUBASDOC              |  6365 |   285K|       |    52   (6)| 00:00:01 |
1229|1219 |                                     HASH JOIN                |                          |   148K|    21M|  2304K| 33484   (4)| 00:06:42 |
1230|1220 |                                      TABLE ACCESS FULL       | BD_CUMANDOC              | 43648 |  1790K|       |   360   (7)| 00:00:05 |
1231|1221 |                                      HASH JOIN               |                          |   146K|    15M|  3824K| 32165   (4)| 00:06:26 |
1232|1222 |                                       TABLE ACCESS FULL      | GT_GENERAL_H             | 68684 |  3018K|       |  1414   (3)| 00:00:17 |
1233|1223 |                                       HASH JOIN RIGHT ANTI   |                          |   165K|     9M|    32M| 29964   (4)| 00:06:00 |
1234|1224 |                                        TABLE ACCESS FULL     | GT_INVOICE_B             |  1152K|    19M|       | 13080   (4)| 00:02:37 |
1235|1225 |                                        TABLE ACCESS FULL     | GT_GENERAL_B             |  1163K|    49M|       | 11983   (4)| 00:02:24 |
1236|1226 |                                 HASH GROUP BY                |                          |   144K|    29M|    62M| 66898   (4)| 00:13:23 |
1237|1227 |                                  HASH JOIN RIGHT ANTI        |                          |   144K|    29M|       | 60039   (4)| 00:12:01 |
1238|1228 |                                   VIEW                       | VW_SQ_21                 |   931 | 19551 |       | 26493   (4)| 00:05:18 |
1239|1229 |                                    NESTED LOOPS              |                          |   931 | 91238 |       | 26493   (4)| 00:05:18 |
1240|1230 |                                     HASH JOIN                |                          |   928 | 71456 |       | 26492   (4)| 00:05:18 |
1241|1231 |                                      TABLE ACCESS FULL       | GT_MEASURE_H             |  2510 |   129K|       | 26138   (4)| 00:05:14 |
1242|1232 |                                      TABLE ACCESS FULL       | GT_POORDER_H             | 19479 |   456K|       |   353   (3)| 00:00:05 |
1243|1233 |                                     INDEX UNIQUE SCAN        | PK_BD_CUBASDOC           |     1 |    21 |       |     1   (0)| 00:00:01 |
1244|1234 |                                   HASH JOIN                  |                          |   148K|    27M|       | 33542   (4)| 00:06:43 |
1245|1235 |                                    TABLE ACCESS FULL         | BD_CUBASDOC              |  6365 |   285K|       |    52   (6)| 00:00:01 |
1246|1236 |                                    HASH JOIN                 |                          |   148K|    21M|  2304K| 33484   (4)| 00:06:42 |
1247|1237 |                                     TABLE ACCESS FULL        | BD_CUMANDOC              | 43648 |  1790K|       |   360   (7)| 00:00:05 |
1248|1238 |                                     HASH JOIN                |                          |   146K|    15M|  3824K| 32165   (4)| 00:06:26 |
1249|1239 |                                      TABLE ACCESS FULL       | GT_GENERAL_H             | 68684 |  3018K|       |  1414   (3)| 00:00:17 |
1250|1240 |                                      HASH JOIN RIGHT ANTI    |                          |   165K|     9M|    32M| 29964   (4)| 00:06:00 |
1251|1241 |                                       TABLE ACCESS FULL      | GT_INVOICE_B             |  1152K|    19M|       | 13080   (4)| 00:02:37 |
1252|1242 |                                       TABLE ACCESS FULL      | GT_GENERAL_B             |  1163K|    49M|       | 11983   (4)| 00:02:24 |
1253|1243 |                               VIEW                           |                          |    10M|  1515M|       |   391K  (2)| 01:18:18 |
1254|1244 |                                HASH GROUP BY                 |                          |    10M|  1611M|  3492M|   391K  (2)| 01:18:18 |
1255|1245 |                                 HASH JOIN                    |                          |    10M|  1611M|  3168K| 16451   (6)| 00:03:18 |
1256|1246 |                                  HASH JOIN                   |                          | 21601 |  2911K|       |   728   (6)| 00:00:09 |
1257|1247 |                                   TABLE ACCESS FULL          | BD_CUBASDOC              |  6365 |   285K|       |    52   (6)| 00:00:01 |
1258|1248 |                                   HASH JOIN                  |                          | 21605 |  1941K|       |   674   (5)| 00:00:09 |
1259|1249 |                                    TABLE ACCESS FULL         | GT_INVOICE_H             | 21430 |  1004K|       |   311   (3)| 00:00:04 |
1260|1250 |                                    TABLE ACCESS FULL         | BD_CUMANDOC              | 43644 |  1875K|       |   361   (7)| 00:00:05 |
1261|1251 |                                  TABLE ACCESS FULL           | GT_INVOICE_B             |  1086K|    31M|       | 13080   (4)| 00:02:37 |
1262|1252 |                              HASH GROUP BY                   |                          |  5206K|   943M|  2981M|   440K  (3)| 01:28:02 |
1263|1253 |                               HASH JOIN                      |                          |    10M|  1822M|  3632K|   149K  (4)| 00:29:59 |
1264|1254 |                                HASH JOIN                     |                          | 21598 |  3374K|       |   134K  (4)| 00:26:50 |
1265|1255 |                                 TABLE ACCESS FULL            | GT_INVOICE_H             | 21430 |  1004K|       |   311   (3)| 00:00:04 |
1266|1256 |                                 HASH JOIN                    |                          | 43630 |  4772K|       |   133K  (4)| 00:26:46 |
1267|1257 |                                  HASH JOIN ANTI              |                          |  6364 |   422K|       |   133K  (4)| 00:26:42 |
1268|1258 |                                   TABLE ACCESS FULL          | BD_CUBASDOC              |  6365 |   285K|       |    52   (6)| 00:00:01 |
1269|1259 |                                   VIEW                       |                          |   166K|  3571K|       |   133K  (4)| 00:26:41 |
1270|1260 |                                    UNION-ALL                 |                          |       |       |       |            |          |
1271|1261 |                                     HASH JOIN OUTER          |                          | 21756 |  6713K|       | 66505   (4)| 00:13:19 |
1272|1262 |                                      VIEW                    |                          |   931 |   143K|       | 26545   (4)| 00:05:19 |
1273|1263 |                                       HASH GROUP BY          |                          |   931 |   119K|       | 26545   (4)| 00:05:19 |
1274|1264 |                                        HASH JOIN             |                          |   931 |   119K|       | 26544   (4)| 00:05:19 |
1275|1265 |                                         HASH JOIN            |                          |   928 | 78880 |       | 26492   (4)| 00:05:18 |
1276|1266 |                                          TABLE ACCESS FULL   | GT_MEASURE_H             |  2510 |   139K|       | 26138   (4)| 00:05:14 |
1277|1267 |                                          TABLE ACCESS FULL   | GT_POORDER_H             | 19479 |   532K|       |   353   (3)| 00:00:05 |
1278|1268 |                                         TABLE ACCESS FULL    | BD_CUBASDOC              |  6366 |   285K|       |    52   (6)| 00:00:01 |
1279|1269 |                                      VIEW                    |                          |   148K|    22M|       | 39955   (3)| 00:08:00 |
1280|1270 |                                       HASH GROUP BY          |                          |   148K|    27M|    59M| 39955   (3)| 00:08:00 |
1281|1271 |                                        HASH JOIN             |                          |   148K|    27M|       | 33542   (4)| 00:06:43 |
1282|1272 |                                         TABLE ACCESS FULL    | BD_CUBASDOC              |  6365 |   285K|       |    52   (6)| 00:00:01 |
1283|1273 |                                         HASH JOIN            |                          |   148K|    21M|  2304K| 33484   (4)| 00:06:42 |
1284|1274 |                                          TABLE ACCESS FULL   | BD_CUMANDOC              | 43648 |  1790K|       |   360   (7)| 00:00:05 |
1285|1275 |                                          HASH JOIN           |                          |   146K|    15M|  3824K| 32165   (4)| 00:06:26 |
1286|1276 |                                           TABLE ACCESS FULL  | GT_GENERAL_H             | 68684 |  3018K|       |  1414   (3)| 00:00:17 |
1287|1277 | TI                                        HASH JOIN RIGHT AN |                          |   165K|     9M|    32M| 29964   (4)| 00:06:00 |
1288|1278 |                                            TABLE ACCESS FULL | GT_INVOICE_B             |  1152K|    19M|       | 13080   (4)| 00:02:37 |
1289|1279 |                                            TABLE ACCESS FULL | GT_GENERAL_B             |  1163K|    49M|       | 11983   (4)| 00:02:24 |
1290|1280 |                                     HASH GROUP BY            |                          |   144K|    29M|    62M| 66898   (4)| 00:13:23 |
1291|1281 |                                      HASH JOIN RIGHT ANTI    |                          |   144K|    29M|       | 60039   (4)| 00:12:01 |
1292|1282 |                                       VIEW                   | VW_SQ_22                 |   931 | 19551 |       | 26493   (4)| 00:05:18 |
1293|1283 |                                        NESTED LOOPS          |                          |   931 | 91238 |       | 26493   (4)| 00:05:18 |
1294|1284 |                                         HASH JOIN            |                          |   928 | 71456 |       | 26492   (4)| 00:05:18 |
1295|1285 |                                          TABLE ACCESS FULL   | GT_MEASURE_H             |  2510 |   129K|       | 26138   (4)| 00:05:14 |
1296|1286 |                                          TABLE ACCESS FULL   | GT_POORDER_H             | 19479 |   456K|       |   353   (3)| 00:00:05 |
1297|1287 |                                         INDEX UNIQUE SCAN    | PK_BD_CUBASDOC           |     1 |    21 |       |     1   (0)| 00:00:01 |
1298|1288 |                                       HASH JOIN              |                          |   148K|    27M|       | 33542   (4)| 00:06:43 |
1299|1289 |                                        TABLE ACCESS FULL     | BD_CUBASDOC              |  6365 |   285K|       |    52   (6)| 00:00:01 |
1300|1290 |                                        HASH JOIN             |                          |   148K|    21M|  2304K| 33484   (4)| 00:06:42 |
1301|1291 |                                         TABLE ACCESS FULL    | BD_CUMANDOC              | 43648 |  1790K|       |   360   (7)| 00:00:05 |
1302|1292 |                                         HASH JOIN            |                          |   146K|    15M|  3824K| 32165   (4)| 00:06:26 |
1303|1293 |                                          TABLE ACCESS FULL   | GT_GENERAL_H             | 68684 |  3018K|       |  1414   (3)| 00:00:17 |
1304|1294 | I                                        HASH JOIN RIGHT ANT |                          |   165K|     9M|    32M| 29964   (4)| 00:06:00 |
1305|1295 |                                           TABLE ACCESS FULL  | GT_INVOICE_B             |  1152K|    19M|       | 13080   (4)| 00:02:37 |
1306|1296 |                                           TABLE ACCESS FULL  | GT_GENERAL_B             |  1163K|    49M|       | 11983   (4)| 00:02:24 |
1307|1297 |                                  TABLE ACCESS FULL           | BD_CUMANDOC              | 43644 |  1875K|       |   361   (7)| 00:00:05 |
1308|1298 |                                TABLE ACCESS FULL             | GT_INVOICE_B             |  1086K|    31M|       | 13080   (4)| 00:02:37 |
1309|1299 |                           HASH GROUP BY                      |                          |  1251K|   204M|   454M|  1144K  (4)| 03:48:58 |
1310|1300 |                            HASH JOIN                         |                          |  1251K|   204M|       |  1097K  (4)| 03:39:28 |
1311|1301 |                             TABLE ACCESS BY INDEX ROWID      | ARAP_DJZB                | 25033 |  1344K|       |  1366   (1)| 00:00:17 |
1312|1302 |                              INDEX RANGE SCAN                | I_ARAP_DJZB_004          | 24211 |       |       |    85   (2)| 00:00:02 |
1313|1303 |                             HASH JOIN                        |                          |  1176K|   130M|       |  1095K  (4)| 03:39:11 |
1314|1304 |                              HASH JOIN ANTI                  |                          |  6335 |   420K|       |  1064K  (4)| 03:32:56 |
1315|1305 |                               TABLE ACCESS FULL              | BD_CUBASDOC              |  6336 |   284K|       |    66  (26)| 00:00:01 |
1316|1306 |                               VIEW                           |                          |   267M|  5620M|       |  1056K  (3)| 03:31:21 |
1317|1307 |                                UNION-ALL                     |                          |       |       |       |            |          |
1318|1308 |                                 HASH JOIN OUTER              |                          |   262M|   121G|    55M|   616K  (3)| 02:03:20 |
1319|1309 |                                  VIEW                        |                          |   166K|    53M|       |   133K  (4)| 00:26:41 |
1320|1310 |                                   UNION-ALL                  |                          |       |       |       |            |          |
1321|1311 |                                    HASH JOIN OUTER           |                          | 21756 |  6713K|       | 66505   (4)| 00:13:19 |
1322|1312 |                                     VIEW                     |                          |   931 |   143K|       | 26545   (4)| 00:05:19 |
1323|1313 |                                      HASH GROUP BY           |                          |   931 |   119K|       | 26545   (4)| 00:05:19 |
1324|1314 |                                       HASH JOIN              |                          |   931 |   119K|       | 26544   (4)| 00:05:19 |
1325|1315 |                                        HASH JOIN             |                          |   928 | 78880 |       | 26492   (4)| 00:05:18 |
1326|1316 |                                         TABLE ACCESS FULL    | GT_MEASURE_H             |  2510 |   139K|       | 26138   (4)| 00:05:14 |
1327|1317 |                                         TABLE ACCESS FULL    | GT_POORDER_H             | 19479 |   532K|       |   353   (3)| 00:00:05 |
1328|1318 |                                        TABLE ACCESS FULL     | BD_CUBASDOC              |  6366 |   285K|       |    52   (6)| 00:00:01 |
1329|1319 |                                     VIEW                     |                          |   148K|    22M|       | 39955   (3)| 00:08:00 |
1330|1320 |                                      HASH GROUP BY           |                          |   148K|    27M|    59M| 39955   (3)| 00:08:00 |
1331|1321 |                                       HASH JOIN              |                          |   148K|    27M|       | 33542   (4)| 00:06:43 |
1332|1322 |                                        TABLE ACCESS FULL     | BD_CUBASDOC              |  6365 |   285K|       |    52   (6)| 00:00:01 |
1333|1323 |                                        HASH JOIN             |                          |   148K|    21M|  2304K| 33484   (4)| 00:06:42 |
1334|1324 |                                         TABLE ACCESS FULL    | BD_CUMANDOC              | 43648 |  1790K|       |   360   (7)| 00:00:05 |
1335|1325 |                                         HASH JOIN            |                          |   146K|    15M|  3824K| 32165   (4)| 00:06:26 |
1336|1326 |                                          TABLE ACCESS FULL   | GT_GENERAL_H             | 68684 |  3018K|       |  1414   (3)| 00:00:17 |
1337|1327 | I                                        HASH JOIN RIGHT ANT |                          |   165K|     9M|    32M| 29964   (4)| 00:06:00 |
1338|1328 |                                           TABLE ACCESS FULL  | GT_INVOICE_B             |  1152K|    19M|       | 13080   (4)| 00:02:37 |
1339|1329 |                                           TABLE ACCESS FULL  | GT_GENERAL_B             |  1163K|    49M|       | 11983   (4)| 00:02:24 |
1340|1330 |                                    HASH GROUP BY             |                          |   144K|    29M|    62M| 66898   (4)| 00:13:23 |
1341|1331 |                                     HASH JOIN RIGHT ANTI     |                          |   144K|    29M|       | 60039   (4)| 00:12:01 |
1342|1332 |                                      VIEW                    | VW_SQ_23                 |   931 | 19551 |       | 26493   (4)| 00:05:18 |
1343|1333 |                                       NESTED LOOPS           |                          |   931 | 91238 |       | 26493   (4)| 00:05:18 |
1344|1334 |                                        HASH JOIN             |                          |   928 | 71456 |       | 26492   (4)| 00:05:18 |
1345|1335 |                                         TABLE ACCESS FULL    | GT_MEASURE_H             |  2510 |   129K|       | 26138   (4)| 00:05:14 |
1346|1336 |                                         TABLE ACCESS FULL    | GT_POORDER_H             | 19479 |   456K|       |   353   (3)| 00:00:05 |
1347|1337 |                                        INDEX UNIQUE SCAN     | PK_BD_CUBASDOC           |     1 |    21 |       |     1   (0)| 00:00:01 |
1348|1338 |                                      HASH JOIN               |                          |   148K|    27M|       | 33542   (4)| 00:06:43 |
1349|1339 |                                       TABLE ACCESS FULL      | BD_CUBASDOC              |  6365 |   285K|       |    52   (6)| 00:00:01 |
1350|1340 |                                       HASH JOIN              |                          |   148K|    21M|  2304K| 33484   (4)| 00:06:42 |
1351|1341 |                                        TABLE ACCESS FULL     | BD_CUMANDOC              | 43648 |  1790K|       |   360   (7)| 00:00:05 |
1352|1342 |                                        HASH JOIN             |                          |   146K|    15M|  3824K| 32165   (4)| 00:06:26 |
1353|1343 |                                         TABLE ACCESS FULL    | GT_GENERAL_H             | 68684 |  3018K|       |  1414   (3)| 00:00:17 |
1354|1344 |                                         HASH JOIN RIGHT ANTI |                          |   165K|     9M|    32M| 29964   (4)| 00:06:00 |
1355|1345 |                                          TABLE ACCESS FULL   | GT_INVOICE_B             |  1152K|    19M|       | 13080   (4)| 00:02:37 |
1356|1346 |                                          TABLE ACCESS FULL   | GT_GENERAL_B             |  1163K|    49M|       | 11983   (4)| 00:02:24 |
1357|1347 |                                  VIEW                        |                          |    10M|  1515M|       |   391K  (2)| 01:18:18 |
1358|1348 |                                   HASH GROUP BY              |                          |    10M|  1611M|  3492M|   391K  (2)| 01:18:18 |
1359|1349 |                                    HASH JOIN                 |                          |    10M|  1611M|  3168K| 16451   (6)| 00:03:18 |
1360|1350 |                                     HASH JOIN                |                          | 21601 |  2911K|       |   728   (6)| 00:00:09 |
1361|1351 |                                      TABLE ACCESS FULL       | BD_CUBASDOC              |  6365 |   285K|       |    52   (6)| 00:00:01 |
1362|1352 |                                      HASH JOIN               |                          | 21605 |  1941K|       |   674   (5)| 00:00:09 |
1363|1353 |                                       TABLE ACCESS FULL      | GT_INVOICE_H             | 21430 |  1004K|       |   311   (3)| 00:00:04 |
1364|1354 |                                       TABLE ACCESS FULL      | BD_CUMANDOC              | 43644 |  1875K|       |   361   (7)| 00:00:05 |
1365|1355 |                                     TABLE ACCESS FULL        | GT_INVOICE_B             |  1086K|    31M|       | 13080   (4)| 00:02:37 |
1366|1356 |                                 HASH GROUP BY                |                          |  5206K|   943M|  2981M|   440K  (3)| 01:28:02 |
1367|1357 |                                  HASH JOIN                   |                          |    10M|  1822M|  3632K|   149K  (4)| 00:29:59 |
1368|1358 |                                   HASH JOIN                  |                          | 21598 |  3374K|       |   134K  (4)| 00:26:50 |
1369|1359 |                                    TABLE ACCESS FULL         | GT_INVOICE_H             | 21430 |  1004K|       |   311   (3)| 00:00:04 |
1370|1360 |                                    HASH JOIN                 |                          | 43630 |  4772K|       |   133K  (4)| 00:26:46 |
1371|1361 |                                     HASH JOIN ANTI           |                          |  6364 |   422K|       |   133K  (4)| 00:26:42 |
1372|1362 |                                      TABLE ACCESS FULL       | BD_CUBASDOC              |  6365 |   285K|       |    52   (6)| 00:00:01 |
1373|1363 |                                      VIEW                    |                          |   166K|  3571K|       |   133K  (4)| 00:26:41 |
1374|1364 |                                       UNION-ALL              |                          |       |       |       |            |          |
1375|1365 |                                        HASH JOIN OUTER       |                          | 21756 |  6713K|       | 66505   (4)| 00:13:19 |
1376|1366 |                                         VIEW                 |                          |   931 |   143K|       | 26545   (4)| 00:05:19 |
1377|1367 |                                          HASH GROUP BY       |                          |   931 |   119K|       | 26545   (4)| 00:05:19 |
1378|1368 |                                           HASH JOIN          |                          |   931 |   119K|       | 26544   (4)| 00:05:19 |
1379|1369 |                                            HASH JOIN         |                          |   928 | 78880 |       | 26492   (4)| 00:05:18 |
1380|1370 | L                                           TABLE ACCESS FUL | GT_MEASURE_H             |  2510 |   139K|       | 26138   (4)| 00:05:14 |
1381|1371 | L                                           TABLE ACCESS FUL | GT_POORDER_H             | 19479 |   532K|       |   353   (3)| 00:00:05 |
1382|1372 |                                            TABLE ACCESS FULL | BD_CUBASDOC              |  6366 |   285K|       |    52   (6)| 00:00:01 |
1383|1373 |                                         VIEW                 |                          |   148K|    22M|       | 39955   (3)| 00:08:00 |
1384|1374 |                                          HASH GROUP BY       |                          |   148K|    27M|    59M| 39955   (3)| 00:08:00 |
1385|1375 |                                           HASH JOIN          |                          |   148K|    27M|       | 33542   (4)| 00:06:43 |
1386|1376 |                                            TABLE ACCESS FULL | BD_CUBASDOC              |  6365 |   285K|       |    52   (6)| 00:00:01 |
1387|1377 |                                            HASH JOIN         |                          |   148K|    21M|  2304K| 33484   (4)| 00:06:42 |
1388|1378 | L                                           TABLE ACCESS FUL | BD_CUMANDOC              | 43648 |  1790K|       |   360   (7)| 00:00:05 |
1389|1379 |                                             HASH JOIN        |                          |   146K|    15M|  3824K| 32165   (4)| 00:06:26 |
1390|1380 | LL                                           TABLE ACCESS FU | GT_GENERAL_H             | 68684 |  3018K|       |  1414   (3)| 00:00:17 |
1391|1381 |  ANTI                                        HASH JOIN RIGHT |                          |   165K|     9M|    32M| 29964   (4)| 00:06:00 |
1392|1382 | ULL                                           TABLE ACCESS F | GT_INVOICE_B             |  1152K|    19M|       | 13080   (4)| 00:02:37 |
1393|1383 | ULL                                           TABLE ACCESS F | GT_GENERAL_B             |  1163K|    49M|       | 11983   (4)| 00:02:24 |
1394|1384 |                                        HASH GROUP BY         |                          |   144K|    29M|    62M| 66898   (4)| 00:13:23 |
1395|1385 |                                         HASH JOIN RIGHT ANTI |                          |   144K|    29M|       | 60039   (4)| 00:12:01 |
1396|1386 |                                          VIEW                | VW_SQ_24                 |   931 | 19551 |       | 26493   (4)| 00:05:18 |
1397|1387 |                                           NESTED LOOPS       |                          |   931 | 91238 |       | 26493   (4)| 00:05:18 |
1398|1388 |                                            HASH JOIN         |                          |   928 | 71456 |       | 26492   (4)| 00:05:18 |
1399|1389 | L                                           TABLE ACCESS FUL | GT_MEASURE_H             |  2510 |   129K|       | 26138   (4)| 00:05:14 |
1400|1390 | L                                           TABLE ACCESS FUL | GT_POORDER_H             | 19479 |   456K|       |   353   (3)| 00:00:05 |
1401|1391 |                                            INDEX UNIQUE SCAN | PK_BD_CUBASDOC           |     1 |    21 |       |     1   (0)| 00:00:01 |
1402|1392 |                                          HASH JOIN           |                          |   148K|    27M|       | 33542   (4)| 00:06:43 |
1403|1393 |                                           TABLE ACCESS FULL  | BD_CUBASDOC              |  6365 |   285K|       |    52   (6)| 00:00:01 |
1404|1394 |                                           HASH JOIN          |                          |   148K|    21M|  2304K| 33484   (4)| 00:06:42 |
1405|1395 |                                            TABLE ACCESS FULL | BD_CUMANDOC              | 43648 |  1790K|       |   360   (7)| 00:00:05 |
1406|1396 |                                            HASH JOIN         |                          |   146K|    15M|  3824K| 32165   (4)| 00:06:26 |
1407|1397 | L                                           TABLE ACCESS FUL | GT_GENERAL_H             | 68684 |  3018K|       |  1414   (3)| 00:00:17 |
1408|1398 | ANTI                                        HASH JOIN RIGHT  |                          |   165K|     9M|    32M| 29964   (4)| 00:06:00 |
1409|1399 | LL                                           TABLE ACCESS FU | GT_INVOICE_B             |  1152K|    19M|       | 13080   (4)| 00:02:37 |
1410|1400 | LL                                           TABLE ACCESS FU | GT_GENERAL_B             |  1163K|    49M|       | 11983   (4)| 00:02:24 |
1411|1401 |                                     TABLE ACCESS FULL        | BD_CUMANDOC              | 43644 |  1875K|       |   361   (7)| 00:00:05 |
1412|1402 |                                   TABLE ACCESS FULL          | GT_INVOICE_B             |  1086K|    31M|       | 13080   (4)| 00:02:37 |
1413|1403 |                              TABLE ACCESS FULL               | ARAP_DJFB                |  1178K|    53M|       | 31199   (4)| 00:06:15 |
1414|1404 |                        INDEX RANGE SCAN                      | I_PO_INVOICE_B_5         |    14 |       |       |     1   (0)| 00:00:01 |
1415|1405 |                      INDEX FAST FULL SCAN                    | PK_PO_ORDER_B            |   227K|  4673K|       |   287   (4)| 00:00:04 |
1416|1406 |                 HASH GROUP BY                                |                          |   202 | 15150 |       |    25M (32)| 84:08:31 |
1417|1407 |                  HASH JOIN ANTI                              |                          |   202 | 15150 |       |    25M (32)| 84:08:31 |
1418|1408 |                   TABLE ACCESS FULL                          | GT_QCYE                  |   203 | 10759 |       |     8   (0)| 00:00:01 |
1419|1409 |                   VIEW                                       |                          |    52G|  1079G|       |    23M (27)| 79:01:26 |
1420|1410 |                    UNION-ALL                                 |                          |       |       |       |            |          |
1421|1411 |                     HASH JOIN RIGHT OUTER                    |                          |    52G|    38T|       |    11M (27)| 39:30:43 |
1422|1412 |                      VIEW                                    |                          |  1221 |   162K|       |   770   (4)| 00:00:10 |
1423|1413 |                       HASH GROUP BY                          |                          |  1221 |   225K|       |   770   (4)| 00:00:10 |
1424|1414 |                        HASH JOIN                             |                          |  1221 |   225K|       |   769   (4)| 00:00:10 |
1425|1415 |                         TABLE ACCESS BY INDEX ROWID          | PO_INVOICE_B             |    10 |   460 |       |     2   (0)| 00:00:01 |
1426|1416 |                          NESTED LOOPS                        |                          |  1221 |   200K|       |   475   (2)| 00:00:06 |
1427|1417 |                           NESTED LOOPS                       |                          |   127 | 15494 |       |   271   (3)| 00:00:04 |
1428|1418 |                            TABLE ACCESS FULL                 | PO_INVOICE               |   127 | 10668 |       |   220   (3)| 00:00:03 |
1429|1419 |                            TABLE ACCESS BY INDEX ROWID       | BD_CUBASDOC              |     1 |    38 |       |     1   (0)| 00:00:01 |
1430|1420 |                             INDEX UNIQUE SCAN                | PK_BD_CUBASDOC           |     1 |       |       |     1   (0)| 00:00:01 |
1431|1421 |                           INDEX RANGE SCAN                   | I_PO_INVOICE_B_5         |    14 |       |       |     1   (0)| 00:00:01 |
1432|1422 |                         INDEX FAST FULL SCAN                 | PK_PO_ORDER_B            |   227K|  4673K|       |   287   (4)| 00:00:04 |
1433|1423 |                      VIEW                                    |                          |    52G|    31T|       |    10M (16)| 34:23:30 |
1434|1424 |                       UNION-ALL                              |                          |       |       |       |            |          |
1435|1425 |                        HASH JOIN RIGHT OUTER                 |                          |    52G|    31T|   202M|  9172K (18)| 30:34:32 |
1436|1426 |                         VIEW                                 |                          |  1251K|   188M|       | 74342   (3)| 00:14:53 |
1437|1427 |                          HASH GROUP BY                       |                          |  1251K|   177M|   407M| 74342   (3)| 00:14:53 |
1438|1428 |                           HASH JOIN                          |                          |  1251K|   177M|       | 32704   (4)| 00:06:33 |
1439|1429 |                            TABLE ACCESS BY INDEX ROWID       | ARAP_DJZB                | 25033 |  1344K|       |  1366   (1)| 00:00:17 |
1440|1430 |                             INDEX RANGE SCAN                 | I_ARAP_DJZB_004          | 24211 |       |       |    85   (2)| 00:00:02 |
1441|1431 |                            HASH JOIN                         |                          |  1176K|   105M|       | 31300   (4)| 00:06:16 |
1442|1432 |                             TABLE ACCESS FULL                | BD_CUBASDOC              |  6336 |   284K|       |    66  (26)| 00:00:01 |
1443|1433 |                             TABLE ACCESS FULL                | ARAP_DJFB                |  1178K|    53M|       | 31199   (4)| 00:06:15 |
1444|1434 |                         VIEW                                 |                          |   267M|   124G|       |  1056K  (3)| 03:31:21 |
1445|1435 |                          UNION-ALL                           |                          |       |       |       |            |          |
1446|1436 |                           HASH JOIN OUTER                    |                          |   262M|   121G|    55M|   616K  (3)| 02:03:20 |
1447|1437 |                            VIEW                              |                          |   166K|    53M|       |   133K  (4)| 00:26:41 |
1448|1438 |                             UNION-ALL                        |                          |       |       |       |            |          |
1449|1439 |                              HASH JOIN OUTER                 |                          | 21756 |  6713K|       | 66505   (4)| 00:13:19 |
1450|1440 |                               VIEW                           |                          |   931 |   143K|       | 26545   (4)| 00:05:19 |
1451|1441 |                                HASH GROUP BY                 |                          |   931 |   119K|       | 26545   (4)| 00:05:19 |
1452|1442 |                                 HASH JOIN                    |                          |   931 |   119K|       | 26544   (4)| 00:05:19 |
1453|1443 |                                  HASH JOIN                   |                          |   928 | 78880 |       | 26492   (4)| 00:05:18 |
1454|1444 |                                   TABLE ACCESS FULL          | GT_MEASURE_H             |  2510 |   139K|       | 26138   (4)| 00:05:14 |
1455|1445 |                                   TABLE ACCESS FULL          | GT_POORDER_H             | 19479 |   532K|       |   353   (3)| 00:00:05 |
1456|1446 |                                  TABLE ACCESS FULL           | BD_CUBASDOC              |  6366 |   285K|       |    52   (6)| 00:00:01 |
1457|1447 |                               VIEW                           |                          |   148K|    22M|       | 39955   (3)| 00:08:00 |
1458|1448 |                                HASH GROUP BY                 |                          |   148K|    27M|    59M| 39955   (3)| 00:08:00 |
1459|1449 |                                 HASH JOIN                    |                          |   148K|    27M|       | 33542   (4)| 00:06:43 |
1460|1450 |                                  TABLE ACCESS FULL           | BD_CUBASDOC              |  6365 |   285K|       |    52   (6)| 00:00:01 |
1461|1451 |                                  HASH JOIN                   |                          |   148K|    21M|  2304K| 33484   (4)| 00:06:42 |
1462|1452 |                                   TABLE ACCESS FULL          | BD_CUMANDOC              | 43648 |  1790K|       |   360   (7)| 00:00:05 |
1463|1453 |                                   HASH JOIN                  |                          |   146K|    15M|  3824K| 32165   (4)| 00:06:26 |
1464|1454 |                                    TABLE ACCESS FULL         | GT_GENERAL_H             | 68684 |  3018K|       |  1414   (3)| 00:00:17 |
1465|1455 |                                    HASH JOIN RIGHT ANTI      |                          |   165K|     9M|    32M| 29964   (4)| 00:06:00 |
1466|1456 |                                     TABLE ACCESS FULL        | GT_INVOICE_B             |  1152K|    19M|       | 13080   (4)| 00:02:37 |
1467|1457 |                                     TABLE ACCESS FULL        | GT_GENERAL_B             |  1163K|    49M|       | 11983   (4)| 00:02:24 |
1468|1458 |                              HASH GROUP BY                   |                          |   144K|    29M|    62M| 66898   (4)| 00:13:23 |
1469|1459 |                               HASH JOIN RIGHT ANTI           |                          |   144K|    29M|       | 60039   (4)| 00:12:01 |
1470|1460 |                                VIEW                          | VW_SQ_25                 |   931 | 19551 |       | 26493   (4)| 00:05:18 |
1471|1461 |                                 NESTED LOOPS                 |                          |   931 | 91238 |       | 26493   (4)| 00:05:18 |
1472|1462 |                                  HASH JOIN                   |                          |   928 | 71456 |       | 26492   (4)| 00:05:18 |
1473|1463 |                                   TABLE ACCESS FULL          | GT_MEASURE_H             |  2510 |   129K|       | 26138   (4)| 00:05:14 |
1474|1464 |                                   TABLE ACCESS FULL          | GT_POORDER_H             | 19479 |   456K|       |   353   (3)| 00:00:05 |
1475|1465 |                                  INDEX UNIQUE SCAN           | PK_BD_CUBASDOC           |     1 |    21 |       |     1   (0)| 00:00:01 |
1476|1466 |                                HASH JOIN                     |                          |   148K|    27M|       | 33542   (4)| 00:06:43 |
1477|1467 |                                 TABLE ACCESS FULL            | BD_CUBASDOC              |  6365 |   285K|       |    52   (6)| 00:00:01 |
1478|1468 |                                 HASH JOIN                    |                          |   148K|    21M|  2304K| 33484   (4)| 00:06:42 |
1479|1469 |                                  TABLE ACCESS FULL           | BD_CUMANDOC              | 43648 |  1790K|       |   360   (7)| 00:00:05 |
1480|1470 |                                  HASH JOIN                   |                          |   146K|    15M|  3824K| 32165   (4)| 00:06:26 |
1481|1471 |                                   TABLE ACCESS FULL          | GT_GENERAL_H             | 68684 |  3018K|       |  1414   (3)| 00:00:17 |
1482|1472 |                                   HASH JOIN RIGHT ANTI       |                          |   165K|     9M|    32M| 29964   (4)| 00:06:00 |
1483|1473 |                                    TABLE ACCESS FULL         | GT_INVOICE_B             |  1152K|    19M|       | 13080   (4)| 00:02:37 |
1484|1474 |                                    TABLE ACCESS FULL         | GT_GENERAL_B             |  1163K|    49M|       | 11983   (4)| 00:02:24 |
1485|1475 |                            VIEW                              |                          |    10M|  1515M|       |   391K  (2)| 01:18:18 |
1486|1476 |                             HASH GROUP BY                    |                          |    10M|  1611M|  3492M|   391K  (2)| 01:18:18 |
1487|1477 |                              HASH JOIN                       |                          |    10M|  1611M|  3168K| 16451   (6)| 00:03:18 |
1488|1478 |                               HASH JOIN                      |                          | 21601 |  2911K|       |   728   (6)| 00:00:09 |
1489|1479 |                                TABLE ACCESS FULL             | BD_CUBASDOC              |  6365 |   285K|       |    52   (6)| 00:00:01 |
1490|1480 |                                HASH JOIN                     |                          | 21605 |  1941K|       |   674   (5)| 00:00:09 |
1491|1481 |                                 TABLE ACCESS FULL            | GT_INVOICE_H             | 21430 |  1004K|       |   311   (3)| 00:00:04 |
1492|1482 |                                 TABLE ACCESS FULL            | BD_CUMANDOC              | 43644 |  1875K|       |   361   (7)| 00:00:05 |
1493|1483 |                               TABLE ACCESS FULL              | GT_INVOICE_B             |  1086K|    31M|       | 13080   (4)| 00:02:37 |
1494|1484 |                           HASH GROUP BY                      |                          |  5206K|   943M|  2981M|   440K  (3)| 01:28:02 |
1495|1485 |                            HASH JOIN                         |                          |    10M|  1822M|  3632K|   149K  (4)| 00:29:59 |
1496|1486 |                             HASH JOIN                        |                          | 21598 |  3374K|       |   134K  (4)| 00:26:50 |
1497|1487 |                              TABLE ACCESS FULL               | GT_INVOICE_H             | 21430 |  1004K|       |   311   (3)| 00:00:04 |
1498|1488 |                              HASH JOIN                       |                          | 43630 |  4772K|       |   133K  (4)| 00:26:46 |
1499|1489 |                               HASH JOIN ANTI                 |                          |  6364 |   422K|       |   133K  (4)| 00:26:42 |
1500|1490 |                                TABLE ACCESS FULL             | BD_CUBASDOC              |  6365 |   285K|       |    52   (6)| 00:00:01 |
1501|1491 |                                VIEW                          |                          |   166K|  3571K|       |   133K  (4)| 00:26:41 |
1502|1492 |                                 UNION-ALL                    |                          |       |       |       |            |          |
1503|1493 |                                  HASH JOIN OUTER             |                          | 21756 |  6713K|       | 66505   (4)| 00:13:19 |
1504|1494 |                                   VIEW                       |                          |   931 |   143K|       | 26545   (4)| 00:05:19 |
1505|1495 |                                    HASH GROUP BY             |                          |   931 |   119K|       | 26545   (4)| 00:05:19 |
1506|1496 |                                     HASH JOIN                |                          |   931 |   119K|       | 26544   (4)| 00:05:19 |
1507|1497 |                                      HASH JOIN               |                          |   928 | 78880 |       | 26492   (4)| 00:05:18 |
1508|1498 |                                       TABLE ACCESS FULL      | GT_MEASURE_H             |  2510 |   139K|       | 26138   (4)| 00:05:14 |
1509|1499 |                                       TABLE ACCESS FULL      | GT_POORDER_H             | 19479 |   532K|       |   353   (3)| 00:00:05 |
1510|1500 |                                      TABLE ACCESS FULL       | BD_CUBASDOC              |  6366 |   285K|       |    52   (6)| 00:00:01 |
1511|1501 |                                   VIEW                       |                          |   148K|    22M|       | 39955   (3)| 00:08:00 |
1512|1502 |                                    HASH GROUP BY             |                          |   148K|    27M|    59M| 39955   (3)| 00:08:00 |
1513|1503 |                                     HASH JOIN                |                          |   148K|    27M|       | 33542   (4)| 00:06:43 |
1514|1504 |                                      TABLE ACCESS FULL       | BD_CUBASDOC              |  6365 |   285K|       |    52   (6)| 00:00:01 |
1515|1505 |                                      HASH JOIN               |                          |   148K|    21M|  2304K| 33484   (4)| 00:06:42 |
1516|1506 |                                       TABLE ACCESS FULL      | BD_CUMANDOC              | 43648 |  1790K|       |   360   (7)| 00:00:05 |
1517|1507 |                                       HASH JOIN              |                          |   146K|    15M|  3824K| 32165   (4)| 00:06:26 |
1518|1508 |                                        TABLE ACCESS FULL     | GT_GENERAL_H             | 68684 |  3018K|       |  1414   (3)| 00:00:17 |
1519|1509 |                                        HASH JOIN RIGHT ANTI  |                          |   165K|     9M|    32M| 29964   (4)| 00:06:00 |
1520|1510 |                                         TABLE ACCESS FULL    | GT_INVOICE_B             |  1152K|    19M|       | 13080   (4)| 00:02:37 |
1521|1511 |                                         TABLE ACCESS FULL    | GT_GENERAL_B             |  1163K|    49M|       | 11983   (4)| 00:02:24 |
1522|1512 |                                  HASH GROUP BY               |                          |   144K|    29M|    62M| 66898   (4)| 00:13:23 |
1523|1513 |                                   HASH JOIN RIGHT ANTI       |                          |   144K|    29M|       | 60039   (4)| 00:12:01 |
1524|1514 |                                    VIEW                      | VW_SQ_26                 |   931 | 19551 |       | 26493   (4)| 00:05:18 |
1525|1515 |                                     NESTED LOOPS             |                          |   931 | 91238 |       | 26493   (4)| 00:05:18 |
1526|1516 |                                      HASH JOIN               |                          |   928 | 71456 |       | 26492   (4)| 00:05:18 |
1527|1517 |                                       TABLE ACCESS FULL      | GT_MEASURE_H             |  2510 |   129K|       | 26138   (4)| 00:05:14 |
1528|1518 |                                       TABLE ACCESS FULL      | GT_POORDER_H             | 19479 |   456K|       |   353   (3)| 00:00:05 |
1529|1519 |                                      INDEX UNIQUE SCAN       | PK_BD_CUBASDOC           |     1 |    21 |       |     1   (0)| 00:00:01 |
1530|1520 |                                    HASH JOIN                 |                          |   148K|    27M|       | 33542   (4)| 00:06:43 |
1531|1521 |                                     TABLE ACCESS FULL        | BD_CUBASDOC              |  6365 |   285K|       |    52   (6)| 00:00:01 |
1532|1522 |                                     HASH JOIN                |                          |   148K|    21M|  2304K| 33484   (4)| 00:06:42 |
1533|1523 |                                      TABLE ACCESS FULL       | BD_CUMANDOC              | 43648 |  1790K|       |   360   (7)| 00:00:05 |
1534|1524 |                                      HASH JOIN               |                          |   146K|    15M|  3824K| 32165   (4)| 00:06:26 |
1535|1525 |                                       TABLE ACCESS FULL      | GT_GENERAL_H             | 68684 |  3018K|       |  1414   (3)| 00:00:17 |
1536|1526 |                                       HASH JOIN RIGHT ANTI   |                          |   165K|     9M|    32M| 29964   (4)| 00:06:00 |
1537|1527 |                                        TABLE ACCESS FULL     | GT_INVOICE_B             |  1152K|    19M|       | 13080   (4)| 00:02:37 |
1538|1528 |                                        TABLE ACCESS FULL     | GT_GENERAL_B             |  1163K|    49M|       | 11983   (4)| 00:02:24 |
1539|1529 |                               TABLE ACCESS FULL              | BD_CUMANDOC              | 43644 |  1875K|       |   361   (7)| 00:00:05 |
1540|1530 |                             TABLE ACCESS FULL                | GT_INVOICE_B             |  1086K|    31M|       | 13080   (4)| 00:02:37 |
1541|1531 |                        HASH GROUP BY                         |                          |  1251K|   204M|   454M|  1144K  (4)| 03:48:58 |
1542|1532 |                         HASH JOIN                            |                          |  1251K|   204M|       |  1097K  (4)| 03:39:28 |
1543|1533 |                          TABLE ACCESS BY INDEX ROWID         | ARAP_DJZB                | 25033 |  1344K|       |  1366   (1)| 00:00:17 |
1544|1534 |                           INDEX RANGE SCAN                   | I_ARAP_DJZB_004          | 24211 |       |       |    85   (2)| 00:00:02 |
1545|1535 |                          HASH JOIN                           |                          |  1176K|   130M|       |  1095K  (4)| 03:39:11 |
1546|1536 |                           HASH JOIN ANTI                     |                          |  6335 |   420K|       |  1064K  (4)| 03:32:56 |
1547|1537 |                            TABLE ACCESS FULL                 | BD_CUBASDOC              |  6336 |   284K|       |    66  (26)| 00:00:01 |
1548|1538 |                            VIEW                              |                          |   267M|  5620M|       |  1056K  (3)| 03:31:21 |
1549|1539 |                             UNION-ALL                        |                          |       |       |       |            |          |
1550|1540 |                              HASH JOIN OUTER                 |                          |   262M|   121G|    55M|   616K  (3)| 02:03:20 |
1551|1541 |                               VIEW                           |                          |   166K|    53M|       |   133K  (4)| 00:26:41 |
1552|1542 |                                UNION-ALL                     |                          |       |       |       |            |          |
1553|1543 |                                 HASH JOIN OUTER              |                          | 21756 |  6713K|       | 66505   (4)| 00:13:19 |
1554|1544 |                                  VIEW                        |                          |   931 |   143K|       | 26545   (4)| 00:05:19 |
1555|1545 |                                   HASH GROUP BY              |                          |   931 |   119K|       | 26545   (4)| 00:05:19 |
1556|1546 |                                    HASH JOIN                 |                          |   931 |   119K|       | 26544   (4)| 00:05:19 |
1557|1547 |                                     HASH JOIN                |                          |   928 | 78880 |       | 26492   (4)| 00:05:18 |
1558|1548 |                                      TABLE ACCESS FULL       | GT_MEASURE_H             |  2510 |   139K|       | 26138   (4)| 00:05:14 |
1559|1549 |                                      TABLE ACCESS FULL       | GT_POORDER_H             | 19479 |   532K|       |   353   (3)| 00:00:05 |
1560|1550 |                                     TABLE ACCESS FULL        | BD_CUBASDOC              |  6366 |   285K|       |    52   (6)| 00:00:01 |
1561|1551 |                                  VIEW                        |                          |   148K|    22M|       | 39955   (3)| 00:08:00 |
1562|1552 |                                   HASH GROUP BY              |                          |   148K|    27M|    59M| 39955   (3)| 00:08:00 |
1563|1553 |                                    HASH JOIN                 |                          |   148K|    27M|       | 33542   (4)| 00:06:43 |
1564|1554 |                                     TABLE ACCESS FULL        | BD_CUBASDOC              |  6365 |   285K|       |    52   (6)| 00:00:01 |
1565|1555 |                                     HASH JOIN                |                          |   148K|    21M|  2304K| 33484   (4)| 00:06:42 |
1566|1556 |                                      TABLE ACCESS FULL       | BD_CUMANDOC              | 43648 |  1790K|       |   360   (7)| 00:00:05 |
1567|1557 |                                      HASH JOIN               |                          |   146K|    15M|  3824K| 32165   (4)| 00:06:26 |
1568|1558 |                                       TABLE ACCESS FULL      | GT_GENERAL_H             | 68684 |  3018K|       |  1414   (3)| 00:00:17 |
1569|1559 |                                       HASH JOIN RIGHT ANTI   |                          |   165K|     9M|    32M| 29964   (4)| 00:06:00 |
1570|1560 |                                        TABLE ACCESS FULL     | GT_INVOICE_B             |  1152K|    19M|       | 13080   (4)| 00:02:37 |
1571|1561 |                                        TABLE ACCESS FULL     | GT_GENERAL_B             |  1163K|    49M|       | 11983   (4)| 00:02:24 |
1572|1562 |                                 HASH GROUP BY                |                          |   144K|    29M|    62M| 66898   (4)| 00:13:23 |
1573|1563 |                                  HASH JOIN RIGHT ANTI        |                          |   144K|    29M|       | 60039   (4)| 00:12:01 |
1574|1564 |                                   VIEW                       | VW_SQ_27                 |   931 | 19551 |       | 26493   (4)| 00:05:18 |
1575|1565 |                                    NESTED LOOPS              |                          |   931 | 91238 |       | 26493   (4)| 00:05:18 |
1576|1566 |                                     HASH JOIN                |                          |   928 | 71456 |       | 26492   (4)| 00:05:18 |
1577|1567 |                                      TABLE ACCESS FULL       | GT_MEASURE_H             |  2510 |   129K|       | 26138   (4)| 00:05:14 |
1578|1568 |                                      TABLE ACCESS FULL       | GT_POORDER_H             | 19479 |   456K|       |   353   (3)| 00:00:05 |
1579|1569 |                                     INDEX UNIQUE SCAN        | PK_BD_CUBASDOC           |     1 |    21 |       |     1   (0)| 00:00:01 |
1580|1570 |                                   HASH JOIN                  |                          |   148K|    27M|       | 33542   (4)| 00:06:43 |
1581|1571 |                                    TABLE ACCESS FULL         | BD_CUBASDOC              |  6365 |   285K|       |    52   (6)| 00:00:01 |
1582|1572 |                                    HASH JOIN                 |                          |   148K|    21M|  2304K| 33484   (4)| 00:06:42 |
1583|1573 |                                     TABLE ACCESS FULL        | BD_CUMANDOC              | 43648 |  1790K|       |   360   (7)| 00:00:05 |
1584|1574 |                                     HASH JOIN                |                          |   146K|    15M|  3824K| 32165   (4)| 00:06:26 |
1585|1575 |                                      TABLE ACCESS FULL       | GT_GENERAL_H             | 68684 |  3018K|       |  1414   (3)| 00:00:17 |
1586|1576 |                                      HASH JOIN RIGHT ANTI    |                          |   165K|     9M|    32M| 29964   (4)| 00:06:00 |
1587|1577 |                                       TABLE ACCESS FULL      | GT_INVOICE_B             |  1152K|    19M|       | 13080   (4)| 00:02:37 |
1588|1578 |                                       TABLE ACCESS FULL      | GT_GENERAL_B             |  1163K|    49M|       | 11983   (4)| 00:02:24 |
1589|1579 |                               VIEW                           |                          |    10M|  1515M|       |   391K  (2)| 01:18:18 |
1590|1580 |                                HASH GROUP BY                 |                          |    10M|  1611M|  3492M|   391K  (2)| 01:18:18 |
1591|1581 |                                 HASH JOIN                    |                          |    10M|  1611M|  3168K| 16451   (6)| 00:03:18 |
1592|1582 |                                  HASH JOIN                   |                          | 21601 |  2911K|       |   728   (6)| 00:00:09 |
1593|1583 |                                   TABLE ACCESS FULL          | BD_CUBASDOC              |  6365 |   285K|       |    52   (6)| 00:00:01 |
1594|1584 |                                   HASH JOIN                  |                          | 21605 |  1941K|       |   674   (5)| 00:00:09 |
1595|1585 |                                    TABLE ACCESS FULL         | GT_INVOICE_H             | 21430 |  1004K|       |   311   (3)| 00:00:04 |
1596|1586 |                                    TABLE ACCESS FULL         | BD_CUMANDOC              | 43644 |  1875K|       |   361   (7)| 00:00:05 |
1597|1587 |                                  TABLE ACCESS FULL           | GT_INVOICE_B             |  1086K|    31M|       | 13080   (4)| 00:02:37 |
1598|1588 |                              HASH GROUP BY                   |                          |  5206K|   943M|  2981M|   440K  (3)| 01:28:02 |
1599|1589 |                               HASH JOIN                      |                          |    10M|  1822M|  3632K|   149K  (4)| 00:29:59 |
1600|1590 |                                HASH JOIN                     |                          | 21598 |  3374K|       |   134K  (4)| 00:26:50 |
1601|1591 |                                 TABLE ACCESS FULL            | GT_INVOICE_H             | 21430 |  1004K|       |   311   (3)| 00:00:04 |
1602|1592 |                                 HASH JOIN                    |                          | 43630 |  4772K|       |   133K  (4)| 00:26:46 |
1603|1593 |                                  HASH JOIN ANTI              |                          |  6364 |   422K|       |   133K  (4)| 00:26:42 |
1604|1594 |                                   TABLE ACCESS FULL          | BD_CUBASDOC              |  6365 |   285K|       |    52   (6)| 00:00:01 |
1605|1595 |                                   VIEW                       |                          |   166K|  3571K|       |   133K  (4)| 00:26:41 |
1606|1596 |                                    UNION-ALL                 |                          |       |       |       |            |          |
1607|1597 |                                     HASH JOIN OUTER          |                          | 21756 |  6713K|       | 66505   (4)| 00:13:19 |
1608|1598 |                                      VIEW                    |                          |   931 |   143K|       | 26545   (4)| 00:05:19 |
1609|1599 |                                       HASH GROUP BY          |                          |   931 |   119K|       | 26545   (4)| 00:05:19 |
1610|1600 |                                        HASH JOIN             |                          |   931 |   119K|       | 26544   (4)| 00:05:19 |
1611|1601 |                                         HASH JOIN            |                          |   928 | 78880 |       | 26492   (4)| 00:05:18 |
1612|1602 |                                          TABLE ACCESS FULL   | GT_MEASURE_H             |  2510 |   139K|       | 26138   (4)| 00:05:14 |
1613|1603 |                                          TABLE ACCESS FULL   | GT_POORDER_H             | 19479 |   532K|       |   353   (3)| 00:00:05 |
1614|1604 |                                         TABLE ACCESS FULL    | BD_CUBASDOC              |  6366 |   285K|       |    52   (6)| 00:00:01 |
1615|1605 |                                      VIEW                    |                          |   148K|    22M|       | 39955   (3)| 00:08:00 |
1616|1606 |                                       HASH GROUP BY          |                          |   148K|    27M|    59M| 39955   (3)| 00:08:00 |
1617|1607 |                                        HASH JOIN             |                          |   148K|    27M|       | 33542   (4)| 00:06:43 |
1618|1608 |                                         TABLE ACCESS FULL    | BD_CUBASDOC              |  6365 |   285K|       |    52   (6)| 00:00:01 |
1619|1609 |                                         HASH JOIN            |                          |   148K|    21M|  2304K| 33484   (4)| 00:06:42 |
1620|1610 |                                          TABLE ACCESS FULL   | BD_CUMANDOC              | 43648 |  1790K|       |   360   (7)| 00:00:05 |
1621|1611 |                                          HASH JOIN           |                          |   146K|    15M|  3824K| 32165   (4)| 00:06:26 |
1622|1612 |                                           TABLE ACCESS FULL  | GT_GENERAL_H             | 68684 |  3018K|       |  1414   (3)| 00:00:17 |
1623|1613 | TI                                        HASH JOIN RIGHT AN |                          |   165K|     9M|    32M| 29964   (4)| 00:06:00 |
1624|1614 |                                            TABLE ACCESS FULL | GT_INVOICE_B             |  1152K|    19M|       | 13080   (4)| 00:02:37 |
1625|1615 |                                            TABLE ACCESS FULL | GT_GENERAL_B             |  1163K|    49M|       | 11983   (4)| 00:02:24 |
1626|1616 |                                     HASH GROUP BY            |                          |   144K|    29M|    62M| 66898   (4)| 00:13:23 |
1627|1617 |                                      HASH JOIN RIGHT ANTI    |                          |   144K|    29M|       | 60039   (4)| 00:12:01 |
1628|1618 |                                       VIEW                   | VW_SQ_28                 |   931 | 19551 |       | 26493   (4)| 00:05:18 |
1629|1619 |                                        NESTED LOOPS          |                          |   931 | 91238 |       | 26493   (4)| 00:05:18 |
1630|1620 |                                         HASH JOIN            |                          |   928 | 71456 |       | 26492   (4)| 00:05:18 |
1631|1621 |                                          TABLE ACCESS FULL   | GT_MEASURE_H             |  2510 |   129K|       | 26138   (4)| 00:05:14 |
1632|1622 |                                          TABLE ACCESS FULL   | GT_POORDER_H             | 19479 |   456K|       |   353   (3)| 00:00:05 |
1633|1623 |                                         INDEX UNIQUE SCAN    | PK_BD_CUBASDOC           |     1 |    21 |       |     1   (0)| 00:00:01 |
1634|1624 |                                       HASH JOIN              |                          |   148K|    27M|       | 33542   (4)| 00:06:43 |
1635|1625 |                                        TABLE ACCESS FULL     | BD_CUBASDOC              |  6365 |   285K|       |    52   (6)| 00:00:01 |
1636|1626 |                                        HASH JOIN             |                          |   148K|    21M|  2304K| 33484   (4)| 00:06:42 |
1637|1627 |                                         TABLE ACCESS FULL    | BD_CUMANDOC              | 43648 |  1790K|       |   360   (7)| 00:00:05 |
1638|1628 |                                         HASH JOIN            |                          |   146K|    15M|  3824K| 32165   (4)| 00:06:26 |
1639|1629 |                                          TABLE ACCESS FULL   | GT_GENERAL_H             | 68684 |  3018K|       |  1414   (3)| 00:00:17 |
1640|1630 | I                                        HASH JOIN RIGHT ANT |                          |   165K|     9M|    32M| 29964   (4)| 00:06:00 |
1641|1631 |                                           TABLE ACCESS FULL  | GT_INVOICE_B             |  1152K|    19M|       | 13080   (4)| 00:02:37 |
1642|1632 |                                           TABLE ACCESS FULL  | GT_GENERAL_B             |  1163K|    49M|       | 11983   (4)| 00:02:24 |
1643|1633 |                                  TABLE ACCESS FULL           | BD_CUMANDOC              | 43644 |  1875K|       |   361   (7)| 00:00:05 |
1644|1634 |                                TABLE ACCESS FULL             | GT_INVOICE_B             |  1086K|    31M|       | 13080   (4)| 00:02:37 |
1645|1635 |                           TABLE ACCESS FULL                  | ARAP_DJFB                |  1178K|    53M|       | 31199   (4)| 00:06:15 |
1646|1636 |                     HASH GROUP BY                            |                          |  1221 |   251K|       |    11M (27)| 39:30:43 |
1647|1637 |                      HASH JOIN                               |                          |  1221 |   251K|       |    11M (27)| 39:30:43 |
1648|1638 |                       TABLE ACCESS BY INDEX ROWID            | PO_INVOICE_B             |    10 |   460 |       |     2   (0)| 00:00:01 |
1649|1639 |                        NESTED LOOPS                          |                          |  1221 |   226K|       |    11M (27)| 39:30:40 |
1650|1640 |                         HASH JOIN ANTI                       |                          |   127 | 18288 |       |    11M (27)| 39:30:37 |
1651|1641 |                          NESTED LOOPS                        |                          |   127 | 15494 |       |   271   (3)| 00:00:04 |
1652|1642 |                           TABLE ACCESS FULL                  | PO_INVOICE               |   127 | 10668 |       |   220   (3)| 00:00:03 |
1653|1643 |                           TABLE ACCESS BY INDEX ROWID        | BD_CUBASDOC              |     1 |    38 |       |     1   (0)| 00:00:01 |
1654|1644 |                            INDEX UNIQUE SCAN                 | PK_BD_CUBASDOC           |     1 |       |       |     1   (0)| 00:00:01 |
1655|1645 |                          VIEW                                |                          |    52G|  1079G|       |    10M (16)| 34:23:30 |
1656|1646 |                           UNION-ALL                          |                          |       |       |       |            |          |
1657|1647 |                            HASH JOIN RIGHT OUTER             |                          |    52G|    31T|   202M|  9172K (18)| 30:34:32 |
1658|1648 |                             VIEW                             |                          |  1251K|   188M|       | 74342   (3)| 00:14:53 |
1659|1649 |                              HASH GROUP BY                   |                          |  1251K|   177M|   407M| 74342   (3)| 00:14:53 |
1660|1650 |                               HASH JOIN                      |                          |  1251K|   177M|       | 32704   (4)| 00:06:33 |
1661|1651 |                                TABLE ACCESS BY INDEX ROWID   | AR
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值