博客讲述了如何通过谓词推入优化SQL查询性能。在一个包含复杂嵌套视图的案例中，由于OWNERR.PP_OOO表的谓词条件未被推入视图，导致大量全表扫描。解决方案包括为全表扫描的对象创建索引和使用/*+ push_pred(v)*/提示，使得过滤条件能尽早应用，从而显著减少执行时间和逻辑读取。经过调整，查询耗时降低了98%，逻辑读资源消耗减少了99%。
案例很简单，主要就是长……
Sql文本：
select count(*)
from VIEW_SB_UUUUUUUUUUUUUUUUU
where 1 = 1
and (KKKKID in (SELECT orgno
FROM PP_OOO
WHERE PARENTORGNO = '1100000784'
or orgno = '1100000784'));
原耗时、执行计划及资源消耗：
Elapsed: 00:00:45.71
Execution Plan
----------------------------------------------------------
Plan hash value: 3484991639
-----------------------------------------------------------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes |TempSpc| Cost (%CPU)| Time |
-----------------------------------------------------------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 1 | 29 | | 169K (1)| 00:33:50 |
| 1 | SORT AGGREGATE | | 1 | 29 | | | |
|* 2 | HASH JOIN | | 141K| 3996K| | 169K (1)| 00:33:50 |
| 3 | TABLE ACCESS BY INDEX ROWID | PP_OOO | 5 | 110 | | 3 (0)| 00:00:01 |
| 4 | BITMAP CONVERSION TO ROWIDS | | | | | | |
| 5 | BITMAP OR | | | | | | |
| 6 | BITMAP CONVERSION FROM ROWIDS | | | | | | |
|* 7 | INDEX RANGE SCAN | IND_PPPPP_PGO | | | | 1 (0)| 00:00:01 |
| 8 | BITMAP CONVERSION FROM ROWIDS | | | | | | |
|* 9 | INDEX RANGE SCAN | PK_PPPPP_KEY | | | | 1 (0)| 00:00:01 |
| 10 | VIEW | VIEW_SB_UUUUUUUUUUUUUUUUU | 141K| 965K| | 169K (1)| 00:33:50 |
| 11 | UNION-ALL | | | | | | |
| 12 | VIEW | | 1194 | 8358 | | 17116 (1)| 00:03:26 |
| 13 | UNION-ALL | | | | | | |
| 14 | NESTED LOOPS OUTER | | 1193 | 270K| | 17115 (1)| 00:03:26 |
| 15 | VIEW | | 1193 | 242K| | 14728 (1)| 00:02:57 |
| 16 | UNION-ALL | | | | | | |
| 17 | HASH UNIQUE | | 281 | 42150 | | 6186 (1)| 00:01:15 |
| 18 | NESTED LOOPS OUTER | | 281 | 42150 | | 6185 (1)| 00:01:15 |
|* 19 | TABLE ACCESS FULL | SB_SSSSSSS | 281 | 34001 | | 6184 (1)| 00:01:15 |
| 20 | TABLE ACCESS BY INDEX ROWID | SB_SSSSSSS_SBXX | 1 | 29 | | 1 (0)| 00:00:01 |
|* 21 | INDEX RANGE SCAN | INX_SSSRRRRXXXXRNO | 1 | | | 0 (0)| 00:00:01 |
| 22 | HASH UNIQUE | | 24 | 3720 | | 425 (1)| 00:00:06 |
| 23 | NESTED LOOPS OUTER | | 24 | 3720 | | 424 (1)| 00:00:06 |
|* 24 | TABLE ACCESS FULL | SB_CKKKKKK_JNSR | 23 | 2898 | | 378 (1)| 00:00:05 |
| 25 | TABLE ACCESS BY INDEX ROWID | SB_CKKKKKK_JN_HXXX | 1 | 29 | | 2 (0)| 00:00:01 |
|* 26 | INDEX RANGE SCAN | INX_CKKKKKKJNHXXXR | 1 | | | 1 (0)| 00:00:01 |
| 27 | HASH UNIQUE | | 228 | 40128 | | 2643 (1)| 00:00:32 |
| 28 | NESTED LOOPS OUTER | | 228 | 40128 | | 2642 (1)| 00:00:32 |
| 29 | NESTED LOOPS OUTER | | 228 | 33516 | | 2641 (1)| 00:00:32 |
|* 30 | TABLE ACCESS FULL | SB_JWWWW | 228 | 26904 | | 2640 (1)| 00:00:32 |
| 31 | TABLE ACCESS BY INDEX ROWID | SB_JWWWW_HXXX | 1 | 29 | | 1 (0)| 00:00:01 |
|* 32 | INDEX RANGE SCAN | INX_JWWWWQSHXXXRNO | 1 | | | 0 (0)| 00:00:01 |
| 33 | TABLE ACCESS BY INDEX ROWID | SB_JWWWW_SBXX | 1 | 29 | | 1 (0)| 00:00:01 |
|* 34 | INDEX RANGE SCAN | INX_JWWWWQSSBXXRNO | 1 | | | 0 (0)| 00:00:01 |
| 35 | HASH UNIQUE | | 63 | 9702 | | 963 (1)| 00:00:12 |
| 36 | NESTED LOOPS OUTER | | 63 | 9702 | | 962 (1)| 00:00:12 |
|* 37 | TABLE ACCESS FULL | SB_JNNNN | 63 | 7875 | | 961 (1)| 00:00:12 |
| 38 | TABLE ACCESS BY INDEX ROWID | SB_JNNNN_HXXX | 1 | 29 | | 1 (0)| 00:00:01 |
|* 39 | INDEX RANGE SCAN | INX_JNNNNQSHXXXRNO | 1 | | | 0 (0)| 00:00:01 |
| 40 | HASH UNIQUE | | 97 | 17751 | | 896 (1)| 00:00:11 |
| 41 | NESTED LOOPS OUTER | | 97 | 17751 | | 895 (1)| 00:00:11 |
| 42 | NESTED LOOPS OUTER | | 97 | 14938 | | 894 (1)| 00:00:11 |
|* 43 | TABLE ACCESS FULL | SB_DDDDDDTTS | 97 | 12125 | | 893 (1)| 00:00:11 |
| 44 | TABLE ACCESS BY INDEX ROWID | SB_DWWWWWTZS_HXXX | 1 | 29 | | 1 (0)| 00:00:01 |
|* 45 | INDEX RANGE SCAN | INX_DWWWWWWWWWWWNO | 1 | | | 0 (0)| 00:00:01 |
| 46 | TABLE ACCESS BY INDEX ROWID | SB_DWWWWWTZS_SBXX | 1 | 29 | | 1 (0)| 00:00:01 |
|* 47 | INDEX RANGE SCAN | INX_DWDDDDDDDDDDNO | 1 | | | 0 (0)| 00:00:01 |
| 48 | HASH UNIQUE | | 7 | 1078 | | 105 (1)| 00:00:02 |
| 49 | NESTED LOOPS OUTER | | 7 | 1078 | | 104 (0)| 00:00:02 |
|* 50 | TABLE ACCESS FULL | SB_JNFFFFFFS | 7 | 875 | | 103 (0)| 00:00:02 |
| 51 | TABLE ACCESS BY INDEX ROWID | SB_DDDDDDTZS_HXXX | 1 | 29 | | 1 (0)| 00:00:01 |
|* 52 | INDEX RANGE SCAN | INX_DNNNNNNNNNNNNO | 1 | | | 0 (0)| 00:00:01 |
| 53 | HASH UNIQUE | | 234 | 35334 | | 3058 (1)| 00:00:37 |
| 54 | NESTED LOOPS OUTER | | 234 | 35334 | | 3057 (1)| 00:00:37 |
|* 55 | TABLE ACCESS FULL | SB_ZZZZ | 234 | 28548 | | 3056 (1)| 00:00:37 |
| 56 | TABLE ACCESS BY INDEX ROWID | SB_ZZZZ_GLXX | 1 | 29 | | 1 (0)| 00:00:01 |
|* 57 | INDEX RANGE SCAN | PK_SB_ZZZZ_GLXX_RPTNO | 1 | | | 0 (0)| 00:00:01 |
| 58 | HASH UNIQUE | | 259 | 39627 | | 450 (1)| 00:00:06 |
| 59 | NESTED LOOPS OUTER | | 259 | 39627 | | 449 (1)| 00:00:06 |
|* 60 | TABLE ACCESS FULL | SB_ZHHH | 259 | 32116 | | 448 (1)| 00:00:06 |
| 61 | TABLE ACCESS BY INDEX ROWID | SB_ZHHH_GLXX | 1 | 29 | | 1 (0)| 00:00:01 |
|* 62 | INDEX RANGE SCAN | PK_SB_ZHHH_GLXX_RPTNO | 1 | | | 0 (0)| 00:00:01 |
| 63 | TABLE ACCESS BY INDEX ROWID | BU_TTTTTTTTTTTINFO | 1 | 24 | | 2 (0)| 00:00:01 |
|* 64 | INDEX UNIQUE SCAN | PK_BRRRRRRRRD_KEY | 1 | | | 1 (0)| 00:00:01 |
| 65 | HASH UNIQUE | | 1 | 128 | | 1 (100)| 00:00:01 |
|* 66 | FILTER | | | | | | |
| 67 | NESTED LOOPS OUTER | | 809 | 101K| | 57694 (1)| 00:11:33 |
|* 68 | HASH JOIN ANTI | | 809 | 78473 | 7272K| 56960 (1)| 00:11:24 |
|* 69 | TABLE ACCESS FULL | BU_TTTTTTTTTTTINFO | 80863 | 6317K| | 40037 (1)| 00:08:01 |
| 70 | VIEW | | 1398K| 22M| | 14639 (1)| 00:02:56 |
| 71 | UNION-ALL | | | | | | |
| 72 | TABLE ACCESS FULL | SB_SSSSSSS | 607K| 9M| | 6174 (1)| 00:01:15 |
| 73 | TABLE ACCESS FULL | SB_CKKKKKK_JNSR | 35512 | 589K| | 378 (1)| 00:00:05 |
| 74 | TABLE ACCESS FULL | SB_JWWWW | 261K| 4348K| | 2635 (1)| 00:00:32 |
| 75 | TABLE ACCESS FULL | SB_JNNNN | 64426 | 1069K| | 960 (1)| 00:00:12 |
| 76 | TABLE ACCESS FULL | SB_DDDDDDTTS | 76194 | 1264K| | 892 (1)| 00:00:11 |
| 77 | TABLE ACCESS FULL | SB_JNFFFFFFS | 4688 | 79696 | | 103 (0)| 00:00:02 |
| 78 | TABLE ACCESS FULL | SB_ZZZZ | 304K| 5055K| | 3051 (1)| 00:00:37 |
| 79 | TABLE ACCESS FULL | SB_ZHHH | 43465 | 721K| | 447 (1)| 00:00:06 |
| 80 | TABLE ACCESS BY INDEX ROWID | PA_CCCC | 1 | 31 | | 1 (0)| 00:00:01 |
|* 81 | INDEX UNIQUE SCAN | PK_PACCCC_KEY | 1 | | | 0 (0)| 00:00:01 |
| 82 | VIEW | | 69988 | 478K| | 55844 (1)| 00:11:11 |
| 83 | UNION-ALL | | | | | | |
|* 84 | HASH JOIN OUTER | | 69987 | 15M| 14M| 55843 (1)| 00:11:11 |
| 85 | VIEW | | 69987 | 13M| | 17027 (1)| 00:03:25 |
| 86 | UNION-ALL | | | | | | |
| 87 | HASH UNIQUE | | 30366 | 4448K| 4968K| 7218 (1)| 00:01:27 |
|* 88 | FILTER | | | | | | |
| 89 | NESTED LOOPS OUTER | | 30366 | 4448K| | 6210 (1)| 00:01:15 |
|* 90 | TABLE ACCESS FULL | SB_SSSSSSS | 30366 | 3588K| | 6208 (1)| 00:01:15 |
| 91 | TABLE ACCESS BY INDEX ROWID | SB_SSSSSSS_SBXX | 1 | 29 | | 1 (0)| 00:00:01 |
|* 92 | INDEX RANGE SCAN | INX_SSSRRRRXXXXRNO | 1 | | | 0 (0)| 00:00:01 |
| 93 | HASH UNIQUE | | 1861 | 281K| | 640 (2)| 00:00:08 |
|* 94 | FILTER | | | | | | |
|* 95 | HASH JOIN OUTER | | 1861 | 281K| | 639 (1)| 00:00:08 |
|* 96 | TABLE ACCESS FULL | SB_CKKKKKK_JNSR | 1776 | 218K| | 380 (2)| 00:00:05 |
| 97 | TABLE ACCESS FULL | SB_CKKKKKK_JN_HXXX | 34954 | 989K| | 258 (1)| 00:00:04 |
| 98 | HASH UNIQUE | | 13095 | 2250K| 2448K| 3165 (1)| 00:00:38 |
|* 99 | FILTER | | | | | | |
|*100 | HASH JOIN RIGHT OUTER | | 13095 | 2250K| | 2657 (1)| 00:00:32 |
| 101 | TABLE ACCESS FULL | SB_JWWWW_SBXX | 123 | 3567 | | 3 (0)| 00:00:01 |
|*102 | HASH JOIN RIGHT OUTER | | 13095 | 1879K| | 2654 (1)| 00:00:32 |
| 103 | TABLE ACCESS FULL | SB_JWWWW_HXXX | 123 | 3567 | | 3 (0)| 00:00:01 |
|*104 | TABLE ACCESS FULL | SB_JWWWW | 13095 | 1508K| | 2650 (1)| 00:00:32 |
| 105 | HASH UNIQUE | | 3221 | 484K| | 966 (1)| 00:00:12 |
|*106 | FILTER | | | | | | |
| 107 | NESTED LOOPS OUTER | | 3221 | 484K| | 965 (1)| 00:00:12 |
|*108 | TABLE ACCESS FULL | SB_JNNNN | 3221 | 393K| | 964 (1)| 00:00:12 |
| 109 | TABLE ACCESS BY INDEX ROWID | SB_JNNNN_HXXX | 1 | 29 | | 1 (0)| 00:00:01 |
|*110 | INDEX RANGE SCAN | INX_JNNNNQSHXXXRNO | 1 | | | 0 (0)| 00:00:01 |
| 111 | HASH UNIQUE | | 3810 | 680K| | 900 (2)| 00:00:11 |
|*112 | FILTER | | | | | | |
| 113 | NESTED LOOPS OUTER | | 3810 | 680K| | 898 (1)| 00:00:11 |
| 114 | NESTED LOOPS OUTER | | 3810 | 572K| | 897 (1)| 00:00:11 |
|*115 | TABLE ACCESS FULL | SB_DDDDDDTTS | 3810 | 465K| | 896 (1)| 00:00:11 |
| 116 | TABLE ACCESS BY INDEX ROWID | SB_DWWWWWTZS_HXXX | 1 | 29 | | 1 (0)| 00:00:01 |
|*117 | INDEX RANGE SCAN | INX_DWWWWWWWWWWWNO | 1 | | | 0 (0)| 00:00:01 |
| 118 | TABLE ACCESS BY INDEX ROWID | SB_DWWWWWTZS_SBXX | 1 | 29 | | 1 (0)| 00:00:01 |
|*119 | INDEX RANGE SCAN | INX_DWDDDDDDDDDDNO | 1 | | | 0 (0)| 00:00:01 |
| 120 | HASH UNIQUE | | 234 | 36036 | | 106 (2)| 00:00:02 |
|*121 | FILTER | | | | | | |
| 122 | NESTED LOOPS OUTER | | 234 | 36036 | | 105 (1)| 00:00:02 |
|*123 | TABLE ACCESS FULL | SB_JNFFFFFFS | 234 | 29250 | | 104 (1)| 00:00:02 |
| 124 | TABLE ACCESS BY INDEX ROWID | SB_DDDDDDTZS_HXXX | 1 | 29 | | 1 (0)| 00:00:01 |
|*125 | INDEX RANGE SCAN | INX_DNNNNNNNNNNNNO | 1 | | | 0 (0)| 00:00:01 |
| 126 | HASH UNIQUE | | 15227 | 2245K| 2496K| 3582 (1)| 00:00:43 |
|*127 | FILTER | | | | | | |
| 128 | NESTED LOOPS OUTER | | 15227 | 2245K| | 3070 (1)| 00:00:37 |
|*129 | TABLE ACCESS FULL | SB_ZZZZ | 15227 | 1814K| | 3068 (1)| 00:00:37 |
| 130 | TABLE ACCESS BY INDEX ROWID | SB_ZZZZ_GLXX | 1 | 29 | | 1 (0)| 00:00:01 |
|*131 | INDEX RANGE SCAN | PK_SB_ZZZZ_GLXX_RPTNO | 1 | | | 0 (0)| 00:00:01 |
| 132 | HASH UNIQUE | | 2173 | 324K| | 451 (2)| 00:00:06 |
|*133 | FILTER | | | | | | |
| 134 | NESTED LOOPS OUTER | | 2173 | 324K| | 450 (1)| 00:00:06 |
|*135 | TABLE ACCESS FULL | SB_ZHHH | 2173 | 263K| | 449 (1)| 00:00:06 |
| 136 | TABLE ACCESS BY INDEX ROWID | SB_ZHHH_GLXX | 1 | 29 | | 1 (0)| 00:00:01 |
|*137 | INDEX RANGE SCAN | PK_SB_ZHHH_GLXX_RPTNO | 1 | | | 0 (0)| 00:00:01 |
| 138 | VIEW | index$_join$_096 | 3018K| 69M| | 32919 (1)| 00:06:36 |
|*139 | HASH JOIN | | | | | | |
| 140 | INDEX FAST FULL SCAN | IDX_BU_TTTTTTTTTTTINFO_TDNOFI | 3018K| 69M| | 14661 (1)| 00:02:56 |
| 141 | INDEX FAST FULL SCAN | PK_BRRRRRRRRD_KEY | 3018K| 69M| | 14293 (1)| 00:02:52 |
| 142 | HASH UNIQUE | | 1 | 128 | | 1 (100)| 00:00:01 |
|*143 | FILTER | | | | | | |
| 144 | NESTED LOOPS OUTER | | 809 | 101K| | 57694 (1)| 00:11:33 |
|*145 | HASH JOIN ANTI | | 809 | 78473 | 7272K| 56960 (1)| 00:11:24 |
|*146 | TABLE ACCESS FULL | BU_TTTTTTTTTTTINFO | 80863 | 6317K| | 40037 (1)| 00:08:01 |
| 147 | VIEW | | 1398K| 22M| | 14639 (1)| 00:02:56 |
| 148 | UNION-ALL | | | | | | |
| 149 | TABLE ACCESS FULL | SB_SSSSSSS | 607K| 9M| | 6174 (1)| 00:01:15 |
| 150 | TABLE ACCESS FULL | SB_CKKKKKK_JNSR | 35512 | 589K| | 378 (1)| 00:00:05 |
| 151 | TABLE ACCESS FULL | SB_JWWWW | 261K| 4348K| | 2635 (1)| 00:00:32 |
| 152 | TABLE ACCESS FULL | SB_JNNNN | 64426 | 1069K| | 960 (1)| 00:00:12 |
| 153 | TABLE ACCESS FULL | SB_DDDDDDTTS | 76194 | 1264K| | 892 (1)| 00:00:11 |
| 154 | TABLE ACCESS FULL | SB_JNFFFFFFS | 4688 | 79696 | | 103 (0)| 00:00:02 |
| 155 | TABLE ACCESS FULL | SB_ZZZZ | 304K| 5055K| | 3051 (1)| 00:00:37 |
| 156 | TABLE ACCESS FULL | SB_ZHHH | 43465 | 721K| | 447 (1)| 00:00:06 |
| 157 | TABLE ACCESS BY INDEX ROWID | PA_CCCC | 1 | 31 | | 1 (0)| 00:00:01 |
|*158 | INDEX UNIQUE SCAN | PK_PACCCC_KEY | 1 | | | 0 (0)| 00:00:01 |
|*159 | HASH JOIN RIGHT SEMI | | 69994 | 3144K| | 96157 (1)| 00:19:14 |
|*160 | TABLE ACCESS FULL | SB_DEEEEEEERR | 7205 | 182K| | 139 (1)| 00:00:02 |
| 161 | VIEW | | 69994 | 1367K| | 96017 (1)| 00:19:13 |
| 162 | UNION-ALL | | | | | | |
|*163 | HASH JOIN OUTER | | 69987 | 15M| 14M| 55843 (1)| 00:11:11 |
|*164 | VIEW | | 69987 | 13M| | 17027 (1)| 00:03:25 |
| 165 | UNION-ALL | | | | | | |
| 166 | HASH UNIQUE | | 30366 | 4448K| 4968K| 7218 (1)| 00:01:27 |
|*167 | FILTER | | | | | | |
| 168 | NESTED LOOPS OUTER | | 30366 | 4448K| | 6210 (1)| 00:01:15 |
|*169 | TABLE ACCESS FULL | SB_SSSSSSS | 30366 | 3588K| | 6208 (1)| 00:01:15 |
| 170 | TABLE ACCESS BY INDEX ROWID | SB_SSSSSSS_SBXX | 1 | 29 | | 1 (0)| 00:00:01 |
|*171 | INDEX RANGE SCAN | INX_SSSRRRRXXXXRNO | 1 | | | 0 (0)| 00:00:01 |
| 172 | HASH UNIQUE | | 1861 | 281K| | 640 (2)| 00:00:08 |
|*173 | FILTER | | | | | | |
|*174 | HASH JOIN OUTER | | 1861 | 281K| | 639 (1)| 00:00:08 |
|*175 | TABLE ACCESS FULL | SB_CKKKKKK_JNSR | 1776 | 218K| | 380 (2)| 00:00:05 |
| 176 | TABLE ACCESS FULL | SB_CKKKKKK_JN_HXXX | 34954 | 989K| | 258 (1)| 00:00:04 |
| 177 | HASH UNIQUE | | 13095 | 2250K| 2448K| 3165 (1)| 00:00:38 |
|*178 | FILTER | | | | | | |
|*179 | HASH JOIN RIGHT OUTER | | 13095 | 2250K| | 2657 (1)| 00:00:32 |
| 180 | TABLE ACCESS FULL | SB_JWWWW_SBXX | 123 | 3567 | | 3 (0)| 00:00:01 |
|*181 | HASH JOIN RIGHT OUTER | | 13095 | 1879K| | 2654 (1)| 00:00:32 |
| 182 | TABLE ACCESS FULL | SB_JWWWW_HXXX | 123 | 3567 | | 3 (0)| 00:00:01 |
|*183 | TABLE ACCESS FULL | SB_JWWWW | 13095 | 1508K| | 2650 (1)| 00:00:32 |
| 184 | HASH UNIQUE | | 3221 | 484K| | 966 (1)| 00:00:12 |
|*185 | FILTER | | | | | | |
| 186 | NESTED LOOPS OUTER | | 3221 | 484K| | 965 (1)| 00:00:12 |
|*187 | TABLE ACCESS FULL | SB_JNNNN | 3221 | 393K| | 964 (1)| 00:00:12 |
| 188 | TABLE ACCESS BY INDEX ROWID | SB_JNNNN_HXXX | 1 | 29 | | 1 (0)| 00:00:01 |
|*189 | INDEX RANGE SCAN | INX_JNNNNQSHXXXRNO | 1 | | | 0 (0)| 00:00:01 |
| 190 | HASH UNIQUE | | 3810 | 680K| | 900 (2)| 00:00:11 |
|*191 | FILTER | | | | | | |
| 192 | NESTED LOOPS OUTER | | 3810 | 680K| | 898 (1)| 00:00:11 |
| 193 | NESTED LOOPS OUTER | | 3810 | 572K| | 897 (1)| 00:00:11 |
|*194 | TABLE ACCESS FULL | SB_DDDDDDTTS | 3810 | 465K| | 896 (1)| 00:00:11 |
| 195 | TABLE ACCESS BY INDEX ROWID| SB_DWWWWWTZS_HXXX | 1 | 29 | | 1 (0)| 00:00:01 |
|*196 | INDEX RANGE SCAN | INX_DWWWWWWWWWWWNO | 1 | | | 0 (0)| 00:00:01 |
| 197 | TABLE ACCESS BY INDEX ROWID | SB_DWWWWWTZS_SBXX | 1 | 29 | | 1 (0)| 00:00:01 |
|*198 | INDEX RANGE SCAN | INX_DWDDDDDDDDDDNO | 1 | | | 0 (0)| 00:00:01 |
| 199 | HASH UNIQUE | | 234 | 36036 | | 106 (2)| 00:00:02 |
|*200 | FILTER | | | | | | |
| 201 | NESTED LOOPS OUTER | | 234 | 36036 | | 105 (1)| 00:00:02 |
|*202 | TABLE ACCESS FULL | SB_JNFFFFFFS | 234 | 29250 | | 104 (1)| 00:00:02 |
| 203 | TABLE ACCESS BY INDEX ROWID | SB_DDDDDDTZS_HXXX | 1 | 29 | | 1 (0)| 00:00:01 |
|*204 | INDEX RANGE SCAN | INX_DNNNNNNNNNNNNO | 1 | | | 0 (0)| 00:00:01 |
| 205 | HASH UNIQUE | | 15227 | 2245K| 2496K| 3582 (1)| 00:00:43 |
|*206 | FILTER | | | | | | |
| 207 | NESTED LOOPS OUTER | | 15227 | 2245K| | 3070 (1)| 00:00:37 |
|*208 | TABLE ACCESS FULL | SB_ZZZZ | 15227 | 1814K| | 3068 (1)| 00:00:37 |
| 209 | TABLE ACCESS BY INDEX ROWID | SB_ZZZZ_GLXX | 1 | 29 | | 1 (0)| 00:00:01 |
|*210 | INDEX RANGE SCAN | PK_SB_ZZZZ_GLXX_RPTNO | 1 | | | 0 (0)| 00:00:01 |
| 211 | HASH UNIQUE | | 2173 | 324K| | 451 (2)| 00:00:06 |
|*212 | FILTER | | | | | | |
| 213 | NESTED LOOPS OUTER | | 2173 | 324K| | 450 (1)| 00:00:06 |
|*214 | TABLE ACCESS FULL | SB_ZHHH | 2173 | 263K| | 449 (1)| 00:00:06 |
| 215 | TABLE ACCESS BY INDEX ROWID | SB_ZHHH_GLXX | 1 | 29 | | 1 (0)| 00:00:01 |
|*216 | INDEX RANGE SCAN | PK_SB_ZHHH_GLXX_RPTNO | 1 | | | 0 (0)| 00:00:01 |
| 217 | VIEW | index$_join$_155 | 3018K| 69M| | 32919 (1)| 00:06:36 |
|*218 | HASH JOIN | | | | | | |
| 219 | INDEX FAST FULL SCAN | IDX_BU_TTTTTTTTTTTINFO_TDNOFI | 3018K| 69M| | 14661 (1)| 00:02:56 |
| 220 | INDEX FAST FULL SCAN | PK_BRRRRRRRRD_KEY | 3018K| 69M| | 14293 (1)| 00:02:52 |
| 221 | HASH UNIQUE | | 7 | 896 | | 40175 (1)| 00:08:03 |
| 222 | NESTED LOOPS OUTER | | 7 | 896 | | 40174 (1)| 00:08:03 |
| 223 | NESTED LOOPS ANTI | | 7 | 679 | | 40167 (1)| 00:08:03 |
|*224 | TABLE ACCESS FULL | BU_TTTTTTTTTTTINFO | 8 | 640 | | 40055 (1)| 00:08:01 |
| 225 | VIEW | | 2 | 34 | | 14 (0)| 00:00:01 |
| 226 | UNION ALL PUSHED PREDICATE | | | | | | |
|*227 | INDEX RANGE SCAN | INX_SSSRSSD_TID | 1 | 17 | | 3 (0)| 00:00:01 |
|*228 | INDEX RANGE SCAN | INX_CKSHHHHHHJNTID | 1 | 17 | | 1 (0)| 00:00:01 |
|*229 | INDEX RANGE SCAN | INX_JWWWWQSTID | 1 | 17 | | 3 (0)| 00:00:01 |
|*230 | INDEX RANGE SCAN | INX_JNNNNQSTID | 1 | 17 | | 1 (0)| 00:00:01 |
|*231 | INDEX RANGE SCAN | INX_DWWWWWTZSTID | 1 | 17 | | 1 (0)| 00:00:01 |
|*232 | INDEX RANGE SCAN | INX_JNFFFFFFSTID | 1 | 17 | | 1 (0)| 00:00:01 |
|*233 | INDEX RANGE SCAN | IDX_SB_ZZZZ_RWIDH | 1 | 17 | | 3 (0)| 00:00:01 |
|*234 | INDEX RANGE SCAN | IDX_SB_ZHHH_RWIDH | 1 | 17 | | 1 (0)| 00:00:01 |
| 235 | TABLE ACCESS BY INDEX ROWID | PA_CCCC | 1 | 31 | | 1 (0)| 00:00:01 |
|*236 | INDEX UNIQUE SCAN | PK_PACCCC_KEY | 1 | | | 0 (0)| 00:00:01 |
-----------------------------------------------------------------------------------------------------------------------------------
Predicate Information (identified by operation id):
---------------------------------------------------
2 - access("KKKKID"="ORGNO")
7 - access("PARENTORGNO"='1100000784')
9 - access("ORGNO"='1100000784')
19 - filter("T2"."SFYSB"='N' AND ADD_MONTHS(INTERNAL_FUNCTION("T2"."SJLRRQ"),1)>SYSDATE@! AND "T2"."SFZX"='Y' AND
"T2"."SXBZ"='1')
21 - access("T2"."RPTNO"="T3"."RPTNO"(+))
24 - filter("T2"."SFYSB"='N' AND ADD_MONTHS(INTERNAL_FUNCTION("T2"."SJLRRQ"),1)>SYSDATE@! AND "T2"."SFZX"='Y' AND
"T2"."SXBZ"='1')
26 - access("T2"."RPTNO"="T3"."RPTNO"(+))
30 - filter("T2"."SFYSB"='N' AND ADD_MONTHS(INTERNAL_FUNCTION("T2"."SJLRRQ"),1)>SYSDATE@! AND "T2"."SFZX"='Y' AND
"T2"."SXBZ"='1')
32 - access("T2"."RPTNO"="T3"."RPTNO"(+))
34 - access("T2"."RPTNO"="T4"."RPTNO"(+))
37 - filter("T2"."SFYSB"='N' AND ADD_MONTHS(INTERNAL_FUNCTION("T2"."SJLRRQ"),1)>SYSDATE@! AND "T2"."SFZX"='Y' AND
"T2"."SXBZ"='1')
39 - access("T2"."RPTNO"="T3"."RPTNO"(+))
43 - filter("T2"."SFYSB"='N' AND ADD_MONTHS(INTERNAL_FUNCTION("T2"."SJLRRQ"),1)>SYSDATE@! AND "T2"."SFZX"='Y' AND
"T2"."SXBZ"='1')
45 - access("T2"."RPTNO"="T4"."RPTNO"(+))
47 - access("T2"."RPTNO"="T3"."RPTNO"(+))
50 - filter("T2"."SFYSB"='N' AND ADD_MONTHS(INTERNAL_FUNCTION("T2"."SJLRRQ"),1)>SYSDATE@! AND "T2"."SFZX"='Y' AND
"T2"."SXBZ"='1')
52 - access("T2"."RPTNO"="T3"."RPTNO"(+))
55 - filter("T2"."SFYSB"='N' AND ADD_MONTHS(INTERNAL_FUNCTION("T2"."SJLRRQ"),1)>SYSDATE@! AND "T2"."SFZX"='Y' AND
"T2"."SXBZ"='1')
57 - access("T2"."RPTNO"="T3"."RPTNO"(+))
60 - filter("T2"."SFYSB"='N' AND ADD_MONTHS(INTERNAL_FUNCTION("T2"."SJLRRQ"),1)>SYSDATE@! AND "T2"."SXBZ"='1' AND
"T2"."SFZX"='Y')
62 - access("T2"."RPTNO"="T3"."RPTNO"(+))
64 - access("TB"."TXNSERIALNO"="T1"."TXNSERIALNO"(+))
66 - filter(NULL IS NOT NULL AND NULL IS NOT NULL AND NULL IS NOT NULL)
68 - access("T1"."TXNSERIALNO"="B"."RWIDH")
69 - filter(ADD_MONTHS(INTERNAL_FUNCTION("T1"."INTERETDATE"),1)>SYSDATE@! AND ("T1"."TRADENO"='010001' OR
"T1"."TRADENO"='010002' OR "T1"."TRADENO"='010003' OR "T1"."TRADENO"='010004' OR "T1"."TRADENO"='010011' OR
"T1"."TRADENO"='020043' OR "T1"."TRADENO"='020088' OR "T1"."TRADENO"='030004' OR "T1"."TRADENO"='030219' OR
"T1"."TRADENO"='030220' OR "T1"."TRADENO"='030221' OR "T1"."TRADENO"='030222' OR "T1"."TRADENO"='030223' OR
"T1"."TRADENO"='030904' OR "T1"."TRADENO"='030908' OR "T1"."TRADENO"='080103' OR "T1"."TRADENO"='080104' OR
"T1"."TRADENO"='080108' OR "T1"."TRADENO"='080202' OR "T1"."TRADENO"='080205' OR "T1"."TRADENO"='080206') AND
"T1"."TRANSTATE"='4')
81 - access("T1"."CCCCNO"="T2"."CCCCNO"(+))
84 - access("TB"."TXNSERIALNO"="T1"."TXNSERIALNO"(+))
88 - filter("T2"."SFYSB"='N' AND "T2"."SXBZ"='0' AND "T2"."SFZX"='Y' OR CASE WHEN "T3"."SFYSB" IS NOT NULL THEN
"T3"."SFYSB" ELSE '*' END ='N' AND CASE WHEN "T3"."SXBZ" IS NOT NULL THEN "T3"."SXBZ" ELSE '*' END ='0' AND CASE WHEN
"T3"."SFZX" IS NOT NULL THEN "T3"."SFZX" ELSE '*' END ='Y')
90 - filter(ADD_MONTHS(INTERNAL_FUNCTION("T2"."SJLRRQ"),1)>SYSDATE@!)
92 - access("T2"."RPTNO"="T3"."RPTNO"(+))
94 - filter("T2"."SFYSB"='N' AND "T2"."SXBZ"='0' AND "T2"."SFZX"='Y' OR CASE WHEN "T3"."SFYSB" IS NOT NULL THEN
"T3"."SFYSB" ELSE '*' END ='N' AND CASE WHEN "T3"."SXBZ" IS NOT NULL THEN "T3"."SXBZ" ELSE '*' END ='0' AND CASE WHEN
"T3"."SFZX" IS NOT NULL THEN "T3"."SFZX" ELSE '*' END ='Y')
95 - access("T2"."RPTNO"="T3"."RPTNO"(+))
96 - filter(ADD_MONTHS(INTERNAL_FUNCTION("T2"."SJLRRQ"),1)>SYSDATE@!)
99 - filter("T2"."SFYSB"='N' AND "T2"."SXBZ"='0' AND "T2"."SFZX"='Y' OR CASE WHEN "T4"."SFYSB" IS NOT NULL THEN
"T4"."SFYSB" ELSE '*' END ='N' AND CASE WHEN "T4"."SXBZ" IS NOT NULL THEN "T4"."SXBZ" ELSE '*' END ='0' AND CASE WHEN
"T4"."SFZX" IS NOT NULL THEN "T4"."SFZX" ELSE '*' END ='Y' OR CASE WHEN "T3"."SFYSB" IS NOT NULL THEN "T3"."SFYSB" ELSE
'*' END ='N' AND CASE WHEN "T3"."SXBZ" IS NOT NULL THEN "T3"."SXBZ" ELSE '*' END ='0' AND CASE WHEN "T3"."SFZX" IS NOT
NULL THEN "T3"."SFZX" ELSE '*' END ='Y')
100 - access("T2"."RPTNO"="T4"."RPTNO"(+))
102 - access("T2"."RPTNO"="T3"."RPTNO"(+))
104 - filter(ADD_MONTHS(INTERNAL_FUNCTION("T2"."SJLRRQ"),1)>SYSDATE@!)
106 - filter("T2"."SFYSB"='N' AND "T2"."SXBZ"='0' AND "T2"."SFZX"='Y' OR CASE WHEN "T3"."SFYSB" IS NOT NULL THEN
"T3"."SFYSB" ELSE '*' END ='N' AND CASE WHEN "T3"."SXBZ" IS NOT NULL THEN "T3"."SXBZ" ELSE '*' END ='0' AND CASE WHEN
"T3"."SFZX" IS NOT NULL THEN "T3"."SFZX" ELSE '*' END ='Y')
108 - filter(ADD_MONTHS(INTERNAL_FUNCTION("T2"."SJLRRQ"),1)>SYSDATE@!)
110 - access("T2"."RPTNO"="T3"."RPTNO"(+))
112 - filter("T2"."SFYSB"='N' AND "T2"."SXBZ"='0' AND "T2"."SFZX"='Y' OR CASE WHEN "T3"."SFYSB" IS NOT NULL THEN
"T3"."SFYSB" ELSE '*' END ='N' AND CASE WHEN "T3"."SXBZ" IS NOT NULL THEN "T3"."SXBZ" ELSE '*' END ='0' AND CASE WHEN
"T3"."SFZX" IS NOT NULL THEN "T3"."SFZX" ELSE '*' END ='Y' OR CASE WHEN "T4"."SFYSB" IS NOT NULL THEN "T4"."SFYSB" ELSE
'*' END ='N' AND CASE WHEN "T4"."SXBZ" IS NOT NULL THEN "T4"."SXBZ" ELSE '*' END ='0' AND CASE WHEN "T4"."SFZX" IS NOT
NULL THEN "T4"."SFZX" ELSE '*' END ='Y')
115 - filter(ADD_MONTHS(INTERNAL_FUNCTION("T2"."SJLRRQ"),1)>SYSDATE@!)
117 - access("T2"."RPTNO"="T4"."RPTNO"(+))
119 - access("T2"."RPTNO"="T3"."RPTNO"(+))
121 - filter("T2"."SFYSB"='N' AND "T2"."SXBZ"='0' AND "T2"."SFZX"='Y' OR CASE WHEN "T3"."SFYSB" IS NOT NULL THEN
"T3"."SFYSB" ELSE '*' END ='N' AND CASE WHEN "T3"."SXBZ" IS NOT NULL THEN "T3"."SXBZ" ELSE '*' END ='0' AND CASE WHEN
"T3"."SFZX" IS NOT NULL THEN "T3"."SFZX" ELSE '*' END ='Y')
123 - filter(ADD_MONTHS(INTERNAL_FUNCTION("T2"."SJLRRQ"),1)>SYSDATE@!)
125 - access("T2"."RPTNO"="T3"."RPTNO"(+))
127 - filter("T2"."SFYSB"='N' AND "T2"."SXBZ"='0' AND "T2"."SFZX"='Y' OR CASE WHEN "T3"."SFYSB" IS NOT NULL THEN
"T3"."SFYSB" ELSE '*' END ='N' AND CASE WHEN "T3"."SXBZ" IS NOT NULL THEN "T3"."SXBZ" ELSE '*' END ='0' AND CASE WHEN
"T3"."SFZX" IS NOT NULL THEN "T3"."SFZX" ELSE '*' END ='Y')
129 - filter(ADD_MONTHS(INTERNAL_FUNCTION("T2"."SJLRRQ"),1)>SYSDATE@!)
131 - access("T2"."RPTNO"="T3"."RPTNO"(+))
133 - filter("T2"."SFYSB"='N' AND "T2"."SXBZ"='0' AND "T2"."SFZX"='Y' OR CASE WHEN "T3"."SFYSB" IS NOT NULL THEN
"T3"."SFYSB" ELSE '*' END ='N' AND CASE WHEN "T3"."SXBZ" IS NOT NULL THEN "T3"."SXBZ" ELSE '*' END ='0' AND CASE WHEN
"T3"."SFZX" IS NOT NULL THEN "T3"."SFZX" ELSE '*' END ='Y')
135 - filter(ADD_MONTHS(INTERNAL_FUNCTION("T2"."SJLRRQ"),1)>SYSDATE@!)
137 - access("T2"."RPTNO"="T3"."RPTNO"(+))
139 - access(ROWID=ROWID)
143 - filter(NULL IS NOT NULL AND NULL IS NOT NULL AND NULL IS NOT NULL)
145 - access("T1"."TXNSERIALNO"="B"."RWIDH")
146 - filter(ADD_MONTHS(INTERNAL_FUNCTION("T1"."INTERETDATE"),1)>SYSDATE@! AND ("T1"."TRADENO"='010001' OR
"T1"."TRADENO"='010002' OR "T1"."TRADENO"='010003' OR "T1"."TRADENO"='010004' OR "T1"."TRADENO"='010011' OR
"T1"."TRADENO"='020043' OR "T1"."TRADENO"='020088' OR "T1"."TRADENO"='030004' OR "T1"."TRADENO"='030219' OR
"T1"."TRADENO"='030220' OR "T1"."TRADENO"='030221' OR "T1"."TRADENO"='030222' OR "T1"."TRADENO"='030223' OR
"T1"."TRADENO"='030904' OR "T1"."TRADENO"='030908' OR "T1"."TRADENO"='080103' OR "T1"."TRADENO"='080104' OR
"T1"."TRADENO"='080108' OR "T1"."TRADENO"='080202' OR "T1"."TRADENO"='080205' OR "T1"."TRADENO"='080206') AND
"T1"."TRANSTATE"='4')
158 - access("T1"."CCCCNO"="T2"."CCCCNO"(+))
159 - access("OT1"."RPTNO"="RPTNO")
160 - filter("STATE"='0')
163 - access("TB"."TXNSERIALNO"="T1"."TXNSERIALNO"(+))
164 - filter(CASE WHEN ("TB"."QTYPE"='1' AND "TB"."CUSTYPE"='D' AND
ROUND("F_EXCHANGERATEUSD_NEW"(TO_DATE('20'||SUBSTR("TB"."RPTNO",13,6),'yyyy-MM-dd'),"TB"."CURSIGN","TB"."AMOUNT"),2)<=5000)
THEN "TB"."JCSFYSB"||"TB"."JCSXBZ"||"TB"."JCSFZX"||"TB"."SBSFYSB"||"TB"."SBSXBZ"||"TB"."SBSFZX"||"TB"."HXSFYSB"||"TB"."HXS
XBZ"||"TB"."HXSFZX" ELSE 'Y1Y******' END ='Y1Y******' AND CASE WHEN ("TB"."QTYPE"='4' AND "TB"."CUSTYPE"='D' AND
ROUND("F_EXCHANGERATEUSD_NEW"(TO_DATE('20'||SUBSTR("TB"."RPTNO",13,6),'yyyy-MM-dd'),"TB"."CURSIGN","TB"."AMOUNT"),2)<=5000)
THEN "TB"."JCSFYSB"||"TB"."JCSXBZ"||"TB"."JCSFZX"||"TB"."SBSFYSB"||"TB"."SBSXBZ"||"TB"."SBSFZX"||"TB"."HXSFYSB"||"TB"."HXS
XBZ"||"TB"."HXSFZX" ELSE 'Y1Y******' END ='Y1Y******')
167 - filter(CASE WHEN '4'='1' THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||CASE WHEN ("T3"."SFYSB" IS NOT NULL) THEN
"T3"."SFYSB" ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END ||'*'||'*' ELSE 'Y1YYYYY'
END ='Y1YYYYY' AND CASE WHEN '4'='2' THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||CASE WHEN ("T3"."SFYSB" IS NOT NULL)
THEN "T3"."SFYSB" ELSE '*' END ||CASE WHEN ("T3"."SXBZ" IS NOT NULL) THEN "T3"."SXBZ" ELSE '*' END ||CASE WHEN
("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END ||'*' ELSE 'Y1Y***YY' END ='Y1Y***YY' AND CASE WHEN '4'='3' THEN
"T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||CASE WHEN ("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB" ELSE '*' END ||CASE WHEN
("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END ||'*'||'*' ELSE 'Y1YYYYY' END ='Y1YYYYY' AND CASE WHEN '4'='4'
THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||CASE WHEN ("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB" ELSE '*' END ||CASE
WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END ||'*'||'*' ELSE 'Y1YYY**' END ='Y1YYY**' AND CASE WHEN
'4'='5' THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||CASE WHEN ("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB" ELSE '*' END
||CASE WHEN ("T3"."SXBZ" IS NOT NULL) THEN "T3"."SXBZ" ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN
"T3"."SFZX" ELSE '*' END ||'*'||'*' ELSE 'Y1Y***YY' END ='Y1Y***YY' AND CASE WHEN '4'='6' THEN
"T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||CASE WHEN ("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB" ELSE '*' END ||CASE WHEN
("T3"."SXBZ" IS NOT NULL) THEN "T3"."SXBZ" ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*'
END ||'*'||'*' ELSE 'Y1Y***YY' END ='Y1Y***YY' AND CASE WHEN '4'='7' THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||CASE
WHEN ("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB" ELSE '*' END ||CASE WHEN ("T3"."SXBZ" IS NOT NULL) THEN "T3"."SXBZ"
ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END ||'*'||'*' ELSE 'Y1Y***YY' END
='Y1Y***YY' AND CASE WHEN '4'='8' THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||CASE WHEN ("T3"."SFYSB" IS NOT NULL) THEN
"T3"."SFYSB" ELSE '*' END ||CASE WHEN ("T3"."SXBZ" IS NOT NULL) THEN "T3"."SXBZ" ELSE '*' END ||CASE WHEN ("T3"."SFZX"
IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END ||'*'||'*' ELSE 'Y1Y***YY' END ='Y1Y***YY')
169 - filter(ADD_MONTHS(INTERNAL_FUNCTION("T2"."SJLRRQ"),1)>SYSDATE@!)
171 - access("T2"."RPTNO"="T3"."RPTNO"(+))
173 - filter(CASE WHEN '6'='1' THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||'*'||'*'||CASE WHEN ("T3"."SFYSB" IS NOT
NULL) THEN "T3"."SFYSB" ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END ELSE 'Y1YYYYY'
END ='Y1YYYYY' AND CASE WHEN '6'='2' THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||'*'||'*'||'*'||CASE WHEN ("T3"."SFZX"
IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END ELSE 'Y1Y***YY' END ='Y1Y***YY' AND CASE WHEN '6'='3' THEN
"T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||'*'||'*'||CASE WHEN ("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB" ELSE '*' END
||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END ELSE 'Y1YYYYY' END ='Y1YYYYY' AND CASE WHEN '6'='4'
THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||'*'||'*'||CASE WHEN ("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB" ELSE '*'
END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END ELSE 'Y1YYY**' END ='Y1YYY**' AND CASE WHEN
'6'='5' THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||'*'||'*'||'*'||CASE WHEN ("T3"."SFYSB" IS NOT NULL) THEN
"T3"."SFYSB" ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END ELSE 'Y1Y***YY' END
='Y1Y***YY' AND CASE WHEN '6'='6' THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||'*'||'*'||'*'||CASE WHEN ("T3"."SFYSB" IS
NOT NULL) THEN "T3"."SFYSB" ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END ELSE
'Y1Y***YY' END ='Y1Y***YY' AND CASE WHEN '6'='7' THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||'*'||'*'||'*'||CASE WHEN
("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB" ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*'
END ELSE 'Y1Y***YY' END ='Y1Y***YY' AND CASE WHEN '6'='8' THEN
"T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||'*'||'*'||'*'||CASE WHEN ("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB" ELSE '*'
END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END ELSE 'Y1Y***YY' END ='Y1Y***YY')
174 - access("T2"."RPTNO"="T3"."RPTNO"(+))
175 - filter(ADD_MONTHS(INTERNAL_FUNCTION("T2"."SJLRRQ"),1)>SYSDATE@!)
178 - filter(CASE WHEN '1'='1' THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||CASE WHEN ("T4"."SFYSB" IS NOT NULL) THEN
"T4"."SFYSB" ELSE '*' END ||CASE WHEN ("T4"."SFZX" IS NOT NULL) THEN "T4"."SFZX" ELSE '*' END ||CASE WHEN ("T3"."SFYSB"
IS NOT NULL) THEN "T3"."SFYSB" ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END ELSE
'Y1YYYYY' END ='Y1YYYYY' AND CASE WHEN '1'='2' THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||CASE WHEN ("T4"."SFYSB" IS
NOT NULL) THEN "T4"."SFYSB" ELSE '*' END ||CASE WHEN ("T4"."SXBZ" IS NOT NULL) THEN "T4"."SXBZ" ELSE '*' END ||CASE WHEN
("T4"."SFZX" IS NOT NULL) THEN "T4"."SFZX" ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*'
END ELSE 'Y1Y***YY' END ='Y1Y***YY' AND CASE WHEN '1'='3' THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||CASE WHEN
("T4"."SFYSB" IS NOT NULL) THEN "T4"."SFYSB" ELSE '*' END ||CASE WHEN ("T4"."SFZX" IS NOT NULL) THEN "T4"."SFZX" ELSE '*'
END ||CASE WHEN ("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB" ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN
"T3"."SFZX" ELSE '*' END ELSE 'Y1YYYYY' END ='Y1YYYYY' AND CASE WHEN '1'='4' THEN
"T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||CASE WHEN ("T4"."SFYSB" IS NOT NULL) THEN "T4"."SFYSB" ELSE '*' END ||CASE WHEN
("T4"."SFZX" IS NOT NULL) THEN "T4"."SFZX" ELSE '*' END ||CASE WHEN ("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB" ELSE '*'
END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END ELSE 'Y1YYY**' END ='Y1YYY**' AND CASE WHEN
'1'='5' THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||CASE WHEN ("T4"."SFYSB" IS NOT NULL) THEN "T4"."SFYSB" ELSE '*' END
||CASE WHEN ("T4"."SXBZ" IS NOT NULL) THEN "T4"."SXBZ" ELSE '*' END ||CASE WHEN ("T4"."SFZX" IS NOT NULL) THEN
"T4"."SFZX" ELSE '*' END ||CASE WHEN ("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB" ELSE '*' END ||CASE WHEN ("T3"."SFZX"
IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END ELSE 'Y1Y***YY' END ='Y1Y***YY' AND CASE WHEN '1'='6' THEN
"T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||CASE WHEN ("T4"."SFYSB" IS NOT NULL) THEN "T4"."SFYSB" ELSE '*' END ||CASE WHEN
("T4"."SXBZ" IS NOT NULL) THEN "T4"."SXBZ" ELSE '*' END ||CASE WHEN ("T4"."SFZX" IS NOT NULL) THEN "T4"."SFZX" ELSE '*'
END ||CASE WHEN ("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB" ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN
"T3"."SFZX" ELSE '*' END ELSE 'Y1Y***YY' END ='Y1Y***YY' AND CASE WHEN '1'='7' THEN
"T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||CASE WHEN ("T4"."SFYSB" IS NOT NULL) THEN "T4"."SFYSB" ELSE '*' END ||CASE WHEN
("T4"."SXBZ" IS NOT NULL) THEN "T4"."SXBZ" ELSE '*' END ||CASE WHEN ("T4"."SFZX" IS NOT NULL) THEN "T4"."SFZX" ELSE '*'
END ||CASE WHEN ("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB" ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN
"T3"."SFZX" ELSE '*' END ELSE 'Y1Y***YY' END ='Y1Y***YY' AND CASE WHEN '1'='8' THEN
"T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||CASE WHEN ("T4"."SFYSB" IS NOT NULL) THEN "T4"."SFYSB" ELSE '*' END ||CASE WHEN
("T4"."SXBZ" IS NOT NULL) THEN "T4"."SXBZ" ELSE '*' END ||CASE WHEN ("T4"."SFZX" IS NOT NULL) THEN "T4"."SFZX" ELSE '*'
END ||CASE WHEN ("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB" ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN
"T3"."SFZX" ELSE '*' END ELSE 'Y1Y***YY' END ='Y1Y***YY')
179 - access("T2"."RPTNO"="T4"."RPTNO"(+))
181 - access("T2"."RPTNO"="T3"."RPTNO"(+))
183 - filter(ADD_MONTHS(INTERNAL_FUNCTION("T2"."SJLRRQ"),1)>SYSDATE@!)
185 - filter(CASE WHEN '5'='1' THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||'*'||'*'||CASE WHEN ("T3"."SFYSB" IS NOT
NULL) THEN "T3"."SFYSB" ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END ELSE 'Y1YYYYY'
END ='Y1YYYYY' AND CASE WHEN '5'='2' THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||'*'||'*'||'*'||CASE WHEN ("T3"."SFZX"
IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END ELSE 'Y1Y***YY' END ='Y1Y***YY' AND CASE WHEN '5'='3' THEN
"T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||'*'||'*'||CASE WHEN ("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB" ELSE '*' END
||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END ELSE 'Y1YYYYY' END ='Y1YYYYY' AND CASE WHEN '5'='4'
THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||'*'||'*'||CASE WHEN ("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB" ELSE '*'
END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END ELSE 'Y1YYY**' END ='Y1YYY**' AND CASE WHEN
'5'='5' THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||'*'||'*'||'*'||CASE WHEN ("T3"."SFYSB" IS NOT NULL) THEN
"T3"."SFYSB" ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END ELSE 'Y1Y***YY' END
='Y1Y***YY' AND CASE WHEN '5'='6' THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||'*'||'*'||'*'||CASE WHEN ("T3"."SFYSB" IS
NOT NULL) THEN "T3"."SFYSB" ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END ELSE
'Y1Y***YY' END ='Y1Y***YY' AND CASE WHEN '5'='7' THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||'*'||'*'||'*'||CASE WHEN
("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB" ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*'
END ELSE 'Y1Y***YY' END ='Y1Y***YY' AND CASE WHEN '5'='8' THEN
"T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||'*'||'*'||'*'||CASE WHEN ("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB" ELSE '*'
END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END ELSE 'Y1Y***YY' END ='Y1Y***YY')
187 - filter(ADD_MONTHS(INTERNAL_FUNCTION("T2"."SJLRRQ"),1)>SYSDATE@!)
189 - access("T2"."RPTNO"="T3"."RPTNO"(+))
191 - filter(CASE WHEN '3'='1' THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||CASE WHEN ("T3"."SFYSB" IS NOT NULL) THEN
"T3"."SFYSB" ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END ||CASE WHEN ("T4"."SFYSB"
IS NOT NULL) THEN "T4"."SFYSB" ELSE '*' END ||CASE WHEN ("T4"."SFZX" IS NOT NULL) THEN "T4"."SFZX" ELSE '*' END ELSE
'Y1YYYYY' END ='Y1YYYYY' AND CASE WHEN '3'='2' THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||CASE WHEN ("T3"."SFYSB" IS
NOT NULL) THEN "T3"."SFYSB" ELSE '*' END ||CASE WHEN ("T3"."SXBZ" IS NOT NULL) THEN "T3"."SXBZ" ELSE '*' END ||CASE WHEN
("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END ||CASE WHEN ("T4"."SFZX" IS NOT NULL) THEN "T4"."SFZX" ELSE '*'
END ELSE 'Y1Y***YY' END ='Y1Y***YY' AND CASE WHEN '3'='3' THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||CASE WHEN
("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB" ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*'
END ||CASE WHEN ("T4"."SFYSB" IS NOT NULL) THEN "T4"."SFYSB" ELSE '*' END ||CASE WHEN ("T4"."SFZX" IS NOT NULL) THEN
"T4"."SFZX" ELSE '*' END ELSE 'Y1YYYYY' END ='Y1YYYYY' AND CASE WHEN '3'='4' THEN
"T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||CASE WHEN ("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB" ELSE '*' END ||CASE WHEN
("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END ||CASE WHEN ("T4"."SFYSB" IS NOT NULL) THEN "T4"."SFYSB" ELSE '*'
END ||CASE WHEN ("T4"."SFZX" IS NOT NULL) THEN "T4"."SFZX" ELSE '*' END ELSE 'Y1YYY**' END ='Y1YYY**' AND CASE WHEN
'3'='5' THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||CASE WHEN ("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB" ELSE '*' END
||CASE WHEN ("T3"."SXBZ" IS NOT NULL) THEN "T3"."SXBZ" ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN
"T3"."SFZX" ELSE '*' END ||CASE WHEN ("T4"."SFYSB" IS NOT NULL) THEN "T4"."SFYSB" ELSE '*' END ||CASE WHEN ("T4"."SFZX"
IS NOT NULL) THEN "T4"."SFZX" ELSE '*' END ELSE 'Y1Y***YY' END ='Y1Y***YY' AND CASE WHEN '3'='6' THEN
"T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||CASE WHEN ("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB" ELSE '*' END ||CASE WHEN
("T3"."SXBZ" IS NOT NULL) THEN "T3"."SXBZ" ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*'
END ||CASE WHEN ("T4"."SFYSB" IS NOT NULL) THEN "T4"."SFYSB" ELSE '*' END ||CASE WHEN ("T4"."SFZX" IS NOT NULL) THEN
"T4"."SFZX" ELSE '*' END ELSE 'Y1Y***YY' END ='Y1Y***YY' AND CASE WHEN '3'='7' THEN
"T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||CASE WHEN ("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB" ELSE '*' END ||CASE WHEN
("T3"."SXBZ" IS NOT NULL) THEN "T3"."SXBZ" ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*'
END ||CASE WHEN ("T4"."SFYSB" IS NOT NULL) THEN "T4"."SFYSB" ELSE '*' END ||CASE WHEN ("T4"."SFZX" IS NOT NULL) THEN
"T4"."SFZX" ELSE '*' END ELSE 'Y1Y***YY' END ='Y1Y***YY' AND CASE WHEN '3'='8' THEN
"T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||CASE WHEN ("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB" ELSE '*' END ||CASE WHEN
("T3"."SXBZ" IS NOT NULL) THEN "T3"."SXBZ" ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*'
END ||CASE WHEN ("T4"."SFYSB" IS NOT NULL) THEN "T4"."SFYSB" ELSE '*' END ||CASE WHEN ("T4"."SFZX" IS NOT NULL) THEN
"T4"."SFZX" ELSE '*' END ELSE 'Y1Y***YY' END ='Y1Y***YY')
194 - filter(ADD_MONTHS(INTERNAL_FUNCTION("T2"."SJLRRQ"),1)>SYSDATE@!)
196 - access("T2"."RPTNO"="T4"."RPTNO"(+))
198 - access("T2"."RPTNO"="T3"."RPTNO"(+))
200 - filter(CASE WHEN '2'='1' THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||'*'||'*'||CASE WHEN ("T3"."SFYSB" IS NOT
NULL) THEN "T3"."SFYSB" ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END ELSE 'Y1YYYYY'
END ='Y1YYYYY' AND CASE WHEN '2'='2' THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||'*'||'*'||'*'||CASE WHEN ("T3"."SFZX"
IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END ELSE 'Y1Y***YY' END ='Y1Y***YY' AND CASE WHEN '2'='3' THEN
"T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||'*'||'*'||CASE WHEN ("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB" ELSE '*' END
||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END ELSE 'Y1YYYYY' END ='Y1YYYYY' AND CASE WHEN '2'='4'
THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||'*'||'*'||CASE WHEN ("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB" ELSE '*'
END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END ELSE 'Y1YYY**' END ='Y1YYY**' AND CASE WHEN
'2'='5' THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||'*'||'*'||'*'||CASE WHEN ("T3"."SFYSB" IS NOT NULL) THEN
"T3"."SFYSB" ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END ELSE 'Y1Y***YY' END
='Y1Y***YY' AND CASE WHEN '2'='6' THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||'*'||'*'||'*'||CASE WHEN ("T3"."SFYSB" IS
NOT NULL) THEN "T3"."SFYSB" ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END ELSE
'Y1Y***YY' END ='Y1Y***YY' AND CASE WHEN '2'='7' THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||'*'||'*'||'*'||CASE WHEN
("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB" ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*'
END ELSE 'Y1Y***YY' END ='Y1Y***YY' AND CASE WHEN '2'='8' THEN
"T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||'*'||'*'||'*'||CASE WHEN ("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB" ELSE '*'
END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END ELSE 'Y1Y***YY' END ='Y1Y***YY')
202 - filter(ADD_MONTHS(INTERNAL_FUNCTION("T2"."SJLRRQ"),1)>SYSDATE@!)
204 - access("T2"."RPTNO"="T3"."RPTNO"(+))
206 - filter(CASE WHEN '7'='1' THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||'*'||'*'||CASE WHEN ("T3"."SFYSB" IS NOT
NULL) THEN "T3"."SFYSB" ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END ELSE 'Y1YYYYY'
END ='Y1YYYYY' AND CASE WHEN '7'='2' THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||'*'||'*'||'*'||CASE WHEN ("T3"."SFZX"
IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END ELSE 'Y1Y***YY' END ='Y1Y***YY' AND CASE WHEN '7'='3' THEN
"T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||'*'||'*'||CASE WHEN ("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB" ELSE '*' END
||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END ELSE 'Y1YYYYY' END ='Y1YYYYY' AND CASE WHEN '7'='4'
THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||'*'||'*'||CASE WHEN ("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB" ELSE '*'
END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END ELSE 'Y1YYY**' END ='Y1YYY**' AND CASE WHEN
'7'='5' THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||'*'||'*'||'*'||CASE WHEN ("T3"."SFYSB" IS NOT NULL) THEN
"T3"."SFYSB" ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END ELSE 'Y1Y***YY' END
='Y1Y***YY' AND CASE WHEN '7'='6' THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||'*'||'*'||'*'||CASE WHEN ("T3"."SFYSB" IS
NOT NULL) THEN "T3"."SFYSB" ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END ELSE
'Y1Y***YY' END ='Y1Y***YY' AND CASE WHEN '7'='7' THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||'*'||'*'||'*'||CASE WHEN
("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB" ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*'
END ELSE 'Y1Y***YY' END ='Y1Y***YY' AND CASE WHEN '7'='8' THEN
"T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||'*'||'*'||'*'||CASE WHEN ("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB" ELSE '*'
END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END ELSE 'Y1Y***YY' END ='Y1Y***YY')
208 - filter(ADD_MONTHS(INTERNAL_FUNCTION("T2"."SJLRRQ"),1)>SYSDATE@!)
210 - access("T2"."RPTNO"="T3"."RPTNO"(+))
212 - filter(CASE WHEN '8'='1' THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||'*'||'*'||CASE WHEN ("T3"."SFYSB" IS NOT
NULL) THEN "T3"."SFYSB" ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END ELSE 'Y1YYYYY'
END ='Y1YYYYY' AND CASE WHEN '8'='2' THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||'*'||'*'||'*'||CASE WHEN ("T3"."SFZX"
IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END ELSE 'Y1Y***YY' END ='Y1Y***YY' AND CASE WHEN '8'='3' THEN
"T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||'*'||'*'||CASE WHEN ("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB" ELSE '*' END
||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END ELSE 'Y1YYYYY' END ='Y1YYYYY' AND CASE WHEN '8'='4'
THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||'*'||'*'||CASE WHEN ("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB" ELSE '*'
END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END ELSE 'Y1YYY**' END ='Y1YYY**' AND CASE WHEN
'8'='5' THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||'*'||'*'||'*'||CASE WHEN ("T3"."SFYSB" IS NOT NULL) THEN
"T3"."SFYSB" ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END ELSE 'Y1Y***YY' END
='Y1Y***YY' AND CASE WHEN '8'='6' THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||'*'||'*'||'*'||CASE WHEN ("T3"."SFYSB" IS
NOT NULL) THEN "T3"."SFYSB" ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END ELSE
'Y1Y***YY' END ='Y1Y***YY' AND CASE WHEN '8'='7' THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||'*'||'*'||'*'||CASE WHEN
("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB" ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*'
END ELSE 'Y1Y***YY' END ='Y1Y***YY' AND CASE WHEN '8'='8' THEN
"T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||'*'||'*'||'*'||CASE WHEN ("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB" ELSE '*'
END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END ELSE 'Y1Y***YY' END ='Y1Y***YY')
214 - filter(ADD_MONTHS(INTERNAL_FUNCTION("T2"."SJLRRQ"),1)>SYSDATE@!)
216 - access("T2"."RPTNO"="T3"."RPTNO"(+))
218 - access(ROWID=ROWID)
224 - filter(ADD_MONTHS(INTERNAL_FUNCTION("T1"."INTERETDATE"),1)>SYSDATE@! AND ("T1"."TRADENO"='010001' OR
"T1"."TRADENO"='010002' OR "T1"."TRADENO"='010003' OR "T1"."TRADENO"='010004' OR "T1"."TRADENO"='010011' OR
"T1"."TRADENO"='020043' OR "T1"."TRADENO"='020088' OR "T1"."TRADENO"='030004' OR "T1"."TRADENO"='030219' OR
"T1"."TRADENO"='030220' OR "T1"."TRADENO"='030221' OR "T1"."TRADENO"='030222' OR "T1"."TRADENO"='030223' OR
"T1"."TRADENO"='030904' OR "T1"."TRADENO"='030908' OR "T1"."TRADENO"='080103' OR "T1"."TRADENO"='080104' OR
"T1"."TRADENO"='080108' OR "T1"."TRADENO"='080202' OR "T1"."TRADENO"='080205' OR "T1"."TRADENO"='080206') AND
"T1"."TRANSTATE"='4' AND CASE WHEN (''='1' AND ''='D' AND ROUND("F_EXCHANGERATEUSD_NEW"(TO_DATE('20','yyyy-MM-dd'),"T1"."C
URSIGN","T1"."AMOUNT"),2)<=5000) THEN '*********' ELSE 'Y1Y******' END ='Y1Y******' AND CASE WHEN (''='4' AND ''='D' AND
ROUND("F_EXCHANGERATEUSD_NEW"(TO_DATE('20','yyyy-MM-dd'),"T1"."CURSIGN","T1"."AMOUNT"),2)<=5000) THEN '*********' ELSE
'Y1Y******' END ='Y1Y******')
227 - access("TT"."RWIDH"="T1"."TXNSERIALNO")
228 - access("T3"."RWIDH"="T1"."TXNSERIALNO")
229 - access("T4"."RWIDH"="T1"."TXNSERIALNO")
230 - access("T5"."RWIDH"="T1"."TXNSERIALNO")
231 - access("T6"."RWIDH"="T1"."TXNSERIALNO")
232 - access("T7"."RWIDH"="T1"."TXNSERIALNO")
233 - access("T8"."RWIDH"="T1"."TXNSERIALNO")
234 - access("T9"."RWIDH"="T1"."TXNSERIALNO")
236 - access("T1"."CCCCNO"="T2"."CCCCNO"(+))
Statistics
----------------------------------------------------------
229 recursive calls
28 db block gets
354584 consistent gets
271906 physical reads
0 redo size
525 bytes sent via SQL*Net to client
520 bytes received via SQL*Net from client
2 SQL*Net roundtrips to/from client
0 sorts (memory)
0 sorts (disk)
1 rows processed
视图源码如下：
CREATE OR REPLACE VIEW OWNERR.VIEW_SB_UUUUUUUUUUUUUUUUU AS
SELECT vb.transactorgno as KKKKID FROM sb_SSSSYYYY vb
WHERE 1=1
and (vb.jcsfysb='N' and vb.jcsxbz='1' and vb.jcsfzx='Y')
and add_months(vb.interetdate,1)>sysdate
union all
SELECT vb.transactorgno as KKKKID FROM sb_SSSSYYYY vb
WHERE 1=1
and ((vb.jcsfysb='N' and vb.jcsxbz='0' and vb.jcsfzx='Y') or (vb.sbsfysb='N' and vb.sbsxbz='0' and vb.sbsfzx='Y') or (vb.hxsfysb='N' and vb.hxsxbz='0' and vb.hxsfzx='Y'))
and add_months(vb.interetdate,1)>sysdate
union all
SELECT vb.transactorgno as KKKKID FROM sb_SSSSYYYY vb
WHERE 1=1
and vb.rptno in (select rptno from sb_DEEEEEEERR where state = '0')
and (case when qtype = '1' then jcsfysb||jcsxbz||jcsfzx||sbsfysb||sbsfzx||hxSFYSB||hxSFZX else 'Y1YYYYY' end ='Y1YYYYY'
and case when qtype = '1' and custype = 'D' and round(f_exchangerateusd_new(to_date('20' || substr(rptno, 13, 6), 'yyyy-MM-dd'), cursign, amount),2) <= 5000
then jcsfysb||jcsxbz||jcsfzx||sbsfysb||sbsxbz||sbsfzx||hxSFYSB||hxSXBZ||hxSFZX else 'Y1Y******' end ='Y1Y******'
and case when qtype = '2' then jcsfysb||jcsxbz||jcsfzx||sbsfysb||sbsxbz||sbsfzx||hxSFZX else 'Y1Y***YY' end ='Y1Y***YY'
and case when qtype = '3' then jcsfysb||jcsxbz||jcsfzx||sbsfysb||sbsfzx||hxSFYSB||hxSFZX else 'Y1YYYYY' end ='Y1YYYYY'
and case when qtype = '4' then jcsfysb||jcsxbz||jcsfzx||sbsfysb||sbsfzx||hxSFYSB||hxSFZX else 'Y1YYY**' end ='Y1YYY**'
and case when qtype = '4' and custype = 'D' and round(f_exchangerateusd_new(to_date('20' || substr(rptno, 13, 6), 'yyyy-MM-dd'), cursign, amount),2) <= 5000
then jcsfysb||jcsxbz||jcsfzx||sbsfysb||sbsxbz||sbsfzx||hxSFYSB||hxSXBZ||hxSFZX else 'Y1Y******' end ='Y1Y******'
and case when qtype = '5' then jcsfysb||jcsxbz||jcsfzx||sbsfysb||sbsxbz||sbsfzx||hxSFYSB||hxSFZX else 'Y1Y***YY' end ='Y1Y***YY'
and case when qtype = '6' then jcsfysb||jcsxbz||jcsfzx||sbsfysb||sbsxbz||sbsfzx||hxSFYSB||hxSFZX else 'Y1Y***YY' end ='Y1Y***YY'
and case when qtype = '7' then jcsfysb||jcsxbz||jcsfzx||sbsfysb||sbsxbz||sbsfzx||hxSFYSB||hxSFZX else 'Y1Y***YY' end ='Y1Y***YY'
and case when qtype = '8' then jcsfysb||jcsxbz||jcsfzx||sbsfysb||sbsxbz||sbsfzx||hxSFYSB||hxSFZX else 'Y1Y***YY' end ='Y1Y***YY')
and add_months(vb.interetdate,1)>sysdate;
============================================================================================
create or replace view OWNERR.sb_SSSSYYYY as
select ot1.txnserialNo,
ot1.currentbizno,
ot1.rptno,
ot1.tradeno,
ot1.cursign,
ot1.amount,
ot1.interetdate,
ot1.cnname,
ot1.qtype,
ot1.jcxx,
ot1.hxxx,
ot1.sbxx,
ot1.transactorgno,
ot1.launchmode,
case ot1.tradeno when 'SGLR' then '手工录入' else ot2.tradename end tradeNameName,
ot1.qtypename,
'P' as NULLSTR,
'0' as NULLNUM,
ot1.jcsfysb,
ot1.jcsxbz,
ot1.jcsfzx,
ot1.sbsfysb,
ot1.sbsxbz,
ot1.sbsfzx,
ot1.hxSFYSB,
ot1.hxSXBZ,
ot1.hxSFZX,
ot1.custype
from (
--------------------------业务申报--------------------------------------------------------------------------------
select tb.txnserialno as txnserialNo,
tb.ywbh as currentbizno,
tb.rptno,
tb.cursign as cursign,
tb.amount as amount,
tb.interetdate as interetdate,
tb.jcxx as jcxx,
tb.hxxx as hxxx,
tb.sbxx as sbxx,
tb.transactorgno as transactorgno,
tb.launchmode as launchmode,
tb.cnname as cnname,
tb.qtype as qtype,
tb.qtypename as qtypename,
case when t1.tradeno is null then 'SGLR' else t1.tradeno end tradeno,
tb.sfzfsb,
tb.custype,
tb.jcsfysb,
tb.jcsxbz,
tb.jcsfzx,
tb.sbsfysb,
tb.sbsxbz,
tb.sbsfzx,
tb.hxSFYSB,
tb.hxSXBZ,
tb.hxSFZX
from (
--1.涉外收入申报单
select distinct t2.rwidh as txnserialNo,
t2.ywbh,
t2.rptno,
t2.txccy as cursign,
t2.txamt as amount,
t2.sjlrrq as interetdate,
'Y' as jcxx,
'' as hxxx,
decode(t3.rptno, null, '', 'Y') as sbxx,
t2.bank_id as transactorgno,
t2.launchmode as launchmode,
t2.custnm as cnname,
'4' as qtype,
'涉外收入' as qtypename,
'' tradeno,
decode(t2.launchmode, 'TP', 'Y', 'N') as sfzfsb,
t2.custype,
t2.sfysb jcsfysb,
t2.sxbz jcsxbz,
t2.sfzx jcsfzx,
case when t3.sfysb is not null then t3.sfysb else '' end sbsfysb,
case when t3.sxbz is not null then t3.sxbz else '' end sbsxbz,
case when t3.sfzx is not null then t3.sfzx else '' end sbsfzx,
'' hxSFYSB,
'' hxSXBZ,
'' hxSFZX
from SB_SSSSSSS t2
left join SB_SSSSSSS_sbxx t3 on t2.rptno = t3.rptno
union all
--2.境内收入申报单
select distinct t2.rwidh,
t2.ywbh,
t2.rptno,
t2.txccy as cursign,
t2.txamt as amount,
t2.sjlrrq as interetdate,
'Y' as jcxx,
decode(t3.rptno, null, '', 'Y') as hxxx,
'' as sbxx,
t2.bank_id as transactorgno,
t2.launchmode as launchmode,
t2.custnm,
'6' as qtype,
'境内收入' as qtypename,
'' tradeno,
decode(t2.launchmode, 'TP', 'Y', 'N') as sfzfsb,
t2.custype,
t2.sfysb jcsfysb,
t2.sxbz jcsxbz,
t2.sfzx jcsfzx,
'' sbsfysb,
'' sbsxbz,
'' sbsfzx，
case when t3.sfysb is not null then t3.sfysb else '' end hxSFYSB,
case when t3.sxbz is not null then t3.sxbz else '' end hxSXBZ,
case when t3.sfzx is not null then t3.sfzx else '' end hxSFZX
from sb_CKKKKKK_jnsr t2
left join sb_CKKKKKK_jn_hxxx t3 on t2.rptno = t3.rptno
union all
--3.境外汇款申请书
select distinct t2.rwidh,
t2.ywbh,
t2.rptno,
t2.txccy as cursign,
t2.txamt as amount,
t2.sjlrrq as interetdate,
'Y' as jcxx,
decode(t4.rptno, null, '', 'Y') as hxxx,
decode(t3.rptno, null, '', 'Y') as sbxx,
t2.bank_id as transactorgno,
t2.launchmode as launchmode,
t2.custnm,
'1' as qtype,
'境外汇款申请书' as qtypename,
'' tradeno,
decode(t2.launchmode, 'TP', 'Y', 'N') as sfzfsb,
t2.custype,
t2.sfysb jcsfysb,
t2.sxbz jcsxbz,
t2.sfzx jcsfzx,
case when t4.sfysb is not null then t4.sfysb else '' end sbsfysb,
case when t4.sxbz is not null then t4.sxbz else '' end sbsxbz,
case when t4.sfzx is not null then t4.sfzx else '' end sbsfzx,
case when t3.sfysb is not null then t3.sfysb else '' end hxsfysb,
case when t3.sxbz is not null then t3.sxbz else '' end hxsxbz,
case when t3.sfzx is not null then t3.sfzx else '' end hxsfzx
from sb_JWWWW t2
left join sb_JWWWW_hxxx t3 on t2.rptno = t3.rptno
left join sb_JWWWW_sbxx t4 on t2.rptno = t4.rptno
union all
--4.境内汇款申请书
select distinct t2.rwidh,
t2.ywbh,
t2.rptno,
t2.txccy as cursign,
t2.txamt as amount,
t2.sjlrrq as interetdate,
'Y' as jcxx,
decode(t3.rptno, null, '', 'Y') as hxxx,
'' as sbxx,
t2.bank_id as transactorgno,
t2.launchmode as launchmode,
t2.custnm,
'5' as qtype,
'境内汇款申请书' as qtypename,
'' tradeno,
decode(t2.launchmode, 'TP', 'Y', 'N') as sfzfsb,
t2.custype,
t2.sfysb jcsfysb,
t2.sxbz jcsxbz,
t2.sfzx jcsfzx,
'' sbsfysb,
'' sbsxbz,
'' sbsfzx,
case when t3.sfysb is not null then t3.sfysb else '' end hxSFYSB,
case when t3.sxbz is not null then t3.sxbz else '' end hxSXBZ,
case when t3.sfzx is not null then t3.sfzx else '' end hxSFZX
from sb_JNNNN t2
left join sb_JNNNN_hxxx t3 on t2.rptno = t3.rptno
union all
--5.对外付款承兑通知书
select distinct t2.rwidh,
t2.ywbh,
t2.rptno,
t2.txccy as cursign,
t2.txamt as amount,
t2.sjlrrq as interetdate,
'Y' as jcxx,
decode(t4.rptno, null, '', 'Y') as hxxx,
decode(t3.rptno, null, '', 'Y') as sbxx,
t2.bank_id as transactorgno,
t2.launchmode as launchmode,
t2.custnm,
'3' as qtype,
'对外付款承兑书' as qtypename,
'' tradeno,
decode(t2.launchmode, 'TP', 'Y', 'N') as sfzfsb,
t2.custype,
t2.sfysb jcsfysb,
t2.sxbz jcsxbz,
t2.sfzx jcsfzx,
case when t3.sfysb is not null then t3.sfysb else '' end sbsfysb,
case when t3.sxbz is not null then t3.sxbz else '' end sbsxbz,
case when t3.sfzx is not null then t3.sfzx else '' end sbsfzx,
case when t4.sfysb is not null then t4.sfysb else '' end hxSFYSB,
case when t4.sxbz is not null then t4.sxbz else '' end hxSXBZ,
case when t4.sfzx is not null then t4.sfzx else '' end hxSFZX
from sb_DDDDDDTTS t2
left join sb_DWWWWWTZS_sbxx t3 on t2.rptno = t3.rptno
left join Sb_DWWWWWTZS_hxxx t4 on t2.rptno = t4.rptno
union all
--6.境内付款承兑通知书
select distinct t2.rwidh,
t2.ywbh,
t2.rptno,
t2.txccy as cursign,
t2.txamt as amount,
t2.sjlrrq as interetdate,
'Y' as jcxx,
decode(t3.rptno, null, '', 'Y') as hxxx,
'' as sbxx,
t2.bank_id as transactorgno,
t2.launchmode as launchmode,
t2.custnm,
'2' as qtype,
'境内付款承兑书' as qtypename,
'' tradeno,
decode(t2.launchmode, 'TP', 'Y', 'N') as sfzfsb,
t2.custype,
t2.sfysb jcsfysb,
t2.sxbz jcsxbz,
t2.sfzx jcsfzx,
'' sbsfysb,
'' sbsxbz,
'' sbsfzx，
case when t3.sfysb is not null then t3.sfysb else '' end hxSFYSB,
case when t3.sxbz is not null then t3.sxbz else '' end hxSXBZ,
case when t3.sfzx is not null then t3.sfzx else '' end hxSFZX
from sb_JNFFFFFFS t2
left join sb_DDDDDDTZS_hxxx t3 on t2.rptno = t3.rptno
union all
--7.外汇账户内结汇
select distinct t2.rwidh,
t2.ywbh,
t2.rptno,
t2.fcyccy as cursign,
t2.fcyamt as amount,
t2.sjlrrq as interetdate,
'Y' as jcxx,
decode(t3.rptno, null, '', 'Y') as hxxx,
'' as sbxx,
t2.KKKKID as transactorgno,
t2.launchmode as launchmode,
t2.custnm,
'7' as qtype,
'外汇账户内结汇' as qtypename,
'' tradeno,
decode(t2.launchmode, 'TP', 'Y', 'N') as sfzfsb,
t2.custype,
t2.sfysb jcsfysb,
t2.sxbz jcsxbz,
t2.sfzx jcsfzx,
'' sbsfysb,
'' sbsxbz,
'' sbsfzx,
case when t3.sfysb is not null then t3.sfysb else '' end hxSFYSB,
case when t3.sxbz is not null then t3.sxbz else '' end hxSXBZ,
case when t3.sfzx is not null then t3.sfzx else '' end hxSFZX
from sb_ZZZZ t2
left join sb_ZZZZ_glxx t3 on t2.rptno = t3.rptno
union all
--8.外汇账户内售汇
select distinct t2.rwidh,
t2.ywbh,
t2.rptno,
t2.lcyccy as cursign,
t2.lcyamt as amount,
t2.sjlrrq as interetdate,
'Y' as jcxx,
decode(t3.rptno, null, '', 'Y') as hxxx,
'' as sbxx,
t2.KKKKID as transactorgno,
t2.launchmode as launchmode,
t2.custnm,
'8' as qtype,
'外汇账户内购汇' as qtypename,
'' tradeno,
decode(t2.launchmode, 'TP', 'Y', 'N') as sfzfsb,
t2.custype,
t2.sfysb jcsfysb,
t2.sxbz jcsxbz,
t2.sfzx jcsfzx,
'' sbsfysb,
'' sbsxbz,
'' sbsfzx,
case when t3.sfysb is not null then t3.sfysb else '' end hxSFYSB,
case when t3.sxbz is not null then t3.sxbz else '' end hxSXBZ,
case when t3.sfzx is not null then t3.sfzx else '' end hxSFZX
from sb_ZHHH t2
left join sb_ZHHH_glxx t3 on t2.rptno = t3.rptno) tb
left join bu_TTTTTTTTTTTINFO t1 on tb.txnserialNo = t1.txnserialno
union all
--未申报统计
select + leading(t1)distinct t1.txnserialno,
t1.currentbizno,
'' rptno,
t1.cursign as cursign,
t1.amount as amount,
t1.interetdate as interetdate,
'' as jcxx,
'' as hxxx,
'' as sbxx,
t1.transactorgno as transactorgno,
'' as launchmode,
t2.cnname,
'' as qtype,
'未录入' as qtypename,
t1.tradeno,
'N' sfzfsb,
'' custype,
'' jcsfysb,
'' jcsxbz,
'' jcsfzx,
'' sbsfysb,
'' sbsxbz,
'' sbsfzx,
'' hxSFYSB,
'' hxSXBZ,
'' hxSFZX
from bu_TTTTTTTTTTTINFO t1
left join pa_CCCC t2 on t1.CCCCno = t2.CCCCno
where t1.tradeno in
('010002', '020088', '020043', '080103', '080104', '020043',
'080103', '080104', '030004', '030904', '030219', '030220',
'030221', '030222', '030223', '030908', '010001', '010011',
'080108', '080206', '080205', '080202', '030004', '030904',
'030219', '030220', '030221', '030222', '030223', '030908',
'010001', '010011', '080108', '080206', '080205', '080202',
'010003', '010004')
and not exists (select 1 from OWNERR.SB_SSSSSSS tt where t1.txnserialno=tt.rwidh)
and not exists (select 1 from OWNERR.sb_CKKKKKK_jnsr t3 where t1.txnserialno=t3.rwidh)
and not exists (select 1 from OWNERR.sb_JWWWW t4 where t1.txnserialno=t4.rwidh)
and not exists (select 1 from OWNERR.sb_JNNNN t5 where t1.txnserialno=t5.rwidh)
and not exists (select 1 from OWNERR.sb_DDDDDDTTS t6 where t1.txnserialno=t6.rwidh)
and not exists (select 1 from OWNERR.sb_JNFFFFFFS t7 where t1.txnserialno=t7.rwidh)
and not exists (select 1 from OWNERR.sb_ZZZZ t8 where t1.txnserialno=t8.rwidh)
and not exists (select 1 from OWNERR.sb_ZHHH t9 where t1.txnserialno=t9.rwidh)
and t1.transtate = '4'
) ot1
left join pa_tradetype ot2 on ot1.tradeno = ot2.tradeno;
该语句VIEW_SB_UUUUUUUUUUUUUUUUU为视图，其中多次调用sb_SSSSYYYY视图，造成了比较复杂的嵌套视图调用，从执行计划看，在执行完对OWNERR.PP_OOO表的查询后得出的结果集较小，比较适合作为驱动条件，但由于视图复杂，该谓词条件并未推入到视图内部进行过滤，而是先生成view的所有数据，即大量的结果集，最后再进行过滤，由此导致视图中出现了大量的全表扫描。综上，考虑：
1） 对全表扫描的对象添加索引：
create index OWNERR.test_temp_i1 on OWNERR.SB_ZZZZ(KKKKID) tablespace xxx;
create index OWNERR.test_temp_i2 on OWNERR.SB_ZHHH(KKKKID) tablespace xxx;
2）添加hint，使OWNERR.PP_OOO的结果集能够作为谓词条件推入到视图尽早进行数据过滤，而非通过全表扫描得到大量数据最后再进行过滤。
select /*+ push_pred(v)*/ count(*)
from VIEW_SB_UUUUUUUUUUUUUUUUU v
where 1 = 1
and (KKKKID in (SELECT orgno
FROM PP_OOO
WHERE PARENTORGNO = '1100000784'
or orgno = '1100000784'));
调整后耗时、执行计划及资源消耗：
Elapsed: 00:00:00.73
Execution Plan
----------------------------------------------------------
Plan hash value: 3495787813
-----------------------------------------------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |
-----------------------------------------------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 1 | 29 | 41838 (1)| 00:08:23 |
| 1 | SORT AGGREGATE | | 1 | 29 | | |
| 2 | NESTED LOOPS | | 404 | 11716 | 41838 (1)| 00:08:23 |
| 3 | TABLE ACCESS BY INDEX ROWID | PP_OOO | 5 | 110 | 3 (0)| 00:00:01 |
| 4 | BITMAP CONVERSION TO ROWIDS | | | | | |
| 5 | BITMAP OR | | | | | |
| 6 | BITMAP CONVERSION FROM ROWIDS | | | | | |
|* 7 | INDEX RANGE SCAN | IND_PPPPP_PGO | | | 1 (0)| 00:00:01 |
| 8 | BITMAP CONVERSION FROM ROWIDS | | | | | |
|* 9 | INDEX RANGE SCAN | PK_PPPPP_KEY | | | 1 (0)| 00:00:01 |
| 10 | VIEW | VIEW_SB_UUUUUUUUUUUUUUUUU | 1 | 7 | 8367 (1)| 00:01:41 |
| 11 | UNION ALL PUSHED PREDICATE | | | | | |
| 12 | VIEW | | 9 | 63 | 1523 (1)| 00:00:19 |
| 13 | UNION-ALL | | | | | |
| 14 | NESTED LOOPS OUTER | | 8 | 1856 | 1522 (1)| 00:00:19 |
| 15 | VIEW | | 8 | 1664 | 1506 (1)| 00:00:19 |
| 16 | UNION-ALL | | | | | |
| 17 | SORT UNIQUE | | 1 | 150 | 777 (1)| 00:00:10 |
| 18 | NESTED LOOPS OUTER | | 1 | 150 | 776 (0)| 00:00:10 |
|* 19 | TABLE ACCESS BY INDEX ROWID | SB_SSSSSSS | 1 | 121 | 775 (0)| 00:00:10 |
|* 20 | INDEX RANGE SCAN | INX_SSSRSSD_BID | 1104 | | 6 (0)| 00:00:01 |
| 21 | TABLE ACCESS BY INDEX ROWID | SB_SSSSSSS_SBXX | 1 | 29 | 1 (0)| 00:00:01 |
|* 22 | INDEX RANGE SCAN | INX_SSSRRRRXXXXRNO | 1 | | 0 (0)| 00:00:01 |
| 23 | SORT UNIQUE | | 1 | 155 | 64 (2)| 00:00:01 |
| 24 | NESTED LOOPS OUTER | | 1 | 155 | 63 (0)| 00:00:01 |
|* 25 | TABLE ACCESS BY INDEX ROWID | SB_CKKKKKK_JNSR | 1 | 126 | 61 (0)| 00:00:01 |
|* 26 | INDEX RANGE SCAN | INX_CKSHHXZYLJNBID | 105 | | 1 (0)| 00:00:01 |
| 27 | TABLE ACCESS BY INDEX ROWID | SB_CKKKKKK_JN_HXXX | 1 | 29 | 2 (0)| 00:00:01 |
|* 28 | INDEX RANGE SCAN | INX_CKKKKKKJNHXXXR | 1 | | 1 (0)| 00:00:01 |
| 29 | SORT UNIQUE | | 1 | 176 | 375 (1)| 00:00:05 |
| 30 | NESTED LOOPS OUTER | | 1 | 176 | 374 (0)| 00:00:05 |
| 31 | NESTED LOOPS OUTER | | 1 | 147 | 373 (0)| 00:00:05 |
|* 32 | TABLE ACCESS BY INDEX ROWID | SB_JWWWW | 1 | 118 | 372 (0)| 00:00:05 |
|* 33 | INDEX RANGE SCAN | INX_JWWWWQSBID | 471 | | 4 (0)| 00:00:01 |
| 34 | TABLE ACCESS BY INDEX ROWID | SB_JWWWW_HXXX | 1 | 29 | 1 (0)| 00:00:01 |
|* 35 | INDEX RANGE SCAN | INX_JWWWWQSHXXXRNO | 1 | | 0 (0)| 00:00:01 |
| 36 | TABLE ACCESS BY INDEX ROWID | SB_JWWWW_SBXX | 1 | 29 | 1 (0)| 00:00:01 |
|* 37 | INDEX RANGE SCAN | INX_JWWWWQSSBXXRNO | 1 | | 0 (0)| 00:00:01 |
| 38 | SORT UNIQUE | | 1 | 154 | 109 (1)| 00:00:02 |
| 39 | NESTED LOOPS OUTER | | 1 | 154 | 108 (0)| 00:00:02 |
|* 40 | TABLE ACCESS BY INDEX ROWID | SB_JNNNN | 1 | 125 | 107 (0)| 00:00:02 |
|* 41 | INDEX RANGE SCAN | INX_JNNNNQSBID | 167 | | 1 (0)| 00:00:01 |
| 42 | TABLE ACCESS BY INDEX ROWID | SB_JNNNN_HXXX | 1 | 29 | 1 (0)| 00:00:01 |
|* 43 | INDEX RANGE SCAN | INX_JNNNNQSHXXXRNO | 1 | | 0 (0)| 00:00:01 |
| 44 | SORT UNIQUE | | 1 | 183 | 151 (1)| 00:00:02 |
| 45 | NESTED LOOPS OUTER | | 1 | 183 | 150 (0)| 00:00:02 |
| 46 | NESTED LOOPS OUTER | | 1 | 154 | 149 (0)| 00:00:02 |
|* 47 | TABLE ACCESS BY INDEX ROWID | SB_DDDDDDTTS | 1 | 125 | 148 (0)| 00:00:02 |
|* 48 | INDEX RANGE SCAN | INX_DWWWWWTZSBID | 217 | | 1 (0)| 00:00:01 |
| 49 | TABLE ACCESS BY INDEX ROWID | SB_DWWWWWTZS_HXXX | 1 | 29 | 1 (0)| 00:00:01 |
|* 50 | INDEX RANGE SCAN | INX_DWWWWWWWWWWWNO | 1 | | 0 (0)| 00:00:01 |
| 51 | TABLE ACCESS BY INDEX ROWID | SB_DWWWWWTZS_SBXX | 1 | 29 | 1 (0)| 00:00:01 |
|* 52 | INDEX RANGE SCAN | INX_DWDDDDDDDDDDNO | 1 | | 0 (0)| 00:00:01 |
| 53 | SORT UNIQUE | | 1 | 154 | 18 (6)| 00:00:01 |
| 54 | NESTED LOOPS OUTER | | 1 | 154 | 17 (0)| 00:00:01 |
|* 55 | TABLE ACCESS BY INDEX ROWID | SB_JNFFFFFFS | 1 | 125 | 16 (0)| 00:00:01 |
|* 56 | INDEX RANGE SCAN | INX_JNFFFFFFSBID | 32 | | 1 (0)| 00:00:01 |
| 57 | TABLE ACCESS BY INDEX ROWID | SB_DDDDDDTZS_HXXX | 1 | 29 | 1 (0)| 00:00:01 |
|* 58 | INDEX RANGE SCAN | INX_DNNNNNNNNNNNNO | 1 | | 0 (0)| 00:00:01 |
| 59 | SORT UNIQUE | | 1 | 151 | 5 (20)| 00:00:01 |
| 60 | NESTED LOOPS OUTER | | 1 | 151 | 4 (0)| 00:00:01 |
|* 61 | TABLE ACCESS BY INDEX ROWID | SB_ZZZZ | 1 | 122 | 3 (0)| 00:00:01 |
|* 62 | INDEX RANGE SCAN | TEST_TEMP_I1 | 644 | | 1 (0)| 00:00:01 |
| 63 | TABLE ACCESS BY INDEX ROWID | SB_ZZZZ_GLXX | 1 | 29 | 1 (0)| 00:00:01 |
|* 64 | INDEX RANGE SCAN | PK_SB_ZZZZ_GLXX_RPTNO | 1 | | 0 (0)| 00:00:01 |
| 65 | SORT UNIQUE | | 1 | 153 | 6 (17)| 00:00:01 |
| 66 | NESTED LOOPS OUTER | | 1 | 153 | 5 (0)| 00:00:01 |
|* 67 | TABLE ACCESS BY INDEX ROWID | SB_ZHHH | 1 | 124 | 4 (0)| 00:00:01 |
|* 68 | INDEX RANGE SCAN | TEST_TEMP_I2 | 113 | | 1 (0)| 00:00:01 |
| 69 | TABLE ACCESS BY INDEX ROWID | SB_ZHHH_GLXX | 1 | 29 | 1 (0)| 00:00:01 |
|* 70 | INDEX RANGE SCAN | PK_SB_ZHHH_GLXX_RPTNO | 1 | | 0 (0)| 00:00:01 |
| 71 | TABLE ACCESS BY INDEX ROWID | BU_TTTTTTTTTTTINFO | 1 | 24 | 2 (0)| 00:00:01 |
|* 72 | INDEX UNIQUE SCAN | PK_BRRRRRRRRD_KEY | 1 | | 1 (0)| 00:00:01 |
| 73 | SORT UNIQUE | | 1 | 128 | 1 (100)| 00:00:01 |
|* 74 | FILTER | | | | | |
| 75 | NESTED LOOPS OUTER | | 1 | 128 | 17732 (1)| 00:03:33 |
|* 76 | HASH JOIN ANTI | | 1 | 97 | 17731 (1)| 00:03:33 |
|* 77 | TABLE ACCESS BY INDEX ROWID | BU_TTTTTTTTTTTINFO | 110 | 8800 | 3084 (1)| 00:00:38 |
|* 78 | INDEX RANGE SCAN | IND_BUTRANSAC_TRG2 | 4090 | | 15 (0)| 00:00:01 |
| 79 | VIEW | | 1398K| 22M| 14639 (1)| 00:02:56 |
| 80 | UNION-ALL | | | | | |
| 81 | TABLE ACCESS FULL | SB_SSSSSSS | 607K| 9M| 6174 (1)| 00:01:15 |
| 82 | TABLE ACCESS FULL | SB_CKKKKKK_JNSR | 35512 | 589K| 378 (1)| 00:00:05 |
| 83 | TABLE ACCESS FULL | SB_JWWWW | 261K| 4348K| 2635 (1)| 00:00:32 |
| 84 | TABLE ACCESS FULL | SB_JNNNN | 64426 | 1069K| 960 (1)| 00:00:12 |
| 85 | TABLE ACCESS FULL | SB_DDDDDDTTS | 76194 | 1264K| 892 (1)| 00:00:11 |
| 86 | TABLE ACCESS FULL | SB_JNFFFFFFS | 4688 | 79696 | 103 (0)| 00:00:02 |
| 87 | TABLE ACCESS FULL | SB_ZZZZ | 304K| 5055K| 3051 (1)| 00:00:37 |
| 88 | TABLE ACCESS FULL | SB_ZHHH | 43465 | 721K| 447 (1)| 00:00:06 |
| 89 | TABLE ACCESS BY INDEX ROWID | PA_CCCC | 1 | 31 | 1 (0)| 00:00:01 |
|* 90 | INDEX UNIQUE SCAN | PK_PACCCC_KEY | 1 | | 0 (0)| 00:00:01 |
| 91 | VIEW | | 145 | 1015 | 1803 (1)| 00:00:22 |
| 92 | UNION-ALL | | | | | |
| 93 | NESTED LOOPS OUTER | | 144 | 33408 | 1802 (1)| 00:00:22 |
| 94 | VIEW | | 144 | 29952 | 1514 (1)| 00:00:19 |
| 95 | UNION-ALL | | | | | |
| 96 | SORT UNIQUE | | 55 | 8250 | 777 (1)| 00:00:10 |
|* 97 | FILTER | | | | | |
| 98 | NESTED LOOPS OUTER | | 55 | 8250 | 776 (0)| 00:00:10 |
|* 99 | TABLE ACCESS BY INDEX ROWID | SB_SSSSSSS | 55 | 6655 | 775 (0)| 00:00:10 |
|*100 | INDEX RANGE SCAN | INX_SSSRSSD_BID | 1104 | | 6 (0)| 00:00:01 |
| 101 | TABLE ACCESS BY INDEX ROWID | SB_SSSSSSS_SBXX | 1 | 29 | 1 (0)| 00:00:01 |
|*102 | INDEX RANGE SCAN | INX_SSSRRRRXXXXRNO | 1 | | 0 (0)| 00:00:01 |
| 103 | SORT UNIQUE | | 6 | 930 | 72 (2)| 00:00:01 |
|*104 | FILTER | | | | | |
| 105 | NESTED LOOPS OUTER | | 6 | 930 | 71 (0)| 00:00:01 |
|*106 | TABLE ACCESS BY INDEX ROWID | SB_CKKKKKK_JNSR | 5 | 630 | 61 (0)| 00:00:01 |
|*107 | INDEX RANGE SCAN | INX_CKSHHXZYLJNBID | 105 | | 1 (0)| 00:00:01 |
| 108 | TABLE ACCESS BY INDEX ROWID | SB_CKKKKKK_JN_HXXX | 1 | 29 | 2 (0)| 00:00:01 |
|*109 | INDEX RANGE SCAN | INX_CKKKKKKJNHXXXR | 1 | | 1 (0)| 00:00:01 |
| 110 | SORT UNIQUE | | 24 | 4224 | 375 (1)| 00:00:05 |
|*111 | FILTER | | | | | |
| 112 | NESTED LOOPS OUTER | | 24 | 4224 | 374 (0)| 00:00:05 |
| 113 | NESTED LOOPS OUTER | | 24 | 3528 | 373 (0)| 00:00:05 |
|*114 | TABLE ACCESS BY INDEX ROWID | SB_JWWWW | 24 | 2832 | 372 (0)| 00:00:05 |
|*115 | INDEX RANGE SCAN | INX_JWWWWQSBID | 471 | | 4 (0)| 00:00:01 |
| 116 | TABLE ACCESS BY INDEX ROWID | SB_JWWWW_HXXX | 1 | 29 | 1 (0)| 00:00:01 |
|*117 | INDEX RANGE SCAN | INX_JWWWWQSHXXXRNO | 1 | | 0 (0)| 00:00:01 |
| 118 | TABLE ACCESS BY INDEX ROWID | SB_JWWWW_SBXX | 1 | 29 | 1 (0)| 00:00:01 |
|*119 | INDEX RANGE SCAN | INX_JWWWWQSSBXXRNO | 1 | | 0 (0)| 00:00:01 |
| 120 | SORT UNIQUE | | 8 | 1232 | 109 (1)| 00:00:02 |
|*121 | FILTER | | | | | |
| 122 | NESTED LOOPS OUTER | | 8 | 1232 | 108 (0)| 00:00:02 |
|*123 | TABLE ACCESS BY INDEX ROWID | SB_JNNNN | 8 | 1000 | 107 (0)| 00:00:02 |
|*124 | INDEX RANGE SCAN | INX_JNNNNQSBID | 167 | | 1 (0)| 00:00:01 |
| 125 | TABLE ACCESS BY INDEX ROWID | SB_JNNNN_HXXX | 1 | 29 | 1 (0)| 00:00:01 |
|*126 | INDEX RANGE SCAN | INX_JNNNNQSHXXXRNO | 1 | | 0 (0)| 00:00:01 |
| 127 | SORT UNIQUE | | 11 | 2013 | 151 (1)| 00:00:02 |
|*128 | FILTER | | | | | |
| 129 | NESTED LOOPS OUTER | | 11 | 2013 | 150 (0)| 00:00:02 |
| 130 | NESTED LOOPS OUTER | | 11 | 1694 | 149 (0)| 00:00:02 |
|*131 | TABLE ACCESS BY INDEX ROWID | SB_DDDDDDTTS | 11 | 1375 | 148 (0)| 00:00:02 |
|*132 | INDEX RANGE SCAN | INX_DWWWWWTZSBID | 217 | | 1 (0)| 00:00:01 |
| 133 | TABLE ACCESS BY INDEX ROWID | SB_DWWWWWTZS_HXXX | 1 | 29 | 1 (0)| 00:00:01 |
|*134 | INDEX RANGE SCAN | INX_DWWWWWWWWWWWNO | 1 | | 0 (0)| 00:00:01 |
| 135 | TABLE ACCESS BY INDEX ROWID | SB_DWWWWWTZS_SBXX | 1 | 29 | 1 (0)| 00:00:01 |
|*136 | INDEX RANGE SCAN | INX_DWDDDDDDDDDDNO | 1 | | 0 (0)| 00:00:01 |
| 137 | SORT UNIQUE | | 2 | 308 | 18 (6)| 00:00:01 |
|*138 | FILTER | | | | | |
| 139 | NESTED LOOPS OUTER | | 2 | 308 | 17 (0)| 00:00:01 |
|*140 | TABLE ACCESS BY INDEX ROWID | SB_JNFFFFFFS | 2 | 250 | 16 (0)| 00:00:01 |
|*141 | INDEX RANGE SCAN | INX_JNFFFFFFSBID | 32 | | 1 (0)| 00:00:01 |
| 142 | TABLE ACCESS BY INDEX ROWID | SB_DDDDDDTZS_HXXX | 1 | 29 | 1 (0)| 00:00:01 |
|*143 | INDEX RANGE SCAN | INX_DNNNNNNNNNNNNO | 1 | | 0 (0)| 00:00:01 |
| 144 | SORT UNIQUE | | 32 | 4832 | 5 (20)| 00:00:01 |
|*145 | FILTER | | | | | |
| 146 | NESTED LOOPS OUTER | | 32 | 4832 | 4 (0)| 00:00:01 |
|*147 | TABLE ACCESS BY INDEX ROWID | SB_ZZZZ | 32 | 3904 | 3 (0)| 00:00:01 |
|*148 | INDEX RANGE SCAN | TEST_TEMP_I1 | 644 | | 1 (0)| 00:00:01 |
| 149 | TABLE ACCESS BY INDEX ROWID | SB_ZZZZ_GLXX | 1 | 29 | 1 (0)| 00:00:01 |
|*150 | INDEX RANGE SCAN | PK_SB_ZZZZ_GLXX_RPTNO | 1 | | 0 (0)| 00:00:01 |
| 151 | SORT UNIQUE | | 6 | 918 | 6 (17)| 00:00:01 |
|*152 | FILTER | | | | | |
| 153 | NESTED LOOPS OUTER | | 6 | 918 | 5 (0)| 00:00:01 |
|*154 | TABLE ACCESS BY INDEX ROWID | SB_ZHHH | 6 | 744 | 4 (0)| 00:00:01 |
|*155 | INDEX RANGE SCAN | TEST_TEMP_I2 | 113 | | 1 (0)| 00:00:01 |
| 156 | TABLE ACCESS BY INDEX ROWID | SB_ZHHH_GLXX | 1 | 29 | 1 (0)| 00:00:01 |
|*157 | INDEX RANGE SCAN | PK_SB_ZHHH_GLXX_RPTNO | 1 | | 0 (0)| 00:00:01 |
| 158 | TABLE ACCESS BY INDEX ROWID | BU_TTTTTTTTTTTINFO | 1 | 24 | 2 (0)| 00:00:01 |
|*159 | INDEX UNIQUE SCAN | PK_BRRRRRRRRD_KEY | 1 | | 1 (0)| 00:00:01 |
| 160 | SORT UNIQUE | | 1 | 128 | 1 (100)| 00:00:01 |
|*161 | FILTER | | | | | |
| 162 | NESTED LOOPS OUTER | | 1 | 128 | 17732 (1)| 00:03:33 |
|*163 | HASH JOIN ANTI | | 1 | 97 | 17731 (1)| 00:03:33 |
|*164 | TABLE ACCESS BY INDEX ROWID | BU_TTTTTTTTTTTINFO | 110 | 8800 | 3084 (1)| 00:00:38 |
|*165 | INDEX RANGE SCAN | IND_BUTRANSAC_TRG2 | 4090 | | 15 (0)| 00:00:01 |
| 166 | VIEW | | 1398K| 22M| 14639 (1)| 00:02:56 |
| 167 | UNION-ALL | | | | | |
| 168 | TABLE ACCESS FULL | SB_SSSSSSS | 607K| 9M| 6174 (1)| 00:01:15 |
| 169 | TABLE ACCESS FULL | SB_CKKKKKK_JNSR | 35512 | 589K| 378 (1)| 00:00:05 |
| 170 | TABLE ACCESS FULL | SB_JWWWW | 261K| 4348K| 2635 (1)| 00:00:32 |
| 171 | TABLE ACCESS FULL | SB_JNNNN | 64426 | 1069K| 960 (1)| 00:00:12 |
| 172 | TABLE ACCESS FULL | SB_DDDDDDTTS | 76194 | 1264K| 892 (1)| 00:00:11 |
| 173 | TABLE ACCESS FULL | SB_JNFFFFFFS | 4688 | 79696 | 103 (0)| 00:00:02 |
| 174 | TABLE ACCESS FULL | SB_ZZZZ | 304K| 5055K| 3051 (1)| 00:00:37 |
| 175 | TABLE ACCESS FULL | SB_ZHHH | 43465 | 721K| 447 (1)| 00:00:06 |
| 176 | TABLE ACCESS BY INDEX ROWID | PA_CCCC | 1 | 31 | 1 (0)| 00:00:01 |
|*177 | INDEX UNIQUE SCAN | PK_PACCCC_KEY | 1 | | 0 (0)| 00:00:01 |
|*178 | HASH JOIN SEMI | | 145 | 6670 | 5041 (1)| 00:01:01 |
| 179 | VIEW | | 145 | 2900 | 4902 (1)| 00:00:59 |
| 180 | UNION-ALL | | | | | |
| 181 | NESTED LOOPS OUTER | | 144 | 33408 | 1802 (1)| 00:00:22 |
|*182 | VIEW | | 144 | 29952 | 1514 (1)| 00:00:19 |
| 183 | UNION-ALL | | | | | |
| 184 | SORT UNIQUE | | 55 | 8250 | 777 (1)| 00:00:10 |
|*185 | FILTER | | | | | |
| 186 | NESTED LOOPS OUTER | | 55 | 8250 | 776 (0)| 00:00:10 |
|*187 | TABLE ACCESS BY INDEX ROWID | SB_SSSSSSS | 55 | 6655 | 775 (0)| 00:00:10 |
|*188 | INDEX RANGE SCAN | INX_SSSRSSD_BID | 1104 | | 6 (0)| 00:00:01 |
| 189 | TABLE ACCESS BY INDEX ROWID | SB_SSSSSSS_SBXX | 1 | 29 | 1 (0)| 00:00:01 |
|*190 | INDEX RANGE SCAN | INX_SSSRRRRXXXXRNO | 1 | | 0 (0)| 00:00:01 |
| 191 | SORT UNIQUE | | 6 | 930 | 72 (2)| 00:00:01 |
|*192 | FILTER | | | | | |
| 193 | NESTED LOOPS OUTER | | 6 | 930 | 71 (0)| 00:00:01 |
|*194 | TABLE ACCESS BY INDEX ROWID | SB_CKKKKKK_JNSR | 5 | 630 | 61 (0)| 00:00:01 |
|*195 | INDEX RANGE SCAN | INX_CKSHHXZYLJNBID | 105 | | 1 (0)| 00:00:01 |
| 196 | TABLE ACCESS BY INDEX ROWID | SB_CKKKKKK_JN_HXXX | 1 | 29 | 2 (0)| 00:00:01 |
|*197 | INDEX RANGE SCAN | INX_CKKKKKKJNHXXXR | 1 | | 1 (0)| 00:00:01 |
| 198 | SORT UNIQUE | | 24 | 4224 | 375 (1)| 00:00:05 |
|*199 | FILTER | | | | | |
| 200 | NESTED LOOPS OUTER | | 24 | 4224 | 374 (0)| 00:00:05 |
| 201 | NESTED LOOPS OUTER | | 24 | 3528 | 373 (0)| 00:00:05 |
|*202 | TABLE ACCESS BY INDEX ROWID| SB_JWWWW | 24 | 2832 | 372 (0)| 00:00:05 |
|*203 | INDEX RANGE SCAN | INX_JWWWWQSBID | 471 | | 4 (0)| 00:00:01 |
| 204 | TABLE ACCESS BY INDEX ROWID| SB_JWWWW_HXXX | 1 | 29 | 1 (0)| 00:00:01 |
|*205 | INDEX RANGE SCAN | INX_JWWWWQSHXXXRNO | 1 | | 0 (0)| 00:00:01 |
| 206 | TABLE ACCESS BY INDEX ROWID | SB_JWWWW_SBXX | 1 | 29 | 1 (0)| 00:00:01 |
|*207 | INDEX RANGE SCAN | INX_JWWWWQSSBXXRNO | 1 | | 0 (0)| 00:00:01 |
| 208 | SORT UNIQUE | | 8 | 1232 | 109 (1)| 00:00:02 |
|*209 | FILTER | | | | | |
| 210 | NESTED LOOPS OUTER | | 8 | 1232 | 108 (0)| 00:00:02 |
|*211 | TABLE ACCESS BY INDEX ROWID | SB_JNNNN | 8 | 1000 | 107 (0)| 00:00:02 |
|*212 | INDEX RANGE SCAN | INX_JNNNNQSBID | 167 | | 1 (0)| 00:00:01 |
| 213 | TABLE ACCESS BY INDEX ROWID | SB_JNNNN_HXXX | 1 | 29 | 1 (0)| 00:00:01 |
|*214 | INDEX RANGE SCAN | INX_JNNNNQSHXXXRNO | 1 | | 0 (0)| 00:00:01 |
| 215 | SORT UNIQUE | | 11 | 2013 | 151 (1)| 00:00:02 |
|*216 | FILTER | | | | | |
| 217 | NESTED LOOPS OUTER | | 11 | 2013 | 150 (0)| 00:00:02 |
| 218 | NESTED LOOPS OUTER | | 11 | 1694 | 149 (0)| 00:00:02 |
|*219 | TABLE ACCESS BY INDEX ROWID| SB_DDDDDDTTS | 11 | 1375 | 148 (0)| 00:00:02 |
|*220 | INDEX RANGE SCAN | INX_DWWWWWTZSBID | 217 | | 1 (0)| 00:00:01 |
| 221 | TABLE ACCESS BY INDEX ROWID| SB_DWWWWWTZS_HXXX | 1 | 29 | 1 (0)| 00:00:01 |
|*222 | INDEX RANGE SCAN | INX_DWWWWWWWWWWWNO | 1 | | 0 (0)| 00:00:01 |
| 223 | TABLE ACCESS BY INDEX ROWID | SB_DWWWWWTZS_SBXX | 1 | 29 | 1 (0)| 00:00:01 |
|*224 | INDEX RANGE SCAN | INX_DWDDDDDDDDDDNO | 1 | | 0 (0)| 00:00:01 |
| 225 | SORT UNIQUE | | 2 | 308 | 18 (6)| 00:00:01 |
|*226 | FILTER | | | | | |
| 227 | NESTED LOOPS OUTER | | 2 | 308 | 17 (0)| 00:00:01 |
|*228 | TABLE ACCESS BY INDEX ROWID | SB_JNFFFFFFS | 2 | 250 | 16 (0)| 00:00:01 |
|*229 | INDEX RANGE SCAN | INX_JNFFFFFFSBID | 32 | | 1 (0)| 00:00:01 |
| 230 | TABLE ACCESS BY INDEX ROWID | SB_DDDDDDTZS_HXXX | 1 | 29 | 1 (0)| 00:00:01 |
|*231 | INDEX RANGE SCAN | INX_DNNNNNNNNNNNNO | 1 | | 0 (0)| 00:00:01 |
| 232 | SORT UNIQUE | | 32 | 4832 | 5 (20)| 00:00:01 |
|*233 | FILTER | | | | | |
| 234 | NESTED LOOPS OUTER | | 32 | 4832 | 4 (0)| 00:00:01 |
|*235 | TABLE ACCESS BY INDEX ROWID | SB_ZZZZ | 32 | 3904 | 3 (0)| 00:00:01 |
|*236 | INDEX RANGE SCAN | TEST_TEMP_I1 | 644 | | 1 (0)| 00:00:01 |
| 237 | TABLE ACCESS BY INDEX ROWID | SB_ZZZZ_GLXX | 1 | 29 | 1 (0)| 00:00:01 |
|*238 | INDEX RANGE SCAN | PK_SB_ZZZZ_GLXX_RPTNO | 1 | | 0 (0)| 00:00:01 |
| 239 | SORT UNIQUE | | 6 | 918 | 6 (17)| 00:00:01 |
|*240 | FILTER | | | | | |
| 241 | NESTED LOOPS OUTER | | 6 | 918 | 5 (0)| 00:00:01 |
|*242 | TABLE ACCESS BY INDEX ROWID | SB_ZHHH | 6 | 744 | 4 (0)| 00:00:01 |
|*243 | INDEX RANGE SCAN | TEST_TEMP_I2 | 113 | | 1 (0)| 00:00:01 |
| 244 | TABLE ACCESS BY INDEX ROWID | SB_ZHHH_GLXX | 1 | 29 | 1 (0)| 00:00:01 |
|*245 | INDEX RANGE SCAN | PK_SB_ZHHH_GLXX_RPTNO | 1 | | 0 (0)| 00:00:01 |
| 246 | TABLE ACCESS BY INDEX ROWID | BU_TTTTTTTTTTTINFO | 1 | 24 | 2 (0)| 00:00:01 |
|*247 | INDEX UNIQUE SCAN | PK_BRRRRRRRRD_KEY | 1 | | 1 (0)| 00:00:01 |
| 248 | SORT UNIQUE | | 1 | 128 | 3100 (1)| 00:00:38 |
| 249 | NESTED LOOPS ANTI | | 1 | 128 | 3099 (1)| 00:00:38 |
| 250 | NESTED LOOPS OUTER | | 1 | 111 | 3085 (1)| 00:00:38 |
|*251 | TABLE ACCESS BY INDEX ROWID | BU_TTTTTTTTTTTINFO | 1 | 80 | 3084 (1)| 00:00:38 |
|*252 | INDEX RANGE SCAN | IND_BUTRANSAC_TRG2 | 4090 | | 15 (0)| 00:00:01 |
| 253 | TABLE ACCESS BY INDEX ROWID | PA_CCCC | 1 | 31 | 1 (0)| 00:00:01 |
|*254 | INDEX UNIQUE SCAN | PK_PACCCC_KEY | 1 | | 0 (0)| 00:00:01 |
| 255 | VIEW | | 2 | 34 | 14 (0)| 00:00:01 |
| 256 | UNION ALL PUSHED PREDICATE | | | | | |
|*257 | INDEX RANGE SCAN | INX_SSSRSSD_TID | 1 | 17 | 3 (0)| 00:00:01 |
|*258 | INDEX RANGE SCAN | INX_CKSHHHHHHJNTID | 1 | 17 | 1 (0)| 00:00:01 |
|*259 | INDEX RANGE SCAN | INX_JWWWWQSTID | 1 | 17 | 3 (0)| 00:00:01 |
|*260 | INDEX RANGE SCAN | INX_JNNNNQSTID | 1 | 17 | 1 (0)| 00:00:01 |
|*261 | INDEX RANGE SCAN | INX_DWWWWWTZSTID | 1 | 17 | 1 (0)| 00:00:01 |
|*262 | INDEX RANGE SCAN | INX_JNFFFFFFSTID | 1 | 17 | 1 (0)| 00:00:01 |
|*263 | INDEX RANGE SCAN | IDX_SB_ZZZZ_RWIDH | 1 | 17 | 3 (0)| 00:00:01 |
|*264 | INDEX RANGE SCAN | IDX_SB_ZHHH_RWIDH | 1 | 17 | 1 (0)| 00:00:01 |
|*265 | TABLE ACCESS FULL | SB_DEEEEEEERR | 7205 | 182K| 139 (1)| 00:00:02 |
-----------------------------------------------------------------------------------------------------------------------
Predicate Information (identified by operation id):
---------------------------------------------------
7 - access("PARENTORGNO"='1100000784')
9 - access("ORGNO"='1100000784')
19 - filter("T2"."SFYSB"='N' AND ADD_MONTHS(INTERNAL_FUNCTION("T2"."SJLRRQ"),1)>SYSDATE@! AND
"T2"."SFZX"='Y' AND "T2"."SXBZ"='1')
20 - access("T2"."BANK_ID"="ORGNO")
22 - access("T2"."RPTNO"="T3"."RPTNO"(+))
25 - filter("T2"."SFYSB"='N' AND ADD_MONTHS(INTERNAL_FUNCTION("T2"."SJLRRQ"),1)>SYSDATE@! AND
"T2"."SFZX"='Y' AND "T2"."SXBZ"='1')
26 - access("T2"."BANK_ID"="ORGNO")
28 - access("T2"."RPTNO"="T3"."RPTNO"(+))
32 - filter("T2"."SFYSB"='N' AND ADD_MONTHS(INTERNAL_FUNCTION("T2"."SJLRRQ"),1)>SYSDATE@! AND
"T2"."SFZX"='Y' AND "T2"."SXBZ"='1')
33 - access("T2"."BANK_ID"="ORGNO")
35 - access("T2"."RPTNO"="T3"."RPTNO"(+))
37 - access("T2"."RPTNO"="T4"."RPTNO"(+))
40 - filter("T2"."SFYSB"='N' AND ADD_MONTHS(INTERNAL_FUNCTION("T2"."SJLRRQ"),1)>SYSDATE@! AND
"T2"."SFZX"='Y' AND "T2"."SXBZ"='1')
41 - access("T2"."BANK_ID"="ORGNO")
43 - access("T2"."RPTNO"="T3"."RPTNO"(+))
47 - filter("T2"."SFYSB"='N' AND ADD_MONTHS(INTERNAL_FUNCTION("T2"."SJLRRQ"),1)>SYSDATE@! AND
"T2"."SFZX"='Y' AND "T2"."SXBZ"='1')
48 - access("T2"."BANK_ID"="ORGNO")
50 - access("T2"."RPTNO"="T4"."RPTNO"(+))
52 - access("T2"."RPTNO"="T3"."RPTNO"(+))
55 - filter("T2"."SFYSB"='N' AND ADD_MONTHS(INTERNAL_FUNCTION("T2"."SJLRRQ"),1)>SYSDATE@! AND
"T2"."SFZX"='Y' AND "T2"."SXBZ"='1')
56 - access("T2"."BANK_ID"="ORGNO")
58 - access("T2"."RPTNO"="T3"."RPTNO"(+))
61 - filter("T2"."SFYSB"='N' AND ADD_MONTHS(INTERNAL_FUNCTION("T2"."SJLRRQ"),1)>SYSDATE@! AND
"T2"."SFZX"='Y' AND "T2"."SXBZ"='1')
62 - access("T2"."KKKKID"="ORGNO")
64 - access("T2"."RPTNO"="T3"."RPTNO"(+))
67 - filter("T2"."SFYSB"='N' AND ADD_MONTHS(INTERNAL_FUNCTION("T2"."SJLRRQ"),1)>SYSDATE@! AND
"T2"."SXBZ"='1' AND "T2"."SFZX"='Y')
68 - access("T2"."KKKKID"="ORGNO")
70 - access("T2"."RPTNO"="T3"."RPTNO"(+))
72 - access("TB"."TXNSERIALNO"="T1"."TXNSERIALNO"(+))
74 - filter(NULL IS NOT NULL AND NULL IS NOT NULL AND NULL IS NOT NULL)
76 - access("T1"."TXNSERIALNO"="B"."RWIDH")
77 - filter(ADD_MONTHS(INTERNAL_FUNCTION("T1"."INTERETDATE"),1)>SYSDATE@! AND ("T1"."TRADENO"='010001' OR
"T1"."TRADENO"='010002' OR "T1"."TRADENO"='010003' OR "T1"."TRADENO"='010004' OR "T1"."TRADENO"='010011' OR
"T1"."TRADENO"='020043' OR "T1"."TRADENO"='020088' OR "T1"."TRADENO"='030004' OR "T1"."TRADENO"='030219' OR
"T1"."TRADENO"='030220' OR "T1"."TRADENO"='030221' OR "T1"."TRADENO"='030222' OR "T1"."TRADENO"='030223' OR
"T1"."TRADENO"='030904' OR "T1"."TRADENO"='030908' OR "T1"."TRADENO"='080103' OR "T1"."TRADENO"='080104' OR
"T1"."TRADENO"='080108' OR "T1"."TRADENO"='080202' OR "T1"."TRADENO"='080205' OR "T1"."TRADENO"='080206') AND
"T1"."TRANSTATE"='4')
78 - access("T1"."TRANSACTORGNO"="ORGNO")
90 - access("T1"."CCCCNO"="T2"."CCCCNO"(+))
97 - filter("T2"."SFYSB"='N' AND "T2"."SXBZ"='0' AND "T2"."SFZX"='Y' OR CASE WHEN "T3"."SFYSB" IS NOT NULL
THEN "T3"."SFYSB" ELSE '*' END ='N' AND CASE WHEN "T3"."SXBZ" IS NOT NULL THEN "T3"."SXBZ" ELSE '*' END ='0'
AND CASE WHEN "T3"."SFZX" IS NOT NULL THEN "T3"."SFZX" ELSE '*' END ='Y')
99 - filter(ADD_MONTHS(INTERNAL_FUNCTION("T2"."SJLRRQ"),1)>SYSDATE@!)
100 - access("T2"."BANK_ID"="ORGNO")
102 - access("T2"."RPTNO"="T3"."RPTNO"(+))
104 - filter("T2"."SFYSB"='N' AND "T2"."SXBZ"='0' AND "T2"."SFZX"='Y' OR CASE WHEN "T3"."SFYSB" IS NOT NULL
THEN "T3"."SFYSB" ELSE '*' END ='N' AND CASE WHEN "T3"."SXBZ" IS NOT NULL THEN "T3"."SXBZ" ELSE '*' END ='0'
AND CASE WHEN "T3"."SFZX" IS NOT NULL THEN "T3"."SFZX" ELSE '*' END ='Y')
106 - filter(ADD_MONTHS(INTERNAL_FUNCTION("T2"."SJLRRQ"),1)>SYSDATE@!)
107 - access("T2"."BANK_ID"="ORGNO")
109 - access("T2"."RPTNO"="T3"."RPTNO"(+))
111 - filter("T2"."SFYSB"='N' AND "T2"."SXBZ"='0' AND "T2"."SFZX"='Y' OR CASE WHEN "T4"."SFYSB" IS NOT NULL
THEN "T4"."SFYSB" ELSE '*' END ='N' AND CASE WHEN "T4"."SXBZ" IS NOT NULL THEN "T4"."SXBZ" ELSE '*' END ='0'
AND CASE WHEN "T4"."SFZX" IS NOT NULL THEN "T4"."SFZX" ELSE '*' END ='Y' OR CASE WHEN "T3"."SFYSB" IS NOT
NULL THEN "T3"."SFYSB" ELSE '*' END ='N' AND CASE WHEN "T3"."SXBZ" IS NOT NULL THEN "T3"."SXBZ" ELSE '*' END
='0' AND CASE WHEN "T3"."SFZX" IS NOT NULL THEN "T3"."SFZX" ELSE '*' END ='Y')
114 - filter(ADD_MONTHS(INTERNAL_FUNCTION("T2"."SJLRRQ"),1)>SYSDATE@!)
115 - access("T2"."BANK_ID"="ORGNO")
117 - access("T2"."RPTNO"="T3"."RPTNO"(+))
119 - access("T2"."RPTNO"="T4"."RPTNO"(+))
121 - filter("T2"."SFYSB"='N' AND "T2"."SXBZ"='0' AND "T2"."SFZX"='Y' OR CASE WHEN "T3"."SFYSB" IS NOT NULL
THEN "T3"."SFYSB" ELSE '*' END ='N' AND CASE WHEN "T3"."SXBZ" IS NOT NULL THEN "T3"."SXBZ" ELSE '*' END ='0'
AND CASE WHEN "T3"."SFZX" IS NOT NULL THEN "T3"."SFZX" ELSE '*' END ='Y')
123 - filter(ADD_MONTHS(INTERNAL_FUNCTION("T2"."SJLRRQ"),1)>SYSDATE@!)
124 - access("T2"."BANK_ID"="ORGNO")
126 - access("T2"."RPTNO"="T3"."RPTNO"(+))
128 - filter("T2"."SFYSB"='N' AND "T2"."SXBZ"='0' AND "T2"."SFZX"='Y' OR CASE WHEN "T3"."SFYSB" IS NOT NULL
THEN "T3"."SFYSB" ELSE '*' END ='N' AND CASE WHEN "T3"."SXBZ" IS NOT NULL THEN "T3"."SXBZ" ELSE '*' END ='0'
AND CASE WHEN "T3"."SFZX" IS NOT NULL THEN "T3"."SFZX" ELSE '*' END ='Y' OR CASE WHEN "T4"."SFYSB" IS NOT
NULL THEN "T4"."SFYSB" ELSE '*' END ='N' AND CASE WHEN "T4"."SXBZ" IS NOT NULL THEN "T4"."SXBZ" ELSE '*' END
='0' AND CASE WHEN "T4"."SFZX" IS NOT NULL THEN "T4"."SFZX" ELSE '*' END ='Y')
131 - filter(ADD_MONTHS(INTERNAL_FUNCTION("T2"."SJLRRQ"),1)>SYSDATE@!)
132 - access("T2"."BANK_ID"="ORGNO")
134 - access("T2"."RPTNO"="T4"."RPTNO"(+))
136 - access("T2"."RPTNO"="T3"."RPTNO"(+))
138 - filter("T2"."SFYSB"='N' AND "T2"."SXBZ"='0' AND "T2"."SFZX"='Y' OR CASE WHEN "T3"."SFYSB" IS NOT NULL
THEN "T3"."SFYSB" ELSE '*' END ='N' AND CASE WHEN "T3"."SXBZ" IS NOT NULL THEN "T3"."SXBZ" ELSE '*' END ='0'
AND CASE WHEN "T3"."SFZX" IS NOT NULL THEN "T3"."SFZX" ELSE '*' END ='Y')
140 - filter(ADD_MONTHS(INTERNAL_FUNCTION("T2"."SJLRRQ"),1)>SYSDATE@!)
141 - access("T2"."BANK_ID"="ORGNO")
143 - access("T2"."RPTNO"="T3"."RPTNO"(+))
145 - filter("T2"."SFYSB"='N' AND "T2"."SXBZ"='0' AND "T2"."SFZX"='Y' OR CASE WHEN "T3"."SFYSB" IS NOT NULL
THEN "T3"."SFYSB" ELSE '*' END ='N' AND CASE WHEN "T3"."SXBZ" IS NOT NULL THEN "T3"."SXBZ" ELSE '*' END ='0'
AND CASE WHEN "T3"."SFZX" IS NOT NULL THEN "T3"."SFZX" ELSE '*' END ='Y')
147 - filter(ADD_MONTHS(INTERNAL_FUNCTION("T2"."SJLRRQ"),1)>SYSDATE@!)
148 - access("T2"."KKKKID"="ORGNO")
150 - access("T2"."RPTNO"="T3"."RPTNO"(+))
152 - filter("T2"."SFYSB"='N' AND "T2"."SXBZ"='0' AND "T2"."SFZX"='Y' OR CASE WHEN "T3"."SFYSB" IS NOT NULL
THEN "T3"."SFYSB" ELSE '*' END ='N' AND CASE WHEN "T3"."SXBZ" IS NOT NULL THEN "T3"."SXBZ" ELSE '*' END ='0'
AND CASE WHEN "T3"."SFZX" IS NOT NULL THEN "T3"."SFZX" ELSE '*' END ='Y')
154 - filter(ADD_MONTHS(INTERNAL_FUNCTION("T2"."SJLRRQ"),1)>SYSDATE@!)
155 - access("T2"."KKKKID"="ORGNO")
157 - access("T2"."RPTNO"="T3"."RPTNO"(+))
159 - access("TB"."TXNSERIALNO"="T1"."TXNSERIALNO"(+))
161 - filter(NULL IS NOT NULL AND NULL IS NOT NULL AND NULL IS NOT NULL)
163 - access("T1"."TXNSERIALNO"="B"."RWIDH")
164 - filter(ADD_MONTHS(INTERNAL_FUNCTION("T1"."INTERETDATE"),1)>SYSDATE@! AND ("T1"."TRADENO"='010001' OR
"T1"."TRADENO"='010002' OR "T1"."TRADENO"='010003' OR "T1"."TRADENO"='010004' OR "T1"."TRADENO"='010011' OR
"T1"."TRADENO"='020043' OR "T1"."TRADENO"='020088' OR "T1"."TRADENO"='030004' OR "T1"."TRADENO"='030219' OR
"T1"."TRADENO"='030220' OR "T1"."TRADENO"='030221' OR "T1"."TRADENO"='030222' OR "T1"."TRADENO"='030223' OR
"T1"."TRADENO"='030904' OR "T1"."TRADENO"='030908' OR "T1"."TRADENO"='080103' OR "T1"."TRADENO"='080104' OR
"T1"."TRADENO"='080108' OR "T1"."TRADENO"='080202' OR "T1"."TRADENO"='080205' OR "T1"."TRADENO"='080206') AND
"T1"."TRANSTATE"='4')
165 - access("T1"."TRANSACTORGNO"="ORGNO")
177 - access("T1"."CCCCNO"="T2"."CCCCNO"(+))
178 - access("OT1"."RPTNO"="RPTNO")
182 - filter(CASE WHEN ("TB"."QTYPE"='1' AND "TB"."CUSTYPE"='D' AND
ROUND("F_EXCHANGERATEUSD_NEW"(TO_DATE('20'||SUBSTR("TB"."RPTNO",13,6),'yyyy-MM-dd'),"TB"."CURSIGN","TB"."AMOUNT
"),2)<=5000) THEN "TB"."JCSFYSB"||"TB"."JCSXBZ"||"TB"."JCSFZX"||"TB"."SBSFYSB"||"TB"."SBSXBZ"||"TB"."SBSFZX"||"
TB"."HXSFYSB"||"TB"."HXSXBZ"||"TB"."HXSFZX" ELSE 'Y1Y******' END ='Y1Y******' AND CASE WHEN ("TB"."QTYPE"='4'
AND "TB"."CUSTYPE"='D' AND ROUND("F_EXCHANGERATEUSD_NEW"(TO_DATE('20'||SUBSTR("TB"."RPTNO",13,6),'yyyy-MM-dd'),
"TB"."CURSIGN","TB"."AMOUNT"),2)<=5000) THEN "TB"."JCSFYSB"||"TB"."JCSXBZ"||"TB"."JCSFZX"||"TB"."SBSFYSB"||"TB"
."SBSXBZ"||"TB"."SBSFZX"||"TB"."HXSFYSB"||"TB"."HXSXBZ"||"TB"."HXSFZX" ELSE 'Y1Y******' END ='Y1Y******')
185 - filter(CASE WHEN '4'='1' THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||CASE WHEN ("T3"."SFYSB" IS NOT
NULL) THEN "T3"."SFYSB" ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END
||'*'||'*' ELSE 'Y1YYYYY' END ='Y1YYYYY' AND CASE WHEN '4'='2' THEN
"T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||CASE WHEN ("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB" ELSE '*' END
||CASE WHEN ("T3"."SXBZ" IS NOT NULL) THEN "T3"."SXBZ" ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL)
THEN "T3"."SFZX" ELSE '*' END ||'*' ELSE 'Y1Y***YY' END ='Y1Y***YY' AND CASE WHEN '4'='3' THEN
"T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||CASE WHEN ("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB" ELSE '*' END
||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END ||'*'||'*' ELSE 'Y1YYYYY' END ='Y1YYYYY'
AND CASE WHEN '4'='4' THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||CASE WHEN ("T3"."SFYSB" IS NOT NULL) THEN
"T3"."SFYSB" ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END ||'*'||'*' ELSE
'Y1YYY**' END ='Y1YYY**' AND CASE WHEN '4'='5' THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||CASE WHEN
("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB" ELSE '*' END ||CASE WHEN ("T3"."SXBZ" IS NOT NULL) THEN
"T3"."SXBZ" ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END ||'*'||'*' ELSE
'Y1Y***YY' END ='Y1Y***YY' AND CASE WHEN '4'='6' THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||CASE WHEN
("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB" ELSE '*' END ||CASE WHEN ("T3"."SXBZ" IS NOT NULL) THEN
"T3"."SXBZ" ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END ||'*'||'*' ELSE
'Y1Y***YY' END ='Y1Y***YY' AND CASE WHEN '4'='7' THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||CASE WHEN
("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB" ELSE '*' END ||CASE WHEN ("T3"."SXBZ" IS NOT NULL) THEN
"T3"."SXBZ" ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END ||'*'||'*' ELSE
'Y1Y***YY' END ='Y1Y***YY' AND CASE WHEN '4'='8' THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||CASE WHEN
("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB" ELSE '*' END ||CASE WHEN ("T3"."SXBZ" IS NOT NULL) THEN
"T3"."SXBZ" ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END ||'*'||'*' ELSE
'Y1Y***YY' END ='Y1Y***YY')
187 - filter(ADD_MONTHS(INTERNAL_FUNCTION("T2"."SJLRRQ"),1)>SYSDATE@!)
188 - access("T2"."BANK_ID"="ORGNO")
190 - access("T2"."RPTNO"="T3"."RPTNO"(+))
192 - filter(CASE WHEN '6'='1' THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||'*'||'*'||CASE WHEN
("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB" ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN
"T3"."SFZX" ELSE '*' END ELSE 'Y1YYYYY' END ='Y1YYYYY' AND CASE WHEN '6'='2' THEN
"T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||'*'||'*'||'*'||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX"
ELSE '*' END ELSE 'Y1Y***YY' END ='Y1Y***YY' AND CASE WHEN '6'='3' THEN
"T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||'*'||'*'||CASE WHEN ("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB" ELSE
'*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END ELSE 'Y1YYYYY' END ='Y1YYYYY'
AND CASE WHEN '6'='4' THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||'*'||'*'||CASE WHEN ("T3"."SFYSB" IS NOT
NULL) THEN "T3"."SFYSB" ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END
ELSE 'Y1YYY**' END ='Y1YYY**' AND CASE WHEN '6'='5' THEN
"T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||'*'||'*'||'*'||CASE WHEN ("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB"
ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END ELSE 'Y1Y***YY' END
='Y1Y***YY' AND CASE WHEN '6'='6' THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||'*'||'*'||'*'||CASE WHEN
("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB" ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN
"T3"."SFZX" ELSE '*' END ELSE 'Y1Y***YY' END ='Y1Y***YY' AND CASE WHEN '6'='7' THEN
"T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||'*'||'*'||'*'||CASE WHEN ("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB"
ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END ELSE 'Y1Y***YY' END
='Y1Y***YY' AND CASE WHEN '6'='8' THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||'*'||'*'||'*'||CASE WHEN
("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB" ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN
"T3"."SFZX" ELSE '*' END ELSE 'Y1Y***YY' END ='Y1Y***YY')
194 - filter(ADD_MONTHS(INTERNAL_FUNCTION("T2"."SJLRRQ"),1)>SYSDATE@!)
195 - access("T2"."BANK_ID"="ORGNO")
197 - access("T2"."RPTNO"="T3"."RPTNO"(+))
199 - filter(CASE WHEN '1'='1' THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||CASE WHEN ("T4"."SFYSB" IS NOT
NULL) THEN "T4"."SFYSB" ELSE '*' END ||CASE WHEN ("T4"."SFZX" IS NOT NULL) THEN "T4"."SFZX" ELSE '*' END
||CASE WHEN ("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB" ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL)
THEN "T3"."SFZX" ELSE '*' END ELSE 'Y1YYYYY' END ='Y1YYYYY' AND CASE WHEN '1'='2' THEN
"T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||CASE WHEN ("T4"."SFYSB" IS NOT NULL) THEN "T4"."SFYSB" ELSE '*' END
||CASE WHEN ("T4"."SXBZ" IS NOT NULL) THEN "T4"."SXBZ" ELSE '*' END ||CASE WHEN ("T4"."SFZX" IS NOT NULL)
THEN "T4"."SFZX" ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END ELSE
'Y1Y***YY' END ='Y1Y***YY' AND CASE WHEN '1'='3' THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||CASE WHEN
("T4"."SFYSB" IS NOT NULL) THEN "T4"."SFYSB" ELSE '*' END ||CASE WHEN ("T4"."SFZX" IS NOT NULL) THEN
"T4"."SFZX" ELSE '*' END ||CASE WHEN ("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB" ELSE '*' END ||CASE WHEN
("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END ELSE 'Y1YYYYY' END ='Y1YYYYY' AND CASE WHEN '1'='4'
THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||CASE WHEN ("T4"."SFYSB" IS NOT NULL) THEN "T4"."SFYSB" ELSE '*'
END ||CASE WHEN ("T4"."SFZX" IS NOT NULL) THEN "T4"."SFZX" ELSE '*' END ||CASE WHEN ("T3"."SFYSB" IS NOT
NULL) THEN "T3"."SFYSB" ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END
ELSE 'Y1YYY**' END ='Y1YYY**' AND CASE WHEN '1'='5' THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||CASE WHEN
("T4"."SFYSB" IS NOT NULL) THEN "T4"."SFYSB" ELSE '*' END ||CASE WHEN ("T4"."SXBZ" IS NOT NULL) THEN
"T4"."SXBZ" ELSE '*' END ||CASE WHEN ("T4"."SFZX" IS NOT NULL) THEN "T4"."SFZX" ELSE '*' END ||CASE WHEN
("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB" ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN
"T3"."SFZX" ELSE '*' END ELSE 'Y1Y***YY' END ='Y1Y***YY' AND CASE WHEN '1'='6' THEN
"T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||CASE WHEN ("T4"."SFYSB" IS NOT NULL) THEN "T4"."SFYSB" ELSE '*' END
||CASE WHEN ("T4"."SXBZ" IS NOT NULL) THEN "T4"."SXBZ" ELSE '*' END ||CASE WHEN ("T4"."SFZX" IS NOT NULL)
THEN "T4"."SFZX" ELSE '*' END ||CASE WHEN ("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB" ELSE '*' END ||CASE
WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END ELSE 'Y1Y***YY' END ='Y1Y***YY' AND CASE WHEN
'1'='7' THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||CASE WHEN ("T4"."SFYSB" IS NOT NULL) THEN "T4"."SFYSB"
ELSE '*' END ||CASE WHEN ("T4"."SXBZ" IS NOT NULL) THEN "T4"."SXBZ" ELSE '*' END ||CASE WHEN ("T4"."SFZX" IS
NOT NULL) THEN "T4"."SFZX" ELSE '*' END ||CASE WHEN ("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB" ELSE '*' END
||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END ELSE 'Y1Y***YY' END ='Y1Y***YY' AND CASE
WHEN '1'='8' THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||CASE WHEN ("T4"."SFYSB" IS NOT NULL) THEN
"T4"."SFYSB" ELSE '*' END ||CASE WHEN ("T4"."SXBZ" IS NOT NULL) THEN "T4"."SXBZ" ELSE '*' END ||CASE WHEN
("T4"."SFZX" IS NOT NULL) THEN "T4"."SFZX" ELSE '*' END ||CASE WHEN ("T3"."SFYSB" IS NOT NULL) THEN
"T3"."SFYSB" ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END ELSE
'Y1Y***YY' END ='Y1Y***YY')
202 - filter(ADD_MONTHS(INTERNAL_FUNCTION("T2"."SJLRRQ"),1)>SYSDATE@!)
203 - access("T2"."BANK_ID"="ORGNO")
205 - access("T2"."RPTNO"="T3"."RPTNO"(+))
207 - access("T2"."RPTNO"="T4"."RPTNO"(+))
209 - filter(CASE WHEN '5'='1' THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||'*'||'*'||CASE WHEN
("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB" ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN
"T3"."SFZX" ELSE '*' END ELSE 'Y1YYYYY' END ='Y1YYYYY' AND CASE WHEN '5'='2' THEN
"T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||'*'||'*'||'*'||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX"
ELSE '*' END ELSE 'Y1Y***YY' END ='Y1Y***YY' AND CASE WHEN '5'='3' THEN
"T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||'*'||'*'||CASE WHEN ("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB" ELSE
'*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END ELSE 'Y1YYYYY' END ='Y1YYYYY'
AND CASE WHEN '5'='4' THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||'*'||'*'||CASE WHEN ("T3"."SFYSB" IS NOT
NULL) THEN "T3"."SFYSB" ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END
ELSE 'Y1YYY**' END ='Y1YYY**' AND CASE WHEN '5'='5' THEN
"T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||'*'||'*'||'*'||CASE WHEN ("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB"
ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END ELSE 'Y1Y***YY' END
='Y1Y***YY' AND CASE WHEN '5'='6' THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||'*'||'*'||'*'||CASE WHEN
("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB" ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN
"T3"."SFZX" ELSE '*' END ELSE 'Y1Y***YY' END ='Y1Y***YY' AND CASE WHEN '5'='7' THEN
"T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||'*'||'*'||'*'||CASE WHEN ("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB"
ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END ELSE 'Y1Y***YY' END
='Y1Y***YY' AND CASE WHEN '5'='8' THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||'*'||'*'||'*'||CASE WHEN
("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB" ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN
"T3"."SFZX" ELSE '*' END ELSE 'Y1Y***YY' END ='Y1Y***YY')
211 - filter(ADD_MONTHS(INTERNAL_FUNCTION("T2"."SJLRRQ"),1)>SYSDATE@!)
212 - access("T2"."BANK_ID"="ORGNO")
214 - access("T2"."RPTNO"="T3"."RPTNO"(+))
216 - filter(CASE WHEN '3'='1' THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||CASE WHEN ("T3"."SFYSB" IS NOT
NULL) THEN "T3"."SFYSB" ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END
||CASE WHEN ("T4"."SFYSB" IS NOT NULL) THEN "T4"."SFYSB" ELSE '*' END ||CASE WHEN ("T4"."SFZX" IS NOT NULL)
THEN "T4"."SFZX" ELSE '*' END ELSE 'Y1YYYYY' END ='Y1YYYYY' AND CASE WHEN '3'='2' THEN
"T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||CASE WHEN ("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB" ELSE '*' END
||CASE WHEN ("T3"."SXBZ" IS NOT NULL) THEN "T3"."SXBZ" ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL)
THEN "T3"."SFZX" ELSE '*' END ||CASE WHEN ("T4"."SFZX" IS NOT NULL) THEN "T4"."SFZX" ELSE '*' END ELSE
'Y1Y***YY' END ='Y1Y***YY' AND CASE WHEN '3'='3' THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||CASE WHEN
("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB" ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN
"T3"."SFZX" ELSE '*' END ||CASE WHEN ("T4"."SFYSB" IS NOT NULL) THEN "T4"."SFYSB" ELSE '*' END ||CASE WHEN
("T4"."SFZX" IS NOT NULL) THEN "T4"."SFZX" ELSE '*' END ELSE 'Y1YYYYY' END ='Y1YYYYY' AND CASE WHEN '3'='4'
THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||CASE WHEN ("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB" ELSE '*'
END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END ||CASE WHEN ("T4"."SFYSB" IS NOT
NULL) THEN "T4"."SFYSB" ELSE '*' END ||CASE WHEN ("T4"."SFZX" IS NOT NULL) THEN "T4"."SFZX" ELSE '*' END
ELSE 'Y1YYY**' END ='Y1YYY**' AND CASE WHEN '3'='5' THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||CASE WHEN
("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB" ELSE '*' END ||CASE WHEN ("T3"."SXBZ" IS NOT NULL) THEN
"T3"."SXBZ" ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END ||CASE WHEN
("T4"."SFYSB" IS NOT NULL) THEN "T4"."SFYSB" ELSE '*' END ||CASE WHEN ("T4"."SFZX" IS NOT NULL) THEN
"T4"."SFZX" ELSE '*' END ELSE 'Y1Y***YY' END ='Y1Y***YY' AND CASE WHEN '3'='6' THEN
"T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||CASE WHEN ("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB" ELSE '*' END
||CASE WHEN ("T3"."SXBZ" IS NOT NULL) THEN "T3"."SXBZ" ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL)
THEN "T3"."SFZX" ELSE '*' END ||CASE WHEN ("T4"."SFYSB" IS NOT NULL) THEN "T4"."SFYSB" ELSE '*' END ||CASE
WHEN ("T4"."SFZX" IS NOT NULL) THEN "T4"."SFZX" ELSE '*' END ELSE 'Y1Y***YY' END ='Y1Y***YY' AND CASE WHEN
'3'='7' THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||CASE WHEN ("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB"
ELSE '*' END ||CASE WHEN ("T3"."SXBZ" IS NOT NULL) THEN "T3"."SXBZ" ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS
NOT NULL) THEN "T3"."SFZX" ELSE '*' END ||CASE WHEN ("T4"."SFYSB" IS NOT NULL) THEN "T4"."SFYSB" ELSE '*' END
||CASE WHEN ("T4"."SFZX" IS NOT NULL) THEN "T4"."SFZX" ELSE '*' END ELSE 'Y1Y***YY' END ='Y1Y***YY' AND CASE
WHEN '3'='8' THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||CASE WHEN ("T3"."SFYSB" IS NOT NULL) THEN
"T3"."SFYSB" ELSE '*' END ||CASE WHEN ("T3"."SXBZ" IS NOT NULL) THEN "T3"."SXBZ" ELSE '*' END ||CASE WHEN
("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END ||CASE WHEN ("T4"."SFYSB" IS NOT NULL) THEN
"T4"."SFYSB" ELSE '*' END ||CASE WHEN ("T4"."SFZX" IS NOT NULL) THEN "T4"."SFZX" ELSE '*' END ELSE
'Y1Y***YY' END ='Y1Y***YY')
219 - filter(ADD_MONTHS(INTERNAL_FUNCTION("T2"."SJLRRQ"),1)>SYSDATE@!)
220 - access("T2"."BANK_ID"="ORGNO")
222 - access("T2"."RPTNO"="T4"."RPTNO"(+))
224 - access("T2"."RPTNO"="T3"."RPTNO"(+))
226 - filter(CASE WHEN '2'='1' THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||'*'||'*'||CASE WHEN
("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB" ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN
"T3"."SFZX" ELSE '*' END ELSE 'Y1YYYYY' END ='Y1YYYYY' AND CASE WHEN '2'='2' THEN
"T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||'*'||'*'||'*'||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX"
ELSE '*' END ELSE 'Y1Y***YY' END ='Y1Y***YY' AND CASE WHEN '2'='3' THEN
"T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||'*'||'*'||CASE WHEN ("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB" ELSE
'*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END ELSE 'Y1YYYYY' END ='Y1YYYYY'
AND CASE WHEN '2'='4' THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||'*'||'*'||CASE WHEN ("T3"."SFYSB" IS NOT
NULL) THEN "T3"."SFYSB" ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END
ELSE 'Y1YYY**' END ='Y1YYY**' AND CASE WHEN '2'='5' THEN
"T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||'*'||'*'||'*'||CASE WHEN ("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB"
ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END ELSE 'Y1Y***YY' END
='Y1Y***YY' AND CASE WHEN '2'='6' THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||'*'||'*'||'*'||CASE WHEN
("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB" ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN
"T3"."SFZX" ELSE '*' END ELSE 'Y1Y***YY' END ='Y1Y***YY' AND CASE WHEN '2'='7' THEN
"T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||'*'||'*'||'*'||CASE WHEN ("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB"
ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END ELSE 'Y1Y***YY' END
='Y1Y***YY' AND CASE WHEN '2'='8' THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||'*'||'*'||'*'||CASE WHEN
("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB" ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN
"T3"."SFZX" ELSE '*' END ELSE 'Y1Y***YY' END ='Y1Y***YY')
228 - filter(ADD_MONTHS(INTERNAL_FUNCTION("T2"."SJLRRQ"),1)>SYSDATE@!)
229 - access("T2"."BANK_ID"="ORGNO")
231 - access("T2"."RPTNO"="T3"."RPTNO"(+))
233 - filter(CASE WHEN '7'='1' THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||'*'||'*'||CASE WHEN
("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB" ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN
"T3"."SFZX" ELSE '*' END ELSE 'Y1YYYYY' END ='Y1YYYYY' AND CASE WHEN '7'='2' THEN
"T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||'*'||'*'||'*'||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX"
ELSE '*' END ELSE 'Y1Y***YY' END ='Y1Y***YY' AND CASE WHEN '7'='3' THEN
"T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||'*'||'*'||CASE WHEN ("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB" ELSE
'*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END ELSE 'Y1YYYYY' END ='Y1YYYYY'
AND CASE WHEN '7'='4' THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||'*'||'*'||CASE WHEN ("T3"."SFYSB" IS NOT
NULL) THEN "T3"."SFYSB" ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END
ELSE 'Y1YYY**' END ='Y1YYY**' AND CASE WHEN '7'='5' THEN
"T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||'*'||'*'||'*'||CASE WHEN ("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB"
ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END ELSE 'Y1Y***YY' END
='Y1Y***YY' AND CASE WHEN '7'='6' THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||'*'||'*'||'*'||CASE WHEN
("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB" ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN
"T3"."SFZX" ELSE '*' END ELSE 'Y1Y***YY' END ='Y1Y***YY' AND CASE WHEN '7'='7' THEN
"T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||'*'||'*'||'*'||CASE WHEN ("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB"
ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END ELSE 'Y1Y***YY' END
='Y1Y***YY' AND CASE WHEN '7'='8' THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||'*'||'*'||'*'||CASE WHEN
("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB" ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN
"T3"."SFZX" ELSE '*' END ELSE 'Y1Y***YY' END ='Y1Y***YY')
235 - filter(ADD_MONTHS(INTERNAL_FUNCTION("T2"."SJLRRQ"),1)>SYSDATE@!)
236 - access("T2"."KKKKID"="ORGNO")
238 - access("T2"."RPTNO"="T3"."RPTNO"(+))
240 - filter(CASE WHEN '8'='1' THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||'*'||'*'||CASE WHEN
("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB" ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN
"T3"."SFZX" ELSE '*' END ELSE 'Y1YYYYY' END ='Y1YYYYY' AND CASE WHEN '8'='2' THEN
"T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||'*'||'*'||'*'||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX"
ELSE '*' END ELSE 'Y1Y***YY' END ='Y1Y***YY' AND CASE WHEN '8'='3' THEN
"T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||'*'||'*'||CASE WHEN ("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB" ELSE
'*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END ELSE 'Y1YYYYY' END ='Y1YYYYY'
AND CASE WHEN '8'='4' THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||'*'||'*'||CASE WHEN ("T3"."SFYSB" IS NOT
NULL) THEN "T3"."SFYSB" ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END
ELSE 'Y1YYY**' END ='Y1YYY**' AND CASE WHEN '8'='5' THEN
"T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||'*'||'*'||'*'||CASE WHEN ("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB"
ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END ELSE 'Y1Y***YY' END
='Y1Y***YY' AND CASE WHEN '8'='6' THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||'*'||'*'||'*'||CASE WHEN
("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB" ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN
"T3"."SFZX" ELSE '*' END ELSE 'Y1Y***YY' END ='Y1Y***YY' AND CASE WHEN '8'='7' THEN
"T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||'*'||'*'||'*'||CASE WHEN ("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB"
ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END ELSE 'Y1Y***YY' END
='Y1Y***YY' AND CASE WHEN '8'='8' THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||'*'||'*'||'*'||CASE WHEN
("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB" ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN
"T3"."SFZX" ELSE '*' END ELSE 'Y1Y***YY' END ='Y1Y***YY')
242 - filter(ADD_MONTHS(INTERNAL_FUNCTION("T2"."SJLRRQ"),1)>SYSDATE@!)
243 - access("T2"."KKKKID"="ORGNO")
245 - access("T2"."RPTNO"="T3"."RPTNO"(+))
247 - access("TB"."TXNSERIALNO"="T1"."TXNSERIALNO"(+))
251 - filter(ADD_MONTHS(INTERNAL_FUNCTION("T1"."INTERETDATE"),1)>SYSDATE@! AND ("T1"."TRADENO"='010001' OR
"T1"."TRADENO"='010002' OR "T1"."TRADENO"='010003' OR "T1"."TRADENO"='010004' OR "T1"."TRADENO"='010011' OR
"T1"."TRADENO"='020043' OR "T1"."TRADENO"='020088' OR "T1"."TRADENO"='030004' OR "T1"."TRADENO"='030219' OR
"T1"."TRADENO"='030220' OR "T1"."TRADENO"='030221' OR "T1"."TRADENO"='030222' OR "T1"."TRADENO"='030223' OR
"T1"."TRADENO"='030904' OR "T1"."TRADENO"='030908' OR "T1"."TRADENO"='080103' OR "T1"."TRADENO"='080104' OR
"T1"."TRADENO"='080108' OR "T1"."TRADENO"='080202' OR "T1"."TRADENO"='080205' OR "T1"."TRADENO"='080206') AND
"T1"."TRANSTATE"='4' AND CASE WHEN (''='1' AND ''='D' AND
ROUND("F_EXCHANGERATEUSD_NEW"(TO_DATE('20','yyyy-MM-dd'),"T1"."CURSIGN","T1"."AMOUNT"),2)<=5000) THEN
'*********' ELSE 'Y1Y******' END ='Y1Y******' AND CASE WHEN (''='4' AND ''='D' AND
ROUND("F_EXCHANGERATEUSD_NEW"(TO_DATE('20','yyyy-MM-dd'),"T1"."CURSIGN","T1"."AMOUNT"),2)<=5000) THEN
'*********' ELSE 'Y1Y******' END ='Y1Y******')
252 - access("T1"."TRANSACTORGNO"="ORGNO")
254 - access("T1"."CCCCNO"="T2"."CCCCNO"(+))
257 - access("TT"."RWIDH"="T1"."TXNSERIALNO")
258 - access("T3"."RWIDH"="T1"."TXNSERIALNO")
259 - access("T4"."RWIDH"="T1"."TXNSERIALNO")
260 - access("T5"."RWIDH"="T1"."TXNSERIALNO")
261 - access("T6"."RWIDH"="T1"."TXNSERIALNO")
262 - access("T7"."RWIDH"="T1"."TXNSERIALNO")
263 - access("T8"."RWIDH"="T1"."TXNSERIALNO")
264 - access("T9"."RWIDH"="T1"."TXNSERIALNO")
265 - filter("STATE"='0')
Statistics
----------------------------------------------------------
269 recursive calls
0 db block gets
774 consistent gets
0 physical reads
0 redo size
525 bytes sent via SQL*Net to client
520 bytes received via SQL*Net from client
2 SQL*Net roundtrips to/from client
162 sorts (memory)
0 sorts (disk)
1 rows processed
'030219', '030220', '030221', '030222', '030223', '030908',
'010001', '010011', '080108', '080206', '080205', '080202',
'010003', '010004')
and not exists (select 1 from OWNERR.SB_SSSSSSS tt where t1.txnserialno=tt.rwidh)
and not exists (select 1 from OWNERR.sb_CKKKKKK_jnsr t3 where t1.txnserialno=t3.rwidh)
and not exists (select 1 from OWNERR.sb_JWWWW t4 where t1.txnserialno=t4.rwidh)
and not exists (select 1 from OWNERR.sb_JNNNN t5 where t1.txnserialno=t5.rwidh)
and not exists (select 1 from OWNERR.sb_DDDDDDTTS t6 where t1.txnserialno=t6.rwidh)
and not exists (select 1 from OWNERR.sb_JNFFFFFFS t7 where t1.txnserialno=t7.rwidh)
and not exists (select 1 from OWNERR.sb_ZZZZ t8 where t1.txnserialno=t8.rwidh)
and not exists (select 1 from OWNERR.sb_ZHHH t9 where t1.txnserialno=t9.rwidh)
and t1.transtate = '4'
) ot1
left join pa_tradetype ot2 on ot1.tradeno = ot2.tradeno;
调整后，sql语句耗时由45.71缩短为0.73，耗时降低98%；逻辑读资源消耗由354584降为774，降低99%
谓词推入见执行计划ID=11 UNION ALL PUSHED PREDICATE
扫一扫
456
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
