|
Зависший запрос
#39860831
Ссылка:
Ссылка на сообщение:
Ссылка с названием темы:
|
|
|
|
Всем здрасьте!
Есть тут спецы, кто навскидку скажет, где проблема?
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
30.
31.
32.
33.
34.
35.
36.
37.
38.
39.
40.
41.
42.
43.
44.
45.
46.
47.
48.
49.
50.
51.
52.
53.
54.
55.
56.
57.
58.
59.
60.
61.
62.
63.
64.
65.
66.
67.
68.
69.
70.
71.
72.
73.
74.
75.
76.
77.
78.
79.
80.
81.
82.
83.
84.
85.
86.
87.
88.
89.
90.
91.
92.
93.
94.
95.
96.
97.
98.
99.
100.
101.
102.
103.
104.
105.
106.
107.
108.
109.
110.
111.
112.
113.
114.
115.
116.
117.
118.
119.
120.
121.
122.
123.
124.
125.
126.
127.
128.
129.
130.
131.
132.
133.
134.
135.
136.
137.
138.
139.
140.
141.
142.
143.
144.
145.
146.
147.
148.
149.
150.
151.
152.
153.
154.
155.
156.
157.
158.
159.
160.
161.
162.
163.
164.
165.
166.
167.
168.
169.
170.
171.
172.
173.
174.
175.
176.
177.
178.
179.
180.
181.
182.
183.
184.
185.
186.
187.
188.
189.
190.
191.
192.
193.
194.
195.
196.
197.
198.
199.
200.
201.
202.
203.
204.
205.
206.
207.
208.
209.
210.
211.
212.
213.
214.
215.
216.
217.
218.
219.
220.
221.
222.
223.
224.
225.
226.
227.
228.
229.
230.
231.
232.
233.
234.
235.
236.
237.
238.
239.
240.
241.
242.
243.
244.
245.
246.
247.
248.
249.
250.
251.
252.
253.
254.
255.
256.
257.
258.
259.
260.
261.
262.
263.
264.
265.
266.
267.
268.
269.
270.
271.
272.
273.
274.
275.
276.
277.
278.
279.
280.
281.
282.
283.
284.
285.
286.
287.
288.
289.
290.
291.
292.
293.
294.
295.
296.
297.
298.
299.
300.
301.
302.
303.
304.
305.
306.
307.
308.
309.
310.
311.
312.
313.
314.
315.
316.
317.
318.
319.
320.
321.
322.
323.
324.
325.
326.
327.
328.
329.
330.
331.
332.
333.
334.
335.
336.
337.
338.
339.
340.
341.
342.
343.
344.
345.
346.
347.
348.
349.
350.
351.
352.
353.
354.
355.
356.
357.
358.
359.
360.
361.
362.
363.
364.
365.
366.
367.
368.
369.
370.
371.
372.
373.
374.
375.
376.
377.
378.
379.
380.
381.
382.
383.
384.
385.
386.
387.
388.
389.
390.
391.
392.
393.
394.
395.
396.
397.
398.
399.
400.
401.
402.
403.
404.
405.
406.
407.
408.
409.
410.
411.
412.
413.
414.
415.
416.
417.
418.
419.
420.
421.
422.
423.
424.
425.
426.
427.
428.
429.
430.
431.
432.
433.
434.
435.
436.
437.
438.
439.
440.
441.
442.
443.
444.
445.
446.
447.
448.
449.
450.
451.
452.
453.
454.
455.
456.
457.
458.
459.
460.
461.
462.
463.
464.
465.
466.
467.
468.
469.
470.
471.
472.
473.
474.
475.
476.
477.
478.
479.
480.
481.
482.
483.
484.
485.
486.
487.
488.
489.
490.
491.
492.
493.
494.
495.
496.
497.
498.
499.
500.
501.
502.
503.
504.
505.
506.
507.
508.
509.
510.
511.
512.
513.
514.
515.
516.
517.
518.
519.
520.
521.
522.
523.
524.
525.
526.
527.
528.
529.
530.
531.
532.
533.
534.
535.
536.
537.
538.
539.
540.
541.
542.
543.
544.
545.
546.
547.
548.
549.
550.
551.
552.
553.
554.
555.
556.
557.
558.
559.
560.
561.
562.
563.
564.
565.
566.
567.
568.
569.
570.
571.
572.
573.
574.
575.
576.
577.
578.
579.
580.
581.
582.
583.
584.
585.
586.
587.
588.
589.
590.
591.
592.
593.
594.
595.
596.
--------------------------------------------------------------------------------------------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes |TempSpc| Cost (%CPU)| Time | Pstart| Pstop |
--------------------------------------------------------------------------------------------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 1022 | 174K| | 447K (1)| 00:00:18 | | |
| 1 | WINDOW SORT | | 1022 | 174K| | 447K (1)| 00:00:18 | | |
| 2 | WINDOW SORT | | 1022 | 174K| | 447K (1)| 00:00:18 | | |
| 3 | WINDOW SORT | | 1022 | 174K| | 447K (1)| 00:00:18 | | |
| 4 | VIEW | | 1022 | 174K| | 447K (1)| 00:00:18 | | |
| 5 | UNION-ALL | | | | | | | | |
| 6 | VIEW | | 1 | 314 | | 167 (3)| 00:00:01 | | |
| 7 | TEMP TABLE TRANSFORMATION | | | | | | | | |
| 8 | LOAD AS SELECT | SYS_TEMP_0FD9E24AC_42F6F019 | | | | | | | |
|* 9 | VIEW | | 1 | 80 | | 5 (0)| 00:00:01 | | |
|* 10 | WINDOW NOSORT STOPKEY | | 4 | 108 | | 5 (0)| 00:00:01 | | |
| 11 | TABLE ACCESS BY INDEX ROWID | VIP_OG_CYCLE_SUMMARY | 4 | 108 | | 5 (0)| 00:00:01 | | |
|* 12 | INDEX RANGE SCAN DESCENDING | VIP_OG_CYCLE_SUMMARY_PK | 4 | | | 1 (0)| 00:00:01 | | |
| 13 | LOAD AS SELECT | SYS_TEMP_0FD9E24AD_42F6F019 | | | | | | | |
| 14 | NESTED LOOPS | | 4 | 2472 | | 54 (0)| 00:00:01 | | |
| 15 | NESTED LOOPS | | 110 | 2472 | | 54 (0)| 00:00:01 | | |
| 16 | NESTED LOOPS OUTER | | 1 | 130 | | 15 (0)| 00:00:01 | | |
| 17 | NESTED LOOPS | | 1 | 94 | | 14 (0)| 00:00:01 | | |
|* 18 | HASH JOIN OUTER | | 1 | 58 | | 5 (0)| 00:00:01 | | |
|* 19 | VIEW | | 1 | 31 | | 2 (0)| 00:00:01 | | |
| 20 | TABLE ACCESS FULL | SYS_TEMP_0FD9E24AC_42F6F019 | 1 | 31 | | 2 (0)| 00:00:01 | | |
| 21 | VIEW | | 1 | 27 | | 3 (0)| 00:00:01 | | |
|* 22 | VIEW | | 1 | 40 | | 3 (0)| 00:00:01 | | |
|* 23 | WINDOW NOSORT STOPKEY | | 1 | 29 | | 3 (0)| 00:00:01 | | |
| 24 | SORT GROUP BY NOSORT | | 1 | 29 | | 3 (0)| 00:00:01 | | |
| 25 | VIEW | | 2 | 58 | | 3 (0)| 00:00:01 | | |
| 26 | NESTED LOOPS | | 2 | 92 | | 3 (0)| 00:00:01 | | |
|* 27 | VIEW | | 1 | 27 | | 2 (0)| 00:00:01 | | |
| 28 | TABLE ACCESS FULL | SYS_TEMP_0FD9E24AC_42F6F019 | 1 | 31 | | 2 (0)| 00:00:01 | | |
|* 29 | INDEX RANGE SCAN | VIP_OG_CYCLE_SUMMARY_PK | 2 | 38 | | 1 (0)| 00:00:01 | | |
| 30 | TABLE ACCESS BY INDEX ROWID BATCHED | VIP_OG_CYCLE_COMPANY_SUMMARY | 1 | 36 | | 9 (0)| 00:00:01 | | |
|* 31 | INDEX RANGE SCAN | VIP_OG_COMPANY_CYCLE_SUM_PK | 1 | | | 8 (0)| 00:00:01 | | |
| 32 | TABLE ACCESS BY INDEX ROWID | VIP_OG_CYCLE_COMPANY_SUMMARY | 1 | 36 | | 1 (0)| 00:00:01 | | |
|* 33 | INDEX UNIQUE SCAN | VIP_OG_COMPANY_CYCLE_SUM_PK | 1 | | | 0 (0)| 00:00:01 | | |
|* 34 | INDEX RANGE SCAN | VIP_OG_CYCLE_PK | 110 | | | 3 (0)| 00:00:01 | | |
|* 35 | TABLE ACCESS BY INDEX ROWID | VIP_OG_CYCLE | 3 | 1464 | | 39 (0)| 00:00:01 | | |
| 36 | LOAD AS SELECT | SYS_TEMP_0FD9E24AE_42F6F019 | | | | | | | |
| 37 | WINDOW SORT | | 1 | 3283 | | 101 (4)| 00:00:01 | | |
| 38 | WINDOW SORT | | 1 | 3283 | | 101 (4)| 00:00:01 | | |
| 39 | NESTED LOOPS | | 1 | 3283 | | 97 (3)| 00:00:01 | | |
| 40 | NESTED LOOPS | | 1 | 3283 | | 97 (3)| 00:00:01 | | |
|* 41 | HASH JOIN | | 1 | 3054 | | 95 (3)| 00:00:01 | | |
| 42 | JOIN FILTER CREATE | :BF0000 | 1 | 2616 | | 92 (2)| 00:00:01 | | |
|* 43 | HASH JOIN | | 1 | 2616 | | 92 (2)| 00:00:01 | | |
| 44 | MERGE JOIN CARTESIAN | | 1 | 2416 | | 4 (0)| 00:00:01 | | |
|* 45 | TABLE ACCESS BY INDEX ROWID BATCHED | EPP_CARRIER_INFO | 1 | 33 | | 2 (0)| 00:00:01 | | |
|* 46 | INDEX RANGE SCAN | EPP_CARRIER_INFO_PK | 1 | | | 1 (0)| 00:00:01 | | |
| 47 | SORT AGGREGATE | | 1 | 25 | | | | | |
|* 48 | TABLE ACCESS BY INDEX ROWID BATCHED | EPP_CARRIER_INFO | 1 | 25 | | 2 (0)| 00:00:01 | | |
|* 49 | INDEX RANGE SCAN | EPP_CARRIER_INFO_PK | 1 | | | 1 (0)| 00:00:01 | | |
| 50 | BUFFER SORT | | 6 | 14298 | | 2 (0)| 00:00:01 | | |
|* 51 | VIEW | | 6 | 14298 | | 2 (0)| 00:00:01 | | |
| 52 | TABLE ACCESS FULL | SYS_TEMP_0FD9E24AD_42F6F019 | 6 | 3708 | | 2 (0)| 00:00:01 | | |
|* 53 | VIEW | | 635 | 124K| | 88 (2)| 00:00:01 | | |
| 54 | WINDOW SORT | | 635 | 114K| | 88 (2)| 00:00:01 | | |
|* 55 | HASH JOIN OUTER | | 635 | 114K| | 88 (2)| 00:00:01 | | |
|* 56 | HASH JOIN | | 622 | 65310 | | 79 (0)| 00:00:01 | | |
|* 57 | TABLE ACCESS FULL | COMPANY_DETAIL | 616 | 13552 | | 8 (0)| 00:00:01 | | |
| 58 | TABLE ACCESS FULL | COMPANY | 1150 | 95450 | | 71 (0)| 00:00:01 | | |
| 59 | VIEW | | 1141 | 90139 | | 9 (12)| 00:00:01 | | |
|* 60 | VIEW | | 1141 | 104K| | 9 (12)| 00:00:01 | | |
| 61 | WINDOW SORT | | 1141 | 70742 | | 9 (12)| 00:00:01 | | |
| 62 | TABLE ACCESS FULL | CONTACT | 1141 | 70742 | | 8 (0)| 00:00:01 | | |
| 63 | VIEW | | 3 | 1314 | | 3 (34)| 00:00:01 | | |
| 64 | HASH GROUP BY | | 3 | 1314 | | 3 (34)| 00:00:01 | | |
|* 65 | VIEW | | 6 | 2628 | | 2 (0)| 00:00:01 | | |
| 66 | JOIN FILTER USE | :BF0000 | 6 | 3708 | | 2 (0)| 00:00:01 | | |
|* 67 | TABLE ACCESS FULL | SYS_TEMP_0FD9E24AD_42F6F019 | 6 | 3708 | | 2 (0)| 00:00:01 | | |
|* 68 | INDEX UNIQUE SCAN | VIP_OG_CYCLE_CHG_INDS_PK | 1 | | | 1 (0)| 00:00:01 | | |
| 69 | TABLE ACCESS BY INDEX ROWID | VIP_OG_CYCLE_CHG_INDS | 1 | 229 | | 2 (0)| 00:00:01 | | |
|* 70 | HASH JOIN ANTI | | 1 | 386 | | 7 (15)| 00:00:01 | | |
|* 71 | HASH JOIN OUTER | | 1 | 348 | | 5 (20)| 00:00:01 | | |
|* 72 | VIEW | | 1 | 334 | | 2 (0)| 00:00:01 | | |
| 73 | TABLE ACCESS FULL | SYS_TEMP_0FD9E24AE_42F6F019 | 1 | 3283 | | 2 (0)| 00:00:01 | | |
| 74 | VIEW | | 1 | 14 | | 3 (34)| 00:00:01 | | |
| 75 | SORT GROUP BY | | 1 | 20 | | 3 (34)| 00:00:01 | | |
| 76 | VIEW | | 1 | 20 | | 3 (34)| 00:00:01 | | |
| 77 | HASH UNIQUE | | 1 | 19 | | 3 (34)| 00:00:01 | | |
| 78 | VIEW | | 1 | 19 | | 2 (0)| 00:00:01 | | |
| 79 | TABLE ACCESS FULL | SYS_TEMP_0FD9E24AE_42F6F019 | 1 | 3283 | | 2 (0)| 00:00:01 | | |
|* 80 | VIEW | | 1 | 38 | | 2 (0)| 00:00:01 | | |
|* 81 | WINDOW NOSORT | | 1 | 100 | | 2 (0)| 00:00:01 | | |
| 82 | NESTED LOOPS | | 1 | 100 | | 2 (0)| 00:00:01 | | |
| 83 | NESTED LOOPS | | 1 | 100 | | 2 (0)| 00:00:01 | | |
| 84 | NESTED LOOPS | | 1 | 68 | | 1 (0)| 00:00:01 | | |
| 85 | TABLE ACCESS BY INDEX ROWID | COMPANY_CARRIER_CONFIG | 1 | 43 | | 0 (0)| 00:00:01 | | |
|* 86 | INDEX RANGE SCAN | COMPANY_CARRIER_CONFIG_PK | 1 | | | 0 (0)| 00:00:01 | | |
| 87 | TABLE ACCESS BY INDEX ROWID | COMPANY_PLAN_DETAIL | 1 | 25 | | 1 (0)| 00:00:01 | | |
|* 88 | INDEX UNIQUE SCAN | COMPANY_PLAN_DETAIL_PK | 1 | | | 0 (0)| 00:00:01 | | |
|* 89 | INDEX UNIQUE SCAN | VIP_OG_COMPANY_CYCLE_SUM_PK | 1 | | | 0 (0)| 00:00:01 | | |
| 90 | SORT AGGREGATE | | 1 | 19 | | | | | |
| 91 | FIRST ROW | | 1 | 19 | | 1 (0)| 00:00:01 | | |
|* 92 | INDEX RANGE SCAN (MIN/MAX) | VIP_OG_CYCLE_SUMMARY_PK | 1 | 19 | | 1 (0)| 00:00:01 | | |
|* 93 | TABLE ACCESS BY INDEX ROWID | VIP_OG_CYCLE_COMPANY_SUMMARY | 1 | 32 | | 1 (0)| 00:00:01 | | |
| 94 | VIEW | | 1020 | 3020K| | 446K (1)| 00:00:18 | | |
| 95 | TEMP TABLE TRANSFORMATION | | | | | | | | |
| 96 | LOAD AS SELECT | SYS_TEMP_0FD9E24AF_42F6F019 | | | | | | | |
|* 97 | VIEW | | 1 | 80 | | 5 (0)| 00:00:01 | | |
|* 98 | WINDOW NOSORT STOPKEY | | 4 | 108 | | 5 (0)| 00:00:01 | | |
| 99 | TABLE ACCESS BY INDEX ROWID | VIP_OG_CYCLE_SUMMARY | 4 | 108 | | 5 (0)| 00:00:01 | | |
|*100 | INDEX RANGE SCAN DESCENDING | VIP_OG_CYCLE_SUMMARY_PK | 4 | | | 1 (0)| 00:00:01 | | |
| 101 | LOAD AS SELECT | SYS_TEMP_0FD9E24B0_42F6F019 | | | | | | | |
| 102 | NESTED LOOPS OUTER | | 1 | 130 | | 15 (0)| 00:00:01 | | |
| 103 | NESTED LOOPS | | 1 | 94 | | 14 (0)| 00:00:01 | | |
|*104 | HASH JOIN OUTER | | 1 | 58 | | 5 (0)| 00:00:01 | | |
| 105 | VIEW | | 1 | 31 | | 2 (0)| 00:00:01 | | |
| 106 | TABLE ACCESS FULL | SYS_TEMP_0FD9E24AF_42F6F019 | 1 | 31 | | 2 (0)| 00:00:01 | | |
| 107 | VIEW | | 1 | 27 | | 3 (0)| 00:00:01 | | |
|*108 | VIEW | | 1 | 40 | | 3 (0)| 00:00:01 | | |
|*109 | WINDOW NOSORT STOPKEY | | 1 | 29 | | 3 (0)| 00:00:01 | | |
| 110 | SORT GROUP BY NOSORT | | 1 | 29 | | 3 (0)| 00:00:01 | | |
| 111 | VIEW | | 2 | 58 | | 3 (0)| 00:00:01 | | |
| 112 | NESTED LOOPS | | 2 | 92 | | 3 (0)| 00:00:01 | | |
|*113 | VIEW | | 1 | 27 | | 2 (0)| 00:00:01 | | |
| 114 | TABLE ACCESS FULL | SYS_TEMP_0FD9E24AF_42F6F019 | 1 | 31 | | 2 (0)| 00:00:01 | | |
|*115 | INDEX RANGE SCAN | VIP_OG_CYCLE_SUMMARY_PK | 2 | 38 | | 1 (0)| 00:00:01 | | |
| 116 | TABLE ACCESS BY INDEX ROWID BATCHED | VIP_OG_CYCLE_COMPANY_SUMMARY | 1 | 36 | | 9 (0)| 00:00:01 | | |
|*117 | INDEX RANGE SCAN | VIP_OG_COMPANY_CYCLE_SUM_PK | 1 | | | 8 (0)| 00:00:01 | | |
| 118 | TABLE ACCESS BY INDEX ROWID | VIP_OG_CYCLE_COMPANY_SUMMARY | 1 | 36 | | 1 (0)| 00:00:01 | | |
|*119 | INDEX UNIQUE SCAN | VIP_OG_COMPANY_CYCLE_SUM_PK | 1 | | | 0 (0)| 00:00:01 | | |
| 120 | LOAD AS SELECT | SYS_TEMP_0FD9E24B1_42F6F019 | | | | | | | |
| 121 | NESTED LOOPS | | 6 | 3498 | | 197 (0)| 00:00:01 | | |
| 122 | NESTED LOOPS | | 550 | 3498 | | 197 (0)| 00:00:01 | | |
|*123 | VIEW | | 5 | 475 | | 2 (0)| 00:00:01 | | |
| 124 | TABLE ACCESS FULL | SYS_TEMP_0FD9E24B0_42F6F019 | 5 | 280 | | 2 (0)| 00:00:01 | | |
|*125 | INDEX RANGE SCAN | VIP_OG_CYCLE_PK | 110 | | | 3 (0)| 00:00:01 | | |
|*126 | TABLE ACCESS BY INDEX ROWID | VIP_OG_CYCLE | 1 | 488 | | 39 (0)| 00:00:01 | | |
| 127 | LOAD AS SELECT | SYS_TEMP_0FD9E24B2_42F6F019 | | | | | | | |
| 128 | HASH UNIQUE | | 16 | 640 | | 3 (34)| 00:00:01 | | |
| 129 | VIEW | | 16 | 640 | | 2 (0)| 00:00:01 | | |
| 130 | TABLE ACCESS FULL | SYS_TEMP_0FD9E24B1_42F6F019 | 16 | 9328 | | 2 (0)| 00:00:01 | | |
| 131 | LOAD AS SELECT | SYS_TEMP_0FD9E24B3_42F6F019 | | | | | | | |
| 132 | HASH UNIQUE | | 16 | 1328 | | 7 (15)| 00:00:01 | | |
|*133 | HASH JOIN | | 16 | 1328 | | 6 (0)| 00:00:01 | | |
| 134 | VIEW | | 16 | 976 | | 2 (0)| 00:00:01 | | |
| 135 | TABLE ACCESS FULL | SYS_TEMP_0FD9E24B1_42F6F019 | 16 | 9328 | | 2 (0)| 00:00:01 | | |
| 136 | TABLE ACCESS FULL | BENEFIT | 51 | 1122 | | 4 (0)| 00:00:01 | | |
| 137 | LOAD AS SELECT | SYS_TEMP_0FD9E24B4_42F6F019 | | | | | | | |
| 138 | TABLE ACCESS BY INDEX ROWID BATCHED | VAL_TABLE_DETAIL | 7 | 294 | | 3 (0)| 00:00:01 | | |
|*139 | INDEX RANGE SCAN | VAL_TABLE_DETAIL_IDX2 | 7 | | | 2 (0)| 00:00:01 | | |
| 140 | LOAD AS SELECT | SYS_TEMP_0FD9E24B5_42F6F019 | | | | | | | |
|*141 | TABLE ACCESS FULL | COMPANY_SALARY_RULE | 1158 | 79902 | | 22 (0)| 00:00:01 | | |
| 142 | LOAD AS SELECT | SYS_TEMP_0FD9E24B6_42F6F019 | | | | | | | |
|*143 | HASH JOIN ANTI | | 1 | 5757 | | 445K (1)| 00:00:18 | | |
|*144 | HASH JOIN OUTER | | 1 | 5719 | | 445K (1)| 00:00:18 | | |
|*145 | HASH JOIN OUTER | | 1 | 5658 | | 564 (2)| 00:00:01 | | |
|*146 | HASH JOIN OUTER | | 1 | 5589 | | 114 (6)| 00:00:01 | | |
|*147 | HASH JOIN OUTER | | 1 | 5534 | | 106 (5)| 00:00:01 | | |
| 148 | VIEW | | 1 | 5267 | | 101 (4)| 00:00:01 | | |
| 149 | WINDOW SORT | | 1 | 3283 | | 101 (4)| 00:00:01 | | |
| 150 | WINDOW SORT | | 1 | 3283 | | 101 (4)| 00:00:01 | | |
| 151 | NESTED LOOPS | | 1 | 3283 | | 97 (3)| 00:00:01 | | |
| 152 | NESTED LOOPS | | 1 | 3283 | | 97 (3)| 00:00:01 | | |
|*153 | HASH JOIN | | 1 | 3054 | | 95 (3)| 00:00:01 | | |
|*154 | HASH JOIN | | 3 | 7848 | | 92 (2)| 00:00:01 | | |
| 155 | MERGE JOIN CARTESIAN | | 3 | 7248 | | 4 (0)| 00:00:01 | | |
|*156 | TABLE ACCESS BY INDEX ROWID BATCHED | EPP_CARRIER_INFO | 1 | 33 | | 2 (0)| 00:00:01 | | |
|*157 | INDEX RANGE SCAN | EPP_CARRIER_INFO_PK | 1 | | | 1 (0)| 00:00:01 | | |
| 158 | SORT AGGREGATE | | 1 | 25 | | | | | |
|*159 | TABLE ACCESS BY INDEX ROWID BATCHED| EPP_CARRIER_INFO | 1 | 25 | | 2 (0)| 00:00:01 | | |
|*160 | INDEX RANGE SCAN | EPP_CARRIER_INFO_PK | 1 | | | 1 (0)| 00:00:01 | | |
| 161 | BUFFER SORT | | 16 | 38128 | | 2 (0)| 00:00:01 | | |
|*162 | VIEW | | 16 | 38128 | | 2 (0)| 00:00:01 | | |
| 163 | TABLE ACCESS FULL | SYS_TEMP_0FD9E24B1_42F6F019 | 16 | 9328 | | 2 (0)| 00:00:01 | | |
|*164 | VIEW | | 635 | 124K| | 88 (2)| 00:00:01 | | |
| 165 | WINDOW SORT | | 635 | 114K| | 88 (2)| 00:00:01 | | |
|*166 | HASH JOIN OUTER | | 635 | 114K| | 88 (2)| 00:00:01 | | |
|*167 | HASH JOIN | | 622 | 65310 | | 79 (0)| 00:00:01 | | |
|*168 | TABLE ACCESS FULL | COMPANY_DETAIL | 616 | 13552 | | 8 (0)| 00:00:01 | | |
| 169 | TABLE ACCESS FULL | COMPANY | 1150 | 95450 | | 71 (0)| 00:00:01 | | |
| 170 | VIEW | | 1141 | 90139 | | 9 (12)| 00:00:01 | | |
|*171 | VIEW | | 1141 | 104K| | 9 (12)| 00:00:01 | | |
| 172 | WINDOW SORT | | 1141 | 70742 | | 9 (12)| 00:00:01 | | |
| 173 | TABLE ACCESS FULL | CONTACT | 1141 | 70742 | | 8 (0)| 00:00:01 | | |
| 174 | VIEW | | 3 | 1314 | | 3 (34)| 00:00:01 | | |
| 175 | HASH GROUP BY | | 3 | 1314 | | 3 (34)| 00:00:01 | | |
|*176 | VIEW | | 16 | 7008 | | 2 (0)| 00:00:01 | | |
| 177 | TABLE ACCESS FULL | SYS_TEMP_0FD9E24B1_42F6F019 | 16 | 9328 | | 2 (0)| 00:00:01 | | |
|*178 | INDEX UNIQUE SCAN | VIP_OG_CYCLE_CHG_INDS_PK | 1 | | | 1 (0)| 00:00:01 | | |
| 179 | TABLE ACCESS BY INDEX ROWID | VIP_OG_CYCLE_CHG_INDS | 1 | 229 | | 2 (0)| 00:00:01 | | |
| 180 | VIEW | | 1 | 267 | | 5 (20)| 00:00:01 | | |
| 181 | VIEW | | 1 | 267 | | 5 (20)| 00:00:01 | | |
|*182 | HASH JOIN | | 1 | 547 | | 5 (20)| 00:00:01 | | |
| 183 | VIEW | | 7 | 1960 | | 2 (0)| 00:00:01 | | |
| 184 | TABLE ACCESS FULL | SYS_TEMP_0FD9E24B4_42F6F019 | 7 | 273 | | 2 (0)| 00:00:01 | | |
| 185 | VIEW | | 7 | 1869 | | 3 (34)| 00:00:01 | | |
| 186 | HASH GROUP BY | | 7 | 189 | | 3 (34)| 00:00:01 | | |
| 187 | VIEW | | 7 | 189 | | 2 (0)| 00:00:01 | | |
| 188 | TABLE ACCESS FULL | SYS_TEMP_0FD9E24B4_42F6F019 | 7 | 273 | | 2 (0)| 00:00:01 | | |
| 189 | VIEW | | 1 | 55 | | 8 (13)| 00:00:01 | | |
| 190 | VIEW | | 1 | 55 | | 8 (13)| 00:00:01 | | |
| 191 | HASH GROUP BY PIVOT | | 1 | 38 | | 8 (13)| 00:00:01 | | |
| 192 | VIEW | | 1 | 38 | | 8 (13)| 00:00:01 | | |
|*193 | VIEW | | 1 | 61 | | 8 (13)| 00:00:01 | | |
|*194 | WINDOW SORT PUSHED RANK | | 1 | 57 | | 8 (13)| 00:00:01 | | |
| 195 | VIEW | | 1 | 57 | | 7 (0)| 00:00:01 | | |
|*196 | HASH JOIN | | 1 | 89 | | 7 (0)| 00:00:01 | | |
| 197 | VIEW | | 5 | 135 | | 2 (0)| 00:00:01 | | |
| 198 | TABLE ACCESS FULL | SYS_TEMP_0FD9E24B0_42F6F019 | 5 | 280 | | 2 (0)| 00:00:01 | | |
|*199 | VIEW | | 1158 | 71796 | | 5 (0)| 00:00:01 | | |
| 200 | TABLE ACCESS FULL | SYS_TEMP_0FD9E24B5_42F6F019 | 1158 | 79902 | | 5 (0)| 00:00:01 | | |
| 201 | VIEW | | 18528 | 1248K| | 450 (1)| 00:00:01 | | |
|*202 | VIEW | | 18528 | 1718K| | 450 (1)| 00:00:01 | | |
| 203 | WINDOW SORT | | 18528 | 1537K| 2072K| 450 (1)| 00:00:01 | | |
| 204 | VIEW | | 18528 | 1537K| | 82 (0)| 00:00:01 | | |
| 205 | MERGE JOIN OUTER | | 18528 | 1610K| | 82 (0)| 00:00:01 | | |
| 206 | VIEW | | 16 | 992 | | 2 (0)| 00:00:01 | | |
| 207 | TABLE ACCESS FULL | SYS_TEMP_0FD9E24B3_42F6F019 | 16 | 1120 | | 2 (0)| 00:00:01 | | |
| 208 | BUFFER SORT | | 1158 | 31266 | | 82 (0)| 00:00:01 | | |
| 209 | VIEW | | 1158 | 31266 | | 5 (0)| 00:00:01 | | |
|*210 | VIEW | | 1158 | 94956 | | 5 (0)| 00:00:01 | | |
| 211 | TABLE ACCESS FULL | SYS_TEMP_0FD9E24B5_42F6F019 | 1158 | 79902 | | 5 (0)| 00:00:01 | | |
| 212 | VIEW | | 20M| 1183M| | 444K (1)| 00:00:18 | | |
|*213 | VIEW | | 20M| 1300M| | 444K (1)| 00:00:18 | | |
| 214 | WINDOW SORT | | 20M| 1494M| 1962M| 444K (1)| 00:00:18 | | |
| 215 | VIEW | | 20M| 1494M| | 79417 (1)| 00:00:04 | | |
| 216 | MERGE JOIN OUTER | | 20M| 1513M| | 79417 (1)| 00:00:04 | | |
| 217 | VIEW | | 16 | 992 | | 2 (0)| 00:00:01 | | |
| 218 | TABLE ACCESS FULL | SYS_TEMP_0FD9E24B3_42F6F019 | 16 | 1120 | | 2 (0)| 00:00:01 | | |
| 219 | BUFFER SORT | | 1271K| 19M| | 79417 (1)| 00:00:04 | | |
| 220 | VIEW | | 1271K| 19M| | 4963 (1)| 00:00:01 | | |
|*221 | VIEW | | 1271K| 86M| | 4963 (1)| 00:00:01 | | |
|*222 | TABLE ACCESS FULL | EMPLOYEE_FROZEN_DATA | 1271K| 80M| | 4963 (1)| 00:00:01 | | |
|*223 | VIEW | | 1 | 38 | | 2 (0)| 00:00:01 | | |
|*224 | WINDOW NOSORT | | 1 | 100 | | 2 (0)| 00:00:01 | | |
| 225 | NESTED LOOPS | | 1 | 100 | | 2 (0)| 00:00:01 | | |
| 226 | NESTED LOOPS | | 1 | 100 | | 2 (0)| 00:00:01 | | |
| 227 | NESTED LOOPS | | 1 | 68 | | 1 (0)| 00:00:01 | | |
| 228 | TABLE ACCESS BY INDEX ROWID | COMPANY_CARRIER_CONFIG | 1 | 43 | | 0 (0)| 00:00:01 | | |
|*229 | INDEX RANGE SCAN | COMPANY_CARRIER_CONFIG_PK | 1 | | | 0 (0)| 00:00:01 | | |
| 230 | TABLE ACCESS BY INDEX ROWID | COMPANY_PLAN_DETAIL | 1 | 25 | | 1 (0)| 00:00:01 | | |
|*231 | INDEX UNIQUE SCAN | COMPANY_PLAN_DETAIL_PK | 1 | | | 0 (0)| 00:00:01 | | |
|*232 | INDEX UNIQUE SCAN | VIP_OG_COMPANY_CYCLE_SUM_PK | 1 | | | 0 (0)| 00:00:01 | | |
| 233 | SORT AGGREGATE | | 1 | 19 | | | | | |
| 234 | FIRST ROW | | 1 | 19 | | 1 (0)| 00:00:01 | | |
|*235 | INDEX RANGE SCAN (MIN/MAX) | VIP_OG_CYCLE_SUMMARY_PK | 1 | 19 | | 1 (0)| 00:00:01 | | |
|*236 | TABLE ACCESS BY INDEX ROWID | VIP_OG_CYCLE_COMPANY_SUMMARY | 1 | 32 | | 1 (0)| 00:00:01 | | |
| 237 | LOAD AS SELECT | SYS_TEMP_0FD9E24B7_42F6F019 | | | | | | | |
| 238 | WINDOW SORT | | 1 | 120 | | 22 (5)| 00:00:01 | | |
| 239 | NESTED LOOPS | | 1 | 120 | | 22 (5)| 00:00:01 | | |
| 240 | VIEW | | 1 | 51 | | 20 (5)| 00:00:01 | | |
| 241 | HASH GROUP BY | | 1 | 76 | | 20 (5)| 00:00:01 | | |
| 242 | NESTED LOOPS | | 1 | 76 | | 19 (0)| 00:00:01 | | |
| 243 | VIEW | | 16 | 656 | | 2 (0)| 00:00:01 | | |
| 244 | TABLE ACCESS FULL | SYS_TEMP_0FD9E24B2_42F6F019 | 16 | 640 | | 2 (0)| 00:00:01 | | |
|*245 | INDEX RANGE SCAN | DEPENDENT_EFF_DATE_PK | 1 | 35 | | 2 (0)| 00:00:01 | | |
|*246 | TABLE ACCESS BY GLOBAL INDEX ROWID BATCHED | DEPENDENT_EFF_DATE | 1 | 69 | | 2 (0)| 00:00:01 | ROWID | ROWID |
|*247 | INDEX RANGE SCAN | DEPENDENT_EFF_DATE_IDX1 | 1 | | | 1 (0)| 00:00:01 | | |
|*248 | HASH JOIN | | 1020 | 3191K| | 951 (1)| 00:00:01 | | |
|*249 | HASH JOIN OUTER | | 1 | 490 | | 239 (3)| 00:00:01 | | |
|*250 | HASH JOIN OUTER | | 1 | 462 | | 201 (2)| 00:00:01 | | |
|*251 | HASH JOIN OUTER | | 1 | 421 | | 198 (2)| 00:00:01 | | |
| 252 | VIEW | | 1 | 380 | | 195 (1)| 00:00:01 | | |
| 253 | TRANSPOSE | | | | | | | | |
| 254 | SORT GROUP BY PIVOT | | 1 | 945 | | 195 (1)| 00:00:01 | | |
|*255 | VIEW | | 907 | 837K| | 194 (0)| 00:00:01 | | |
| 256 | TABLE ACCESS FULL | SYS_TEMP_0FD9E24B6_42F6F019 | 907 | 3097K| | 194 (0)| 00:00:01 | | |
|*257 | VIEW | | 1 | 41 | | 3 (34)| 00:00:01 | | |
|*258 | WINDOW SORT PUSHED RANK | | 1 | 57 | | 3 (34)| 00:00:01 | | |
|*259 | VIEW | | 1 | 57 | | 2 (0)| 00:00:01 | | |
| 260 | TABLE ACCESS FULL | SYS_TEMP_0FD9E24B7_42F6F019 | 1 | 89 | | 2 (0)| 00:00:01 | | |
|*261 | VIEW | | 1 | 41 | | 3 (34)| 00:00:01 | | |
|*262 | WINDOW SORT PUSHED RANK | | 1 | 57 | | 3 (34)| 00:00:01 | | |
|*263 | VIEW | | 1 | 57 | | 2 (0)| 00:00:01 | | |
| 264 | TABLE ACCESS FULL | SYS_TEMP_0FD9E24B7_42F6F019 | 1 | 89 | | 2 (0)| 00:00:01 | | |
| 265 | VIEW | | 18 | 504 | | 38 (6)| 00:00:01 | | |
| 266 | TRANSPOSE | | | | | | | | |
| 267 | SORT GROUP BY PIVOT | | 18 | 1854 | | 38 (6)| 00:00:01 | | |
| 268 | NESTED LOOPS | | 18 | 1854 | | 37 (3)| 00:00:01 | | |
| 269 | NESTED LOOPS | | 18 | 1854 | | 37 (3)| 00:00:01 | | |
| 270 | VIEW | | 18 | 954 | | 19 (6)| 00:00:01 | | |
| 271 | HASH GROUP BY | | 18 | 1404 | | 19 (6)| 00:00:01 | | |
| 272 | NESTED LOOPS | | 18 | 1404 | | 18 (0)| 00:00:01 | | |
| 273 | VIEW | | 16 | 656 | | 2 (0)| 00:00:01 | | |
| 274 | TABLE ACCESS FULL | SYS_TEMP_0FD9E24B2_42F6F019 | 16 | 640 | | 2 (0)| 00:00:01 | | |
|*275 | INDEX RANGE SCAN | PPT_COLLECTED_DATA_PK | 1 | 37 | | 1 (0)| 00:00:01 | | |
|*276 | INDEX UNIQUE SCAN | PPT_COLLECTED_DATA_PK | 1 | | | 0 (0)| 00:00:01 | | |
| 277 | TABLE ACCESS BY INDEX ROWID | PPT_COLLECTED_DATA | 1 | 50 | | 1 (0)| 00:00:01 | | |
|*278 | VIEW | | 907 | 2403K| | 711 (1)| 00:00:01 | | |
|*279 | WINDOW SORT PUSHED RANK | | 907 | 2407K| 3640K| 711 (1)| 00:00:01 | | |
|*280 | VIEW | | 907 | 2407K| | 194 (0)| 00:00:01 | | |
| 281 | TABLE ACCESS FULL | SYS_TEMP_0FD9E24B6_42F6F019 | 907 | 3097K| | 194 (0)| 00:00:01 | | |
| 282 | VIEW | | 1 | 106 | | 167 (3)| 00:00:01 | | |
| 283 | TEMP TABLE TRANSFORMATION | | | | | | | | |
| 284 | LOAD AS SELECT | SYS_TEMP_0FD9E24B8_42F6F019 | | | | | | | |
|*285 | VIEW | | 1 | 80 | | 5 (0)| 00:00:01 | | |
|*286 | WINDOW NOSORT STOPKEY | | 4 | 108 | | 5 (0)| 00:00:01 | | |
| 287 | TABLE ACCESS BY INDEX ROWID | VIP_OG_CYCLE_SUMMARY | 4 | 108 | | 5 (0)| 00:00:01 | | |
|*288 | INDEX RANGE SCAN DESCENDING | VIP_OG_CYCLE_SUMMARY_PK | 4 | | | 1 (0)| 00:00:01 | | |
| 289 | LOAD AS SELECT | SYS_TEMP_0FD9E24B9_42F6F019 | | | | | | | |
| 290 | NESTED LOOPS | | 4 | 2472 | | 54 (0)| 00:00:01 | | |
| 291 | NESTED LOOPS | | 110 | 2472 | | 54 (0)| 00:00:01 | | |
| 292 | NESTED LOOPS OUTER | | 1 | 130 | | 15 (0)| 00:00:01 | | |
| 293 | NESTED LOOPS | | 1 | 94 | | 14 (0)| 00:00:01 | | |
|*294 | HASH JOIN OUTER | | 1 | 58 | | 5 (0)| 00:00:01 | | |
|*295 | VIEW | | 1 | 31 | | 2 (0)| 00:00:01 | | |
| 296 | TABLE ACCESS FULL | SYS_TEMP_0FD9E24B8_42F6F019 | 1 | 31 | | 2 (0)| 00:00:01 | | |
| 297 | VIEW | | 1 | 27 | | 3 (0)| 00:00:01 | | |
|*298 | VIEW | | 1 | 40 | | 3 (0)| 00:00:01 | | |
|*299 | WINDOW NOSORT STOPKEY | | 1 | 29 | | 3 (0)| 00:00:01 | | |
| 300 | SORT GROUP BY NOSORT | | 1 | 29 | | 3 (0)| 00:00:01 | | |
| 301 | VIEW | | 2 | 58 | | 3 (0)| 00:00:01 | | |
| 302 | NESTED LOOPS | | 2 | 92 | | 3 (0)| 00:00:01 | | |
|*303 | VIEW | | 1 | 27 | | 2 (0)| 00:00:01 | | |
| 304 | TABLE ACCESS FULL | SYS_TEMP_0FD9E24B8_42F6F019 | 1 | 31 | | 2 (0)| 00:00:01 | | |
|*305 | INDEX RANGE SCAN | VIP_OG_CYCLE_SUMMARY_PK | 2 | 38 | | 1 (0)| 00:00:01 | | |
| 306 | TABLE ACCESS BY INDEX ROWID BATCHED | VIP_OG_CYCLE_COMPANY_SUMMARY | 1 | 36 | | 9 (0)| 00:00:01 | | |
|*307 | INDEX RANGE SCAN | VIP_OG_COMPANY_CYCLE_SUM_PK | 1 | | | 8 (0)| 00:00:01 | | |
| 308 | TABLE ACCESS BY INDEX ROWID | VIP_OG_CYCLE_COMPANY_SUMMARY | 1 | 36 | | 1 (0)| 00:00:01 | | |
|*309 | INDEX UNIQUE SCAN | VIP_OG_COMPANY_CYCLE_SUM_PK | 1 | | | 0 (0)| 00:00:01 | | |
|*310 | INDEX RANGE SCAN | VIP_OG_CYCLE_PK | 110 | | | 3 (0)| 00:00:01 | | |
|*311 | TABLE ACCESS BY INDEX ROWID | VIP_OG_CYCLE | 3 | 1464 | | 39 (0)| 00:00:01 | | |
| 312 | LOAD AS SELECT | SYS_TEMP_0FD9E24BA_42F6F019 | | | | | | | |
| 313 | WINDOW SORT | | 1 | 3283 | | 101 (4)| 00:00:01 | | |
| 314 | WINDOW SORT | | 1 | 3283 | | 101 (4)| 00:00:01 | | |
| 315 | NESTED LOOPS | | 1 | 3283 | | 97 (3)| 00:00:01 | | |
| 316 | NESTED LOOPS | | 1 | 3283 | | 97 (3)| 00:00:01 | | |
|*317 | HASH JOIN | | 1 | 3054 | | 95 (3)| 00:00:01 | | |
| 318 | JOIN FILTER CREATE | :BF0000 | 1 | 2616 | | 92 (2)| 00:00:01 | | |
|*319 | HASH JOIN | | 1 | 2616 | | 92 (2)| 00:00:01 | | |
| 320 | MERGE JOIN CARTESIAN | | 1 | 2416 | | 4 (0)| 00:00:01 | | |
|*321 | TABLE ACCESS BY INDEX ROWID BATCHED | EPP_CARRIER_INFO | 1 | 33 | | 2 (0)| 00:00:01 | | |
|*322 | INDEX RANGE SCAN | EPP_CARRIER_INFO_PK | 1 | | | 1 (0)| 00:00:01 | | |
| 323 | SORT AGGREGATE | | 1 | 25 | | | | | |
|*324 | TABLE ACCESS BY INDEX ROWID BATCHED | EPP_CARRIER_INFO | 1 | 25 | | 2 (0)| 00:00:01 | | |
|*325 | INDEX RANGE SCAN | EPP_CARRIER_INFO_PK | 1 | | | 1 (0)| 00:00:01 | | |
| 326 | BUFFER SORT | | 6 | 14298 | | 2 (0)| 00:00:01 | | |
|*327 | VIEW | | 6 | 14298 | | 2 (0)| 00:00:01 | | |
| 328 | TABLE ACCESS FULL | SYS_TEMP_0FD9E24B9_42F6F019 | 6 | 3708 | | 2 (0)| 00:00:01 | | |
|*329 | VIEW | | 635 | 124K| | 88 (2)| 00:00:01 | | |
| 330 | WINDOW SORT | | 635 | 114K| | 88 (2)| 00:00:01 | | |
|*331 | HASH JOIN OUTER | | 635 | 114K| | 88 (2)| 00:00:01 | | |
|*332 | HASH JOIN | | 622 | 65310 | | 79 (0)| 00:00:01 | | |
|*333 | TABLE ACCESS FULL | COMPANY_DETAIL | 616 | 13552 | | 8 (0)| 00:00:01 | | |
| 334 | TABLE ACCESS FULL | COMPANY | 1150 | 95450 | | 71 (0)| 00:00:01 | | |
| 335 | VIEW | | 1141 | 90139 | | 9 (12)| 00:00:01 | | |
|*336 | VIEW | | 1141 | 104K| | 9 (12)| 00:00:01 | | |
| 337 | WINDOW SORT | | 1141 | 70742 | | 9 (12)| 00:00:01 | | |
| 338 | TABLE ACCESS FULL | CONTACT | 1141 | 70742 | | 8 (0)| 00:00:01 | | |
| 339 | VIEW | | 3 | 1314 | | 3 (34)| 00:00:01 | | |
| 340 | HASH GROUP BY | | 3 | 1314 | | 3 (34)| 00:00:01 | | |
|*341 | VIEW | | 6 | 2628 | | 2 (0)| 00:00:01 | | |
| 342 | JOIN FILTER USE | :BF0000 | 6 | 3708 | | 2 (0)| 00:00:01 | | |
|*343 | TABLE ACCESS FULL | SYS_TEMP_0FD9E24B9_42F6F019 | 6 | 3708 | | 2 (0)| 00:00:01 | | |
|*344 | INDEX UNIQUE SCAN | VIP_OG_CYCLE_CHG_INDS_PK | 1 | | | 1 (0)| 00:00:01 | | |
| 345 | TABLE ACCESS BY INDEX ROWID | VIP_OG_CYCLE_CHG_INDS | 1 | 229 | | 2 (0)| 00:00:01 | | |
|*346 | HASH JOIN ANTI | | 1 | 178 | | 7 (15)| 00:00:01 | | |
|*347 | HASH JOIN OUTER | | 1 | 140 | | 5 (20)| 00:00:01 | | |
|*348 | VIEW | | 1 | 126 | | 2 (0)| 00:00:01 | | |
| 349 | TABLE ACCESS FULL | SYS_TEMP_0FD9E24BA_42F6F019 | 1 | 3283 | | 2 (0)| 00:00:01 | | |
| 350 | VIEW | | 1 | 14 | | 3 (34)| 00:00:01 | | |
| 351 | SORT GROUP BY | | 1 | 20 | | 3 (34)| 00:00:01 | | |
| 352 | VIEW | | 1 | 20 | | 3 (34)| 00:00:01 | | |
| 353 | HASH UNIQUE | | 1 | 19 | | 3 (34)| 00:00:01 | | |
| 354 | VIEW | | 1 | 19 | | 2 (0)| 00:00:01 | | |
| 355 | TABLE ACCESS FULL | SYS_TEMP_0FD9E24BA_42F6F019 | 1 | 3283 | | 2 (0)| 00:00:01 | | |
|*356 | VIEW | | 1 | 38 | | 2 (0)| 00:00:01 | | |
|*357 | WINDOW NOSORT | | 1 | 100 | | 2 (0)| 00:00:01 | | |
| 358 | NESTED LOOPS | | 1 | 100 | | 2 (0)| 00:00:01 | | |
| 359 | NESTED LOOPS | | 1 | 100 | | 2 (0)| 00:00:01 | | |
| 360 | NESTED LOOPS | | 1 | 68 | | 1 (0)| 00:00:01 | | |
| 361 | TABLE ACCESS BY INDEX ROWID | COMPANY_CARRIER_CONFIG | 1 | 43 | | 0 (0)| 00:00:01 | | |
|*362 | INDEX RANGE SCAN | COMPANY_CARRIER_CONFIG_PK | 1 | | | 0 (0)| 00:00:01 | | |
| 363 | TABLE ACCESS BY INDEX ROWID | COMPANY_PLAN_DETAIL | 1 | 25 | | 1 (0)| 00:00:01 | | |
|*364 | INDEX UNIQUE SCAN | COMPANY_PLAN_DETAIL_PK | 1 | | | 0 (0)| 00:00:01 | | |
|*365 | INDEX UNIQUE SCAN | VIP_OG_COMPANY_CYCLE_SUM_PK | 1 | | | 0 (0)| 00:00:01 | | |
| 366 | SORT AGGREGATE | | 1 | 19 | | | | | |
| 367 | FIRST ROW | | 1 | 19 | | 1 (0)| 00:00:01 | | |
|*368 | INDEX RANGE SCAN (MIN/MAX) | VIP_OG_CYCLE_SUMMARY_PK | 1 | 19 | | 1 (0)| 00:00:01 | | |
|*369 | TABLE ACCESS BY INDEX ROWID | VIP_OG_CYCLE_COMPANY_SUMMARY | 1 | 32 | | 1 (0)| 00:00:01 | | |
--------------------------------------------------------------------------------------------------------------------------------------------------------------------
Predicate Information (identified by operation id):
---------------------------------------------------
9 - filter("from$_subquery$_014"."rowlimit_$$_rownumber"<=1)
10 - filter(ROW_NUMBER() OVER ( ORDER BY "CONTROL_ID","CARRIER_ID",INTERNAL_FUNCTION("CYCLE_NUMBER") DESC )<=1)
12 - access("CONTROL_ID"='SMLMKT' AND "CARRIER_ID"='CIGNA_1')
18 - access("PREVIOUS_CARRIER_CYCLE"."CARRIER_ID"(+)="LAST_CARRIER_CYCLE"."CARRIER_ID" AND
"PREVIOUS_CARRIER_CYCLE"."CONTROL_ID"(+)="LAST_CARRIER_CYCLE"."CONTROL_ID")
19 - filter("LAST_CARRIER_CYCLE"."CONTROL_ID"='SMLMKT' AND "LAST_CARRIER_CYCLE"."CARRIER_ID"='CIGNA_1')
22 - filter("from$_subquery$_018"."rowlimit_$$_rownumber"<=1 AND "from$_subquery$_018"."CONTROL_ID"='SMLMKT' AND
"from$_subquery$_018"."CARRIER_ID"='CIGNA_1')
23 - filter(ROW_NUMBER() OVER ( ORDER BY NULL )<=1)
27 - filter("LAST_CARRIER_CYCLE"."CONTROL_ID"='SMLMKT' AND "LAST_CARRIER_CYCLE"."CARRIER_ID"='CIGNA_1')
29 - access("VCS"."CONTROL_ID"='SMLMKT' AND "VCS"."CARRIER_ID"='CIGNA_1' AND "VCS"."CYCLE_NUMBER"<"LAST_CARRIER_CYCLE"."CYCLE_NUMBER")
31 - access("VCCS_LAST"."CONTROL_ID"='SMLMKT' AND "VCCS_LAST"."CARRIER_ID"='CIGNA_1' AND "VCCS_LAST"."CYCLE_NUMBER"="LAST_CARRIER_CYCLE"."CYCLE_NUMBER")
filter("VCCS_LAST"."CARRIER_ID"='CIGNA_1' AND "VCCS_LAST"."CYCLE_NUMBER"="LAST_CARRIER_CYCLE"."CYCLE_NUMBER")
33 - access("VCCS_PREVIOUS"."CONTROL_ID"(+)="PREVIOUS_CARRIER_CYCLE"."CONTROL_ID" AND "VCCS_PREVIOUS"."COMPANY_ID"(+)="VCCS_LAST"."COMPANY_ID" AND
"VCCS_PREVIOUS"."CARRIER_ID"(+)="PREVIOUS_CARRIER_CYCLE"."CARRIER_ID" AND "VCCS_PREVIOUS"."CYCLE_NUMBER"(+)="PREVIOUS_CARRIER_CYCLE"."CYCLE_NUMBER")
34 - access("VIP_CYCLE"."CONTROL_ID"='SMLMKT' AND "VIP_CYCLE"."CARRIER_ID"='CIGNA_1' AND "VIP_CYCLE"."CYCLE_NUMBER"="VCCS_LAST"."CYCLE_NUMBER")
35 - filter("VIP_CYCLE"."COMPANY_ID"="VCCS_LAST"."COMPANY_ID")
41 - access("COMPANIES"."COMPANY_ID"="VIP_CYCLE_COMPANY_CUSTOM"."COMPANY_ID" AND "CARRIER_ID"="VIP_CYCLE_COMPANY_CUSTOM"."CARRIER_ID" AND
"COMPANIES"."CONTROL_ID"="VIP_CYCLE_COMPANY_CUSTOM"."CONTROL_ID")
43 - access("LAST_CYCLE_DATA"."COMPANY_ID"="COMPANIES"."COMPANY_ID" AND "CONTROL_ID"="COMPANIES"."CONTROL_ID")
45 - filter("TERM_DATE" IS NULL OR "TERM_DATE">=TRUNC(SYSDATE@!))
46 - access("CONTROL_ID"='SMLMKT' AND "CARRIER_ID"='CIGNA_1')
filter("EFF_DATE"= (SELECT MAX("EPC"."EFF_DATE") FROM "Z_MM_CC_A"."EPP_CARRIER_INFO" "EPC" WHERE "EPC"."CARRIER_ID"=:B1 AND "EPC"."CONTROL_ID"=:B2
AND ("EPC"."TERM_DATE" IS NULL OR "EPC"."TERM_DATE">=TRUNC(SYSDATE@!))))
48 - filter("EPC"."TERM_DATE" IS NULL OR "EPC"."TERM_DATE">=TRUNC(SYSDATE@!))
49 - access("EPC"."CONTROL_ID"=:B1 AND "EPC"."CARRIER_ID"=:B2)
51 - filter(("LAST_CYCLE_DATA"."BENEFIT_ID"='LTD' OR "LAST_CYCLE_DATA"."BENEFIT_ID"='STD') AND "LAST_CYCLE_DATA"."CARRIER_ID"='CIGNA_1' AND
"LAST_CYCLE_DATA"."CONTROL_ID"='SMLMKT')
53 - filter("COMPANIES"."COMPANY_ONECODE"='RESI61' AND "COMPANIES"."CONTROL_ID"='SMLMKT')
55 - access("CD"."CONTROL_ID"="CONTACTS"."CONTROL_ID"(+) AND "CD"."COMPANY_ID"="CONTACTS"."COMPANY_ID"(+))
56 - access("C"."COMPANY_ID"="CD"."COMPANY_ID" AND "C"."CONTROL_ID"="CD"."CONTROL_ID")
57 - filter("CD"."TEST_COMPANY_IND"='N')
60 - filter("CONTACT_ID"="MAX_CONTACT_ID")
65 - filter("CONTROL_ID"='SMLMKT' AND "CARRIER_ID"='CIGNA_1')
67 - filter(SYS_OP_BLOOM_FILTER(:BF0000,"C2","C1","C0"))
68 - access("VIP_OG_CYCLE_CHG_INDS"."CONTROL_ID"='SMLMKT' AND "VIP_OG_CYCLE_CHG_INDS"."CARRIER_ID"='CIGNA_1' AND
"LAST_CYCLE_DATA"."CYCLE_NUMBER"="VIP_OG_CYCLE_CHG_INDS"."CYCLE_NUMBER" AND "LAST_CYCLE_DATA"."BENEFIT_ID"="VIP_OG_CYCLE_CHG_INDS"."BENEFIT_ID" AND
"LAST_CYCLE_DATA"."SSN"="VIP_OG_CYCLE_CHG_INDS"."SSN" AND "LAST_CYCLE_DATA"."DEP_SSN"="VIP_OG_CYCLE_CHG_INDS"."DEP_SSN")
filter("VIP_OG_CYCLE_CHG_INDS"."BENEFIT_ID"='LTD' OR "VIP_OG_CYCLE_CHG_INDS"."BENEFIT_ID"='STD')
70 - access("VIP_CYCLE_DATA_FILTERED"."COMPANY_ID"="COMPANY_ID")
71 - access("VIP_CYCLE_DATA_FILTERED"."CONTROL_ID"="VIP_CYCLE_COMPANY_BENEFITS"."CONTROL_ID"(+) AND
"VIP_CYCLE_DATA_FILTERED"."COMPANY_ID"="VIP_CYCLE_COMPANY_BENEFITS"."COMPANY_ID"(+))
72 - filter("VIP_CYCLE_DATA_FILTERED"."COMPANY_ROW_NUMBER"=1)
80 - filter("RN"=1 AND "CUTOFF_DATE">="OE_FILE_DATE")
81 - filter(ROW_NUMBER() OVER ( PARTITION BY "CPD"."COMPANY_ID" ORDER BY "CPD"."PLAN_YEAR")<=1)
86 - access("CCC"."CONTROL_ID"='SMLMKT' AND "CCC"."CARRIER_ID"='CIGNA_1')
filter("CCC"."CARRIER_ID"='CIGNA_1')
88 - access("CCC"."COMPANY_ID"="CPD"."COMPANY_ID" AND "CPD"."CONTROL_ID"='SMLMKT' AND "CCC"."PLAN_YEAR"="CPD"."PLAN_YEAR")
89 - access("VGCCS"."CONTROL_ID"='SMLMKT' AND "VGCCS"."COMPANY_ID"="CCC"."COMPANY_ID" AND "VGCCS"."CARRIER_ID"='CIGNA_1' AND "VGCCS"."CYCLE_NUMBER"=
(SELECT MAX("VGCS"."CYCLE_NUMBER") FROM "VIP_OG_CYCLE_SUMMARY" "VGCS" WHERE "VGCS"."CARRIER_ID"='CIGNA_1' AND "VGCS"."CONTROL_ID"='SMLMKT'))
92 - access("VGCS"."CONTROL_ID"='SMLMKT' AND "VGCS"."CARRIER_ID"='CIGNA_1')
93 - filter("CPD"."YEAR_BEGIN_DATE">"VGCCS"."CUTOFF_DATE")
97 - filter("from$_subquery$_108"."rowlimit_$$_rownumber"<=1)
98 - filter(ROW_NUMBER() OVER ( ORDER BY "CONTROL_ID","CARRIER_ID",INTERNAL_FUNCTION("CYCLE_NUMBER") DESC )<=1)
100 - access("CONTROL_ID"='SMLMKT' AND "CARRIER_ID"='CIGNA_1')
104 - access("PREVIOUS_CARRIER_CYCLE"."CARRIER_ID"(+)="LAST_CARRIER_CYCLE"."CARRIER_ID" AND
"PREVIOUS_CARRIER_CYCLE"."CONTROL_ID"(+)="LAST_CARRIER_CYCLE"."CONTROL_ID")
108 - filter("from$_subquery$_112"."rowlimit_$$_rownumber"<=1)
109 - filter(ROW_NUMBER() OVER ( ORDER BY NULL )<=1)
113 - filter("LAST_CARRIER_CYCLE"."CONTROL_ID"='SMLMKT' AND "LAST_CARRIER_CYCLE"."CARRIER_ID"='CIGNA_1')
115 - access("VCS"."CONTROL_ID"='SMLMKT' AND "VCS"."CARRIER_ID"='CIGNA_1' AND "VCS"."CYCLE_NUMBER"<"LAST_CARRIER_CYCLE"."CYCLE_NUMBER")
117 - access("VCCS_LAST"."CONTROL_ID"="LAST_CARRIER_CYCLE"."CONTROL_ID" AND "VCCS_LAST"."CARRIER_ID"="LAST_CARRIER_CYCLE"."CARRIER_ID" AND
"VCCS_LAST"."CYCLE_NUMBER"="LAST_CARRIER_CYCLE"."CYCLE_NUMBER")
filter("VCCS_LAST"."CARRIER_ID"="LAST_CARRIER_CYCLE"."CARRIER_ID" AND "VCCS_LAST"."CYCLE_NUMBER"="LAST_CARRIER_CYCLE"."CYCLE_NUMBER")
119 - access("VCCS_PREVIOUS"."CONTROL_ID"(+)="PREVIOUS_CARRIER_CYCLE"."CONTROL_ID" AND "VCCS_PREVIOUS"."COMPANY_ID"(+)="VCCS_LAST"."COMPANY_ID" AND
"VCCS_PREVIOUS"."CARRIER_ID"(+)="PREVIOUS_CARRIER_CYCLE"."CARRIER_ID" AND "VCCS_PREVIOUS"."CYCLE_NUMBER"(+)="PREVIOUS_CARRIER_CYCLE"."CYCLE_NUMBER")
123 - filter("LAST_COMPANY_CYCLE"."CONTROL_ID"='SMLMKT' AND "LAST_COMPANY_CYCLE"."CARRIER_ID"='CIGNA_1')
125 - access("VIP_CYCLE"."CONTROL_ID"='SMLMKT' AND "VIP_CYCLE"."CARRIER_ID"='CIGNA_1' AND "VIP_CYCLE"."CYCLE_NUMBER"="LAST_COMPANY_CYCLE"."CYCLE_NUMBER")
126 - filter("VIP_CYCLE"."COMPANY_ID"="LAST_COMPANY_CYCLE"."COMPANY_ID")
133 - access("LAST_CYCLE_DATA"."BENEFIT_ID"="BENEFIT"."BENEFIT_ID" AND "LAST_CYCLE_DATA"."CONTROL_ID"="BENEFIT"."CONTROL_ID")
139 - access("VAL_TABLE_ID"='STDLTD_MAX_SAL')
141 - filter(("CARRIER_ID"='*ALL*' OR "CARRIER_ID"='CIGNA_1') AND "CONTROL_ID"='SMLMKT' AND "ELIG_GROUP_ID"=0)
143 - access("VIP_CYCLE"."COMPANY_ID"="COMPANY_ID")
144 - access("FRZN"."PLAN_ID"(+)="VIP_CYCLE"."PLAN_ID" AND "FRZN"."BENEFIT_ID"(+)="VIP_CYCLE"."BENEFIT_ID" AND "FRZN"."SSN"(+)="VIP_CYCLE"."SSN" AND
"FRZN"."PLAN_YEAR"(+)="VIP_CYCLE"."PLAN_YEAR" AND "FRZN"."COMPANY_ID"(+)="VIP_CYCLE"."COMPANY_ID" AND "FRZN"."CONTROL_ID"(+)="VIP_CYCLE"."CONTROL_ID")
145 - access("CSR"."PLAN_ID"(+)="VIP_CYCLE"."PLAN_ID" AND "CSR"."BENEFIT_ID"(+)="VIP_CYCLE"."BENEFIT_ID" AND "CSR"."SSN"(+)="VIP_CYCLE"."SSN" AND
"CSR"."PLAN_YEAR"(+)="VIP_CYCLE"."PLAN_YEAR" AND "CSR"."COMPANY_ID"(+)="VIP_CYCLE"."COMPANY_ID" AND "CSR"."CARRIER_ID"(+)="VIP_CYCLE"."CARRIER_ID" AND
"CSR"."CONTROL_ID"(+)="VIP_CYCLE"."CONTROL_ID")
146 - access("CCSR"."PLAN_YEAR"(+)="VIP_CYCLE"."PLAN_YEAR" AND "CCSR"."COMPANY_ID"(+)="VIP_CYCLE"."COMPANY_ID" AND
"CCSR"."CONTROL_ID"(+)="VIP_CYCLE"."CONTROL_ID")
147 - access("STANDARD_PLAN_PERCENT"."PLAN4"(+)=SUBSTR("VIP_CYCLE"."PLAN_ID",4,1) AND "STANDARD_PLAN_PERCENT"."BENEFIT_ID"(+)="VIP_CYCLE"."BENEFIT_ID")
153 - access("COMPANIES"."COMPANY_ID"="VIP_CYCLE_COMPANY_CUSTOM"."COMPANY_ID" AND "CARRIER_ID"="VIP_CYCLE_COMPANY_CUSTOM"."CARRIER_ID" AND
"COMPANIES"."CONTROL_ID"="VIP_CYCLE_COMPANY_CUSTOM"."CONTROL_ID")
154 - access("LAST_CYCLE_DATA"."COMPANY_ID"="COMPANIES"."COMPANY_ID" AND "CONTROL_ID"="COMPANIES"."CONTROL_ID")
156 - filter("TERM_DATE" IS NULL OR "TERM_DATE">=TRUNC(SYSDATE@!))
157 - access("CONTROL_ID"='SMLMKT' AND "CARRIER_ID"='CIGNA_1')
filter("EFF_DATE"= (SELECT MAX("EPC"."EFF_DATE") FROM "Z_MM_CC_A"."EPP_CARRIER_INFO" "EPC" WHERE "EPC"."CARRIER_ID"=:B1 AND "EPC"."CONTROL_ID"=:B2
AND ("EPC"."TERM_DATE" IS NULL OR "EPC"."TERM_DATE">=TRUNC(SYSDATE@!))))
159 - filter("EPC"."TERM_DATE" IS NULL OR "EPC"."TERM_DATE">=TRUNC(SYSDATE@!))
160 - access("EPC"."CONTROL_ID"=:B1 AND "EPC"."CARRIER_ID"=:B2)
162 - filter(("LAST_CYCLE_DATA"."BENEFIT_ID"='LTD' OR "LAST_CYCLE_DATA"."BENEFIT_ID"='STD') AND "LAST_CYCLE_DATA"."CARRIER_ID"='CIGNA_1' AND
"LAST_CYCLE_DATA"."CONTROL_ID"='SMLMKT')
164 - filter("COMPANIES"."COMPANY_ONECODE"='RESI61' AND "COMPANIES"."CONTROL_ID"='SMLMKT')
166 - access("CD"."CONTROL_ID"="CONTACTS"."CONTROL_ID"(+) AND "CD"."COMPANY_ID"="CONTACTS"."COMPANY_ID"(+))
167 - access("C"."COMPANY_ID"="CD"."COMPANY_ID" AND "C"."CONTROL_ID"="CD"."CONTROL_ID")
168 - filter("CD"."TEST_COMPANY_IND"='N')
171 - filter("CONTACT_ID"="MAX_CONTACT_ID")
176 - filter("CONTROL_ID"='SMLMKT' AND "CARRIER_ID"='CIGNA_1')
178 - access("VIP_OG_CYCLE_CHG_INDS"."CONTROL_ID"='SMLMKT' AND "VIP_OG_CYCLE_CHG_INDS"."CARRIER_ID"='CIGNA_1' AND
"LAST_CYCLE_DATA"."CYCLE_NUMBER"="VIP_OG_CYCLE_CHG_INDS"."CYCLE_NUMBER" AND "LAST_CYCLE_DATA"."BENEFIT_ID"="VIP_OG_CYCLE_CHG_INDS"."BENEFIT_ID" AND
"LAST_CYCLE_DATA"."SSN"="VIP_OG_CYCLE_CHG_INDS"."SSN" AND "LAST_CYCLE_DATA"."DEP_SSN"="VIP_OG_CYCLE_CHG_INDS"."DEP_SSN")
filter("VIP_OG_CYCLE_CHG_INDS"."BENEFIT_ID"='LTD' OR "VIP_OG_CYCLE_CHG_INDS"."BENEFIT_ID"='STD')
182 - access("STDLTD_MAX_SAL_TABLE"."SEQ_NO"="STDLTD_MAX_SAL_MAX_SEQ"."SEQ_NO" AND "STDLTD_MAX_SAL_TABLE"."PLAN4"="STDLTD_MAX_SAL_MAX_SEQ"."PLAN4" AND
"STDLTD_MAX_SAL_TABLE"."BENEFIT_ID"="STDLTD_MAX_SAL_MAX_SEQ"."BENEFIT_ID")
193 - filter("RULE_NUMBER"=1)
194 - filter(ROW_NUMBER() OVER ( PARTITION BY "CONTROL_ID","COMPANY_ID","PLAN_YEAR","BENEFIT_CATEGORY" ORDER BY
"BENEFIT_ID","PLAN_ID","SALARY_CHOICE","SALARY_RULE")<=1)
196 - access("LAST_COMPANY_CYCLE"."CONTROL_ID"="CSR"."CONTROL_ID" AND "LAST_COMPANY_CYCLE"."COMPANY_ID"="CSR"."COMPANY_ID" AND
"LAST_COMPANY_CYCLE"."PLAN_YEAR"="CSR"."PLAN_YEAR")
199 - filter("CSR"."BENEFIT_CATEGORY"='DISABILITY' OR "CSR"."BENEFIT_CATEGORY"='LIFE')
202 - filter("CSR_MATCH_SCORE"="MAX_CSR_MATCH_SCORE")
210 - filter("CSR"."CONTROL_ID"="VIP_CYCLE"."CONTROL_ID" AND "CSR"."COMPANY_ID"="VIP_CYCLE"."COMPANY_ID" AND "CSR"."PLAN_YEAR"="VIP_CYCLE"."PLAN_YEAR" AND
"CSR"."BENEFIT_CATEGORY"="VIP_CYCLE"."BENEFIT_CATEGORY" AND ("CSR"."CARRIER_ID"="VIP_CYCLE"."CARRIER_ID" OR "CSR"."CARRIER_ID"='*ALL*') AND
("CSR"."BENEFIT_ID"="VIP_CYCLE"."BENEFIT_ID" OR "CSR"."BENEFIT_ID"='*ALL*') AND ("CSR"."PLAN_ID"="VIP_CYCLE"."PLAN_ID" OR "CSR"."PLAN_ID"='*ALL*'))
213 - filter("FRZN_MATCH_SCORE"="MAX_FRZN_MATCH_SCORE")
221 - filter("EFS"."CONTROL_ID"="VIP_CYCLE"."CONTROL_ID" AND "EFS"."COMPANY_ID"="VIP_CYCLE"."COMPANY_ID" AND "EFS"."PLAN_YEAR"="VIP_CYCLE"."PLAN_YEAR" AND
"EFS"."SSN"="VIP_CYCLE"."SSN" AND "EFS"."BENEFIT_CATEGORY"="VIP_CYCLE"."BENEFIT_CATEGORY" AND ("EFS"."BENEFIT_ID"="VIP_CYCLE"."BENEFIT_ID" OR
"EFS"."BENEFIT_ID"='*ALL*') AND ("EFS"."PLAN_ID"="VIP_CYCLE"."PLAN_ID" OR "EFS"."PLAN_ID"='*ALL*'))
222 - filter("FRZN_ELEMENT"='SALARY' AND "CONTROL_ID"='SMLMKT')
223 - filter("RN"=1 AND "CUTOFF_DATE">="OE_FILE_DATE")
224 - filter(ROW_NUMBER() OVER ( PARTITION BY "CPD"."COMPANY_ID" ORDER BY "CPD"."PLAN_YEAR")<=1)
229 - access("CCC"."CONTROL_ID"='SMLMKT' AND "CCC"."CARRIER_ID"='CIGNA_1')
filter("CCC"."CARRIER_ID"='CIGNA_1')
231 - access("CCC"."COMPANY_ID"="CPD"."COMPANY_ID" AND "CPD"."CONTROL_ID"='SMLMKT' AND "CCC"."PLAN_YEAR"="CPD"."PLAN_YEAR")
232 - access("VGCCS"."CONTROL_ID"='SMLMKT' AND "VGCCS"."COMPANY_ID"="CCC"."COMPANY_ID" AND "VGCCS"."CARRIER_ID"='CIGNA_1' AND "VGCCS"."CYCLE_NUMBER"=
(SELECT MAX("VGCS"."CYCLE_NUMBER") FROM "VIP_OG_CYCLE_SUMMARY" "VGCS" WHERE "VGCS"."CARRIER_ID"='CIGNA_1' AND "VGCS"."CONTROL_ID"='SMLMKT'))
235 - access("VGCS"."CONTROL_ID"='SMLMKT' AND "VGCS"."CARRIER_ID"='CIGNA_1')
236 - filter("CPD"."YEAR_BEGIN_DATE">"VGCCS"."CUTOFF_DATE")
245 - access("DEPENDENT_EFF_DATE"."CONTROL_ID"="VIP_CYCLE_COMPANY_SSN"."CONTROL_ID" AND "DEPENDENT_EFF_DATE"."SSN"="VIP_CYCLE_COMPANY_SSN"."SSN" AND
"DEPENDENT_EFF_DATE"."EFF_DATE"<="VIP_CYCLE_COMPANY_SSN"."CUTOFF_DATE")
filter("DEPENDENT_EFF_DATE"."EFF_DATE"<="VIP_CYCLE_COMPANY_SSN"."CUTOFF_DATE")
246 - filter(("DEPENDENT_EFF_DATE"."RELATION"='C' OR "DEPENDENT_EFF_DATE"."RELATION"='D' OR "DEPENDENT_EFF_DATE"."RELATION"='DP' OR
"DEPENDENT_EFF_DATE"."RELATION"='DPCNT' OR "DEPENDENT_EFF_DATE"."RELATION"='DPCT' OR "DEPENDENT_EFF_DATE"."RELATION"='DPDNT' OR
"DEPENDENT_EFF_DATE"."RELATION"='DPDT' OR "DEPENDENT_EFF_DATE"."RELATION"='DPNT' OR "DEPENDENT_EFF_DATE"."RELATION"='DPT' OR
"DEPENDENT_EFF_DATE"."RELATION"='Q' OR "DEPENDENT_EFF_DATE"."RELATION"='QD' OR "DEPENDENT_EFF_DATE"."RELATION"='S' OR
"DEPENDENT_EFF_DATE"."RELATION"='SSCNT' OR "DEPENDENT_EFF_DATE"."RELATION"='SSCT' OR "DEPENDENT_EFF_DATE"."RELATION"='SSDNT' OR
"DEPENDENT_EFF_DATE"."RELATION"='SSDT' OR "DEPENDENT_EFF_DATE"."RELATION"='SSNT' OR "DEPENDENT_EFF_DATE"."RELATION"='SST') AND
"DEPENDENT_EFF_DATE"."CONTROL_ID"="DEPENDENTS_MAX_DATE"."CONTROL_ID")
247 - access("DEPENDENT_EFF_DATE"."SSN"="DEPENDENTS_MAX_DATE"."SSN" AND "DEPENDENT_EFF_DATE"."DEP_SSN"="DEPENDENTS_MAX_DATE"."DEP_SSN" AND
SYS_OP_DESCEND("EFF_DATE")=SYS_OP_DESCEND("DEPENDENTS_MAX_DATE"."EFF_DATE"))
filter(SYS_OP_UNDESCEND(SYS_OP_DESCEND("EFF_DATE"))="DEPENDENTS_MAX_DATE"."EFF_DATE")
248 - access("EMP_COPIES"."SSN"="from$_subquery$_209"."SSN" AND "EMP_COPIES"."COMPANY_ID"="from$_subquery$_209"."COMPANY_ID" AND
"EMP_COPIES"."CARRIER_ID"="from$_subquery$_209"."CARRIER_ID" AND "EMP_COPIES"."CONTROL_ID"="from$_subquery$_209"."CONTROL_ID")
249 - access("from$_subquery$_209"."CONTROL_ID"="from$_subquery$_206"."CONTROL_ID"(+) AND
"from$_subquery$_209"."CARRIER_ID"="from$_subquery$_206"."CARRIER_ID"(+) AND "from$_subquery$_209"."COMPANY_ID"="from$_subquery$_206"."COMPANY_ID"(+) AND
"from$_subquery$_209"."SSN"="from$_subquery$_206"."SSN"(+))
250 - access("C"."SSN"(+)="from$_subquery$_209"."SSN" AND "C"."COMPANY_ID"(+)="from$_subquery$_209"."COMPANY_ID" AND
"C"."CARRIER_ID"(+)="from$_subquery$_209"."CARRIER_ID" AND "C"."CONTROL_ID"(+)="from$_subquery$_209"."CONTROL_ID")
251 - access("SPOUSES"."SSN"(+)="from$_subquery$_209"."SSN" AND "SPOUSES"."COMPANY_ID"(+)="from$_subquery$_209"."COMPANY_ID" AND
"SPOUSES"."CARRIER_ID"(+)="from$_subquery$_209"."CARRIER_ID" AND "SPOUSES"."CONTROL_ID"(+)="from$_subquery$_209"."CONTROL_ID")
255 - filter("DEP_SSN"='000000000' AND "RELATION"='EE')
257 - filter("DEPENDENT_NUMBER"(+)=1)
258 - filter(ROW_NUMBER() OVER ( PARTITION BY "CONTROL_ID","CARRIER_ID","COMPANY_ID","SSN" ORDER BY "BIRTHDATE","DEP_SSN")<=1)
259 - filter("RELATION"='DP' OR "RELATION"='DPNT' OR "RELATION"='DPT' OR "RELATION"='S' OR "RELATION"='SSNT' OR "RELATION"='SST')
261 - filter("DEPENDENT_NUMBER"(+)=1)
262 - filter(ROW_NUMBER() OVER ( PARTITION BY "CONTROL_ID","CARRIER_ID","COMPANY_ID","SSN" ORDER BY "BIRTHDATE","DEP_SSN")<=1)
263 - filter("RELATION"='C' OR "RELATION"='D' OR "RELATION"='DPCNT' OR "RELATION"='DPCT' OR "RELATION"='DPDNT' OR "RELATION"='DPDT' OR "RELATION"='Q' OR
"RELATION"='QD' OR "RELATION"='SSCNT' OR "RELATION"='SSCT' OR "RELATION"='SSDNT' OR "RELATION"='SSDT')
275 - access("PPT_COLLECTED_DATA"."CONTROL_ID"="VIP_CYCLE_COMPANY_SSN"."CONTROL_ID" AND "PPT_COLLECTED_DATA"."SSN"="VIP_CYCLE_COMPANY_SSN"."SSN" AND
"PPT_COLLECTED_DATA"."EFF_DATE"<="VIP_CYCLE_COMPANY_SSN"."CUTOFF_DATE")
filter("PPT_COLLECTED_DATA"."EFF_DATE"<="VIP_CYCLE_COMPANY_SSN"."CUTOFF_DATE")
276 - access("PPT_COLLECTED_DATA"."CONTROL_ID"="PPT_MAX_DATE"."CONTROL_ID" AND "PPT_COLLECTED_DATA"."SSN"="PPT_MAX_DATE"."SSN" AND
"PPT_COLLECTED_DATA"."ANSWER_TYPE"="PPT_MAX_DATE"."ANSWER_TYPE" AND "PPT_COLLECTED_DATA"."EFF_DATE"="PPT_MAX_DATE"."EFF_DATE")
278 - filter("EMP_COPY_NUMBER"=1)
279 - filter(ROW_NUMBER() OVER ( PARTITION BY "SSN" ORDER BY NULL )<=1)
280 - filter("DEP_SSN"='000000000' AND "RELATION"='EE')
285 - filter("from$_subquery$_233"."rowlimit_$$_rownumber"<=1)
286 - filter(ROW_NUMBER() OVER ( ORDER BY "CONTROL_ID","CARRIER_ID",INTERNAL_FUNCTION("CYCLE_NUMBER") DESC )<=1)
288 - access("CONTROL_ID"='SMLMKT' AND "CARRIER_ID"='CIGNA_1')
294 - access("PREVIOUS_CARRIER_CYCLE"."CARRIER_ID"(+)="LAST_CARRIER_CYCLE"."CARRIER_ID" AND
"PREVIOUS_CARRIER_CYCLE"."CONTROL_ID"(+)="LAST_CARRIER_CYCLE"."CONTROL_ID")
295 - filter("LAST_CARRIER_CYCLE"."CONTROL_ID"='SMLMKT' AND "LAST_CARRIER_CYCLE"."CARRIER_ID"='CIGNA_1')
298 - filter("from$_subquery$_237"."rowlimit_$$_rownumber"<=1 AND "from$_subquery$_237"."CONTROL_ID"='SMLMKT' AND
"from$_subquery$_237"."CARRIER_ID"='CIGNA_1')
299 - filter(ROW_NUMBER() OVER ( ORDER BY NULL )<=1)
303 - filter("LAST_CARRIER_CYCLE"."CONTROL_ID"='SMLMKT' AND "LAST_CARRIER_CYCLE"."CARRIER_ID"='CIGNA_1')
305 - access("VCS"."CONTROL_ID"='SMLMKT' AND "VCS"."CARRIER_ID"='CIGNA_1' AND "VCS"."CYCLE_NUMBER"<"LAST_CARRIER_CYCLE"."CYCLE_NUMBER")
307 - access("VCCS_LAST"."CONTROL_ID"='SMLMKT' AND "VCCS_LAST"."CARRIER_ID"='CIGNA_1' AND "VCCS_LAST"."CYCLE_NUMBER"="LAST_CARRIER_CYCLE"."CYCLE_NUMBER")
filter("VCCS_LAST"."CARRIER_ID"='CIGNA_1' AND "VCCS_LAST"."CYCLE_NUMBER"="LAST_CARRIER_CYCLE"."CYCLE_NUMBER")
309 - access("VCCS_PREVIOUS"."CONTROL_ID"(+)="PREVIOUS_CARRIER_CYCLE"."CONTROL_ID" AND "VCCS_PREVIOUS"."COMPANY_ID"(+)="VCCS_LAST"."COMPANY_ID" AND
"VCCS_PREVIOUS"."CARRIER_ID"(+)="PREVIOUS_CARRIER_CYCLE"."CARRIER_ID" AND "VCCS_PREVIOUS"."CYCLE_NUMBER"(+)="PREVIOUS_CARRIER_CYCLE"."CYCLE_NUMBER")
310 - access("VIP_CYCLE"."CONTROL_ID"='SMLMKT' AND "VIP_CYCLE"."CARRIER_ID"='CIGNA_1' AND "VIP_CYCLE"."CYCLE_NUMBER"="VCCS_LAST"."CYCLE_NUMBER")
311 - filter("VIP_CYCLE"."COMPANY_ID"="VCCS_LAST"."COMPANY_ID")
317 - access("COMPANIES"."COMPANY_ID"="VIP_CYCLE_COMPANY_CUSTOM"."COMPANY_ID" AND "CARRIER_ID"="VIP_CYCLE_COMPANY_CUSTOM"."CARRIER_ID" AND
"COMPANIES"."CONTROL_ID"="VIP_CYCLE_COMPANY_CUSTOM"."CONTROL_ID")
319 - access("LAST_CYCLE_DATA"."COMPANY_ID"="COMPANIES"."COMPANY_ID" AND "CONTROL_ID"="COMPANIES"."CONTROL_ID")
321 - filter("TERM_DATE" IS NULL OR "TERM_DATE">=TRUNC(SYSDATE@!))
322 - access("CONTROL_ID"='SMLMKT' AND "CARRIER_ID"='CIGNA_1')
filter("EFF_DATE"= (SELECT MAX("EPC"."EFF_DATE") FROM "Z_MM_CC_A"."EPP_CARRIER_INFO" "EPC" WHERE "EPC"."CARRIER_ID"=:B1 AND "EPC"."CONTROL_ID"=:B2
AND ("EPC"."TERM_DATE" IS NULL OR "EPC"."TERM_DATE">=TRUNC(SYSDATE@!))))
324 - filter("EPC"."TERM_DATE" IS NULL OR "EPC"."TERM_DATE">=TRUNC(SYSDATE@!))
325 - access("EPC"."CONTROL_ID"=:B1 AND "EPC"."CARRIER_ID"=:B2)
327 - filter(("LAST_CYCLE_DATA"."BENEFIT_ID"='LTD' OR "LAST_CYCLE_DATA"."BENEFIT_ID"='STD') AND "LAST_CYCLE_DATA"."CARRIER_ID"='CIGNA_1' AND
"LAST_CYCLE_DATA"."CONTROL_ID"='SMLMKT')
329 - filter("COMPANIES"."COMPANY_ONECODE"='RESI61' AND "COMPANIES"."CONTROL_ID"='SMLMKT')
331 - access("CD"."CONTROL_ID"="CONTACTS"."CONTROL_ID"(+) AND "CD"."COMPANY_ID"="CONTACTS"."COMPANY_ID"(+))
332 - access("C"."COMPANY_ID"="CD"."COMPANY_ID" AND "C"."CONTROL_ID"="CD"."CONTROL_ID")
333 - filter("CD"."TEST_COMPANY_IND"='N')
336 - filter("CONTACT_ID"="MAX_CONTACT_ID")
341 - filter("CONTROL_ID"='SMLMKT' AND "CARRIER_ID"='CIGNA_1')
343 - filter(SYS_OP_BLOOM_FILTER(:BF0000,"C2","C1","C0"))
344 - access("VIP_OG_CYCLE_CHG_INDS"."CONTROL_ID"='SMLMKT' AND "VIP_OG_CYCLE_CHG_INDS"."CARRIER_ID"='CIGNA_1' AND
"LAST_CYCLE_DATA"."CYCLE_NUMBER"="VIP_OG_CYCLE_CHG_INDS"."CYCLE_NUMBER" AND "LAST_CYCLE_DATA"."BENEFIT_ID"="VIP_OG_CYCLE_CHG_INDS"."BENEFIT_ID" AND
"LAST_CYCLE_DATA"."SSN"="VIP_OG_CYCLE_CHG_INDS"."SSN" AND "LAST_CYCLE_DATA"."DEP_SSN"="VIP_OG_CYCLE_CHG_INDS"."DEP_SSN")
filter("VIP_OG_CYCLE_CHG_INDS"."BENEFIT_ID"='LTD' OR "VIP_OG_CYCLE_CHG_INDS"."BENEFIT_ID"='STD')
346 - access("VIP_CYCLE_DATA_FILTERED"."COMPANY_ID"="COMPANY_ID")
347 - access("VIP_CYCLE_DATA_FILTERED"."CONTROL_ID"="VIP_CYCLE_COMPANY_BENEFITS"."CONTROL_ID"(+) AND
"VIP_CYCLE_DATA_FILTERED"."COMPANY_ID"="VIP_CYCLE_COMPANY_BENEFITS"."COMPANY_ID"(+))
348 - filter("VIP_CYCLE_DATA_FILTERED"."COMPANY_ROW_NUMBER"=1)
356 - filter("RN"=1 AND "CUTOFF_DATE">="OE_FILE_DATE")
357 - filter(ROW_NUMBER() OVER ( PARTITION BY "CPD"."COMPANY_ID" ORDER BY "CPD"."PLAN_YEAR")<=1)
362 - access("CCC"."CONTROL_ID"='SMLMKT' AND "CCC"."CARRIER_ID"='CIGNA_1')
filter("CCC"."CARRIER_ID"='CIGNA_1')
364 - access("CCC"."COMPANY_ID"="CPD"."COMPANY_ID" AND "CPD"."CONTROL_ID"='SMLMKT' AND "CCC"."PLAN_YEAR"="CPD"."PLAN_YEAR")
365 - access("VGCCS"."CONTROL_ID"='SMLMKT' AND "VGCCS"."COMPANY_ID"="CCC"."COMPANY_ID" AND "VGCCS"."CARRIER_ID"='CIGNA_1' AND "VGCCS"."CYCLE_NUMBER"=
(SELECT MAX("VGCS"."CYCLE_NUMBER") FROM "VIP_OG_CYCLE_SUMMARY" "VGCS" WHERE "VGCS"."CARRIER_ID"='CIGNA_1' AND "VGCS"."CONTROL_ID"='SMLMKT'))
368 - access("VGCS"."CONTROL_ID"='SMLMKT' AND "VGCS"."CARRIER_ID"='CIGNA_1')
369 - filter("CPD"."YEAR_BEGIN_DATE">"VGCCS"."CUTOFF_DATE")
|
|
|
