Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -----------------------------------------------------------------------------------------------------
- Plan hash VALUE: 2789149815
- --------------------------------------------------------------------------------------------------------------------------------------------------------------------------
- | Id | Operation | Name | ROWS | Bytes | Cost (%CPU)| TIME | TQ |IN-OUT| PQ Distrib |
- --------------------------------------------------------------------------------------------------------------------------------------------------------------------------
- | 0 | SELECT STATEMENT | | 8 | 64552 | 797 (1)| 00:00:01 | | | |
- | 1 | TEMP TABLE TRANSFORMATION | | | | | | | | |
- | 2 | PX COORDINATOR | | | | | | | | |
- | 3 | PX SEND QC (RANDOM) | :TQ10008 | 1 | 442 | 142 (3)| 00:00:01 | Q1,08 | P->S | QC (RAND) |
- | 4 | LOAD AS SELECT (TEMP SEGMENT MERGE) | SYS_TEMP_0FD9D6B48_DA83F60A | | | | | Q1,08 | PCWP | |
- | 5 | NESTED LOOPS | | 1 | 442 | 142 (3)| 00:00:01 | Q1,08 | PCWP | |
- | 6 | NESTED LOOPS | | 1 | 440 | 140 (3)| 00:00:01 | Q1,08 | PCWP | |
- | 7 | NESTED LOOPS | | 1 | 438 | 137 (2)| 00:00:01 | Q1,08 | PCWP | |
- |* 8 | HASH JOIN | | 1 | 436 | 135 (2)| 00:00:01 | Q1,08 | PCWP | |
- | 9 | PX RECEIVE | | 13 | 3042 | 122 (1)| 00:00:01 | Q1,08 | PCWP | |
- | 10 | PX SEND HASH | :TQ10006 | 13 | 3042 | 122 (1)| 00:00:01 | Q1,06 | P->P | HASH |
- |* 11 | HASH JOIN BUFFERED | | 13 | 3042 | 122 (1)| 00:00:01 | Q1,06 | PCWP | |
- | 12 | PX RECEIVE | | 1 | 202 | 24 (9)| 00:00:01 | Q1,06 | PCWP | |
- | 13 | PX SEND HYBRID HASH | :TQ10003 | 1 | 202 | 24 (9)| 00:00:01 | Q1,03 | P->P | HYBRID HASH|
- | 14 | STATISTICS COLLECTOR | | | | | | Q1,03 | PCWC | |
- | 15 | VIEW | | 1 | 202 | 24 (9)| 00:00:01 | Q1,03 | PCWP | |
- | 16 | HASH UNIQUE | | 1 | 280 | 24 (9)| 00:00:01 | Q1,03 | PCWP | |
- | 17 | PX RECEIVE | | 1 | 280 | 24 (9)| 00:00:01 | Q1,03 | PCWP | |
- | 18 | PX SEND HASH | :TQ10001 | 1 | 280 | 24 (9)| 00:00:01 | Q1,01 | P->P | HASH |
- | 19 | HASH UNIQUE | | 1 | 280 | 24 (9)| 00:00:01 | Q1,01 | PCWP | |
- | 20 | NESTED LOOPS | | 1 | 280 | 22 (0)| 00:00:01 | Q1,01 | PCWP | |
- | 21 | NESTED LOOPS | | 1 | 280 | 22 (0)| 00:00:01 | Q1,01 | PCWP | |
- | 22 | NESTED LOOPS | | 1 | 243 | 22 (0)| 00:00:01 | Q1,01 | PCWP | |
- | 23 | NESTED LOOPS | | 31 | 4991 | 7 (0)| 00:00:01 | Q1,01 | PCWP | |
- | 24 | NESTED LOOPS | | 1 | 139 | 4 (0)| 00:00:01 | Q1,01 | PCWP | |
- | 25 | PX RECEIVE | | | | | | Q1,01 | PCWP | |
- | 26 | PX SEND BROADCAST | :TQ10000 | | | | | Q1,00 | S->P | BROADCAST |
- | 27 | PX SELECTOR | | | | | | Q1,00 | SCWC | |
- | 28 | TABLE ACCESS BY INDEX ROWID | FND_VS_VALUE_SETS | 1 | 34 | 2 (0)| 00:00:01 | Q1,00 | SCWC | |
- |* 29 | INDEX UNIQUE SCAN | FND_VS_VALUE_SETS_U2 | 1 | | 1 (0)| 00:00:01 | Q1,00 | SCWP | |
- | 30 | PX BLOCK ITERATOR | | 1 | 105 | 2 (0)| 00:00:01 | Q1,01 | PCWC | |
- |* 31 | TABLE ACCESS STORAGE FULL | FND_TREE_VERSION | 1 | 105 | 2 (0)| 00:00:01 | Q1,01 | PCWP | |
- | 32 | TABLE ACCESS BY INDEX ROWID BATCHED| FND_VS_VALUES_B | 65 | 1430 | 14 (0)| 00:00:01 | Q1,01 | PCWP | |
- |* 33 | INDEX RANGE SCAN | FND_VS_VALUES_B_N1 | 65 | | 1 (0)| 00:00:01 | Q1,01 | PCWP | |
- |* 34 | TABLE ACCESS BY INDEX ROWID BATCHED | GL_SEG_VAL_HIER_RF | 1 | 82 | 3 (0)| 00:00:01 | Q1,01 | PCWP | |
- |* 35 | INDEX RANGE SCAN | GL_SEG_VAL_HIER_RF_N2 | 1 | | 2 (0)| 00:00:01 | Q1,01 | PCWP | |
- |* 36 | INDEX UNIQUE SCAN | FND_VS_VALUES_TL_U1 | 1 | | 0 (0)| 00:00:01 | Q1,01 | PCWP | |
- | 37 | TABLE ACCESS BY INDEX ROWID | FND_VS_VALUES_TL | 1 | 37 | 1 (0)| 00:00:01 | Q1,01 | PCWP | |
- | 38 | PX RECEIVE | | 46796 | 1462K| 99 (2)| 00:00:01 | Q1,06 | PCWP | |
- | 39 | PX SEND HYBRID HASH | :TQ10004 | 46796 | 1462K| 99 (2)| 00:00:01 | Q1,04 | P->P | HYBRID HASH|
- | 40 | PX BLOCK ITERATOR | | 46796 | 1462K| 99 (2)| 00:00:01 | Q1,04 | PCWC | |
- | 41 | TABLE ACCESS STORAGE FULL | GL_CODE_COMBINATIONS | 46796 | 1462K| 99 (2)| 00:00:01 | Q1,04 | PCWP | |
- | 42 | PX RECEIVE | | 1 | 202 | 13 (8)| 00:00:01 | Q1,08 | PCWP | |
- | 43 | PX SEND HASH | :TQ10007 | 1 | 202 | 13 (8)| 00:00:01 | Q1,07 | P->P | HASH |
- | 44 | VIEW | | 1 | 202 | 13 (8)| 00:00:01 | Q1,07 | PCWP | |
- | 45 | HASH UNIQUE | | 1 | 280 | 13 (8)| 00:00:01 | Q1,07 | PCWP | |
- | 46 | PX RECEIVE | | 1 | 280 | 13 (8)| 00:00:01 | Q1,07 | PCWP | |
- | 47 | PX SEND HASH | :TQ10005 | 1 | 280 | 13 (8)| 00:00:01 | Q1,05 | P->P | HASH |
- | 48 | HASH UNIQUE | | 1 | 280 | 13 (8)| 00:00:01 | Q1,05 | PCWP | |
- | 49 | NESTED LOOPS | | 1 | 280 | 12 (0)| 00:00:01 | Q1,05 | PCWP | |
- | 50 | NESTED LOOPS | | 1 | 280 | 12 (0)| 00:00:01 | Q1,05 | PCWP | |
- | 51 | NESTED LOOPS | | 1 | 243 | 12 (0)| 00:00:01 | Q1,05 | PCWP | |
- | 52 | NESTED LOOPS | | 1 | 221 | 11 (0)| 00:00:01 | Q1,05 | PCWP | |
- | 53 | NESTED LOOPS | | 1 | 139 | 4 (0)| 00:00:01 | Q1,05 | PCWP | |
- | 54 | PX RECEIVE | | | | | | Q1,05 | PCWP | |
- | 55 | PX SEND BROADCAST | :TQ10002 | | | | | Q1,02 | S->P | BROADCAST |
- | 56 | PX SELECTOR | | | | | | Q1,02 | SCWC | |
- | 57 | TABLE ACCESS BY INDEX ROWID | FND_VS_VALUE_SETS | 1 | 34 | 2 (0)| 00:00:01 | Q1,02 | SCWC | |
- |* 58 | INDEX UNIQUE SCAN | FND_VS_VALUE_SETS_U2 | 1 | | 1 (0)| 00:00:01 | Q1,02 | SCWP | |
- | 59 | PX BLOCK ITERATOR | | 1 | 105 | 2 (0)| 00:00:01 | Q1,05 | PCWC | |
- |* 60 | TABLE ACCESS STORAGE FULL | FND_TREE_VERSION | 1 | 105 | 2 (0)| 00:00:01 | Q1,05 | PCWP | |
- |* 61 | TABLE ACCESS BY INDEX ROWID BATCHED | GL_SEG_VAL_HIER_RF | 2 | 164 | 32 (0)| 00:00:01 | Q1,05 | PCWP | |
- |* 62 | INDEX RANGE SCAN | GL_SEG_VAL_HIER_RF_N2 | 169 | | 5 (0)| 00:00:01 | Q1,05 | PCWP | |
- | 63 | TABLE ACCESS BY INDEX ROWID BATCHED | FND_VS_VALUES_B | 1 | 22 | 2 (0)| 00:00:01 | Q1,05 | PCWP | |
- |* 64 | INDEX RANGE SCAN | FND_VS_VALUES_B_N1 | 1 | | 1 (0)| 00:00:01 | Q1,05 | PCWP | |
- |* 65 | INDEX UNIQUE SCAN | FND_VS_VALUES_TL_U1 | 1 | | 0 (0)| 00:00:01 | Q1,05 | PCWP | |
- | 66 | TABLE ACCESS BY INDEX ROWID | FND_VS_VALUES_TL | 1 | 37 | 1 (0)| 00:00:01 | Q1,05 | PCWP | |
- | 67 | VIEW PUSHED PREDICATE | | 1 | 2 | 10 (10)| 00:00:01 | Q1,08 | PCWP | |
- | 68 | SORT UNIQUE | | 1 | 280 | 10 (10)| 00:00:01 | Q1,08 | PCWP | |
- | 69 | NESTED LOOPS | | 1 | 280 | 9 (0)| 00:00:01 | Q1,08 | PCWP | |
- | 70 | NESTED LOOPS | | 1 | 280 | 9 (0)| 00:00:01 | Q1,08 | PCWP | |
- | 71 | NESTED LOOPS | | 1 | 175 | 8 (0)| 00:00:01 | Q1,08 | PCWP | |
- | 72 | NESTED LOOPS | | 1 | 93 | 5 (0)| 00:00:01 | Q1,08 | PCWP | |
- | 73 | NESTED LOOPS | | 1 | 56 | 4 (0)| 00:00:01 | Q1,08 | PCWP | |
- | 74 | TABLE ACCESS BY INDEX ROWID | FND_VS_VALUE_SETS | 1 | 34 | 2 (0)| 00:00:01 | Q1,08 | PCWP | |
- |* 75 | INDEX UNIQUE SCAN | FND_VS_VALUE_SETS_U2 | 1 | | 1 (0)| 00:00:01 | Q1,08 | PCWP | |
- | 76 | TABLE ACCESS BY INDEX ROWID BATCHED | FND_VS_VALUES_B | 1 | 22 | 2 (0)| 00:00:01 | Q1,08 | PCWP | |
- |* 77 | INDEX RANGE SCAN | FND_VS_VALUES_B_N1 | 1 | | 1 (0)| 00:00:01 | Q1,08 | PCWP | |
- | 78 | TABLE ACCESS BY INDEX ROWID | FND_VS_VALUES_TL | 1 | 37 | 1 (0)| 00:00:01 | Q1,08 | PCWP | |
- |* 79 | INDEX UNIQUE SCAN | FND_VS_VALUES_TL_U1 | 1 | | 0 (0)| 00:00:01 | Q1,08 | PCWP | |
- |* 80 | TABLE ACCESS BY INDEX ROWID BATCHED | GL_SEG_VAL_HIER_RF | 1 | 82 | 3 (0)| 00:00:01 | Q1,08 | PCWP | |
- |* 81 | INDEX RANGE SCAN | GL_SEG_VAL_HIER_RF_N2 | 1 | | 2 (0)| 00:00:01 | Q1,08 | PCWP | |
- |* 82 | INDEX UNIQUE SCAN | FND_TREE_VERSION_U1 | 1 | | 0 (0)| 00:00:01 | Q1,08 | PCWP | |
- |* 83 | TABLE ACCESS BY INDEX ROWID | FND_TREE_VERSION | 1 | 105 | 1 (0)| 00:00:01 | Q1,08 | PCWP | |
- | 84 | VIEW PUSHED PREDICATE | | 1 | 2 | 11 (10)| 00:00:01 | Q1,08 | PCWP | |
- | 85 | SORT UNIQUE | | 1 | 280 | 11 (10)| 00:00:01 | Q1,08 | PCWP | |
- | 86 | NESTED LOOPS | | 1 | 280 | 10 (0)| 00:00:01 | Q1,08 | PCWP | |
- | 87 | NESTED LOOPS | | 1 | 280 | 10 (0)| 00:00:01 | Q1,08 | PCWP | |
- | 88 | NESTED LOOPS | | 1 | 198 | 7 (0)| 00:00:01 | Q1,08 | PCWP | |
- | 89 | NESTED LOOPS | | 1 | 161 | 6 (0)| 00:00:01 | Q1,08 | PCWP | |
- | 90 | NESTED LOOPS | | 1 | 139 | 4 (0)| 00:00:01 | Q1,08 | PCWP | |
- | 91 | TABLE ACCESS BY INDEX ROWID | FND_VS_VALUE_SETS | 1 | 34 | 2 (0)| 00:00:01 | Q1,08 | PCWP | |
- |* 92 | INDEX UNIQUE SCAN | FND_VS_VALUE_SETS_U2 | 1 | | 1 (0)| 00:00:01 | Q1,08 | PCWP | |
- |* 93 | TABLE ACCESS BY INDEX ROWID BATCHED | FND_TREE_VERSION | 1 | 105 | 2 (0)| 00:00:01 | Q1,08 | PCWP | |
- |* 94 | INDEX RANGE SCAN | FND_TREE_VERSION_U1 | 1 | | 1 (0)| 00:00:01 | Q1,08 | PCWP | |
- | 95 | TABLE ACCESS BY INDEX ROWID BATCHED | FND_VS_VALUES_B | 1 | 22 | 2 (0)| 00:00:01 | Q1,08 | PCWP | |
- |* 96 | INDEX RANGE SCAN | FND_VS_VALUES_B_N1 | 1 | | 1 (0)| 00:00:01 | Q1,08 | PCWP | |
- | 97 | TABLE ACCESS BY INDEX ROWID | FND_VS_VALUES_TL | 1 | 37 | 1 (0)| 00:00:01 | Q1,08 | PCWP | |
- |* 98 | INDEX UNIQUE SCAN | FND_VS_VALUES_TL_U1 | 1 | | 0 (0)| 00:00:01 | Q1,08 | PCWP | |
- |* 99 | INDEX RANGE SCAN | GL_SEG_VAL_HIER_RF_N2 | 1 | | 2 (0)| 00:00:01 | Q1,08 | PCWP | |
- |*100 | TABLE ACCESS BY INDEX ROWID | GL_SEG_VAL_HIER_RF | 1 | 82 | 3 (0)| 00:00:01 | Q1,08 | PCWP | |
- | 101 | VIEW PUSHED PREDICATE | | 1 | 2 | 11 (10)| 00:00:01 | Q1,08 | PCWP | |
- | 102 | SORT UNIQUE | | 1 | 280 | 11 (10)| 00:00:01 | Q1,08 | PCWP | |
- | 103 | NESTED LOOPS | | 1 | 280 | 10 (0)| 00:00:01 | Q1,08 | PCWP | |
- | 104 | NESTED LOOPS | | 1 | 280 | 10 (0)| 00:00:01 | Q1,08 | PCWP | |
- | 105 | NESTED LOOPS | | 1 | 198 | 7 (0)| 00:00:01 | Q1,08 | PCWP | |
- | 106 | NESTED LOOPS | | 1 | 161 | 6 (0)| 00:00:01 | Q1,08 | PCWP | |
- | 107 | NESTED LOOPS | | 1 | 139 | 4 (0)| 00:00:01 | Q1,08 | PCWP | |
- | 108 | TABLE ACCESS BY INDEX ROWID | FND_VS_VALUE_SETS | 1 | 34 | 2 (0)| 00:00:01 | Q1,08 | PCWP | |
- |*109 | INDEX UNIQUE SCAN | FND_VS_VALUE_SETS_U2 | 1 | | 1 (0)| 00:00:01 | Q1,08 | PCWP | |
- |*110 | TABLE ACCESS BY INDEX ROWID BATCHED | FND_TREE_VERSION | 1 | 105 | 2 (0)| 00:00:01 | Q1,08 | PCWP | |
- |*111 | INDEX RANGE SCAN | FND_TREE_VERSION_U1 | 1 | | 1 (0)| 00:00:01 | Q1,08 | PCWP | |
- | 112 | TABLE ACCESS BY INDEX ROWID BATCHED | FND_VS_VALUES_B | 1 | 22 | 2 (0)| 00:00:01 | Q1,08 | PCWP | |
- |*113 | INDEX RANGE SCAN | FND_VS_VALUES_B_N1 | 1 | | 1 (0)| 00:00:01 | Q1,08 | PCWP | |
- | 114 | TABLE ACCESS BY INDEX ROWID | FND_VS_VALUES_TL | 1 | 37 | 1 (0)| 00:00:01 | Q1,08 | PCWP | |
- |*115 | INDEX UNIQUE SCAN | FND_VS_VALUES_TL_U1 | 1 | | 0 (0)| 00:00:01 | Q1,08 | PCWP | |
- |*116 | INDEX RANGE SCAN | GL_SEG_VAL_HIER_RF_N2 | 1 | | 2 (0)| 00:00:01 | Q1,08 | PCWP | |
- |*117 | TABLE ACCESS BY INDEX ROWID | GL_SEG_VAL_HIER_RF | 1 | 82 | 3 (0)| 00:00:01 | Q1,08 | PCWP | |
- | 118 | PX COORDINATOR | | | | | | | | |
- | 119 | PX SEND QC (RANDOM) | :TQ20000 | 1 | 297 | 3 (0)| 00:00:01 | Q2,00 | P->S | QC (RAND) |
- | 120 | LOAD AS SELECT (TEMP SEGMENT MERGE) | SYS_TEMP_0FD9D6B49_DA83F60A | | | | | Q2,00 | PCWP | |
- |*121 | COUNT STOPKEY | | | | | | Q2,00 | PCWP | |
- | 122 | MAT_VIEW ACCESS BY INDEX ROWID BATCHED | GL_JE_SOURCES_AL_V | 1 | 29 | 2 (0)| 00:00:01 | Q2,00 | PCWP | |
- |*123 | INDEX RANGE SCAN | GL_JE_SOURCES_AL_V_N1 | 1 | | 1 (0)| 00:00:01 | Q2,00 | PCWP | |
- |*124 | COUNT STOPKEY | | | | | | Q2,00 | PCWP | |
- | 125 | MAT_VIEW ACCESS BY INDEX ROWID BATCHED | GL_JE_CATEGORIES_AL_V | 1 | 36 | 2 (0)| 00:00:01 | Q2,00 | PCWP | |
- |*126 | INDEX RANGE SCAN | GL_JE_CATEGORIES_AL_V_N1 | 1 | | 1 (0)| 00:00:01 | Q2,00 | PCWP | |
- | 127 | NESTED LOOPS | | 1 | 297 | 3 (0)| 00:00:01 | Q2,00 | PCWP | |
- | 128 | NESTED LOOPS | | 1 | 297 | 3 (0)| 00:00:01 | Q2,00 | PCWP | |
- | 129 | NESTED LOOPS | | 1 | 242 | 3 (0)| 00:00:01 | Q2,00 | PCWP | |
- | 130 | NESTED LOOPS | | 1 | 94 | 3 (0)| 00:00:01 | Q2,00 | PCWP | |
- | 131 | VIEW | | 1 | 13 | 2 (0)| 00:00:01 | Q2,00 | PCWP | |
- | 132 | PX BLOCK ITERATOR | | 1 | 32 | 2 (0)| 00:00:01 | Q2,00 | PCWC | |
- | 133 | TABLE ACCESS STORAGE FULL | SYS_TEMP_0FD9D6B48_DA83F60A | 1 | 32 | 2 (0)| 00:00:01 | Q2,00 | PCWP | |
- |*134 | TABLE ACCESS BY INDEX ROWID BATCHED | GL_JE_LINES | 1 | 81 | 3 (0)| 00:00:01 | Q2,00 | PCWP | |
- |*135 | INDEX RANGE SCAN | GL_JE_LINES_N1 | 1 | | 2 (0)| 00:00:01 | Q2,00 | PCWP | |
- |*136 | TABLE ACCESS BY INDEX ROWID | GL_JE_HEADERS | 1 | 148 | 1 (0)| 00:00:01 | Q2,00 | PCWP | |
- |*137 | INDEX UNIQUE SCAN | GL_JE_HEADERS_U1 | 1 | | 0 (0)| 00:00:01 | Q2,00 | PCWP | |
- |*138 | INDEX UNIQUE SCAN | GL_JE_BATCHES_U1 | 1 | | 0 (0)| 00:00:01 | Q2,00 | PCWP | |
- |*139 | TABLE ACCESS BY INDEX ROWID | GL_JE_BATCHES | 1 | 55 | 1 (0)| 00:00:01 | Q2,00 | PCWP | |
- | 140 | PX COORDINATOR | | | | | | | | |
- | 141 | PX SEND QC (RANDOM) | :TQ30004 | 1 | 401 | 510 (1)| 00:00:01 | Q3,04 | P->S | QC (RAND) |
- | 142 | LOAD AS SELECT (TEMP SEGMENT MERGE) | SYS_TEMP_0FD9D6B4A_DA83F60A | | | | | Q3,04 | PCWP | |
- | 143 | NESTED LOOPS | | 1 | 401 | 510 (1)| 00:00:01 | Q3,04 | PCWP | |
- | 144 | NESTED LOOPS | | 1 | 401 | 510 (1)| 00:00:01 | Q3,04 | PCWP | |
- | 145 | NESTED LOOPS | | 1 | 327 | 509 (1)| 00:00:01 | Q3,04 | PCWP | |
- | 146 | NESTED LOOPS | | 1 | 275 | 509 (1)| 00:00:01 | Q3,04 | PCWP | |
- |*147 | HASH JOIN | | 1 | 249 | 509 (1)| 00:00:01 | Q3,04 | PCWP | |
- | 148 | PX RECEIVE | | 25060 | 1590K| 433 (1)| 00:00:01 | Q3,04 | PCWP | |
- | 149 | PX SEND HASH | :TQ30002 | 25060 | 1590K| 433 (1)| 00:00:01 | Q3,02 | P->P | HASH |
- |*150 | HASH JOIN BUFFERED | | 25060 | 1590K| 433 (1)| 00:00:01 | Q3,02 | PCWP | |
- | 151 | PX RECEIVE | | 25060 | 905K| 349 (0)| 00:00:01 | Q3,02 | PCWP | |
- | 152 | PX SEND HYBRID HASH | :TQ30000 | 25060 | 905K| 349 (0)| 00:00:01 | Q3,00 | P->P | HYBRID HASH|
- | 153 | STATISTICS COLLECTOR | | | | | | Q3,00 | PCWC | |
- | 154 | PX BLOCK ITERATOR | | 25060 | 905K| 349 (0)| 00:00:01 | Q3,00 | PCWC | |
- |*155 | TABLE ACCESS STORAGE FULL | XLA_AE_HEADERS | 25060 | 905K| 349 (0)| 00:00:01 | Q3,00 | PCWP | |
- | 156 | PX RECEIVE | | 53792 | 1470K| 83 (0)| 00:00:01 | Q3,02 | PCWP | |
- | 157 | PX SEND HYBRID HASH | :TQ30001 | 53792 | 1470K| 83 (0)| 00:00:01 | Q3,01 | P->P | HYBRID HASH|
- | 158 | PX BLOCK ITERATOR | | 53792 | 1470K| 83 (0)| 00:00:01 | Q3,01 | PCWC | |
- | 159 | TABLE ACCESS STORAGE FULL | XLA_EVENTS | 53792 | 1470K| 83 (0)| 00:00:01 | Q3,01 | PCWP | |
- | 160 | PX RECEIVE | | 26695 | 4796K| 76 (0)| 00:00:01 | Q3,04 | PCWP | |
- | 161 | PX SEND HASH | :TQ30003 | 26695 | 4796K| 76 (0)| 00:00:01 | Q3,03 | P->P | HASH |
- | 162 | PX BLOCK ITERATOR | | 26695 | 4796K| 76 (0)| 00:00:01 | Q3,03 | PCWC | |
- |*163 | TABLE ACCESS STORAGE FULL | XLA_TRANSACTION_ENTITIES | 26695 | 4796K| 76 (0)| 00:00:01 | Q3,03 | PCWP | |
- |*164 | INDEX UNIQUE SCAN | XLA_EVENT_TYPES_B_U2 | 1 | 26 | 0 (0)| 00:00:01 | Q3,04 | PCWP | |
- | 165 | TABLE ACCESS BY INDEX ROWID BATCHED | XLA_EVENT_TYPES_TL | 1 | 52 | 2 (0)| 00:00:01 | Q3,04 | PCWP | |
- |*166 | INDEX RANGE SCAN | XLA_EVENT_TYPES_TL_U1 | 1 | | 1 (0)| 00:00:01 | Q3,04 | PCWP | |
- |*167 | INDEX RANGE SCAN | XLA_AE_LINES_U1 | 1 | | 2 (0)| 00:00:01 | Q3,04 | PCWP | |
- | 168 | TABLE ACCESS BY INDEX ROWID | XLA_AE_LINES | 1 | 74 | 3 (0)| 00:00:01 | Q3,04 | PCWP | |
- | 169 | SORT ORDER BY | | 8 | 64552 | 138 (2)| 00:00:01 | | | |
- | 170 | COUNT | | | | | | | | |
- | 171 | PX COORDINATOR | | | | | | | | |
- | 172 | PX SEND QC (RANDOM) | :TQ50027 | 8 | 64552 | 137 (1)| 00:00:01 | Q5,27 | P->S | QC (RAND) |
- | 173 | BUFFER SORT | | 8 | 64552 | | | Q5,27 | PCWP | |
- | 174 | VIEW | | 8 | 64552 | 137 (1)| 00:00:01 | Q5,27 | PCWP | |
- | 175 | UNION-ALL | | | | | | Q5,27 | PCWP | |
- | 176 | NESTED LOOPS | | 1 | 275 | 10 (0)| 00:00:01 | Q5,27 | PCWP | |
- | 177 | NESTED LOOPS | | 1 | 275 | 10 (0)| 00:00:01 | Q5,27 | PCWP | |
- | 178 | NESTED LOOPS | | 1 | 238 | 9 (0)| 00:00:01 | Q5,27 | PCWP | |
- | 179 | NESTED LOOPS | | 1 | 216 | 7 (0)| 00:00:01 | Q5,00 | S->P | |
- | 180 | NESTED LOOPS | | 1 | 131 | 4 (0)| 00:00:01 | | | |
- | 181 | TABLE ACCESS BY INDEX ROWID | FND_VS_VALUE_SETS | 1 | 34 | 2 (0)| 00:00:01 | | | |
- |*182 | INDEX UNIQUE SCAN | FND_VS_VALUE_SETS_U2 | 1 | | 1 (0)| 00:00:01 | | | |
- |*183 | TABLE ACCESS BY INDEX ROWID BATCHED | FND_TREE_VERSION | 1 | 97 | 2 (0)| 00:00:01 | | | |
- |*184 | INDEX RANGE SCAN | FND_TREE_VERSION_U1 | 1 | | 1 (0)| 00:00:01 | | | |
- |*185 | TABLE ACCESS BY INDEX ROWID BATCHED | GL_SEG_VAL_HIER_RF | 1 | 85 | 3 (0)| 00:00:01 | | | |
- |*186 | INDEX RANGE SCAN | GL_SEG_VAL_HIER_RF_N2 | 1 | | 2 (0)| 00:00:01 | | | |
- | 187 | TABLE ACCESS BY INDEX ROWID BATCHED | FND_VS_VALUES_B | 1 | 22 | 2 (0)| 00:00:01 | Q5,27 | PCWP | |
- |*188 | INDEX RANGE SCAN | FND_VS_VALUES_B_N1 | 1 | | 1 (0)| 00:00:01 | Q5,27 | PCWP | |
- |*189 | INDEX UNIQUE SCAN | FND_VS_VALUES_TL_U1 | 1 | | 0 (0)| 00:00:01 | Q5,27 | PCWP | |
- | 190 | TABLE ACCESS BY INDEX ROWID | FND_VS_VALUES_TL | 1 | 37 | 1 (0)| 00:00:01 | Q5,27 | PCWP | |
- | 191 | NESTED LOOPS | | 1 | 3961 | 7 (0)| 00:00:01 | Q5,27 | PCWP | |
- | 192 | NESTED LOOPS | | 1 | 3864 | 7 (0)| 00:00:01 | Q5,27 | PCWP | |
- |*193 | HASH JOIN | | 1 | 3847 | 6 (0)| 00:00:01 | Q5,27 | PCWP | |
- | 194 | JOIN FILTER CREATE | :BF0000 | 1 | 2719 | 4 (0)| 00:00:01 | Q5,27 | PCWP | |
- | 195 | PX RECEIVE | | 1 | 2719 | 4 (0)| 00:00:01 | Q5,27 | PCWP | |
- | 196 | PX SEND HYBRID HASH | :TQ50013 | 1 | 2719 | 4 (0)| 00:00:01 | Q5,13 | P->P | HYBRID HASH|
- | 197 | STATISTICS COLLECTOR | | | | | | Q5,13 | PCWC | |
- | 198 | BUFFER SORT | | 8 | 64552 | | | Q5,13 | PCWP | |
- | 199 | NESTED LOOPS | | 1 | 2719 | 4 (0)| 00:00:01 | Q5,13 | PCWP | |
- | 200 | NESTED LOOPS | | 1 | 2719 | 4 (0)| 00:00:01 | Q5,13 | PCWP | |
- |*201 | HASH JOIN | | 1 | 2649 | 4 (0)| 00:00:01 | Q5,13 | PCWP | |
- | 202 | PX RECEIVE | | 1 | 221 | 2 (0)| 00:00:01 | Q5,13 | PCWP | |
- | 203 | PX SEND HYBRID HASH | :TQ50001 | 1 | 221 | 2 (0)| 00:00:01 | Q5,01 | P->P | HYBRID HASH|
- | 204 | STATISTICS COLLECTOR | | | | | | Q5,01 | PCWC | |
- | 205 | VIEW | | 1 | 221 | 2 (0)| 00:00:01 | Q5,01 | PCWP | |
- | 206 | PX BLOCK ITERATOR | | 1 | 32 | 2 (0)| 00:00:01 | Q5,01 | PCWC | |
- | 207 | TABLE ACCESS STORAGE FULL | SYS_TEMP_0FD9D6B48_DA83F60A | 1 | 32 | 2 (0)| 00:00:01 | Q5,01 | PCWP | |
- | 208 | PX RECEIVE | | 1 | 2428 | 2 (0)| 00:00:01 | Q5,13 | PCWP | |
- | 209 | PX SEND HYBRID HASH | :TQ50002 | 1 | 2428 | 2 (0)| 00:00:01 | Q5,02 | P->P | HYBRID HASH|
- |*210 | VIEW | | 1 | 2428 | 2 (0)| 00:00:01 | Q5,02 | PCWP | |
- | 211 | PX BLOCK ITERATOR | | 1 | 152 | 2 (0)| 00:00:01 | Q5,02 | PCWC | |
- | 212 | TABLE ACCESS STORAGE FULL | SYS_TEMP_0FD9D6B4A_DA83F60A | 1 | 152 | 2 (0)| 00:00:01 | Q5,02 | PCWP | |
- |*213 | INDEX UNIQUE SCAN | AP_INVOICES_ALL_U1 | 1 | | 0 (0)| 00:00:01 | Q5,13 | PCWP | |
- | 214 | TABLE ACCESS BY INDEX ROWID | AP_INVOICES_ALL | 1 | 70 | 1 (0)| 00:00:01 | Q5,13 | PCWP | |
- | 215 | PX RECEIVE | | 1 | 1128 | 2 (0)| 00:00:01 | Q5,27 | PCWP | |
- | 216 | PX SEND HYBRID HASH | :TQ50014 | 1 | 1128 | 2 (0)| 00:00:01 | Q5,14 | P->P | HYBRID HASH|
- | 217 | JOIN FILTER USE | :BF0000 | 1 | 1128 | 2 (0)| 00:00:01 | Q5,14 | PCWP | |
- |*218 | VIEW | | 1 | 1128 | 2 (0)| 00:00:01 | Q5,14 | PCWP | |
- | 219 | PX BLOCK ITERATOR | | 1 | 297 | 2 (0)| 00:00:01 | Q5,14 | PCWC | |
- | 220 | TABLE ACCESS STORAGE FULL | SYS_TEMP_0FD9D6B49_DA83F60A | 1 | 297 | 2 (0)| 00:00:01 | Q5,14 | PCWP | |
- |*221 | TABLE ACCESS BY INDEX ROWID BATCHED | GL_IMPORT_REFERENCES | 1 | 17 | 3 (0)| 00:00:01 | Q5,27 | PCWP | |
- |*222 | INDEX RANGE SCAN | GL_IMPORT_REFERENCES_N1 | 1 | | 2 (0)| 00:00:01 | Q5,27 | PCWP | |
- |*223 | TABLE ACCESS BY INDEX ROWID | HZ_PARTIES | 1 | 97 | 2 (0)| 00:00:01 | Q5,27 | PCWP | |
- |*224 | INDEX UNIQUE SCAN | HZ_PARTIES_PK | 1 | | 1 (0)| 00:00:01 | Q5,27 | PCWP | |
- | 225 | NESTED LOOPS | | 1 | 275 | 10 (0)| 00:00:01 | Q5,27 | PCWP | |
- | 226 | NESTED LOOPS | | 1 | 275 | 10 (0)| 00:00:01 | Q5,27 | PCWP | |
- | 227 | NESTED LOOPS | | 1 | 238 | 9 (0)| 00:00:01 | Q5,27 | PCWP | |
- | 228 | NESTED LOOPS | | 1 | 216 | 7 (0)| 00:00:01 | Q5,00 | S->P | |
- | 229 | NESTED LOOPS | | 1 | 131 | 4 (0)| 00:00:01 | | | |
- | 230 | TABLE ACCESS BY INDEX ROWID | FND_VS_VALUE_SETS | 1 | 34 | 2 (0)| 00:00:01 | | | |
- |*231 | INDEX UNIQUE SCAN | FND_VS_VALUE_SETS_U2 | 1 | | 1 (0)| 00:00:01 | | | |
- |*232 | TABLE ACCESS BY INDEX ROWID BATCHED | FND_TREE_VERSION | 1 | 97 | 2 (0)| 00:00:01 | | | |
- |*233 | INDEX RANGE SCAN | FND_TREE_VERSION_U1 | 1 | | 1 (0)| 00:00:01 | | | |
- |*234 | TABLE ACCESS BY INDEX ROWID BATCHED | GL_SEG_VAL_HIER_RF | 1 | 85 | 3 (0)| 00:00:01 | | | |
- |*235 | INDEX RANGE SCAN | GL_SEG_VAL_HIER_RF_N2 | 1 | | 2 (0)| 00:00:01 | | | |
- | 236 | TABLE ACCESS BY INDEX ROWID BATCHED | FND_VS_VALUES_B | 1 | 22 | 2 (0)| 00:00:01 | Q5,27 | PCWP | |
- |*237 | INDEX RANGE SCAN | FND_VS_VALUES_B_N1 | 1 | | 1 (0)| 00:00:01 | Q5,27 | PCWP | |
- |*238 | INDEX UNIQUE SCAN | FND_VS_VALUES_TL_U1 | 1 | | 0 (0)| 00:00:01 | Q5,27 | PCWP | |
- | 239 | TABLE ACCESS BY INDEX ROWID | FND_VS_VALUES_TL | 1 | 37 | 1 (0)| 00:00:01 | Q5,27 | PCWP | |
- | 240 | NESTED LOOPS | | 1 | 4323 | 7 (0)| 00:00:01 | Q5,27 | PCWP | |
- | 241 | NESTED LOOPS | | 1 | 4226 | 7 (0)| 00:00:01 | Q5,27 | PCWP | |
- |*242 | HASH JOIN | | 1 | 3794 | 7 (0)| 00:00:01 | Q5,27 | PCWP | |
- | 243 | PX RECEIVE | | 1 | 3573 | 5 (0)| 00:00:01 | Q5,27 | PCWP | |
- | 244 | PX SEND HYBRID HASH | :TQ50015 | 1 | 3573 | 5 (0)| 00:00:01 | Q5,15 | P->P | HYBRID HASH|
- | 245 | STATISTICS COLLECTOR | | | | | | Q5,15 | PCWC | |
- |*246 | HASH JOIN BUFFERED | | 1 | 3573 | 5 (0)| 00:00:01 | Q5,15 | PCWP | |
- | 247 | PX RECEIVE | | 1 | 1145 | 3 (0)| 00:00:01 | Q5,15 | PCWP | |
- | 248 | PX SEND HYBRID HASH | :TQ50003 | 1 | 1145 | 3 (0)| 00:00:01 | Q5,03 | P->P | HYBRID HASH|
- | 249 | STATISTICS COLLECTOR | | | | | | Q5,03 | PCWC | |
- | 250 | NESTED LOOPS | | 1 | 1145 | 3 (0)| 00:00:01 | Q5,03 | PCWP | |
- | 251 | NESTED LOOPS | | 1 | 1145 | 3 (0)| 00:00:01 | Q5,03 | PCWP | |
- |*252 | VIEW | | 1 | 1128 | 2 (0)| 00:00:01 | Q5,03 | PCWP | |
- | 253 | PX BLOCK ITERATOR | | 1 | 297 | 2 (0)| 00:00:01 | Q5,03 | PCWC | |
- | 254 | TABLE ACCESS STORAGE FULL | SYS_TEMP_0FD9D6B49_DA83F60A | 1 | 297 | 2 (0)| 00:00:01 | Q5,03 | PCWP | |
- |*255 | INDEX RANGE SCAN | GL_IMPORT_REFERENCES_N1 | 1 | | 2 (0)| 00:00:01 | Q5,03 | PCWP | |
- |*256 | TABLE ACCESS BY INDEX ROWID | GL_IMPORT_REFERENCES | 1 | 17 | 3 (0)| 00:00:01 | Q5,03 | PCWP | |
- | 257 | PX RECEIVE | | 1 | 2428 | 2 (0)| 00:00:01 | Q5,15 | PCWP | |
- | 258 | PX SEND HYBRID HASH | :TQ50004 | 1 | 2428 | 2 (0)| 00:00:01 | Q5,04 | P->P | HYBRID HASH|
- |*259 | VIEW | | 1 | 2428 | 2 (0)| 00:00:01 | Q5,04 | PCWP | |
- | 260 | PX BLOCK ITERATOR | | 1 | 152 | 2 (0)| 00:00:01 | Q5,04 | PCWC | |
- | 261 | TABLE ACCESS STORAGE FULL | SYS_TEMP_0FD9D6B4A_DA83F60A | 1 | 152 | 2 (0)| 00:00:01 | Q5,04 | PCWP | |
- | 262 | PX RECEIVE | | 1 | 221 | 2 (0)| 00:00:01 | Q5,27 | PCWP | |
- | 263 | PX SEND HYBRID HASH | :TQ50016 | 1 | 221 | 2 (0)| 00:00:01 | Q5,16 | P->P | HYBRID HASH|
- | 264 | VIEW | | 1 | 221 | 2 (0)| 00:00:01 | Q5,16 | PCWP | |
- | 265 | PX BLOCK ITERATOR | | 1 | 32 | 2 (0)| 00:00:01 | Q5,16 | PCWC | |
- | 266 | TABLE ACCESS STORAGE FULL | SYS_TEMP_0FD9D6B48_DA83F60A | 1 | 32 | 2 (0)| 00:00:01 | Q5,16 | PCWP | |
- | 267 | TABLE ACCESS BY INDEX ROWID | AP_CHECKS_ALL | 1 | 432 | 1 (0)| 00:00:01 | Q5,27 | PCWP | |
- |*268 | INDEX UNIQUE SCAN | AP_CHECKS_U1 | 1 | | 0 (0)| 00:00:01 | Q5,27 | PCWP | |
- |*269 | TABLE ACCESS BY INDEX ROWID | HZ_PARTIES | 1 | 97 | 2 (0)| 00:00:01 | Q5,27 | PCWP | |
- |*270 | INDEX UNIQUE SCAN | HZ_PARTIES_PK | 1 | | 1 (0)| 00:00:01 | Q5,27 | PCWP | |
- | 271 | NESTED LOOPS | | 1 | 275 | 10 (0)| 00:00:01 | Q5,27 | PCWP | |
- | 272 | NESTED LOOPS | | 1 | 275 | 10 (0)| 00:00:01 | Q5,27 | PCWP | |
- | 273 | NESTED LOOPS | | 1 | 238 | 9 (0)| 00:00:01 | Q5,27 | PCWP | |
- | 274 | NESTED LOOPS | | 1 | 216 | 7 (0)| 00:00:01 | Q5,00 | S->P | |
- | 275 | NESTED LOOPS | | 1 | 131 | 4 (0)| 00:00:01 | | | |
- | 276 | TABLE ACCESS BY INDEX ROWID | FND_VS_VALUE_SETS | 1 | 34 | 2 (0)| 00:00:01 | | | |
- |*277 | INDEX UNIQUE SCAN | FND_VS_VALUE_SETS_U2 | 1 | | 1 (0)| 00:00:01 | | | |
- |*278 | TABLE ACCESS BY INDEX ROWID BATCHED | FND_TREE_VERSION | 1 | 97 | 2 (0)| 00:00:01 | | | |
- |*279 | INDEX RANGE SCAN | FND_TREE_VERSION_U1 | 1 | | 1 (0)| 00:00:01 | | | |
- |*280 | TABLE ACCESS BY INDEX ROWID BATCHED | GL_SEG_VAL_HIER_RF | 1 | 85 | 3 (0)| 00:00:01 | | | |
- |*281 | INDEX RANGE SCAN | GL_SEG_VAL_HIER_RF_N2 | 1 | | 2 (0)| 00:00:01 | | | |
- | 282 | TABLE ACCESS BY INDEX ROWID BATCHED | FND_VS_VALUES_B | 1 | 22 | 2 (0)| 00:00:01 | Q5,27 | PCWP | |
- |*283 | INDEX RANGE SCAN | FND_VS_VALUES_B_N1 | 1 | | 1 (0)| 00:00:01 | Q5,27 | PCWP | |
- |*284 | INDEX UNIQUE SCAN | FND_VS_VALUES_TL_U1 | 1 | | 0 (0)| 00:00:01 | Q5,27 | PCWP | |
- | 285 | TABLE ACCESS BY INDEX ROWID | FND_VS_VALUES_TL | 1 | 37 | 1 (0)| 00:00:01 | Q5,27 | PCWP | |
- | 286 | NESTED LOOPS | | 1 | 4001 | 8 (0)| 00:00:01 | Q5,27 | PCWP | |
- | 287 | NESTED LOOPS | | 1 | 3904 | 7 (0)| 00:00:01 | Q5,27 | PCWP | |
- | 288 | NESTED LOOPS | | 1 | 3884 | 7 (0)| 00:00:01 | Q5,27 | PCWP | |
- | 289 | NESTED LOOPS | | 1 | 3859 | 7 (0)| 00:00:01 | Q5,27 | PCWP | |
- |*290 | HASH JOIN | | 1 | 3807 | 7 (0)| 00:00:01 | Q5,27 | PCWP | |
- | 291 | PX RECEIVE | | 1 | 3586 | 5 (0)| 00:00:01 | Q5,27 | PCWP | |
- | 292 | PX SEND HYBRID HASH | :TQ50017 | 1 | 3586 | 5 (0)| 00:00:01 | Q5,17 | P->P | HYBRID HASH|
- | 293 | STATISTICS COLLECTOR | | | | | | Q5,17 | PCWC | |
- |*294 | HASH JOIN BUFFERED | | 1 | 3586 | 5 (0)| 00:00:01 | Q5,17 | PCWP | |
- | 295 | PX RECEIVE | | 1 | 1145 | 3 (0)| 00:00:01 | Q5,17 | PCWP | |
- | 296 | PX SEND HYBRID HASH | :TQ50005 | 1 | 1145 | 3 (0)| 00:00:01 | Q5,05 | P->P | HYBRID HASH|
- | 297 | STATISTICS COLLECTOR | | | | | | Q5,05 | PCWC | |
- | 298 | NESTED LOOPS | | 1 | 1145 | 3 (0)| 00:00:01 | Q5,05 | PCWP | |
- | 299 | NESTED LOOPS | | 1 | 1145 | 3 (0)| 00:00:01 | Q5,05 | PCWP | |
- |*300 | VIEW | | 1 | 1128 | 2 (0)| 00:00:01 | Q5,05 | PCWP | |
- | 301 | PX BLOCK ITERATOR | | 1 | 297 | 2 (0)| 00:00:01 | Q5,05 | PCWC | |
- | 302 | TABLE ACCESS STORAGE FULL | SYS_TEMP_0FD9D6B49_DA83F60A | 1 | 297 | 2 (0)| 00:00:01 | Q5,05 | PCWP | |
- |*303 | INDEX RANGE SCAN | GL_IMPORT_REFERENCES_N1 | 1 | | 2 (0)| 00:00:01 | Q5,05 | PCWP | |
- |*304 | TABLE ACCESS BY INDEX ROWID | GL_IMPORT_REFERENCES | 1 | 17 | 3 (0)| 00:00:01 | Q5,05 | PCWP | |
- | 305 | PX RECEIVE | | 1 | 2441 | 2 (0)| 00:00:01 | Q5,17 | PCWP | |
- | 306 | PX SEND HYBRID HASH | :TQ50006 | 1 | 2441 | 2 (0)| 00:00:01 | Q5,06 | P->P | HYBRID HASH|
- |*307 | VIEW | | 1 | 2441 | 2 (0)| 00:00:01 | Q5,06 | PCWP | |
- | 308 | PX BLOCK ITERATOR | | 1 | 152 | 2 (0)| 00:00:01 | Q5,06 | PCWC | |
- | 309 | TABLE ACCESS STORAGE FULL | SYS_TEMP_0FD9D6B4A_DA83F60A | 1 | 152 | 2 (0)| 00:00:01 | Q5,06 | PCWP | |
- | 310 | PX RECEIVE | | 1 | 221 | 2 (0)| 00:00:01 | Q5,27 | PCWP | |
- | 311 | PX SEND HYBRID HASH | :TQ50018 | 1 | 221 | 2 (0)| 00:00:01 | Q5,18 | P->P | HYBRID HASH|
- | 312 | VIEW | | 1 | 221 | 2 (0)| 00:00:01 | Q5,18 | PCWP | |
- | 313 | PX BLOCK ITERATOR | | 1 | 32 | 2 (0)| 00:00:01 | Q5,18 | PCWC | |
- | 314 | TABLE ACCESS STORAGE FULL | SYS_TEMP_0FD9D6B48_DA83F60A | 1 | 32 | 2 (0)| 00:00:01 | Q5,18 | PCWP | |
- | 315 | TABLE ACCESS BY INDEX ROWID | RA_CUSTOMER_TRX_ALL | 1 | 52 | 1 (0)| 00:00:01 | Q5,27 | PCWP | |
- |*316 | INDEX UNIQUE SCAN | RA_CUSTOMER_TRX_U1 | 1 | | 0 (0)| 00:00:01 | Q5,27 | PCWP | |
- | 317 | TABLE ACCESS BY INDEX ROWID | RA_CUST_TRX_TYPES_ALL | 1 | 25 | 1 (0)| 00:00:01 | Q5,27 | PCWP | |
- |*318 | INDEX UNIQUE SCAN | RA_CUST_TRX_TYPES_ALL_U1 | 1 | | 0 (0)| 00:00:01 | Q5,27 | PCWP | |
- | 319 | TABLE ACCESS BY INDEX ROWID | HZ_CUST_ACCOUNTS | 1 | 20 | 1 (0)| 00:00:01 | Q5,27 | PCWP | |
- |*320 | INDEX UNIQUE SCAN | HZ_CUST_ACCOUNTS_PK | 1 | | 0 (0)| 00:00:01 | Q5,27 | PCWP | |
- |*321 | TABLE ACCESS BY INDEX ROWID | HZ_PARTIES | 1 | 97 | 2 (0)| 00:00:01 | Q5,27 | PCWP | |
- |*322 | INDEX UNIQUE SCAN | HZ_PARTIES_PK | 1 | | 1 (0)| 00:00:01 | Q5,27 | PCWP | |
- | 323 | NESTED LOOPS | | 1 | 275 | 10 (0)| 00:00:01 | Q5,27 | PCWP | |
- | 324 | NESTED LOOPS | | 1 | 275 | 10 (0)| 00:00:01 | Q5,27 | PCWP | |
- | 325 | NESTED LOOPS | | 1 | 238 | 9 (0)| 00:00:01 | Q5,27 | PCWP | |
- | 326 | NESTED LOOPS | | 1 | 216 | 7 (0)| 00:00:01 | Q5,00 | S->P | |
- | 327 | NESTED LOOPS | | 1 | 131 | 4 (0)| 00:00:01 | | | |
- | 328 | TABLE ACCESS BY INDEX ROWID | FND_VS_VALUE_SETS | 1 | 34 | 2 (0)| 00:00:01 | | | |
- |*329 | INDEX UNIQUE SCAN | FND_VS_VALUE_SETS_U2 | 1 | | 1 (0)| 00:00:01 | | | |
- |*330 | TABLE ACCESS BY INDEX ROWID BATCHED | FND_TREE_VERSION | 1 | 97 | 2 (0)| 00:00:01 | | | |
- |*331 | INDEX RANGE SCAN | FND_TREE_VERSION_U1 | 1 | | 1 (0)| 00:00:01 | | | |
- |*332 | TABLE ACCESS BY INDEX ROWID BATCHED | GL_SEG_VAL_HIER_RF | 1 | 85 | 3 (0)| 00:00:01 | | | |
- |*333 | INDEX RANGE SCAN | GL_SEG_VAL_HIER_RF_N2 | 1 | | 2 (0)| 00:00:01 | | | |
- | 334 | TABLE ACCESS BY INDEX ROWID BATCHED | FND_VS_VALUES_B | 1 | 22 | 2 (0)| 00:00:01 | Q5,27 | PCWP | |
- |*335 | INDEX RANGE SCAN | FND_VS_VALUES_B_N1 | 1 | | 1 (0)| 00:00:01 | Q5,27 | PCWP | |
- |*336 | INDEX UNIQUE SCAN | FND_VS_VALUES_TL_U1 | 1 | | 0 (0)| 00:00:01 | Q5,27 | PCWP | |
- | 337 | TABLE ACCESS BY INDEX ROWID | FND_VS_VALUES_TL | 1 | 37 | 1 (0)| 00:00:01 | Q5,27 | PCWP | |
- | 338 | NESTED LOOPS | | 1 | 4000 | 8 (0)| 00:00:01 | Q5,27 | PCWP | |
- | 339 | NESTED LOOPS | | 1 | 3903 | 8 (0)| 00:00:01 | Q5,27 | PCWP | |
- | 340 | NESTED LOOPS | | 1 | 3883 | 7 (0)| 00:00:01 | Q5,27 | PCWP | |
- | 341 | NESTED LOOPS | | 1 | 3858 | 7 (0)| 00:00:01 | Q5,27 | PCWP | |
- | 342 | NESTED LOOPS | | 1 | 3821 | 7 (0)| 00:00:01 | Q5,27 | PCWP | |
- |*343 | HASH JOIN | | 1 | 3807 | 7 (0)| 00:00:01 | Q5,27 | PCWP | |
- | 344 | PX RECEIVE | | 1 | 3586 | 5 (0)| 00:00:01 | Q5,27 | PCWP | |
- | 345 | PX SEND HYBRID HASH | :TQ50019 | 1 | 3586 | 5 (0)| 00:00:01 | Q5,19 | P->P | HYBRID HASH|
- | 346 | STATISTICS COLLECTOR | | | | | | Q5,19 | PCWC | |
- |*347 | HASH JOIN BUFFERED | | 1 | 3586 | 5 (0)| 00:00:01 | Q5,19 | PCWP | |
- | 348 | PX RECEIVE | | 1 | 1145 | 3 (0)| 00:00:01 | Q5,19 | PCWP | |
- | 349 | PX SEND HYBRID HASH | :TQ50007 | 1 | 1145 | 3 (0)| 00:00:01 | Q5,07 | P->P | HYBRID HASH|
- | 350 | STATISTICS COLLECTOR | | | | | | Q5,07 | PCWC | |
- | 351 | NESTED LOOPS | | 1 | 1145 | 3 (0)| 00:00:01 | Q5,07 | PCWP | |
- | 352 | NESTED LOOPS | | 1 | 1145 | 3 (0)| 00:00:01 | Q5,07 | PCWP | |
- |*353 | VIEW | | 1 | 1128 | 2 (0)| 00:00:01 | Q5,07 | PCWP | |
- | 354 | PX BLOCK ITERATOR | | 1 | 297 | 2 (0)| 00:00:01 | Q5,07 | PCWC | |
- | 355 | TABLE ACCESS STORAGE FULL | SYS_TEMP_0FD9D6B49_DA83F60A | 1 | 297 | 2 (0)| 00:00:01 | Q5,07 | PCWP | |
- |*356 | INDEX RANGE SCAN | GL_IMPORT_REFERENCES_N1 | 1 | | 2 (0)| 00:00:01 | Q5,07 | PCWP | |
- |*357 | TABLE ACCESS BY INDEX ROWID | GL_IMPORT_REFERENCES | 1 | 17 | 3 (0)| 00:00:01 | Q5,07 | PCWP | |
- | 358 | PX RECEIVE | | 1 | 2441 | 2 (0)| 00:00:01 | Q5,19 | PCWP | |
- | 359 | PX SEND HYBRID HASH | :TQ50008 | 1 | 2441 | 2 (0)| 00:00:01 | Q5,08 | P->P | HYBRID HASH|
- |*360 | VIEW | | 1 | 2441 | 2 (0)| 00:00:01 | Q5,08 | PCWP | |
- | 361 | PX BLOCK ITERATOR | | 1 | 152 | 2 (0)| 00:00:01 | Q5,08 | PCWC | |
- | 362 | TABLE ACCESS STORAGE FULL | SYS_TEMP_0FD9D6B4A_DA83F60A | 1 | 152 | 2 (0)| 00:00:01 | Q5,08 | PCWP | |
- | 363 | PX RECEIVE | | 1 | 221 | 2 (0)| 00:00:01 | Q5,27 | PCWP | |
- | 364 | PX SEND HYBRID HASH | :TQ50020 | 1 | 221 | 2 (0)| 00:00:01 | Q5,20 | P->P | HYBRID HASH|
- | 365 | VIEW | | 1 | 221 | 2 (0)| 00:00:01 | Q5,20 | PCWP | |
- | 366 | PX BLOCK ITERATOR | | 1 | 32 | 2 (0)| 00:00:01 | Q5,20 | PCWC | |
- | 367 | TABLE ACCESS STORAGE FULL | SYS_TEMP_0FD9D6B48_DA83F60A | 1 | 32 | 2 (0)| 00:00:01 | Q5,20 | PCWP | |
- | 368 | TABLE ACCESS BY INDEX ROWID | AR_ADJUSTMENTS_ALL | 1 | 14 | 1 (0)| 00:00:01 | Q5,27 | PCWP | |
- |*369 | INDEX UNIQUE SCAN | AR_ADJUSTMENTS_U1 | 1 | | 0 (0)| 00:00:01 | Q5,27 | PCWP | |
- | 370 | TABLE ACCESS BY INDEX ROWID | RA_CUSTOMER_TRX_ALL | 1 | 37 | 1 (0)| 00:00:01 | Q5,27 | PCWP | |
- |*371 | INDEX UNIQUE SCAN | RA_CUSTOMER_TRX_U1 | 1 | | 0 (0)| 00:00:01 | Q5,27 | PCWP | |
- | 372 | TABLE ACCESS BY INDEX ROWID | RA_CUST_TRX_TYPES_ALL | 1 | 25 | 1 (0)| 00:00:01 | Q5,27 | PCWP | |
- |*373 | INDEX UNIQUE SCAN | RA_CUST_TRX_TYPES_ALL_U1 | 1 | | 0 (0)| 00:00:01 | Q5,27 | PCWP | |
- | 374 | TABLE ACCESS BY INDEX ROWID | HZ_CUST_ACCOUNTS | 1 | 20 | 1 (0)| 00:00:01 | Q5,27 | PCWP | |
- |*375 | INDEX UNIQUE SCAN | HZ_CUST_ACCOUNTS_PK | 1 | | 0 (0)| 00:00:01 | Q5,27 | PCWP | |
- |*376 | TABLE ACCESS BY INDEX ROWID | HZ_PARTIES | 1 | 97 | 2 (0)| 00:00:01 | Q5,27 | PCWP | |
- |*377 | INDEX UNIQUE SCAN | HZ_PARTIES_PK | 1 | | 1 (0)| 00:00:01 | Q5,27 | PCWP | |
- | 378 | NESTED LOOPS | | 1 | 275 | 10 (0)| 00:00:01 | Q5,27 | PCWP | |
- | 379 | NESTED LOOPS | | 1 | 275 | 10 (0)| 00:00:01 | Q5,27 | PCWP | |
- | 380 | NESTED LOOPS | | 1 | 238 | 9 (0)| 00:00:01 | Q5,27 | PCWP | |
- | 381 | NESTED LOOPS | | 1 | 216 | 7 (0)| 00:00:01 | Q5,00 | S->P | |
- | 382 | NESTED LOOPS | | 1 | 131 | 4 (0)| 00:00:01 | | | |
- | 383 | TABLE ACCESS BY INDEX ROWID | FND_VS_VALUE_SETS | 1 | 34 | 2 (0)| 00:00:01 | | | |
- |*384 | INDEX UNIQUE SCAN | FND_VS_VALUE_SETS_U2 | 1 | | 1 (0)| 00:00:01 | | | |
- |*385 | TABLE ACCESS BY INDEX ROWID BATCHED | FND_TREE_VERSION | 1 | 97 | 2 (0)| 00:00:01 | | | |
- |*386 | INDEX RANGE SCAN | FND_TREE_VERSION_U1 | 1 | | 1 (0)| 00:00:01 | | | |
- |*387 | TABLE ACCESS BY INDEX ROWID BATCHED | GL_SEG_VAL_HIER_RF | 1 | 85 | 3 (0)| 00:00:01 | | | |
- |*388 | INDEX RANGE SCAN | GL_SEG_VAL_HIER_RF_N2 | 1 | | 2 (0)| 00:00:01 | | | |
- | 389 | TABLE ACCESS BY INDEX ROWID BATCHED | FND_VS_VALUES_B | 1 | 22 | 2 (0)| 00:00:01 | Q5,27 | PCWP | |
- |*390 | INDEX RANGE SCAN | FND_VS_VALUES_B_N1 | 1 | | 1 (0)| 00:00:01 | Q5,27 | PCWP | |
- |*391 | INDEX UNIQUE SCAN | FND_VS_VALUES_TL_U1 | 1 | | 0 (0)| 00:00:01 | Q5,27 | PCWP | |
- | 392 | TABLE ACCESS BY INDEX ROWID | FND_VS_VALUES_TL | 1 | 37 | 1 (0)| 00:00:01 | Q5,27 | PCWP | |
- | 393 | NESTED LOOPS | | 1 | 3845 | 7 (0)| 00:00:01 | Q5,27 | PCWP | |
- | 394 | NESTED LOOPS | | 1 | 3845 | 7 (0)| 00:00:01 | Q5,27 | PCWP | |
- |*395 | HASH JOIN | | 1 | 3807 | 7 (0)| 00:00:01 | Q5,27 | PCWP | |
- | 396 | PX RECEIVE | | 1 | 3586 | 5 (0)| 00:00:01 | Q5,27 | PCWP | |
- | 397 | PX SEND HYBRID HASH | :TQ50021 | 1 | 3586 | 5 (0)| 00:00:01 | Q5,21 | P->P | HYBRID HASH|
- | 398 | STATISTICS COLLECTOR | | | | | | Q5,21 | PCWC | |
- |*399 | HASH JOIN BUFFERED | | 1 | 3586 | 5 (0)| 00:00:01 | Q5,21 | PCWP | |
- | 400 | PX RECEIVE | | 1 | 1145 | 3 (0)| 00:00:01 | Q5,21 | PCWP | |
- | 401 | PX SEND HYBRID HASH | :TQ50009 | 1 | 1145 | 3 (0)| 00:00:01 | Q5,09 | P->P | HYBRID HASH|
- | 402 | STATISTICS COLLECTOR | | | | | | Q5,09 | PCWC | |
- | 403 | NESTED LOOPS | | 1 | 1145 | 3 (0)| 00:00:01 | Q5,09 | PCWP | |
- | 404 | NESTED LOOPS | | 1 | 1145 | 3 (0)| 00:00:01 | Q5,09 | PCWP | |
- |*405 | VIEW | | 1 | 1128 | 2 (0)| 00:00:01 | Q5,09 | PCWP | |
- | 406 | PX BLOCK ITERATOR | | 1 | 297 | 2 (0)| 00:00:01 | Q5,09 | PCWC | |
- | 407 | TABLE ACCESS STORAGE FULL | SYS_TEMP_0FD9D6B49_DA83F60A | 1 | 297 | 2 (0)| 00:00:01 | Q5,09 | PCWP | |
- |*408 | INDEX RANGE SCAN | GL_IMPORT_REFERENCES_N1 | 1 | | 2 (0)| 00:00:01 | Q5,09 | PCWP | |
- |*409 | TABLE ACCESS BY INDEX ROWID | GL_IMPORT_REFERENCES | 1 | 17 | 3 (0)| 00:00:01 | Q5,09 | PCWP | |
- | 410 | PX RECEIVE | | 1 | 2441 | 2 (0)| 00:00:01 | Q5,21 | PCWP | |
- | 411 | PX SEND HYBRID HASH | :TQ50010 | 1 | 2441 | 2 (0)| 00:00:01 | Q5,10 | P->P | HYBRID HASH|
- |*412 | VIEW | | 1 | 2441 | 2 (0)| 00:00:01 | Q5,10 | PCWP | |
- | 413 | PX BLOCK ITERATOR | | 1 | 152 | 2 (0)| 00:00:01 | Q5,10 | PCWC | |
- | 414 | TABLE ACCESS STORAGE FULL | SYS_TEMP_0FD9D6B4A_DA83F60A | 1 | 152 | 2 (0)| 00:00:01 | Q5,10 | PCWP | |
- | 415 | PX RECEIVE | | 1 | 221 | 2 (0)| 00:00:01 | Q5,27 | PCWP | |
- | 416 | PX SEND HYBRID HASH | :TQ50022 | 1 | 221 | 2 (0)| 00:00:01 | Q5,22 | P->P | HYBRID HASH|
- | 417 | VIEW | | 1 | 221 | 2 (0)| 00:00:01 | Q5,22 | PCWP | |
- | 418 | PX BLOCK ITERATOR | | 1 | 32 | 2 (0)| 00:00:01 | Q5,22 | PCWC | |
- | 419 | TABLE ACCESS STORAGE FULL | SYS_TEMP_0FD9D6B48_DA83F60A | 1 | 32 | 2 (0)| 00:00:01 | Q5,22 | PCWP | |
- |*420 | INDEX UNIQUE SCAN | AR_CASH_RECEIPTS_U1 | 1 | | 0 (0)| 00:00:01 | Q5,27 | PCWP | |
- | 421 | TABLE ACCESS BY INDEX ROWID | AR_CASH_RECEIPTS_ALL | 1 | 38 | 1 (0)| 00:00:01 | Q5,27 | PCWP | |
- | 422 | NESTED LOOPS | | 1 | 275 | 10 (0)| 00:00:01 | Q5,27 | PCWP | |
- | 423 | NESTED LOOPS | | 1 | 275 | 10 (0)| 00:00:01 | Q5,27 | PCWP | |
- | 424 | NESTED LOOPS | | 1 | 238 | 9 (0)| 00:00:01 | Q5,27 | PCWP | |
- | 425 | NESTED LOOPS | | 1 | 216 | 7 (0)| 00:00:01 | Q5,00 | S->P | |
- | 426 | NESTED LOOPS | | 1 | 131 | 4 (0)| 00:00:01 | | | |
- | 427 | TABLE ACCESS BY INDEX ROWID | FND_VS_VALUE_SETS | 1 | 34 | 2 (0)| 00:00:01 | | | |
- |*428 | INDEX UNIQUE SCAN | FND_VS_VALUE_SETS_U2 | 1 | | 1 (0)| 00:00:01 | | | |
- |*429 | TABLE ACCESS BY INDEX ROWID BATCHED | FND_TREE_VERSION | 1 | 97 | 2 (0)| 00:00:01 | | | |
- |*430 | INDEX RANGE SCAN | FND_TREE_VERSION_U1 | 1 | | 1 (0)| 00:00:01 | | | |
- |*431 | TABLE ACCESS BY INDEX ROWID BATCHED | GL_SEG_VAL_HIER_RF | 1 | 85 | 3 (0)| 00:00:01 | | | |
- |*432 | INDEX RANGE SCAN | GL_SEG_VAL_HIER_RF_N2 | 1 | | 2 (0)| 00:00:01 | | | |
- | 433 | TABLE ACCESS BY INDEX ROWID BATCHED | FND_VS_VALUES_B | 1 | 22 | 2 (0)| 00:00:01 | Q5,27 | PCWP | |
- |*434 | INDEX RANGE SCAN | FND_VS_VALUES_B_N1 | 1 | | 1 (0)| 00:00:01 | Q5,27 | PCWP | |
- |*435 | INDEX UNIQUE SCAN | FND_VS_VALUES_TL_U1 | 1 | | 0 (0)| 00:00:01 | Q5,27 | PCWP | |
- | 436 | TABLE ACCESS BY INDEX ROWID | FND_VS_VALUES_TL | 1 | 37 | 1 (0)| 00:00:01 | Q5,27 | PCWP | |
- | 437 | BUFFER SORT | | | | | | Q5,27 | PCWC | |
- | 438 | PX RECEIVE | | | | | | Q5,27 | PCWP | |
- | 439 | PX SEND ROUND-ROBIN | :TQ50000 | | | | | | S->P | RND-ROBIN |
- | 440 | HASH UNIQUE | | 1 | 446 | 15 (7)| 00:00:01 | | | |
- |*441 | FILTER | | | | | | | | |
- | 442 | PX COORDINATOR | | | | | | | | |
- | 443 | PX SEND QC (RANDOM) | :TQ40002 | 1 | 446 | 4 (0)| 00:00:01 | Q4,02 | P->S | QC (RAND) |
- |*444 | HASH JOIN BUFFERED | | 1 | 446 | 4 (0)| 00:00:01 | Q4,02 | PCWP | |
- | 445 | PX RECEIVE | | 1 | 29 | 2 (0)| 00:00:01 | Q4,02 | PCWP | |
- | 446 | PX SEND HYBRID HASH | :TQ40000 | 1 | 29 | 2 (0)| 00:00:01 | Q4,00 | P->P | HYBRID HASH|
- | 447 | STATISTICS COLLECTOR | | | | | | Q4,00 | PCWC | |
- | 448 | VIEW | | 1 | 29 | 2 (0)| 00:00:01 | Q4,00 | PCWP | |
- | 449 | PX BLOCK ITERATOR | | 1 | 32 | 2 (0)| 00:00:01 | Q4,00 | PCWC | |
- | 450 | TABLE ACCESS STORAGE FULL | SYS_TEMP_0FD9D6B48_DA83F60A | 1 | 32 | 2 (0)| 00:00:01 | Q4,00 | PCWP | |
- | 451 | PX RECEIVE | | 1 | 417 | 2 (0)| 00:00:01 | Q4,02 | PCWP | |
- | 452 | PX SEND HYBRID HASH | :TQ40001 | 1 | 417 | 2 (0)| 00:00:01 | Q4,01 | P->P | HYBRID HASH|
- |*453 | VIEW | | 1 | 417 | 2 (0)| 00:00:01 | Q4,01 | PCWP | |
- | 454 | PX BLOCK ITERATOR | | 1 | 297 | 2 (0)| 00:00:01 | Q4,01 | PCWC | |
- | 455 | TABLE ACCESS STORAGE FULL | SYS_TEMP_0FD9D6B49_DA83F60A | 1 | 297 | 2 (0)| 00:00:01 | Q4,01 | PCWP | |
- |*456 | INDEX RANGE SCAN | GL_IMPORT_REFERENCES_N1 | 1 | 10 | 3 (0)| 00:00:01 | | | |
- | 457 | NESTED LOOPS | | 1 | 275 | 10 (0)| 00:00:01 | Q5,27 | PCWP | |
- | 458 | NESTED LOOPS | | 1 | 275 | 10 (0)| 00:00:01 | Q5,27 | PCWP | |
- | 459 | NESTED LOOPS | | 1 | 238 | 9 (0)| 00:00:01 | Q5,27 | PCWP | |
- | 460 | NESTED LOOPS | | 1 | 216 | 7 (0)| 00:00:01 | Q5,00 | S->P | |
- | 461 | NESTED LOOPS | | 1 | 131 | 4 (0)| 00:00:01 | | | |
- | 462 | TABLE ACCESS BY INDEX ROWID | FND_VS_VALUE_SETS | 1 | 34 | 2 (0)| 00:00:01 | | | |
- |*463 | INDEX UNIQUE SCAN | FND_VS_VALUE_SETS_U2 | 1 | | 1 (0)| 00:00:01 | | | |
- |*464 | TABLE ACCESS BY INDEX ROWID BATCHED | FND_TREE_VERSION | 1 | 97 | 2 (0)| 00:00:01 | | | |
- |*465 | INDEX RANGE SCAN | FND_TREE_VERSION_U1 | 1 | | 1 (0)| 00:00:01 | | | |
- |*466 | TABLE ACCESS BY INDEX ROWID BATCHED | GL_SEG_VAL_HIER_RF | 1 | 85 | 3 (0)| 00:00:01 | | | |
- |*467 | INDEX RANGE SCAN | GL_SEG_VAL_HIER_RF_N2 | 1 | | 2 (0)| 00:00:01 | | | |
- | 468 | TABLE ACCESS BY INDEX ROWID BATCHED | FND_VS_VALUES_B | 1 | 22 | 2 (0)| 00:00:01 | Q5,27 | PCWP | |
- |*469 | INDEX RANGE SCAN | FND_VS_VALUES_B_N1 | 1 | | 1 (0)| 00:00:01 | Q5,27 | PCWP | |
- |*470 | INDEX UNIQUE SCAN | FND_VS_VALUES_TL_U1 | 1 | | 0 (0)| 00:00:01 | Q5,27 | PCWP | |
- | 471 | TABLE ACCESS BY INDEX ROWID | FND_VS_VALUES_TL | 1 | 37 | 1 (0)| 00:00:01 | Q5,27 | PCWP | |
- |*472 | HASH JOIN | | 1 | 4251 | 10 (0)| 00:00:01 | Q5,27 | PCWP | |
- | 473 | PX RECEIVE | | 1 | 4030 | 8 (0)| 00:00:01 | Q5,27 | PCWP | |
- | 474 | PX SEND HYBRID HASH | :TQ50023 | 1 | 4030 | 8 (0)| 00:00:01 | Q5,23 | P->P | HYBRID HASH|
- | 475 | STATISTICS COLLECTOR | | | | | | Q5,23 | PCWC | |
- | 476 | BUFFER SORT | | 8 | 64552 | | | Q5,23 | PCWP | |
- | 477 | NESTED LOOPS | | 1 | 4030 | 8 (0)| 00:00:01 | Q5,23 | PCWP | |
- | 478 | NESTED LOOPS | | 1 | 3998 | 8 (0)| 00:00:01 | Q5,23 | PCWP | |
- | 479 | NESTED LOOPS | | 1 | 3956 | 8 (0)| 00:00:01 | Q5,23 | PCWP | |
- | 480 | NESTED LOOPS | | 1 | 3904 | 7 (0)| 00:00:01 | Q5,23 | PCWP | |
- | 481 | NESTED LOOPS | | 1 | 3875 | 7 (0)| 00:00:01 | Q5,23 | PCWP | |
- | 482 | NESTED LOOPS | | 1 | 3858 | 6 (0)| 00:00:01 | Q5,23 | PCWP | |
- | 483 | NESTED LOOPS | | 1 | 3849 | 6 (0)| 00:00:01 | Q5,23 | PCWP | |
- | 484 | NESTED LOOPS | | 1 | 3752 | 5 (0)| 00:00:01 | Q5,23 | PCWP | |
- | 485 | NESTED LOOPS | | 1 | 3732 | 5 (0)| 00:00:01 | Q5,23 | PCWP | |
- | 486 | NESTED LOOPS | | 1 | 3705 | 5 (0)| 00:00:01 | Q5,23 | PCWP | |
- | 487 | NESTED LOOPS | | 1 | 3635 | 5 (0)| 00:00:01 | Q5,23 | PCWP | |
- | 488 | NESTED LOOPS | | 1 | 3620 | 4 (0)| 00:00:01 | Q5,23 | PCWP | |
- | 489 | NESTED LOOPS | | 1 | 3590 | 4 (0)| 00:00:01 | Q5,23 | PCWP | |
- |*490 | HASH JOIN | | 1 | 3546 | 4 (0)| 00:00:01 | Q5,23 | PCWP | |
- | 491 | PX RECEIVE | | 1 | 1128 | 2 (0)| 00:00:01 | Q5,23 | PCWP | |
- | 492 | PX SEND HYBRID HASH | :TQ50011 | 1 | 1128 | 2 (0)| 00:00:01 | Q5,11 | P->P | HYBRID HASH|
- | 493 | STATISTICS COLLECTOR | | | | | | Q5,11 | PCWC | |
- |*494 | VIEW | | 1 | 1128 | 2 (0)| 00:00:01 | Q5,11 | PCWP | |
- | 495 | PX BLOCK ITERATOR | | 1 | 297 | 2 (0)| 00:00:01 | Q5,11 | PCWC | |
- | 496 | TABLE ACCESS STORAGE FULL | SYS_TEMP_0FD9D6B49_DA83F60A | 1 | 297 | 2 (0)| 00:00:01 | Q5,11 | PCWP | |
- | 497 | PX RECEIVE | | 1 | 2418 | 2 (0)| 00:00:01 | Q5,23 | PCWP | |
- | 498 | PX SEND HYBRID HASH | :TQ50012 | 1 | 2418 | 2 (0)| 00:00:01 | Q5,12 | P->P | HYBRID HASH|
- | 499 | VIEW | | 1 | 2418 | 2 (0)| 00:00:01 | Q5,12 | PCWP | |
- | 500 | PX BLOCK ITERATOR | | 1 | 152 | 2 (0)| 00:00:01 | Q5,12 | PCWC | |
- | 501 | TABLE ACCESS STORAGE FULL | SYS_TEMP_0FD9D6B4A_DA83F60A | 1 | 152 | 2 (0)| 00:00:01 | Q5,12 | PCWP | |
- |*502 | TABLE ACCESS BY INDEX ROWID | CMR_RCV_EVENTS | 1 | 44 | 1 (0)| 00:00:01 | Q5,23 | PCWP | |
- |*503 | INDEX UNIQUE SCAN | CMR_RCV_EVENTS_U1 | 1 | | 0 (0)| 00:00:01 | Q5,23 | PCWP | |
- |*504 | TABLE ACCESS BY INDEX ROWID | CMR_RCV_TRANSACTIONS | 1 | 30 | 1 (0)| 00:00:01 | Q5,23 | PCWP | |
- |*505 | INDEX UNIQUE SCAN | CMR_RCV_TRANSACTIONS_PK | 1 | | 0 (0)| 00:00:01 | Q5,23 | PCWP | |
- | 506 | TABLE ACCESS BY INDEX ROWID | PO_DISTRIBUTIONS_ALL | 1 | 15 | 1 (0)| 00:00:01 | Q5,23 | PCWP | |
- |*507 | INDEX UNIQUE SCAN | PO_DISTRIBUTIONS_U1 | 1 | | 0 (0)| 00:00:01 | Q5,23 | PCWP | |
- | 508 | TABLE ACCESS BY INDEX ROWID | PO_LINES_ALL | 1 | 70 | 1 (0)| 00:00:01 | Q5,23 | PCWP | |
- |*509 | INDEX UNIQUE SCAN | PO_LINES_U1 | 1 | | 0 (0)| 00:00:01 | Q5,23 | PCWP | |
- | 510 | TABLE ACCESS BY INDEX ROWID | PO_HEADERS_ALL | 1 | 27 | 1 (0)| 00:00:01 | Q5,23 | PCWP | |
- |*511 | INDEX UNIQUE SCAN | PO_HEADERS_U1 | 1 | | 0 (0)| 00:00:01 | Q5,23 | PCWP | |
- | 512 | TABLE ACCESS BY INDEX ROWID | POZ_SUPPLIERS | 1 | 20 | 1 (0)| 00:00:01 | Q5,23 | PCWP | |
- |*513 | INDEX UNIQUE SCAN | POZ_SUPPLIERS_U1 | 1 | | 0 (0)| 00:00:01 | Q5,23 | PCWP | |
- |*514 | TABLE ACCESS BY INDEX ROWID | HZ_PARTIES | 1 | 97 | 2 (0)| 00:00:01 | Q5,23 | PCWP | |
- |*515 | INDEX UNIQUE SCAN | HZ_PARTIES_PK | 1 | | 1 (0)| 00:00:01 | Q5,23 | PCWP | |
- |*516 | INDEX RANGE SCAN | XLA_DISTRIBUTION_LINKS_N3 | 1 | 9 | 2 (0)| 00:00:01 | Q5,23 | PCWP | |
- |*517 | TABLE ACCESS BY INDEX ROWID BATCHED | GL_IMPORT_REFERENCES | 1 | 17 | 3 (0)| 00:00:01 | Q5,23 | PCWP | |
- |*518 | INDEX RANGE SCAN | GL_IMPORT_REFERENCES_N1 | 1 | | 2 (0)| 00:00:01 | Q5,23 | PCWP | |
- |*519 | TABLE ACCESS BY INDEX ROWID BATCHED | HR_ALL_ORGANIZATION_UNITS_F | 1 | 29 | 2 (0)| 00:00:01 | Q5,23 | PCWP | |
- |*520 | INDEX RANGE SCAN | HR_ALL_ORGANIZATION_UNITS_PK | 1 | | 1 (0)| 00:00:01 | Q5,23 | PCWP | |
- |*521 | TABLE ACCESS BY INDEX ROWID BATCHED | HR_ORGANIZATION_INFORMATION_F | 1 | 52 | 2 (0)| 00:00:01 | Q5,23 | PCWP | |
- |*522 | INDEX RANGE SCAN | HR_ORGANIZATION_INFORMATION_N2 | 1 | | 1 (0)| 00:00:01 | Q5,23 | PCWP | |
- |*523 | TABLE ACCESS BY INDEX ROWID BATCHED | HR_ORG_UNIT_CLASSIFICATIONS_F | 1 | 42 | 2 (0)| 00:00:01 | Q5,23 | PCWP | |
- |*524 | INDEX RANGE SCAN | HR_ORG_UNIT_CLASS_U2 | 1 | | 1 (0)| 00:00:01 | Q5,23 | PCWP | |
- |*525 | TABLE ACCESS BY INDEX ROWID | HR_ORGANIZATION_UNITS_F_TL | 1 | 32 | 1 (0)| 00:00:01 | Q5,23 | PCWP | |
- |*526 | INDEX UNIQUE SCAN | HR_ORGANIZATION_UNITS_F_TL_PK | 1 | | 0 (0)| 00:00:01 | Q5,23 | PCWP | |
- | 527 | PX RECEIVE | | 1 | 221 | 2 (0)| 00:00:01 | Q5,27 | PCWP | |
- | 528 | PX SEND HYBRID HASH | :TQ50024 | 1 | 221 | 2 (0)| 00:00:01 | Q5,24 | P->P | HYBRID HASH|
- | 529 | VIEW | | 1 | 221 | 2 (0)| 00:00:01 | Q5,24 | PCWP | |
- | 530 | PX BLOCK ITERATOR | | 1 | 32 | 2 (0)| 00:00:01 | Q5,24 | PCWC | |
- | 531 | TABLE ACCESS STORAGE FULL | SYS_TEMP_0FD9D6B48_DA83F60A | 1 | 32 | 2 (0)| 00:00:01 | Q5,24 | PCWP | |
- | 532 | NESTED LOOPS | | 1 | 275 | 10 (0)| 00:00:01 | Q5,27 | PCWP | |
- | 533 | NESTED LOOPS | | 1 | 275 | 10 (0)| 00:00:01 | Q5,27 | PCWP | |
- | 534 | NESTED LOOPS | | 1 | 238 | 9 (0)| 00:00:01 | Q5,27 | PCWP | |
- | 535 | NESTED LOOPS | | 1 | 216 | 7 (0)| 00:00:01 | Q5,00 | S->P | |
- | 536 | NESTED LOOPS | | 1 | 131 | 4 (0)| 00:00:01 | | | |
- | 537 | TABLE ACCESS BY INDEX ROWID | FND_VS_VALUE_SETS | 1 | 34 | 2 (0)| 00:00:01 | | | |
- |*538 | INDEX UNIQUE SCAN | FND_VS_VALUE_SETS_U2 | 1 | | 1 (0)| 00:00:01 | | | |
- |*539 | TABLE ACCESS BY INDEX ROWID BATCHED | FND_TREE_VERSION | 1 | 97 | 2 (0)| 00:00:01 | | | |
- |*540 | INDEX RANGE SCAN | FND_TREE_VERSION_U1 | 1 | | 1 (0)| 00:00:01 | | | |
- |*541 | TABLE ACCESS BY INDEX ROWID BATCHED | GL_SEG_VAL_HIER_RF | 1 | 85 | 3 (0)| 00:00:01 | | | |
- |*542 | INDEX RANGE SCAN | GL_SEG_VAL_HIER_RF_N2 | 1 | | 2 (0)| 00:00:01 | | | |
- | 543 | TABLE ACCESS BY INDEX ROWID BATCHED | FND_VS_VALUES_B | 1 | 22 | 2 (0)| 00:00:01 | Q5,27 | PCWP | |
- |*544 | INDEX RANGE SCAN | FND_VS_VALUES_B_N1 | 1 | | 1 (0)| 00:00:01 | Q5,27 | PCWP | |
- |*545 | INDEX UNIQUE SCAN | FND_VS_VALUES_TL_U1 | 1 | | 0 (0)| 00:00:01 | Q5,27 | PCWP | |
- | 546 | TABLE ACCESS BY INDEX ROWID | FND_VS_VALUES_TL | 1 | 37 | 1 (0)| 00:00:01 | Q5,27 | PCWP | |
- |*547 | HASH JOIN | | 1 | 1824 | 4 (0)| 00:00:01 | Q5,27 | PCWP | |
- | 548 | PX RECEIVE | | 1 | 221 | 2 (0)| 00:00:01 | Q5,27 | PCWP | |
- | 549 | PX SEND HYBRID HASH | :TQ50025 | 1 | 221 | 2 (0)| 00:00:01 | Q5,25 | P->P | HYBRID HASH|
- | 550 | STATISTICS COLLECTOR | | | | | | Q5,25 | PCWC | |
- | 551 | VIEW | | 1 | 221 | 2 (0)| 00:00:01 | Q5,25 | PCWP | |
- | 552 | PX BLOCK ITERATOR | | 1 | 32 | 2 (0)| 00:00:01 | Q5,25 | PCWC | |
- | 553 | TABLE ACCESS STORAGE FULL | SYS_TEMP_0FD9D6B48_DA83F60A | 1 | 32 | 2 (0)| 00:00:01 | Q5,25 | PCWP | |
- | 554 | PX RECEIVE | | 1 | 1603 | 2 (0)| 00:00:01 | Q5,27 | PCWP | |
- | 555 | PX SEND HYBRID HASH | :TQ50026 | 1 | 1603 | 2 (0)| 00:00:01 | Q5,26 | P->P | HYBRID HASH|
- |*556 | VIEW | | 1 | 1603 | 2 (0)| 00:00:01 | Q5,26 | PCWP | |
- | 557 | PX BLOCK ITERATOR | | 1 | 297 | 2 (0)| 00:00:01 | Q5,26 | PCWC | |
- | 558 | TABLE ACCESS STORAGE FULL | SYS_TEMP_0FD9D6B49_DA83F60A | 1 | 297 | 2 (0)| 00:00:01 | Q5,26 | PCWP | |
- --------------------------------------------------------------------------------------------------------------------------------------------------------------------------
- Predicate Information (IDENTIFIED BY operation id):
- ---------------------------------------------------
- 8 - access("CC"."SEGMENT4"="ACTIVITY"."CHILD_VALUE")
- 11 - access("CC"."SEGMENT5"="SOF"."CHILD_VALUE")
- 29 - access("VALUE_SET_CODE"='Source of Funds UOB Ledger' AND "ENTERPRISE_ID"=1 AND "SANDBOX_ID"='1')
- 31 - storage("TREE_CODE"='Source of Funds UOB Ledger' AND "TREE_STRUCTURE_CODE"='GL_ACCT_FLEX' AND "STATUS"='ACTIVE' AND "EFFECTIVE_END_DATE">=SYSDATE@! AND
- "EFFECTIVE_START_DATE"<=SYSDATE@! AND "ENTERPRISE_ID"=1)
- FILTER("TREE_CODE"='Source of Funds UOB Ledger' AND "TREE_STRUCTURE_CODE"='GL_ACCT_FLEX' AND "STATUS"='ACTIVE' AND "EFFECTIVE_END_DATE">=SYSDATE@! AND
- "EFFECTIVE_START_DATE"<=SYSDATE@! AND "ENTERPRISE_ID"=1)
- 33 - access("VALUE_SET_ID"="VALUE_SET_ID" AND "ENTERPRISE_ID"=1 AND "SANDBOX_ID"='1')
- FILTER("SANDBOX_ID"='1' AND "ENTERPRISE_ID"=1)
- 34 - FILTER(LEAST(:P_SOF) IS NULL OR "GLH"."ANCESTOR_PK1_VALUE"=:P_SOF)
- 35 - access("GLH"."TREE_STRUCTURE_CODE"='GL_ACCT_FLEX' AND "GLH"."TREE_CODE"='Source of Funds UOB Ledger' AND "TREE_VERSION_ID"="GLH"."TREE_VERSION_ID" AND
- "GLH"."PK1_VALUE"="VALUE")
- 36 - access("VALUE_ID"="VALUE_ID" AND "LANGUAGE"=USERENV('LANG') AND "ENTERPRISE_ID"=1 AND "SANDBOX_ID"='1')
- 58 - access("VALUE_SET_CODE"='Activity UOB Ledger' AND "ENTERPRISE_ID"=1 AND "SANDBOX_ID"='1')
- 60 - storage("TREE_CODE"='Activity UOB Ledger' AND "TREE_STRUCTURE_CODE"='GL_ACCT_FLEX' AND "STATUS"='ACTIVE' AND "EFFECTIVE_END_DATE">=SYSDATE@! AND
- "EFFECTIVE_START_DATE"<=SYSDATE@! AND "ENTERPRISE_ID"=1)
- FILTER("TREE_CODE"='Activity UOB Ledger' AND "TREE_STRUCTURE_CODE"='GL_ACCT_FLEX' AND "STATUS"='ACTIVE' AND "EFFECTIVE_END_DATE">=SYSDATE@! AND
- "EFFECTIVE_START_DATE"<=SYSDATE@! AND "ENTERPRISE_ID"=1)
- 61 - FILTER(LEAST(:P_ACTIVITY) IS NULL OR "GLH"."ANCESTOR_PK1_VALUE"=:P_ACTIVITY)
- 62 - access("GLH"."TREE_STRUCTURE_CODE"='GL_ACCT_FLEX' AND "GLH"."TREE_CODE"='Activity UOB Ledger' AND "TREE_VERSION_ID"="GLH"."TREE_VERSION_ID")
- 64 - access("VALUE_SET_ID"="VALUE_SET_ID" AND "GLH"."PK1_VALUE"="VALUE" AND "ENTERPRISE_ID"=1 AND "SANDBOX_ID"='1')
- 65 - access("VALUE_ID"="VALUE_ID" AND "LANGUAGE"=USERENV('LANG') AND "ENTERPRISE_ID"=1 AND "SANDBOX_ID"='1')
- 75 - access("VALUE_SET_CODE"='Company UOB Ledger' AND "ENTERPRISE_ID"=1 AND "SANDBOX_ID"='1')
- 77 - access("VALUE_SET_ID"="VALUE_SET_ID" AND "VALUE"="CC"."SEGMENT1" AND "ENTERPRISE_ID"=1 AND "SANDBOX_ID"='1')
- 79 - access("VALUE_ID"="VALUE_ID" AND "LANGUAGE"=USERENV('LANG') AND "ENTERPRISE_ID"=1 AND "SANDBOX_ID"='1')
- 80 - FILTER(LEAST(:P_COMPANY) IS NULL OR "GLH"."ANCESTOR_PK1_VALUE"=:P_COMPANY)
- 81 - access("GLH"."TREE_STRUCTURE_CODE"='GL_ACCT_FLEX' AND "GLH"."TREE_CODE"='Company UOB Ledger' AND "GLH"."PK1_VALUE"="CC"."SEGMENT1")
- FILTER("GLH"."PK1_VALUE"="CC"."SEGMENT1" AND "GLH"."PK1_VALUE"="VALUE")
- 82 - access("TREE_STRUCTURE_CODE"='GL_ACCT_FLEX' AND "TREE_CODE"='Company UOB Ledger' AND "TREE_VERSION_ID"="GLH"."TREE_VERSION_ID" AND "ENTERPRISE_ID"=1)
- 83 - FILTER("STATUS"='ACTIVE' AND "EFFECTIVE_END_DATE">=SYSDATE@! AND "EFFECTIVE_START_DATE"<=SYSDATE@!)
- 92 - access("VALUE_SET_CODE"='Analysis UOB Ledger' AND "ENTERPRISE_ID"=1 AND "SANDBOX_ID"='1')
- 93 - FILTER("STATUS"='ACTIVE' AND "EFFECTIVE_END_DATE">=SYSDATE@! AND "EFFECTIVE_START_DATE"<=SYSDATE@!)
- 94 - access("TREE_STRUCTURE_CODE"='GL_ACCT_FLEX' AND "TREE_CODE"='Analysis UOB Ledger' AND "ENTERPRISE_ID"=1)
- FILTER("ENTERPRISE_ID"=1)
- 96 - access("VALUE_SET_ID"="VALUE_SET_ID" AND "VALUE"="CC"."SEGMENT2" AND "ENTERPRISE_ID"=1 AND "SANDBOX_ID"='1')
- 98 - access("VALUE_ID"="VALUE_ID" AND "LANGUAGE"=USERENV('LANG') AND "ENTERPRISE_ID"=1 AND "SANDBOX_ID"='1')
- 99 - access("GLH"."TREE_STRUCTURE_CODE"='GL_ACCT_FLEX' AND "GLH"."TREE_CODE"='Analysis UOB Ledger' AND "TREE_VERSION_ID"="GLH"."TREE_VERSION_ID" AND
- "GLH"."PK1_VALUE"="CC"."SEGMENT2")
- FILTER("GLH"."PK1_VALUE"="VALUE")
- 100 - FILTER(LEAST(:P_ANALYSIS) IS NULL OR "GLH"."ANCESTOR_PK1_VALUE"=:P_ANALYSIS)
- 109 - access("VALUE_SET_CODE"='Cost Centre UOB Ledger' AND "ENTERPRISE_ID"=1 AND "SANDBOX_ID"='1')
- 110 - FILTER("STATUS"='ACTIVE' AND "EFFECTIVE_END_DATE">=SYSDATE@! AND "EFFECTIVE_START_DATE"<=SYSDATE@!)
- 111 - access("TREE_STRUCTURE_CODE"='GL_ACCT_FLEX' AND "TREE_CODE"='Cost Centre UOB Ledger' AND "ENTERPRISE_ID"=1)
- FILTER("ENTERPRISE_ID"=1)
- 113 - access("VALUE_SET_ID"="VALUE_SET_ID" AND "VALUE"="CC"."SEGMENT3" AND "ENTERPRISE_ID"=1 AND "SANDBOX_ID"='1')
- 115 - access("VALUE_ID"="VALUE_ID" AND "LANGUAGE"=USERENV('LANG') AND "ENTERPRISE_ID"=1 AND "SANDBOX_ID"='1')
- 116 - access("GLH"."TREE_STRUCTURE_CODE"='GL_ACCT_FLEX' AND "GLH"."TREE_CODE"='Cost Centre UOB Ledger' AND "TREE_VERSION_ID"="GLH"."TREE_VERSION_ID" AND
- "GLH"."PK1_VALUE"="CC"."SEGMENT3")
- FILTER("GLH"."PK1_VALUE"="VALUE")
- 117 - FILTER(LEAST(:P_COST_CENTRE) IS NULL OR "GLH"."ANCESTOR_PK1_VALUE"=:P_COST_CENTRE)
- 121 - FILTER(ROWNUM=1)
- 123 - access("JE_SOURCE_NAME"=:B1 AND "LANGUAGE"=USERENV('LANG'))
- 124 - FILTER(ROWNUM=1)
- 126 - access("JE_CATEGORY_NAME"=:B1 AND "LANGUAGE"=USERENV('LANG'))
- 134 - FILTER("GLL"."LEDGER_ID"=TO_NUMBER(:P_LEDGER_ID) AND "GLL"."CURRENCY_CODE"<>'STAT')
- 135 - access("GLL"."CODE_COMBINATION_ID"="CC"."CODE_COMBINATION_ID" AND "GLL"."PERIOD_NAME"=:P_PERIOD_NAME)
- 136 - FILTER("GLH"."PERIOD_NAME"=:P_PERIOD_NAME AND "GLH"."LEDGER_ID"=TO_NUMBER(:P_LEDGER_ID))
- 137 - access("GLH"."JE_HEADER_ID"="GLL"."JE_HEADER_ID")
- 138 - access("GLH"."JE_BATCH_ID"="GLB"."JE_BATCH_ID")
- 139 - FILTER("GLB"."STATUS"='P')
- 147 - access("XAH"."ENTITY_ID"="ENTITY_ID" AND "XEV"."ENTITY_ID"="ENTITY_ID")
- 150 - access("XAH"."EVENT_ID"="XEV"."EVENT_ID")
- 155 - storage("XAH"."PERIOD_NAME"=:P_PERIOD_NAME AND "XAH"."LEDGER_ID"=TO_NUMBER(:P_LEDGER_ID))
- FILTER("XAH"."PERIOD_NAME"=:P_PERIOD_NAME AND "XAH"."LEDGER_ID"=TO_NUMBER(:P_LEDGER_ID))
- 163 - storage("LEDGER_ID"=TO_NUMBER(:P_LEDGER_ID))
- FILTER("LEDGER_ID"=TO_NUMBER(:P_LEDGER_ID))
- 164 - access("XEV"."APPLICATION_ID"="B"."APPLICATION_ID" AND "XEV"."EVENT_TYPE_CODE"="B"."EVENT_TYPE_CODE")
- 166 - access("B"."APPLICATION_ID"="T"."APPLICATION_ID" AND "B"."EVENT_TYPE_CODE"="T"."EVENT_TYPE_CODE" AND "T"."LANGUAGE"=USERENV('LANG'))
- FILTER("B"."EVENT_TYPE_CODE"="T"."EVENT_TYPE_CODE" AND "T"."LANGUAGE"=USERENV('LANG'))
- 167 - access("XAH"."AE_HEADER_ID"="XAL"."AE_HEADER_ID" AND "XAH"."APPLICATION_ID"="XAL"."APPLICATION_ID")
- FILTER("XAL"."APPLICATION_ID"="B"."APPLICATION_ID" AND "XAH"."APPLICATION_ID"="XAL"."APPLICATION_ID")
- 182 - access("VALUE_SET_CODE"='Analysis UOB Ledger' AND "ENTERPRISE_ID"=1 AND "SANDBOX_ID"='1')
- 183 - FILTER("EFFECTIVE_END_DATE">=SYSDATE@! AND "EFFECTIVE_START_DATE"<=SYSDATE@!)
- 184 - access("TREE_STRUCTURE_CODE"='GL_ACCT_FLEX' AND "TREE_CODE"='Analysis UOB Ledger' AND "ENTERPRISE_ID"=1)
- FILTER("ENTERPRISE_ID"=1)
- 185 - FILTER("GH"."DISTANCE"=1 AND "GH"."ANCESTOR_PK1_VALUE" IS NOT NULL)
- 186 - access("GH"."TREE_STRUCTURE_CODE"='GL_ACCT_FLEX' AND "GH"."TREE_CODE"='Analysis UOB Ledger' AND "TREE_VERSION_ID"="GH"."TREE_VERSION_ID" AND
- "GH"."PK1_VALUE"=:B1)
- 188 - access("VALUE_SET_ID"="VALUE_SET_ID" AND "VALUE"="GH"."ANCESTOR_PK1_VALUE" AND "ENTERPRISE_ID"=1 AND "SANDBOX_ID"='1')
- 189 - access("VALUE_ID"="VALUE_ID" AND "LANGUAGE"=USERENV('LANG') AND "ENTERPRISE_ID"=1 AND "SANDBOX_ID"='1')
- 193 - access("AIA"."SET_OF_BOOKS_ID"="GL_DATA"."LEDGER_ID" AND "XLA"."LEDGER_ID"="GL_DATA"."LEDGER_ID")
- 201 - access("CC"."CODE_COMBINATION_ID"="XLA"."CODE_COMBINATION_ID")
- 210 - FILTER("XLA"."ENTITY_CODE"='AP_INVOICES')
- 213 - access("AIA"."INVOICE_ID"="XLA"."SOURCE_ID_INT_1")
- 218 - FILTER("GL_DATA"."JE_SOURCE"='Payables' AND "GL_DATA"."REVERSED_JE_HEADER_ID" IS NULL)
- 221 - FILTER("GIR"."GL_SL_LINK_ID" IS NOT NULL AND "GIR"."GL_SL_LINK_TABLE" IS NOT NULL AND "XLA"."GL_SL_LINK_ID"="GIR"."GL_SL_LINK_ID" AND
- "GIR"."GL_SL_LINK_TABLE"="XLA"."GL_SL_LINK_TABLE")
- 222 - access("GL_DATA"."JE_HEADER_ID"="GIR"."JE_HEADER_ID" AND "GIR"."JE_LINE_NUM"="GL_DATA"."JE_LINE_NUM")
- 223 - FILTER(NVL("OBJECT_TYPE",'X')<>'CONSUMER')
- 224 - access("AIA"."PARTY_ID"="PARTY_ID")
- 231 - access("VALUE_SET_CODE"='Analysis UOB Ledger' AND "ENTERPRISE_ID"=1 AND "SANDBOX_ID"='1')
- 232 - FILTER("EFFECTIVE_END_DATE">=SYSDATE@! AND "EFFECTIVE_START_DATE"<=SYSDATE@!)
- 233 - access("TREE_STRUCTURE_CODE"='GL_ACCT_FLEX' AND "TREE_CODE"='Analysis UOB Ledger' AND "ENTERPRISE_ID"=1)
- FILTER("ENTERPRISE_ID"=1)
- 234 - FILTER("GH"."DISTANCE"=1 AND "GH"."ANCESTOR_PK1_VALUE" IS NOT NULL)
- 235 - access("GH"."TREE_STRUCTURE_CODE"='GL_ACCT_FLEX' AND "GH"."TREE_CODE"='Analysis UOB Ledger' AND "TREE_VERSION_ID"="GH"."TREE_VERSION_ID" AND
- "GH"."PK1_VALUE"=:B1)
- 237 - access("VALUE_SET_ID"="VALUE_SET_ID" AND "VALUE"="GH"."ANCESTOR_PK1_VALUE" AND "ENTERPRISE_ID"=1 AND "SANDBOX_ID"='1')
- 238 - access("VALUE_ID"="VALUE_ID" AND "LANGUAGE"=USERENV('LANG') AND "ENTERPRISE_ID"=1 AND "SANDBOX_ID"='1')
- 242 - access("CC"."CODE_COMBINATION_ID"="XLA"."CODE_COMBINATION_ID")
- 246 - access("XLA"."LEDGER_ID"="GL_DATA"."LEDGER_ID" AND "XLA"."GL_SL_LINK_ID"="GIR"."GL_SL_LINK_ID" AND "GIR"."GL_SL_LINK_TABLE"="XLA"."GL_SL_LINK_TABLE")
- 252 - FILTER("GL_DATA"."JE_SOURCE"='Payables' AND "GL_DATA"."REVERSED_JE_HEADER_ID" IS NULL)
- 255 - access("GL_DATA"."JE_HEADER_ID"="GIR"."JE_HEADER_ID" AND "GIR"."JE_LINE_NUM"="GL_DATA"."JE_LINE_NUM")
- 256 - FILTER("GIR"."GL_SL_LINK_ID" IS NOT NULL AND "GIR"."GL_SL_LINK_TABLE" IS NOT NULL)
- 259 - FILTER("XLA"."ENTITY_CODE"='AP_PAYMENTS')
- 268 - access("ACA"."CHECK_ID"="XLA"."SOURCE_ID_INT_1")
- 269 - FILTER(NVL("OBJECT_TYPE",'X')<>'CONSUMER')
- 270 - access("ACA"."PARTY_ID"="PARTY_ID")
- 277 - access("VALUE_SET_CODE"='Analysis UOB Ledger' AND "ENTERPRISE_ID"=1 AND "SANDBOX_ID"='1')
- 278 - FILTER("EFFECTIVE_END_DATE">=SYSDATE@! AND "EFFECTIVE_START_DATE"<=SYSDATE@!)
- 279 - access("TREE_STRUCTURE_CODE"='GL_ACCT_FLEX' AND "TREE_CODE"='Analysis UOB Ledger' AND "ENTERPRISE_ID"=1)
- FILTER("ENTERPRISE_ID"=1)
- 280 - FILTER("GH"."DISTANCE"=1 AND "GH"."ANCESTOR_PK1_VALUE" IS NOT NULL)
- 281 - access("GH"."TREE_STRUCTURE_CODE"='GL_ACCT_FLEX' AND "GH"."TREE_CODE"='Analysis UOB Ledger' AND "TREE_VERSION_ID"="GH"."TREE_VERSION_ID" AND
- "GH"."PK1_VALUE"=:B1)
- 283 - access("VALUE_SET_ID"="VALUE_SET_ID" AND "VALUE"="GH"."ANCESTOR_PK1_VALUE" AND "ENTERPRISE_ID"=1 AND "SANDBOX_ID"='1')
- 284 - access("VALUE_ID"="VALUE_ID" AND "LANGUAGE"=USERENV('LANG') AND "ENTERPRISE_ID"=1 AND "SANDBOX_ID"='1')
- 290 - access("CC"."CODE_COMBINATION_ID"="XLA"."CODE_COMBINATION_ID")
- 294 - access("XLA"."LEDGER_ID"="GL_DATA"."LEDGER_ID" AND "XLA"."GL_SL_LINK_ID"="GIR"."GL_SL_LINK_ID" AND "GIR"."GL_SL_LINK_TABLE"="XLA"."GL_SL_LINK_TABLE")
- 300 - FILTER("GL_DATA"."JE_SOURCE"='Receivables' AND "GL_DATA"."REVERSED_JE_HEADER_ID" IS NULL)
- 303 - access("GL_DATA"."JE_HEADER_ID"="GIR"."JE_HEADER_ID" AND "GIR"."JE_LINE_NUM"="GL_DATA"."JE_LINE_NUM")
- 304 - FILTER("GIR"."GL_SL_LINK_ID" IS NOT NULL AND "GIR"."GL_SL_LINK_TABLE" IS NOT NULL)
- 307 - FILTER("XLA"."APPLICATION_ID"=222 AND "XLA"."ENTITY_CODE"<>'ADJUSTMENTS' AND "XLA"."ENTITY_CODE"<>'RECEIPTS')
- 316 - access("XLA"."SOURCE_ID_INT_1"="RCT"."CUSTOMER_TRX_ID")
- 318 - access("RCT"."CUST_TRX_TYPE_SEQ_ID"="RCTTA"."CUST_TRX_TYPE_SEQ_ID")
- 320 - access("RCT"."BILL_TO_CUSTOMER_ID"="CA"."CUST_ACCOUNT_ID")
- 321 - FILTER(NVL("OBJECT_TYPE",'X')<>'CONSUMER')
- 322 - access("CA"."PARTY_ID"="PARTY_ID")
- 329 - access("VALUE_SET_CODE"='Analysis UOB Ledger' AND "ENTERPRISE_ID"=1 AND "SANDBOX_ID"='1')
- 330 - FILTER("EFFECTIVE_END_DATE">=SYSDATE@! AND "EFFECTIVE_START_DATE"<=SYSDATE@!)
- 331 - access("TREE_STRUCTURE_CODE"='GL_ACCT_FLEX' AND "TREE_CODE"='Analysis UOB Ledger' AND "ENTERPRISE_ID"=1)
- FILTER("ENTERPRISE_ID"=1)
- 332 - FILTER("GH"."DISTANCE"=1 AND "GH"."ANCESTOR_PK1_VALUE" IS NOT NULL)
- 333 - access("GH"."TREE_STRUCTURE_CODE"='GL_ACCT_FLEX' AND "GH"."TREE_CODE"='Analysis UOB Ledger' AND "TREE_VERSION_ID"="GH"."TREE_VERSION_ID" AND
- "GH"."PK1_VALUE"=:B1)
- 335 - access("VALUE_SET_ID"="VALUE_SET_ID" AND "VALUE"="GH"."ANCESTOR_PK1_VALUE" AND "ENTERPRISE_ID"=1 AND "SANDBOX_ID"='1')
- 336 - access("VALUE_ID"="VALUE_ID" AND "LANGUAGE"=USERENV('LANG') AND "ENTERPRISE_ID"=1 AND "SANDBOX_ID"='1')
- 343 - access("CC"."CODE_COMBINATION_ID"="XLA"."CODE_COMBINATION_ID")
- 347 - access("XLA"."LEDGER_ID"="GL_DATA"."LEDGER_ID" AND "XLA"."GL_SL_LINK_ID"="GIR"."GL_SL_LINK_ID" AND "GIR"."GL_SL_LINK_TABLE"="XLA"."GL_SL_LINK_TABLE")
- 353 - FILTER("GL_DATA"."JE_SOURCE"='Receivables' AND "GL_DATA"."REVERSED_JE_HEADER_ID" IS NULL)
- 356 - access("GL_DATA"."JE_HEADER_ID"="GIR"."JE_HEADER_ID" AND "GIR"."JE_LINE_NUM"="GL_DATA"."JE_LINE_NUM")
- 357 - FILTER("GIR"."GL_SL_LINK_ID" IS NOT NULL AND "GIR"."GL_SL_LINK_TABLE" IS NOT NULL)
- 360 - FILTER("XLA"."ENTITY_CODE"='ADJUSTMENTS' AND "XLA"."APPLICATION_ID"=222)
- 369 - access("XLA"."SOURCE_ID_INT_1"="ADA"."ADJUSTMENT_ID")
- 371 - access("ADA"."CUSTOMER_TRX_ID"="RCT"."CUSTOMER_TRX_ID")
- 373 - access("RCT"."CUST_TRX_TYPE_SEQ_ID"="RCTTA"."CUST_TRX_TYPE_SEQ_ID")
- 375 - access("RCT"."BILL_TO_CUSTOMER_ID"="CA"."CUST_ACCOUNT_ID")
- 376 - FILTER(NVL("OBJECT_TYPE",'X')<>'CONSUMER')
- 377 - access("CA"."PARTY_ID"="PARTY_ID")
- 384 - access("VALUE_SET_CODE"='Analysis UOB Ledger' AND "ENTERPRISE_ID"=1 AND "SANDBOX_ID"='1')
- 385 - FILTER("EFFECTIVE_END_DATE">=SYSDATE@! AND "EFFECTIVE_START_DATE"<=SYSDATE@!)
- 386 - access("TREE_STRUCTURE_CODE"='GL_ACCT_FLEX' AND "TREE_CODE"='Analysis UOB Ledger' AND "ENTERPRISE_ID"=1)
- FILTER("ENTERPRISE_ID"=1)
- 387 - FILTER("GH"."DISTANCE"=1 AND "GH"."ANCESTOR_PK1_VALUE" IS NOT NULL)
- 388 - access("GH"."TREE_STRUCTURE_CODE"='GL_ACCT_FLEX' AND "GH"."TREE_CODE"='Analysis UOB Ledger' AND "TREE_VERSION_ID"="GH"."TREE_VERSION_ID" AND
- "GH"."PK1_VALUE"=:B1)
- 390 - access("VALUE_SET_ID"="VALUE_SET_ID" AND "VALUE"="GH"."ANCESTOR_PK1_VALUE" AND "ENTERPRISE_ID"=1 AND "SANDBOX_ID"='1')
- 391 - access("VALUE_ID"="VALUE_ID" AND "LANGUAGE"=USERENV('LANG') AND "ENTERPRISE_ID"=1 AND "SANDBOX_ID"='1')
- 395 - access("CC"."CODE_COMBINATION_ID"="XLA"."CODE_COMBINATION_ID")
- 399 - access("XLA"."LEDGER_ID"="GL_DATA"."LEDGER_ID" AND "XLA"."GL_SL_LINK_ID"="GIR"."GL_SL_LINK_ID" AND "GIR"."GL_SL_LINK_TABLE"="XLA"."GL_SL_LINK_TABLE")
- 405 - FILTER("GL_DATA"."JE_SOURCE"='Receivables' AND "GL_DATA"."REVERSED_JE_HEADER_ID" IS NULL)
- 408 - access("GL_DATA"."JE_HEADER_ID"="GIR"."JE_HEADER_ID" AND "GIR"."JE_LINE_NUM"="GL_DATA"."JE_LINE_NUM")
- 409 - FILTER("GIR"."GL_SL_LINK_ID" IS NOT NULL AND "GIR"."GL_SL_LINK_TABLE" IS NOT NULL)
- 412 - FILTER("XLA"."ENTITY_CODE"='RECEIPTS' AND "XLA"."APPLICATION_ID"=222)
- 420 - access("XLA"."SOURCE_ID_INT_1"="ACRA"."CASH_RECEIPT_ID")
- 428 - access("VALUE_SET_CODE"='Analysis UOB Ledger' AND "ENTERPRISE_ID"=1 AND "SANDBOX_ID"='1')
- 429 - FILTER("EFFECTIVE_END_DATE">=SYSDATE@! AND "EFFECTIVE_START_DATE"<=SYSDATE@!)
- 430 - access("TREE_STRUCTURE_CODE"='GL_ACCT_FLEX' AND "TREE_CODE"='Analysis UOB Ledger' AND "ENTERPRISE_ID"=1)
- FILTER("ENTERPRISE_ID"=1)
- 431 - FILTER("GH"."DISTANCE"=1 AND "GH"."ANCESTOR_PK1_VALUE" IS NOT NULL)
- 432 - access("GH"."TREE_STRUCTURE_CODE"='GL_ACCT_FLEX' AND "GH"."TREE_CODE"='Analysis UOB Ledger' AND "TREE_VERSION_ID"="GH"."TREE_VERSION_ID" AND
- "GH"."PK1_VALUE"=:B1)
- 434 - access("VALUE_SET_ID"="VALUE_SET_ID" AND "VALUE"="GH"."ANCESTOR_PK1_VALUE" AND "ENTERPRISE_ID"=1 AND "SANDBOX_ID"='1')
- 435 - access("VALUE_ID"="VALUE_ID" AND "LANGUAGE"=USERENV('LANG') AND "ENTERPRISE_ID"=1 AND "SANDBOX_ID"='1')
- 441 - FILTER("GL_DATA"."JE_SOURCE"<>'Receivables' AND "GL_DATA"."JE_SOURCE"<>'Payables' AND "GL_DATA"."JE_SOURCE"<>'Receipt Accounting' OR
- ("GL_DATA"."JE_SOURCE"='Payables' OR "GL_DATA"."JE_SOURCE"='Receipt Accounting' OR "GL_DATA"."JE_SOURCE"='Receivables') AND NOT EXISTS (SELECT 0 FROM
- "GL_IMPORT_REFERENCES" "GIR" WHERE "GIR"."JE_LINE_NUM"=:B1 AND "GIR"."JE_HEADER_ID"=:B2))
- 444 - access("CC"."CODE_COMBINATION_ID"="GL_DATA"."CODE_COMBINATION_ID")
- 453 - FILTER("GL_DATA"."REVERSED_JE_HEADER_ID" IS NULL)
- 456 - access("GIR"."JE_HEADER_ID"=:B1 AND "GIR"."JE_LINE_NUM"=:B2)
- 463 - access("VALUE_SET_CODE"='Analysis UOB Ledger' AND "ENTERPRISE_ID"=1 AND "SANDBOX_ID"='1')
- 464 - FILTER("EFFECTIVE_END_DATE">=SYSDATE@! AND "EFFECTIVE_START_DATE"<=SYSDATE@!)
- 465 - access("TREE_STRUCTURE_CODE"='GL_ACCT_FLEX' AND "TREE_CODE"='Analysis UOB Ledger' AND "ENTERPRISE_ID"=1)
- FILTER("ENTERPRISE_ID"=1)
- 466 - FILTER("GH"."DISTANCE"=1 AND "GH"."ANCESTOR_PK1_VALUE" IS NOT NULL)
- 467 - access("GH"."TREE_STRUCTURE_CODE"='GL_ACCT_FLEX' AND "GH"."TREE_CODE"='Analysis UOB Ledger' AND "TREE_VERSION_ID"="GH"."TREE_VERSION_ID" AND
- "GH"."PK1_VALUE"=:B1)
- 469 - access("VALUE_SET_ID"="VALUE_SET_ID" AND "VALUE"="GH"."ANCESTOR_PK1_VALUE" AND "ENTERPRISE_ID"=1 AND "SANDBOX_ID"='1')
- 470 - access("VALUE_ID"="VALUE_ID" AND "LANGUAGE"=USERENV('LANG') AND "ENTERPRISE_ID"=1 AND "SANDBOX_ID"='1')
- 472 - access("CC"."CODE_COMBINATION_ID"="XLA"."CODE_COMBINATION_ID")
- 490 - access("XLA"."LEDGER_ID"="GL_DATA"."LEDGER_ID")
- 494 - FILTER("GL_DATA"."JE_SOURCE"='Receipt Accounting' AND "GL_DATA"."REVERSED_JE_HEADER_ID" IS NULL)
- 502 - FILTER("XLA"."LEGAL_ENTITY_ID"="CRE"."LEGAL_ENTITY_ID" AND "XLA"."LEDGER_ID"="CRE"."LEDGER_ID" AND "CRE"."CMR_RCV_TRANSACTION_ID" IS NOT NULL)
- 503 - access("XLA"."EVENT_ID"="CRE"."EVENT_ID")
- 504 - FILTER("XLA"."SOURCE_ID_INT_1"="CRT"."CMR_RCV_TRANSACTION_ID" OR "XLA"."SOURCE_ID_INT_1"="CRE"."ACCOUNTING_EVENT_ID")
- 505 - access("CRE"."CMR_RCV_TRANSACTION_ID"="CRT"."CMR_RCV_TRANSACTION_ID")
- 507 - access("D"."PO_DISTRIBUTION_ID"="CRT"."PO_DISTRIBUTION_ID")
- 509 - access("PL"."PO_LINE_ID"="D"."PO_LINE_ID")
- 511 - access("H"."PO_HEADER_ID"="PL"."PO_HEADER_ID")
- FILTER("D"."PO_HEADER_ID"="H"."PO_HEADER_ID")
- 513 - access("H"."VENDOR_ID"="PS"."VENDOR_ID")
- 514 - FILTER(NVL("OBJECT_TYPE",'X')<>'CONSUMER')
- 515 - access("PS"."PARTY_ID"="PARTY_ID")
- 516 - access("XLA"."AE_HEADER_ID"="XDL"."AE_HEADER_ID" AND "XLA"."AE_LINE_NUM"="XDL"."AE_LINE_NUM")
- 517 - FILTER("GIR"."GL_SL_LINK_ID" IS NOT NULL AND "GIR"."GL_SL_LINK_TABLE" IS NOT NULL AND "XLA"."GL_SL_LINK_ID"="GIR"."GL_SL_LINK_ID" AND
- "GIR"."GL_SL_LINK_TABLE"="XLA"."GL_SL_LINK_TABLE")
- 518 - access("GL_DATA"."JE_HEADER_ID"="GIR"."JE_HEADER_ID" AND "GIR"."JE_LINE_NUM"="GL_DATA"."JE_LINE_NUM")
- 519 - FILTER("BUSINESS_GROUP_ID"=0 OR "BUSINESS_GROUP_ID"=1 OR "BUSINESS_GROUP_ID"=DECODE(SYS_CONTEXT('FND_VPD_CTX','FND_ENTERPRISE_ID'),NULL,"BUSINESS_GROUP_ID"
- ,TO_NUMBER(SYS_CONTEXT('FND_VPD_CTX','FND_ENTERPRISE_ID'))))
- 520 - access("CRE"."BUSINESS_UNIT_ID"="ORGANIZATION_ID" AND "EFFECTIVE_END_DATE">=TRUNC(SYSDATE@!) AND "EFFECTIVE_START_DATE"<=TRUNC(SYSDATE@!))
- FILTER("EFFECTIVE_END_DATE">=TRUNC(SYSDATE@!))
- 521 - FILTER("EFFECTIVE_START_DATE"<=TRUNC(SYSDATE@!) AND "EFFECTIVE_END_DATE">=TRUNC(SYSDATE@!) AND (("BUSINESS_GROUP_ID"=0 OR "BUSINESS_GROUP_ID"=1) OR
- "BUSINESS_GROUP_ID"=DECODE(SYS_CONTEXT('FND_VPD_CTX','FND_ENTERPRISE_ID'),NULL,"BUSINESS_GROUP_ID",TO_NUMBER(SYS_CONTEXT('FND_VPD_CTX','FND_ENTERPRISE_ID')))))
- 522 - access("ORGANIZATION_ID"="ORGANIZATION_ID" AND "ORG_INFORMATION_CONTEXT"='FUN_BUSINESS_UNIT')
- 523 - FILTER("BUSINESS_GROUP_ID"=0 OR "BUSINESS_GROUP_ID"=1 OR "BUSINESS_GROUP_ID"=DECODE(SYS_CONTEXT('FND_VPD_CTX','FND_ENTERPRISE_ID'),NULL,"BUSINESS_GROUP_ID"
- ,TO_NUMBER(SYS_CONTEXT('FND_VPD_CTX','FND_ENTERPRISE_ID'))))
- 524 - access("ORGANIZATION_ID"="ORGANIZATION_ID" AND "CLASSIFICATION_CODE"='FUN_BUSINESS_UNIT' AND "EFFECTIVE_END_DATE">=TRUNC(SYSDATE@!) AND
- "EFFECTIVE_START_DATE"<=TRUNC(SYSDATE@!))
- FILTER("EFFECTIVE_END_DATE">=TRUNC(SYSDATE@!))
- 525 - FILTER("BUSINESS_GROUP_ID"=0 OR "BUSINESS_GROUP_ID"=1 OR "BUSINESS_GROUP_ID"=DECODE(SYS_CONTEXT('FND_VPD_CTX','FND_ENTERPRISE_ID'),NULL,"BUSINESS_GROUP_ID"
- ,TO_NUMBER(SYS_CONTEXT('FND_VPD_CTX','FND_ENTERPRISE_ID'))))
- 526 - access("ORGANIZATION_ID"="ORGANIZATION_ID" AND "LANGUAGE"=USERENV('LANG') AND "EFFECTIVE_START_DATE"="EFFECTIVE_START_DATE" AND
- "EFFECTIVE_END_DATE"="EFFECTIVE_END_DATE")
- FILTER("EFFECTIVE_START_DATE"<=TRUNC(SYSDATE@!) AND "EFFECTIVE_END_DATE">=TRUNC(SYSDATE@!))
- 538 - access("VALUE_SET_CODE"='Analysis UOB Ledger' AND "ENTERPRISE_ID"=1 AND "SANDBOX_ID"='1')
- 539 - FILTER("EFFECTIVE_END_DATE">=SYSDATE@! AND "EFFECTIVE_START_DATE"<=SYSDATE@!)
- 540 - access("TREE_STRUCTURE_CODE"='GL_ACCT_FLEX' AND "TREE_CODE"='Analysis UOB Ledger' AND "ENTERPRISE_ID"=1)
- FILTER("ENTERPRISE_ID"=1)
- 541 - FILTER("GH"."DISTANCE"=1 AND "GH"."ANCESTOR_PK1_VALUE" IS NOT NULL)
- 542 - access("GH"."TREE_STRUCTURE_CODE"='GL_ACCT_FLEX' AND "GH"."TREE_CODE"='Analysis UOB Ledger' AND "TREE_VERSION_ID"="GH"."TREE_VERSION_ID" AND
- "GH"."PK1_VALUE"=:B1)
- 544 - access("VALUE_SET_ID"="VALUE_SET_ID" AND "VALUE"="GH"."ANCESTOR_PK1_VALUE" AND "ENTERPRISE_ID"=1 AND "SANDBOX_ID"='1')
- 545 - access("VALUE_ID"="VALUE_ID" AND "LANGUAGE"=USERENV('LANG') AND "ENTERPRISE_ID"=1 AND "SANDBOX_ID"='1')
- 547 - access("CC"."CODE_COMBINATION_ID"="GL_DATA"."CODE_COMBINATION_ID")
- 556 - FILTER("GL_DATA"."REVERSED_JE_HEADER_ID" IS NOT NULL)
- Note
- -----
- - Degree OF Parallelism IS 5 because OF TABLE property
- - this IS an adaptive plan
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
