PLAN_TABLE_OUTPUT Plan hash value: 726219735 ---------------------------------------------------------------------------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes |TempSpc| Cost (%CPU)| Time | ---------------------------------------------------------------------------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 102 | 393K| | 73139 (2)| 00:00:03 | | 1 | HASH UNIQUE | | 102 | 393K| | 73139 (2)| 00:00:03 | | 2 | VIEW | | 102 | 393K| | 73138 (2)| 00:00:03 | | 3 | UNION-ALL | | | | | | | | 4 | VIEW | | 1 | 3942 | | 34799 (2)| 00:00:02 | | 5 | TEMP TABLE TRANSFORMATION | | | | | | | | 6 | LOAD AS SELECT | SYS_TEMP_0FD9D6D61_7EE0762F | | | | | | |* 7 | TABLE ACCESS FULL | MN_ERP_PAYMENT | 99956 | 20M| | 1082 (2)| 00:00:01 | | 8 | HASH GROUP BY | | 1 | 557 | | 33717 (2)| 00:00:02 | |* 9 | HASH JOIN OUTER | | 1 | 557 | | 33716 (2)| 00:00:02 | | 10 | VIEW | | 1 | 528 | | 973 (2)| 00:00:01 | | 11 | NESTED LOOPS | | 1 | 787 | | 973 (2)| 00:00:01 | | 12 | NESTED LOOPS | | 1 | 787 | | 973 (2)| 00:00:01 | | 13 | NESTED LOOPS | | 1 | 754 | | 972 (2)| 00:00:01 | | 14 | NESTED LOOPS | | 1 | 696 | | 971 (2)| 00:00:01 | |* 15 | HASH JOIN | | 1 | 675 | | 970 (2)| 00:00:01 | | 16 | NESTED LOOPS | | 1 | 651 | | 873 (2)| 00:00:01 | | 17 | NESTED LOOPS | | 12 | 651 | | 873 (2)| 00:00:01 | | 18 | NESTED LOOPS | | 1 | 627 | | 872 (2)| 00:00:01 | | 19 | NESTED LOOPS | | 1 | 612 | | 871 (2)| 00:00:01 | | 20 | NESTED LOOPS | | 1 | 596 | | 870 (2)| 00:00:01 | | 21 | NESTED LOOPS | | 1 | 586 | | 869 (2)| 00:00:01 | | 22 | NESTED LOOPS | | 1 | 561 | | 868 (2)| 00:00:01 | | 23 | NESTED LOOPS | | 2 | 1040 | | 867 (2)| 00:00:01 | |* 24 | HASH JOIN | | 4 | 1996 | | 863 (2)| 00:00:01 | |* 25 | HASH JOIN OUTER | | 1 | 475 | | 766 (2)| 00:00:01 | | 26 | NESTED LOOPS | | 1 | 269 | | 764 (2)| 00:00:01 | | 27 | NESTED LOOPS | | 3 | 269 | | 764 (2)| 00:00:01 | |* 28 | HASH JOIN | | 3 | 519 | | 761 (2)| 00:00:01 | |* 29 | TABLE ACCESS FULL | MN_DYN_ENUM_NS | 1 | 21 | | 49 (0)| 00:00:01 | |* 30 | HASH JOIN | | 1187 | 176K| | 712 (2)| 00:00:01 | |* 31 | HASH JOIN | | 990 | 116K| | 614 (2)| 00:00:01 | | 32 | NESTED LOOPS | | 13 | 585 | | 50 (0)| 00:00:01 | | 33 | NESTED LOOPS | | 13 | 585 | | 50 (0)| 00:00:01 | |* 34 | TABLE ACCESS FULL | MN_DYN_ENUM_NS | 1 | 21 | | 49 (0)| 00:00:01 | |* 35 | INDEX RANGE SCAN | MN_53101_IDX1 | 12 | | | 0 (0)| 00:00:01 | | 36 | TABLE ACCESS BY INDEX ROWID | MN_DYN_ENUM_CONST | 12 | 288 | | 1 (0)| 00:00:01 | | 37 | VIEW | | 99956 | 7320K| | 563 (2)| 00:00:01 | | 38 | TABLE ACCESS FULL | SYS_TEMP_0FD9D6D61_7EE0762F | 99956 | 20M| | 563 (2)| 00:00:01 | | 39 | TABLE ACCESS FULL | MN_DYN_ENUM_CONST | 6971 | 217K| | 97 (0)| 00:00:01 | |* 40 | INDEX UNIQUE SCAN | MN_11004_PK | 1 | | | 0 (0)| 00:00:01 | |* 41 | TABLE ACCESS BY INDEX ROWID | MN_REBATE_PAYMENT | 1 | 96 | | 1 (0)| 00:00:01 | | 42 | VIEW | | 12 | 2472 | | 2 (0)| 00:00:01 | | 43 | TABLE ACCESS BY INDEX ROWID | MN_DYN_ENUM_CONST | 12 | 288 | | 2 (0)| 00:00:01 | |* 44 | INDEX RANGE SCAN | MN_53101_IDX1 | 12 | | | 1 (0)| 00:00:01 | |* 45 | TABLE ACCESS FULL | MN_DYN_ENUM_NS | 1 | 21 | | 49 (0)| 00:00:01 | | 46 | TABLE ACCESS FULL | MN_DYN_ENUM_CONST | 6971 | 163K| | 97 (0)| 00:00:01 | |* 47 | TABLE ACCESS BY INDEX ROWID | MN_DYN_ENUM_NS | 1 | 21 | | 1 (0)| 00:00:01 | |* 48 | INDEX UNIQUE SCAN | MN_53100_PK | 1 | | | 0 (0)| 00:00:01 | |* 49 | VIEW | | 1 | 41 | | 1 (0)| 00:00:01 | | 50 | SORT UNIQUE | | | | | | | | 51 | UNION-ALL PARTITION | | | | | | | | 52 | NESTED LOOPS | | 1 | 114 | | 564 (1)| 00:00:01 | | 53 | NESTED LOOPS | | 1 | 114 | | 564 (1)| 00:00:01 | | 54 | NESTED LOOPS | | 1 | 74 | | 563 (1)| 00:00:01 | | 55 | TABLE ACCESS BY INDEX ROWID | MN_REBATE_PAYMENT | 1 | 22 | | 2 (0)| 00:00:01 | |* 56 | INDEX UNIQUE SCAN | MN_11004_PK | 1 | | | 1 (0)| 00:00:01 | |* 57 | VIEW | | 1 | 52 | | 561 (1)| 00:00:01 | |* 58 | TABLE ACCESS FULL | SYS_TEMP_0FD9D6D61_7EE0762F | 1612 | 343K| | 561 (1)| 00:00:01 | |* 59 | INDEX RANGE SCAN | REBATEPAYMENTGRP | 1 | | | 0 (0)| 00:00:01 | |* 60 | TABLE ACCESS BY INDEX ROWID | MN_BUCKET_LINE | 1 | 40 | | 1 (0)| 00:00:01 | | 61 | NESTED LOOPS | | 1 | 117 | | 564 (1)| 00:00:01 | | 62 | NESTED LOOPS | | 1 | 117 | | 564 (1)| 00:00:01 | | 63 | NESTED LOOPS | | 1 | 74 | | 563 (1)| 00:00:01 | | 64 | TABLE ACCESS BY INDEX ROWID | MN_REBATE_PAYMENT | 1 | 22 | | 2 (0)| 00:00:01 | |* 65 | INDEX UNIQUE SCAN | MN_11004_PK | 1 | | | 1 (0)| 00:00:01 | |* 66 | VIEW | | 1 | 52 | | 561 (1)| 00:00:01 | |* 67 | TABLE ACCESS FULL | SYS_TEMP_0FD9D6D61_7EE0762F | 1612 | 343K| | 561 (1)| 00:00:01 | |* 68 | INDEX RANGE SCAN | MN_11108_PMT_ID_IDX | 1 | | | 0 (0)| 00:00:01 | |* 69 | TABLE ACCESS BY INDEX ROWID | MN_MCO_BUCKET_LINE | 1 | 43 | | 1 (0)| 00:00:01 | |* 70 | INDEX RANGE SCAN | CATMAPFLDIDX6 | 1 | 25 | | 0 (0)| 00:00:01 | | 71 | TABLE ACCESS BY INDEX ROWID | MN_PAYMENT_PROG | 1 | 10 | | 1 (0)| 00:00:01 | |* 72 | INDEX UNIQUE SCAN | MN_11012_PK | 1 | | | 0 (0)| 00:00:01 | | 73 | TABLE ACCESS BY INDEX ROWID | MN_STRUCTURED_DOC | 1 | 16 | | 1 (0)| 00:00:01 | |* 74 | INDEX UNIQUE SCAN | MN_10253_PK | 1 | | | 0 (0)| 00:00:01 | |* 75 | TABLE ACCESS BY INDEX ROWID | MN_STRUCTURED_CONTRACT | 1 | 15 | | 1 (0)| 00:00:01 | |* 76 | INDEX RANGE SCAN | MN_CF_STRUCT_CTRT_BKT_IDX | 1 | | | 0 (0)| 00:00:01 | |* 77 | INDEX RANGE SCAN | MN_53101_IDX1 | 12 | | | 0 (0)| 00:00:01 | |* 78 | TABLE ACCESS FULL | MN_DYN_ENUM_NS | 1 | 21 | | 49 (0)| 00:00:01 | |* 79 | TABLE ACCESS BY INDEX ROWID | MN_DYN_ENUM_CONST | 1 | 24 | | 1 (0)| 00:00:01 | | 80 | TABLE ACCESS FULL | MN_DYN_ENUM_CONST | 6971 | 163K| | 97 (0)| 00:00:01 | |* 81 | TABLE ACCESS BY INDEX ROWID | MN_DYN_ENUM_NS | 1 | 21 | | 1 (0)| 00:00:01 | |* 82 | INDEX UNIQUE SCAN | MN_53100_PK | 1 | | | 0 (0)| 00:00:01 | | 83 | TABLE ACCESS BY INDEX ROWID | MN_PAYMENT_PKG | 1 | 58 | | 1 (0)| 00:00:01 | |* 84 | INDEX UNIQUE SCAN | MN_11034_PK | 1 | | | 0 (0)| 00:00:01 | |* 85 | INDEX UNIQUE SCAN | MN_18815_PK | 1 | | | 0 (0)| 00:00:01 | | 86 | TABLE ACCESS BY INDEX ROWID | MN_MEMBER | 1 | 33 | | 1 (0)| 00:00:01 | | 87 | VIEW | | 213K| 6053K| | 32741 (2)| 00:00:02 | | 88 | HASH GROUP BY | | 213K| 6053K| 8384K| 32741 (2)| 00:00:02 | | 89 | VIEW | | 213K| 6053K| | 31664 (2)| 00:00:02 | | 90 | UNION-ALL | | | | | | | |* 91 | HASH JOIN | | 146K| 9573K| | 21773 (1)| 00:00:01 | |* 92 | INDEX RANGE SCAN | CATMAPFLDIDX6 | 3677 | 91925 | | 14 (0)| 00:00:01 | | 93 | NESTED LOOPS | | 107K| 4394K| | 21758 (1)| 00:00:01 | | 94 | NESTED LOOPS | | 371K| 4394K| | 21758 (1)| 00:00:01 | |* 95 | TABLE ACCESS FULL | MN_REBATE_PAYMENT | 1275 | 35700 | | 9594 (2)| 00:00:01 | |* 96 | INDEX RANGE SCAN | REBATEPAYMENTGRP | 291 | | | 0 (0)| 00:00:01 | | 97 | TABLE ACCESS BY INDEX ROWID | MN_BUCKET_LINE | 84 | 1176 | | 33 (0)| 00:00:01 | |* 98 | HASH JOIN | | 67423 | 4608K| | 9891 (2)| 00:00:01 | |* 99 | INDEX RANGE SCAN | CATMAPFLDIDX6 | 3677 | 91925 | | 14 (0)| 00:00:01 | | 100 | NESTED LOOPS | | 39765 | 1747K| | 9877 (2)| 00:00:01 | | 101 | NESTED LOOPS | | 39765 | 1747K| | 9877 (2)| 00:00:01 | |*102 | TABLE ACCESS FULL | MN_REBATE_PAYMENT | 1275 | 35700 | | 9594 (2)| 00:00:01 | |*103 | INDEX RANGE SCAN | MN_11108_PMT_ID_IDX | 31 | | | 0 (0)| 00:00:01 | | 104 | TABLE ACCESS BY INDEX ROWID | MN_MCO_BUCKET_LINE | 31 | 527 | | 5 (0)| 00:00:01 | | 105 | VIEW | | 1 | 3942 | | 36907 (2)| 00:00:02 | | 106 | TEMP TABLE TRANSFORMATION | | | | | | | | 107 | LOAD AS SELECT | SYS_TEMP_0FD9D6D62_7EE0762F | | | | | | |*108 | TABLE ACCESS FULL | MN_ERP_PAYMENT | 1 | 218 | | 1072 (1)| 00:00:01 | | 109 | HASH GROUP BY | | 1 | 845 | | 35835 (2)| 00:00:02 | | 110 | NESTED LOOPS | | 1 | 845 | | 35834 (2)| 00:00:02 | | 111 | NESTED LOOPS | | 1 | 845 | | 35834 (2)| 00:00:02 | |*112 | HASH JOIN | | 1 | 824 | | 35833 (2)| 00:00:02 | | 113 | NESTED LOOPS | | 1 | 792 | | 35736 (2)| 00:00:02 | | 114 | NESTED LOOPS | | 1 | 792 | | 35736 (2)| 00:00:02 | |*115 | HASH JOIN | | 1 | 771 | | 35735 (2)| 00:00:02 | |*116 | HASH JOIN OUTER | | 1 | 747 | | 35637 (2)| 00:00:02 | | 117 | NESTED LOOPS | | 1 | 541 | | 35635 (2)| 00:00:02 | | 118 | NESTED LOOPS | | 1 | 541 | | 35635 (2)| 00:00:02 | |*119 | HASH JOIN | | 1 | 520 | | 35634 (2)| 00:00:02 | | 120 | NESTED LOOPS | | 1 | 496 | | 35537 (2)| 00:00:02 | | 121 | NESTED LOOPS | | 1 | 496 | | 35537 (2)| 00:00:02 | | 122 | NESTED LOOPS | | 1 | 463 | | 35536 (2)| 00:00:02 | | 123 | NESTED LOOPS | | 1 | 439 | | 35535 (2)| 00:00:02 | | 124 | NESTED LOOPS | | 1 | 424 | | 35534 (2)| 00:00:02 | | 125 | NESTED LOOPS | | 1 | 402 | | 31751 (2)| 00:00:02 | | 126 | NESTED LOOPS | | 1 | 377 | | 31751 (2)| 00:00:02 | | 127 | NESTED LOOPS | | 1 | 334 | | 31750 (2)| 00:00:02 | | 128 | NESTED LOOPS | | 1 | 318 | | 31749 (2)| 00:00:02 | | 129 | NESTED LOOPS | | 1 | 308 | | 31748 (2)| 00:00:02 | |*130 | HASH JOIN | | 1 | 250 | | 31747 (2)| 00:00:02 | | 131 | JOIN FILTER CREATE | :BF0000 | 1 | 221 | | 53 (0)| 00:00:01 | | 132 | NESTED LOOPS | | 1 | 221 | | 53 (0)| 00:00:01 | | 133 | NESTED LOOPS | | 1 | 221 | | 53 (0)| 00:00:01 | |*134 | HASH JOIN | | 1 | 120 | | 52 (0)| 00:00:01 | | 135 | NESTED LOOPS | | 13 | 585 | | 50 (0)| 00:00:01 | | 136 | NESTED LOOPS | | 13 | 585 | | 50 (0)| 00:00:01 | |*137 | TABLE ACCESS FULL | MN_DYN_ENUM_NS | 1 | 21 | | 49 (0)| 00:00:01 | |*138 | INDEX RANGE SCAN | MN_53101_IDX1 | 12 | | | 0 (0)| 00:00:01 | | 139 | TABLE ACCESS BY INDEX ROWID | MN_DYN_ENUM_CONST | 12 | 288 | | 1 (0)| 00:00:01 | | 140 | VIEW | | 1 | 75 | | 2 (0)| 00:00:01 | | 141 | TABLE ACCESS FULL | SYS_TEMP_0FD9D6D62_7EE0762F | 1 | 218 | | 2 (0)| 00:00:01 | |*142 | INDEX UNIQUE SCAN | MN_11004_PK | 1 | | | 0 (0)| 00:00:01 | |*143 | TABLE ACCESS BY INDEX ROWID | MN_REBATE_PAYMENT | 1 | 101 | | 1 (0)| 00:00:01 | | 144 | VIEW | | 2609 | 75661 | | 31693 (2)| 00:00:02 | | 145 | HASH GROUP BY | | 2609 | 75661 | | 31693 (2)| 00:00:02 | | 146 | VIEW | | 2609 | 75661 | | 31692 (2)| 00:00:02 | | 147 | JOIN FILTER USE | :BF0000 | | | | | | | 148 | UNION-ALL | | | | | | | |*149 | HASH JOIN | | 366 | 28548 | | 21801 (2)| 00:00:01 | | 150 | NESTED LOOPS | | 268 | 14204 | | 21787 (2)| 00:00:01 | | 151 | NESTED LOOPS | | 371K| 14204 | | 21787 (2)| 00:00:01 | |*152 | TABLE ACCESS FULL | MN_REBATE_PAYMENT | 1275 | 35700 | | 9594 (2)| 00:00:01 | |*153 | INDEX RANGE SCAN | REBATEPAYMENTGRP | 291 | | | 0 (0)| 00:00:01 | |*154 | ID TABLE ACCESS BY INDEX ROW | MN_BUCKET_LINE | 1 | 25 | | 33 (0)| 00:00:01 | |*155 | INDEX RANGE SCAN | CATMAPFLDIDX6 | 3677 | 91925 | | 14 (0)| 00:00:01 | |*156 | HASH JOIN | | 2243 | 177K| | 9891 (2)| 00:00:01 | | 157 | NESTED LOOPS | | 1323 | 74088 | | 9877 (2)| 00:00:01 | | 158 | NESTED LOOPS | | 39525 | 74088 | | 9877 (2)| 00:00:01 | |*159 | TABLE ACCESS FULL | MN_REBATE_PAYMENT | 1275 | 35700 | | 9594 (2)| 00:00:01 | |*160 | INDEX RANGE SCAN | MN_11108_PMT_ID_IDX | 31 | | | 0 (0)| 00:00:01 | |*161 | ID TABLE ACCESS BY INDEX ROW | MN_MCO_BUCKET_LINE | 1 | 28 | | 5 (0)| 00:00:01 | |*162 | INDEX RANGE SCAN | CATMAPFLDIDX6 | 3677 | 91925 | | 14 (0)| 00:00:01 | | 163 | TABLE ACCESS BY INDEX ROWID | MN_PAYMENT_PKG | 1 | 58 | | 1 (0)| 00:00:01 | |*164 | INDEX UNIQUE SCAN | MN_11034_PK | 1 | | | 0 (0)| 00:00:01 | | 165 | TABLE ACCESS BY INDEX ROWID | MN_PAYMENT_PROG | 1 | 10 | | 1 (0)| 00:00:01 | |*166 | INDEX UNIQUE SCAN | MN_11012_PK | 1 | | | 0 (0)| 00:00:01 | | 167 | TABLE ACCESS BY INDEX ROWID | MN_STRUCTURED_DOC | 1 | 16 | | 1 (0)| 00:00:01 | |*168 | INDEX UNIQUE SCAN | MN_10253_PK | 1 | | | 0 (0)| 00:00:01 | |*169 | VIEW | | 1 | 43 | | 1 (0)| 00:00:01 | | 170 | UNION-ALL PARTITION | | | | | | | | 171 | NESTED LOOPS | | 1 | 95 | | 4 (0)| 00:00:01 | | 172 | NESTED LOOPS | | 1 | 95 | | 4 (0)| 00:00:01 | | 173 | NESTED LOOPS | | 1 | 58 | | 3 (0)| 00:00:01 | |*174 | INDEX UNIQUE SCAN | MN_11004_PK | 1 | 6 | | 1 (0)| 00:00:01 | |*175 | VIEW | | 1 | 52 | | 2 (0)| 00:00:01 | |*176 | TABLE ACCESS FULL | SYS_TEMP_0FD9D6D62_7EE0762F | 1 | 218 | | 2 (0)| 00:00:01 | |*177 | INDEX RANGE SCAN | REBATEPAYMENTGRP | 1 | | | 0 (0)| 00:00:01 | |*178 | TABLE ACCESS BY INDEX ROWID | MN_BUCKET_LINE | 1 | 37 | | 1 (0)| 00:00:01 | | 179 | NESTED LOOPS | | 1 | 95 | | 4 (0)| 00:00:01 | | 180 | NESTED LOOPS | | 1 | 95 | | 4 (0)| 00:00:01 | | 181 | NESTED LOOPS | | 1 | 58 | | 3 (0)| 00:00:01 | |*182 | INDEX UNIQUE SCAN | MN_11004_PK | 1 | 6 | | 1 (0)| 00:00:01 | |*183 | VIEW | | 1 | 52 | | 2 (0)| 00:00:01 | |*184 | TABLE ACCESS FULL | SYS_TEMP_0FD9D6D62_7EE0762F | 1 | 218 | | 2 (0)| 00:00:01 | |*185 | INDEX RANGE SCAN | MN_11108_PMT_ID_IDX | 1 | | | 0 (0)| 00:00:01 | |*186 | TABLE ACCESS BY INDEX ROWID | MN_MCO_BUCKET_LINE | 1 | 37 | | 1 (0)| 00:00:01 | |*187 | INDEX RANGE SCAN | CATMAPFLDIDX6 | 1 | 25 | | 0 (0)| 00:00:01 | |*188 | TABLE ACCESS BY INDEX ROWID | MN_RBTPMT_SALE_CLOSED | 1 | 22 | | 3783 (1)| 00:00:01 | |*189 | INDEX RANGE SCAN | MN_10726_IDX12 | 11982 | | | 0 (0)| 00:00:01 | |*190 | TABLE ACCESS BY INDEX ROWID | MN_STRUCTURED_CONTRACT | 1 | 15 | | 1 (0)| 00:00:01 | |*191 | INDEX RANGE SCAN | MN_CF_STRUCT_CTRT_BKT_IDX | 1 | | | 0 (0)| 00:00:01 | |*192 | TABLE ACCESS BY INDEX ROWID | MN_DYN_ENUM_CONST | 1 | 24 | | 1 (0)| 00:00:01 | |*193 | INDEX RANGE SCAN | MN_53101_IDX1 | 12 | | | 0 (0)| 00:00:01 | |*194 | TABLE ACCESS FULL | MN_DYN_ENUM_NS | 1 | 21 | | 49 (0)| 00:00:01 | |*195 | INDEX UNIQUE SCAN | MN_18815_PK | 1 | | | 0 (0)| 00:00:01 | | 196 | TABLE ACCESS BY INDEX ROWID | MN_MEMBER | 1 | 33 | | 1 (0)| 00:00:01 | | 197 | TABLE ACCESS FULL | MN_DYN_ENUM_CONST | 6971 | 163K| | 97 (0)| 00:00:01 | |*198 | INDEX UNIQUE SCAN | MN_53100_PK | 1 | | | 0 (0)| 00:00:01 | |*199 | TABLE ACCESS BY INDEX ROWID | MN_DYN_ENUM_NS | 1 | 21 | | 1 (0)| 00:00:01 | | 200 | VIEW | | 12 | 2472 | | 2 (0)| 00:00:01 | | 201 | TABLE ACCESS BY INDEX ROWID | MN_DYN_ENUM_CONST | 12 | 288 | | 2 (0)| 00:00:01 | |*202 | INDEX RANGE SCAN | MN_53101_IDX1 | 12 | | | 1 (0)| 00:00:01 | |*203 | TABLE ACCESS FULL | MN_DYN_ENUM_NS | 1 | 21 | | 49 (0)| 00:00:01 | | 204 | TABLE ACCESS FULL | MN_DYN_ENUM_CONST | 6971 | 163K| | 97 (0)| 00:00:01 | |*205 | INDEX UNIQUE SCAN | MN_53100_PK | 1 | | | 0 (0)| 00:00:01 | |*206 | TABLE ACCESS BY INDEX ROWID | MN_DYN_ENUM_NS | 1 | 21 | | 1 (0)| 00:00:01 | | 207 | TABLE ACCESS FULL | MN_DYN_ENUM_CONST | 6971 | 217K| | 97 (0)| 00:00:01 | |*208 | INDEX UNIQUE SCAN | MN_53100_PK | 1 | | | 0 (0)| 00:00:01 | |*209 | TABLE ACCESS BY INDEX ROWID | MN_DYN_ENUM_NS | 1 | 21 | | 1 (0)| 00:00:01 | | 210 | VIEW | | 100 | 384K| | 1432 (1)| 00:00:01 | | 211 | TEMP TABLE TRANSFORMATION | | | | | | | | 212 | LOAD AS SELECT | SYS_TEMP_0FD9D6D63_7EE0762F | | | | | | |*213 | TABLE ACCESS FULL | MN_ERP_PAYMENT | 1 | 218 | | 1072 (1)| 00:00:01 | | 214 | HASH GROUP BY | | | 769 | | 360 (1)| 00:00:01 | | 215 | NESTED LOOPS | | 1 | 769 | | 359 (1)| 00:00:01 | | 216 | NESTED LOOPS | | 1 | 769 | | 359 (1)| 00:00:01 | | 217 | NESTED LOOPS | | 1 | 736 | | 358 (1)| 00:00:01 | | 218 | NESTED LOOPS | | 1 | 678 | | 357 (1)| 00:00:01 | |*219 | HASH JOIN | | 1 | 657 | | 356 (1)| 00:00:01 | | 220 | NESTED LOOPS | | 1 | 633 | | 258 (1)| 00:00:01 | | 221 | NESTED LOOPS | | 12 | 633 | | 258 (1)| 00:00:01 | | 222 | NESTED LOOPS | | 1 | 609 | | 257 (1)| 00:00:01 | | 223 | NESTED LOOPS | | 1 | 594 | | 256 (1)| 00:00:01 | | 224 | NESTED LOOPS | | 1 | 578 | | 255 (1)| 00:00:01 | | 225 | NESTED LOOPS | | 1 | 568 | | 254 (1)| 00:00:01 | |*226 | HASH JOIN | | 1 | 547 | | 253 (1)| 00:00:01 | | 227 | NESTED LOOPS | | 1 | 523 | | 156 (1)| 00:00:01 | | 228 | NESTED LOOPS | | 1 | 523 | | 156 (1)| 00:00:01 | |*229 | HASH JOIN | | 1 | 502 | | 155 (1)| 00:00:01 | | 230 | NESTED LOOPS | | 1 | 478 | | 57 (0)| 00:00:01 | |*231 | HASH JOIN OUTER | | 1 | 453 | | 57 (0)| 00:00:01 | | 232 | NESTED LOOPS | | 1 | 247 | | 55 (0)| 00:00:01 | | 233 | NESTED LOOPS | | 1 | 247 | | 55 (0)| 00:00:01 | |*234 | HASH JOIN | | 1 | 169 | | 54 (0)| 00:00:01 | |*235 | HASH JOIN | | 1 | 128 | | 52 (0)| 00:00:01 | | 236 | NESTED LOOPS | | 13 | 689 | | 50 (0)| 00:00:01 | | 237 | NESTED LOOPS | | 13 | 689 | | 50 (0)| 00:00:01 | |*238 | TABLE ACCESS FULL | MN_DYN_ENUM_NS | 1 | 21 | | 49 (0)| 00:00:01 | |*239 | INDEX RANGE SCAN | MN_53101_IDX1 | 12 | | | 0 (0)| 00:00:01 | | 240 | TABLE ACCESS BY INDEX ROWID | MN_DYN_ENUM_CONST | 12 | 384 | | 1 (0)| 00:00:01 | | 241 | VIEW | | 1 | 75 | | 2 (0)| 00:00:01 | | 242 | TABLE ACCESS FULL | SYS_TEMP_0FD9D6D63_7EE0762F | 1 | 218 | | 2 (0)| 00:00:01 | | 243 | VIEW | | 2 | 82 | | 2 (0)| 00:00:01 | | 244 | UNION-ALL | | | | | | | | 245 | NESTED LOOPS | | 1 | 92 | | 35 (0)| 00:00:01 | | 246 | NESTED LOOPS | | 291 | 92 | | 35 (0)| 00:00:01 | | 247 | NESTED LOOPS | | 1 | 58 | | 2 (0)| 00:00:01 | |*248 | VIEW | | 1 | 52 | | 2 (0)| 00:00:01 | | 249 | TABLE ACCESS FULL | SYS_TEMP_0FD9D6D63_7EE0762F | 1 | 218 | | 2 (0)| 00:00:01 | |*250 | INDEX UNIQUE SCAN | MN_11004_PK | 1 | 6 | | 0 (0)| 00:00:01 | |*251 | INDEX RANGE SCAN | REBATEPAYMENTGRP | 291 | | | 0 (0)| 00:00:01 | |*252 | TABLE ACCESS BY INDEX ROWID | MN_BUCKET_LINE | 1 | 34 | | 33 (0)| 00:00:01 | | 253 | NESTED LOOPS | | 1 | 96 | | 7 (0)| 00:00:01 | | 254 | NESTED LOOPS | | 31 | 96 | | 7 (0)| 00:00:01 | | 255 | NESTED LOOPS | | 1 | 58 | | 2 (0)| 00:00:01 | |*256 | VIEW | | 1 | 52 | | 2 (0)| 00:00:01 | | 257 | TABLE ACCESS FULL | SYS_TEMP_0FD9D6D63_7EE0762F | 1 | 218 | | 2 (0)| 00:00:01 | |*258 | INDEX UNIQUE SCAN | MN_11004_PK | 1 | 6 | | 0 (0)| 00:00:01 | |*259 | INDEX RANGE SCAN | MN_11108_PMT_ID_IDX | 31 | | | 0 (0)| 00:00:01 | |*260 | TABLE ACCESS BY INDEX ROWID | MN_MCO_BUCKET_LINE | 1 | 38 | | 5 (0)| 00:00:01 | |*261 | INDEX UNIQUE SCAN | MN_11004_PK | 1 | | | 0 (0)| 00:00:01 | |*262 | TABLE ACCESS BY INDEX ROWID | MN_REBATE_PAYMENT | 1 | 78 | | 1 (0)| 00:00:01 | | 263 | VIEW | | 12 | 2472 | | 2 (0)| 00:00:01 | | 264 | TABLE ACCESS BY INDEX ROWID | MN_DYN_ENUM_CONST | 12 | 288 | | 2 (0)| 00:00:01 | |*265 | INDEX RANGE SCAN | MN_53101_IDX1 | 12 | | | 1 (0)| 00:00:01 | |*266 | TABLE ACCESS FULL | MN_DYN_ENUM_NS | 1 | 21 | | 49 (0)| 00:00:01 | |*267 | INDEX RANGE SCAN | CATMAPFLDIDX6 | 1 | 25 | | 0 (0)| 00:00:01 | | 268 | TABLE ACCESS FULL | MN_DYN_ENUM_CONST | 6971 | 163K| | 97 (0)| 00:00:01 | |*269 | INDEX UNIQUE SCAN | MN_53100_PK | 1 | | | 0 (0)| 00:00:01 | |*270 | TABLE ACCESS BY INDEX ROWID | MN_DYN_ENUM_NS | 1 | 21 | | 1 (0)| 00:00:01 | | 271 | TABLE ACCESS FULL | MN_DYN_ENUM_CONST | 6971 | 163K| | 97 (0)| 00:00:01 | |*272 | TABLE ACCESS BY INDEX ROWID | MN_DYN_ENUM_NS | 1 | 21 | | 1 (0)| 00:00:01 | |*273 | INDEX UNIQUE SCAN | MN_53100_PK | 1 | | | 0 (0)| 00:00:01 | | 274 | TABLE ACCESS BY INDEX ROWID | MN_PAYMENT_PROG | 1 | 10 | | 1 (0)| 00:00:01 | |*275 | INDEX UNIQUE SCAN | MN_11012_PK | 1 | | | 0 (0)| 00:00:01 | | 276 | TABLE ACCESS BY INDEX ROWID | MN_STRUCTURED_DOC | 1 | 16 | | 1 (0)| 00:00:01 | |*277 | INDEX UNIQUE SCAN | MN_10253_PK | 1 | | | 0 (0)| 00:00:01 | |*278 | TABLE ACCESS BY INDEX ROWID | MN_STRUCTURED_CONTRACT | 1 | 15 | | 1 (0)| 00:00:01 | |*279 | INDEX RANGE SCAN | MN_CF_STRUCT_CTRT_BKT_IDX | 1 | | | 0 (0)| 00:00:01 | |*280 | INDEX RANGE SCAN | MN_53101_IDX1 | 12 | | | 0 (0)| 00:00:01 | |*281 | TABLE ACCESS FULL | MN_DYN_ENUM_NS | 1 | 21 | | 49 (0)| 00:00:01 | |*282 | TABLE ACCESS BY INDEX ROWID | MN_DYN_ENUM_CONST | 1 | 24 | | 1 (0)| 00:00:01 | | 283 | TABLE ACCESS FULL | MN_DYN_ENUM_CONST | 6971 | 163K| | 97 (0)| 00:00:01 | |*284 | TABLE ACCESS BY INDEX ROWID | MN_DYN_ENUM_NS | 1 | 21 | | 1 (0)| 00:00:01 | |*285 | INDEX UNIQUE SCAN | MN_53100_PK | 1 | | | 0 (0)| 00:00:01 | | 286 | TABLE ACCESS BY INDEX ROWID | MN_PAYMENT_PKG | 1 | 58 | | 1 (0)| 00:00:01 | |*287 | INDEX UNIQUE SCAN | MN_11034_PK | 1 | | | 0 (0)| 00:00:01 | |*288 | INDEX UNIQUE SCAN | MN_18815_PK | 1 | | | 0 (0)| 00:00:01 | | 289 | TABLE ACCESS BY INDEX ROWID | MN_MEMBER | 1 | 33 | | 1 (0)| 00:00:01 | ---------------------------------------------------------------------------------------------------------------------------------------------------- Predicate Information (identified by operation id): --------------------------------------------------- 7 - filter("ERP"."ORG_UNIT_ID"=10223 AND TRUNC(INTERNAL_FUNCTION("ERP"."ERP_PMT_DATE"))>=TO_DATE(' 2013-08-01 00:00:00', 'syyyy-mm-dd hh24:mi:ss') AND TRUNC(INTERNAL_FUNCTION("ERP"."ERP_PMT_DATE"))<=TO_DATE(' 2017-10-15 00:00:00', 'syyyy-mm-dd hh24:mi:ss') AND "ERP"."ERP_PMT_TYPE"=10) 9 - access("MAP_FIELD"."FLD_VALUE"="REV_PMT"."PRODUCT"(+) AND "REV_PMT"."REBATE_PMT_ID"(+)="REB"."REV_REBATE_PMT_FK") 15 - access("CODE"="CONT"."STRUCT_DOC_TYPE") 24 - access("REB"."PROGRAM_TYPE"="CODE") 25 - access("REB"."REBATE_SUB_TYPE"=TO_NUMBER("RBT_SUB_TYPE"."CODE"(+))) 28 - access("NS_ID"="DYN_ENUM_NS_ID") 29 - filter("NS_NAME"='PaymentMethod') 30 - access("ERP"."ERP_PMT_METHOD"="CONST_NAME") 31 - access("CODE"="ERP"."ERP_PMT_TYPE") 34 - filter("NS_NAME"='ERPPaymentType') 35 - access("NS_ID"="DYN_ENUM_NS_ID") 40 - access("REB"."REBATE_PMT_ID"="ERP"."REBATE_PMT_ID") 41 - filter("REB"."PYMT_PKG_FK" IS NOT NULL AND TO_DATE("MN_GLOBAL_PKG"."FORMAT_TIMESTAMP_WITHTZ"("REB"."START_DATE",'PST','yyyy-MM-dd'),' YYYY-MM-DD')>=TO_DATE(' 2016-01-01 00:00:00', 'syyyy-mm-dd hh24:mi:ss') AND TO_DATE("MN_GLOBAL_PKG"."FORMAT_TIMESTAMP_WITHTZ"("REB"."END_DATE",'PST','yyyy-MM-dd'),'YYYY-MM-DD')<=TO_DATE(' 2017-09-30 00:00:00', 'syyyy-mm-dd hh24:mi:ss')) 44 - access("NS_ID"= (SELECT "DYN_ENUM_NS_ID" FROM "REVM_TRAN"."MN_DYN_ENUM_NS" "MN_DYN_ENUM_NS" WHERE "NS_NAME"='RebateSubType')) 45 - filter("NS_NAME"='RebateSubType') 47 - filter("NS_NAME"='ProgramType') 48 - access("NS_ID"="DYN_ENUM_NS_ID") 49 - filter("ERP"."ERP_PMT_TYPE"="ERP_PMT_TYPE" AND "ERP"."ERP_PMT_DATE"="ERP_PMT_DATE") 56 - access("REB"."REBATE_PMT_ID"="REB"."REBATE_PMT_ID") 57 - filter("REB"."REBATE_PMT_ID"="ERP"."REBATE_PMT_ID" AND "ERP"."REBATE_PMT_ID"="REB"."REBATE_PMT_ID") 58 - filter("C16"=10223) 59 - access("REB"."REBATE_PMT_ID"="BKT_LINE"."REBATE_PMT_ID") filter("BKT_LINE"."REBATE_PMT_ID"="REB"."REBATE_PMT_ID") 60 - filter("BKT_LINE"."PMT_BENEFIT_ID" IS NOT NULL AND TO_DATE("MN_GLOBAL_PKG"."FORMAT_TIMESTAMP_WITHTZ"("BKT_LINE"."SALE_INV_DATE_SQL",' PST','yyyy-MM-dd'),'YYYY-MM-DD')>=TO_DATE(' 2016-01-01 00:00:00', 'syyyy-mm-dd hh24:mi:ss') AND TO_DATE("MN_GLOBAL_PKG"."FORMAT_TIMESTAMP_WITHTZ"("BKT_LINE"."SALE_INV_DATE_SQL",'PST','yyyy-MM-dd'),'YYYY-MM-DD')<=TO_DATE(' 2017-09-30 00:00:00', 'syyyy-mm-dd hh24:mi:ss') AND "BKT_LINE"."INCLUSION_TYPE"='INC') 65 - access("REB"."REBATE_PMT_ID"="REB"."REBATE_PMT_ID") 66 - filter("REB"."REBATE_PMT_ID"="ERP"."REBATE_PMT_ID" AND "ERP"."REBATE_PMT_ID"="REB"."REBATE_PMT_ID") 67 - filter("C16"=10223) 68 - access("REB"."REBATE_PMT_ID"="BKT_LINE"."REBATE_PMT_ID") filter("BKT_LINE"."REBATE_PMT_ID"="REB"."REBATE_PMT_ID") 69 - filter(TO_DATE("MN_GLOBAL_PKG"."FORMAT_TIMESTAMP_WITHTZ"("BKT_LINE"."SALE_INV_DATE_SQL",'PST','yyyy-MM-dd'),'YYYY-MM-DD')>=TO_DATE(' 2016-01-01 00:00:00', 'syyyy-mm-dd hh24:mi:ss') AND TO_DATE("MN_GLOBAL_PKG"."FORMAT_TIMESTAMP_WITHTZ"("BKT_LINE"."SALE_INV_DATE_SQL",'PST',' yyyy-MM-dd'),'YYYY-MM-DD')<=TO_DATE(' 2017-09-30 00:00:00', 'syyyy-mm-dd hh24:mi:ss') AND "BKT_LINE"."INCLUSION_TYPE"='INC' AND "BKT_LINE"."PMT_BENEFIT_ID" IS NOT NULL) 70 - access("FLD_NAME"='tradeName' AND "MAP_FIELD"."CAT_MAP_ID"="SALE_ITEM_ID") filter("MAP_FIELD"."CAT_MAP_ID"="SALE_ITEM_ID") 72 - access("REB"."CURR_PAY_PROG_ID"="PROG"."PAY_PROG_ID") 74 - access("PROG"."STRUCT_CONTRACT_ID"="DOC"."STRUCT_DOC_ID") 75 - filter("CONT"."CTRT_SUB_TYPE" IS NOT NULL) 76 - access("DOC"."STRUCT_DOC_ID"="CONT"."STRUCT_DOC_ID") 77 - access("NS_ID"= (SELECT "DYN_ENUM_NS_ID" FROM "REVM_TRAN"."MN_DYN_ENUM_NS" "MN_DYN_ENUM_NS" WHERE "NS_NAME"='ContractSubType')) 78 - filter("NS_NAME"='ContractSubType') 79 - filter("CONT"."CTRT_SUB_TYPE"="CODE") 81 - filter("NS_NAME"='ContractType') 82 - access("NS_ID"="DYN_ENUM_NS_ID") 84 - access("REB"."PYMT_PKG_FK"="PYMT_PKG"."PYMT_PKG_ID") 85 - access("ERP"."PAYEE_ID"="MEM"."MEMBER_ID") 91 - access("MAP_FIELD1"."CAT_MAP_ID"="BKT_LINE1"."SALE_ITEM_ID") 92 - access("FLD_NAME"='tradeName') 95 - filter(TO_DATE("MN_GLOBAL_PKG"."FORMAT_TIMESTAMP_WITHTZ"("RBT_PAY1"."START_DATE",'PST','yyyy-MM-dd'),'YYYY-MM-DD')>=TO_DATE(' 2016-01-01 00:00:00', 'syyyy-mm-dd hh24:mi:ss') AND TO_DATE("MN_GLOBAL_PKG"."FORMAT_TIMESTAMP_WITHTZ"("RBT_PAY1"."END_DATE",'PST','yyyy-MM-d d'),'YYYY-MM-DD')<=TO_DATE(' 2017-09-30 00:00:00', 'syyyy-mm-dd hh24:mi:ss')) 96 - access("RBT_PAY1"."REBATE_PMT_ID"="BKT_LINE1"."REBATE_PMT_ID") 98 - access("MAP_FIELD1"."CAT_MAP_ID"="BKT_LINE1"."SALE_ITEM_ID") 99 - access("FLD_NAME"='tradeName') 102 - filter(TO_DATE("MN_GLOBAL_PKG"."FORMAT_TIMESTAMP_WITHTZ"("RBT_PAY1"."START_DATE",'PST','yyyy-MM-dd'),'YYYY-MM-DD')>=TO_DATE(' 2016-01-01 00:00:00', 'syyyy-mm-dd hh24:mi:ss') AND TO_DATE("MN_GLOBAL_PKG"."FORMAT_TIMESTAMP_WITHTZ"("RBT_PAY1"."END_DATE",'PST','yyyy-MM-d d'),'YYYY-MM-DD')<=TO_DATE(' 2017-09-30 00:00:00', 'syyyy-mm-dd hh24:mi:ss')) 103 - access("RBT_PAY1"."REBATE_PMT_ID"="BKT_LINE1"."REBATE_PMT_ID") 108 - filter(("ERP"."ERP_PMT_TYPE"=20 OR "ERP"."ERP_PMT_TYPE"=30) AND "ERP"."ORG_UNIT_ID"=10223 AND TRUNC(INTERNAL_FUNCTION("ERP"."ERP_PMT_DATE"))>=TO_DATE(' 2017-07-01 00:00:00', 'syyyy-mm-dd hh24:mi:ss') AND TRUNC(INTERNAL_FUNCTION("ERP"."ERP_PMT_DATE"))<=TO_DATE(' 2017-10-15 00:00:00', 'syyyy-mm-dd hh24:mi:ss')) 112 - access("ERP"."ERP_PMT_METHOD"="CONST_NAME") 115 - access("REB"."PROGRAM_TYPE"="CODE") 116 - access("REB"."REBATE_SUB_TYPE"=TO_NUMBER("RBT_SUB_TYPE"."CODE"(+))) 119 - access("CODE"="CONT"."STRUCT_DOC_TYPE") 130 - access("REV_PMT"."REBATE_PMT_ID"="REB"."REV_REBATE_PMT_FK") 134 - access("CODE"="ERP"."ERP_PMT_TYPE") 137 - filter("NS_NAME"='ERPPaymentType') 138 - access("NS_ID"="DYN_ENUM_NS_ID") 142 - access("REB"."REBATE_PMT_ID"="ERP"."REBATE_PMT_ID") 143 - filter("REB"."REV_REBATE_PMT_FK" IS NOT NULL AND "REB"."PYMT_PKG_FK" IS NOT NULL AND TO_DATE("MN_GLOBAL_PKG"."FORMAT_TIMESTAMP_WITHTZ"("REB"."START_DATE",'PST','yyyy-MM-dd'),'YYYY-MM-DD')>=TO_DATE(' 2016-01-01 00:00:00', 'syyyy-mm-dd hh24:mi:ss') AND TO_DATE("MN_GLOBAL_PKG"."FORMAT_TIMESTAMP_WITHTZ"("REB"."END_DATE",'PST','yyyy-MM-dd'),'YYYY-MM-DD')<=TO_DATE( ' 2017-09-30 00:00:00', 'syyyy-mm-dd hh24:mi:ss')) 149 - access("MAP_FIELD1"."CAT_MAP_ID"="BKT_LINE1"."SALE_ITEM_ID") 152 - filter(TO_DATE("MN_GLOBAL_PKG"."FORMAT_TIMESTAMP_WITHTZ"("RBT_PAY1"."START_DATE",'PST','yyyy-MM-dd'),'YYYY-MM-DD')>=TO_DATE(' 2016-01-01 00:00:00', 'syyyy-mm-dd hh24:mi:ss') AND TO_DATE("MN_GLOBAL_PKG"."FORMAT_TIMESTAMP_WITHTZ"("RBT_PAY1"."END_DATE",'PST','yyyy-MM-d d'),'YYYY-MM-DD')<=TO_DATE(' 2017-09-30 00:00:00', 'syyyy-mm-dd hh24:mi:ss')) 153 - access("RBT_PAY1"."REBATE_PMT_ID"="BKT_LINE1"."REBATE_PMT_ID") 154 - filter(TO_DATE("MN_GLOBAL_PKG"."FORMAT_TIMESTAMP_WITHTZ"("BKT_LINE1"."SALE_INV_DATE_SQL",'PST','yyyy-MM-dd'),'YYYY-MM-DD')>=TO_DATE(' 2016-01-01 00:00:00', 'syyyy-mm-dd hh24:mi:ss') AND TO_DATE("MN_GLOBAL_PKG"."FORMAT_TIMESTAMP_WITHTZ"("BKT_LINE1"."SALE_INV_DATE_SQL",'PST' ,'yyyy-MM-dd'),'YYYY-MM-DD')<=TO_DATE(' 2017-09-30 00:00:00', 'syyyy-mm-dd hh24:mi:ss')) 155 - access("FLD_NAME"='tradeName') 156 - access("MAP_FIELD1"."CAT_MAP_ID"="BKT_LINE1"."SALE_ITEM_ID") 159 - filter(TO_DATE("MN_GLOBAL_PKG"."FORMAT_TIMESTAMP_WITHTZ"("RBT_PAY1"."START_DATE",'PST','yyyy-MM-dd'),'YYYY-MM-DD')>=TO_DATE(' 2016-01-01 00:00:00', 'syyyy-mm-dd hh24:mi:ss') AND TO_DATE("MN_GLOBAL_PKG"."FORMAT_TIMESTAMP_WITHTZ"("RBT_PAY1"."END_DATE",'PST','yyyy-MM-d d'),'YYYY-MM-DD')<=TO_DATE(' 2017-09-30 00:00:00', 'syyyy-mm-dd hh24:mi:ss')) 160 - access("RBT_PAY1"."REBATE_PMT_ID"="BKT_LINE1"."REBATE_PMT_ID") 161 - filter(TO_DATE("MN_GLOBAL_PKG"."FORMAT_TIMESTAMP_WITHTZ"("BKT_LINE1"."SALE_INV_DATE_SQL",'PST','yyyy-MM-dd'),'YYYY-MM-DD')>=TO_DATE(' 2016-01-01 00:00:00', 'syyyy-mm-dd hh24:mi:ss') AND TO_DATE("MN_GLOBAL_PKG"."FORMAT_TIMESTAMP_WITHTZ"("BKT_LINE1"."SALE_INV_DATE_SQL",'PST' ,'yyyy-MM-dd'),'YYYY-MM-DD')<=TO_DATE(' 2017-09-30 00:00:00', 'syyyy-mm-dd hh24:mi:ss')) 162 - access("FLD_NAME"='tradeName') 164 - access("REB"."PYMT_PKG_FK"="PYMT_PKG"."PYMT_PKG_ID") 166 - access("REB"."CURR_PAY_PROG_ID"="PROG"."PAY_PROG_ID") 168 - access("PROG"."STRUCT_CONTRACT_ID"="DOC"."STRUCT_DOC_ID") 169 - filter("ERP"."ERP_PMT_TYPE"="ERP_PMT_TYPE" AND "ERP"."ERP_PMT_DATE"="ERP_PMT_DATE") 174 - access("REB"."REBATE_PMT_ID"="REB"."REBATE_PMT_ID") 175 - filter("REB"."REBATE_PMT_ID"="ERP"."REBATE_PMT_ID" AND "ERP"."REBATE_PMT_ID"="REB"."REBATE_PMT_ID") 176 - filter("C16"=10223) 177 - access("REB"."REBATE_PMT_ID"="BKT_LINE"."REBATE_PMT_ID") filter("BKT_LINE"."REBATE_PMT_ID"="REB"."REBATE_PMT_ID") 178 - filter("BKT_LINE"."PMT_BENEFIT_ID" IS NOT NULL AND TO_DATE("MN_GLOBAL_PKG"."FORMAT_TIMESTAMP_WITHTZ"("BKT_LINE"."SALE_INV_DATE_SQL",' PST','yyyy-MM-dd'),'YYYY-MM-DD')>=TO_DATE(' 2016-01-01 00:00:00', 'syyyy-mm-dd hh24:mi:ss') AND TO_DATE("MN_GLOBAL_PKG"."FORMAT_TIMESTAMP_WITHTZ"("BKT_LINE"."SALE_INV_DATE_SQL",'PST','yyyy-MM-dd'),'YYYY-MM-DD')<=TO_DATE(' 2017-09-30 00:00:00', 'syyyy-mm-dd hh24:mi:ss') AND "BKT_LINE"."INCLUSION_TYPE"='INC') 182 - access("REB"."REBATE_PMT_ID"="REB"."REBATE_PMT_ID") 183 - filter("REB"."REBATE_PMT_ID"="ERP"."REBATE_PMT_ID" AND "ERP"."REBATE_PMT_ID"="REB"."REBATE_PMT_ID") 184 - filter("C16"=10223) 185 - access("REB"."REBATE_PMT_ID"="BKT_LINE"."REBATE_PMT_ID") filter("BKT_LINE"."REBATE_PMT_ID"="REB"."REBATE_PMT_ID") 186 - filter(TO_DATE("MN_GLOBAL_PKG"."FORMAT_TIMESTAMP_WITHTZ"("BKT_LINE"."SALE_INV_DATE_SQL",'PST','yyyy-MM-dd'),'YYYY-MM-DD')>=TO_DATE(' 2016-01-01 00:00:00', 'syyyy-mm-dd hh24:mi:ss') AND TO_DATE("MN_GLOBAL_PKG"."FORMAT_TIMESTAMP_WITHTZ"("BKT_LINE"."SALE_INV_DATE_SQL",'PST',' yyyy-MM-dd'),'YYYY-MM-DD')<=TO_DATE(' 2017-09-30 00:00:00', 'syyyy-mm-dd hh24:mi:ss') AND "BKT_LINE"."INCLUSION_TYPE"='INC' AND "BKT_LINE"."PMT_BENEFIT_ID" IS NOT NULL) 187 - access("FLD_NAME"='tradeName' AND "MAP_FIELD"."FLD_VALUE"="REV_PMT"."PRODUCT" AND "MAP_FIELD"."CAT_MAP_ID"="SALE_ITEM_ID") 188 - filter("RBTPMT"."REBATE_BUCKET_LINE_ID"="BUCKET_LINE_ID" AND (CASE WHEN ("REB"."PMT_STATUS"='REV' AND "ERP"."ERP_PMT_TYPE"=30) THEN "RBTPMT"."REBATE_REVERSAL_STATUS" ELSE 'NONE' END ='NONE' OR CASE WHEN ("REB"."PMT_STATUS"='REV' AND "ERP"."ERP_PMT_TYPE"=30) THEN "RBTPMT"."REBATE_REVERSAL_STATUS" ELSE 'NONE' END ='REPLCMNT') AND CASE "ERP"."ERP_PMT_TYPE" WHEN 20 THEN "RBTPMT"."REBATE_REVERSAL_STATUS" ELSE 'REVERSAL' END ='REVERSAL') 189 - access("RBTPMT"."ITEM_ID"="SALE_ITEM_ID") 190 - filter("CONT"."CTRT_SUB_TYPE" IS NOT NULL) 191 - access("DOC"."STRUCT_DOC_ID"="CONT"."STRUCT_DOC_ID") 192 - filter("CONT"."CTRT_SUB_TYPE"="CODE") 193 - access("NS_ID"= (SELECT "DYN_ENUM_NS_ID" FROM "REVM_TRAN"."MN_DYN_ENUM_NS" "MN_DYN_ENUM_NS" WHERE "NS_NAME"='ContractSubType')) 194 - filter("NS_NAME"='ContractSubType') 195 - access("ERP"."PAYEE_ID"="MEM"."MEMBER_ID") 198 - access("NS_ID"="DYN_ENUM_NS_ID") 199 - filter("NS_NAME"='ContractType') 202 - access("NS_ID"= (SELECT "DYN_ENUM_NS_ID" FROM "REVM_TRAN"."MN_DYN_ENUM_NS" "MN_DYN_ENUM_NS" WHERE "NS_NAME"='RebateSubType')) 203 - filter("NS_NAME"='RebateSubType') 205 - access("NS_ID"="DYN_ENUM_NS_ID") 206 - filter("NS_NAME"='ProgramType') 208 - access("NS_ID"="DYN_ENUM_NS_ID") 209 - filter("NS_NAME"='PaymentMethod') 213 - filter(("ERP"."ERP_PMT_TYPE"=20 OR "ERP"."ERP_PMT_TYPE"=30) AND "ERP"."ORG_UNIT_ID"=10223 AND TRUNC(INTERNAL_FUNCTION("ERP"."ERP_PMT_DATE"))>=TO_DATE(' 2017-07-01 00:00:00', 'syyyy-mm-dd hh24:mi:ss') AND TRUNC(INTERNAL_FUNCTION("ERP"."ERP_PMT_DATE"))<=TO_DATE(' 2017-10-15 00:00:00', 'syyyy-mm-dd hh24:mi:ss')) 219 - access("CODE"="CONT"."STRUCT_DOC_TYPE") 226 - access("CODE"="ERP"."ERP_PMT_TYPE") 229 - access("REB"."PROGRAM_TYPE"="CODE") 231 - access("REB"."REBATE_SUB_TYPE"=TO_NUMBER("RBT_SUB_TYPE"."CODE"(+))) 234 - access("ERP"."ERP_PMT_TYPE"="ERP_PMT_TYPE" AND "ERP"."ERP_PMT_DATE"="ERP_PMT_DATE") 235 - access("ERP"."ERP_PMT_METHOD"="CONST_NAME") 238 - filter("NS_NAME"='PaymentMethod') 239 - access("NS_ID"="DYN_ENUM_NS_ID") 248 - filter("ERP"."ORG_UNIT_ID"=10223) 250 - access("REB"."REBATE_PMT_ID"="ERP"."REBATE_PMT_ID") 251 - access("REB"."REBATE_PMT_ID"="BKT_LINE"."REBATE_PMT_ID") 252 - filter("BKT_LINE"."PMT_BENEFIT_ID" IS NOT NULL AND TO_DATE("MN_GLOBAL_PKG"."FORMAT_TIMESTAMP_WITHTZ"("BKT_LINE"."SALE_INV_DATE_SQL",' PST','yyyy-MM-dd'),'YYYY-MM-DD')>=TO_DATE(' 2016-01-01 00:00:00', 'syyyy-mm-dd hh24:mi:ss') AND TO_DATE("MN_GLOBAL_PKG"."FORMAT_TIMESTAMP_WITHTZ"("BKT_LINE"."SALE_INV_DATE_SQL",'PST','yyyy-MM-dd'),'YYYY-MM-DD')<=TO_DATE(' 2017-09-30 00:00:00', 'syyyy-mm-dd hh24:mi:ss') AND "BKT_LINE"."INCLUSION_TYPE"='INC') 256 - filter("ERP"."ORG_UNIT_ID"=10223) 258 - access("REB"."REBATE_PMT_ID"="ERP"."REBATE_PMT_ID") 259 - access("REB"."REBATE_PMT_ID"="BKT_LINE"."REBATE_PMT_ID") 260 - filter(TO_DATE("MN_GLOBAL_PKG"."FORMAT_TIMESTAMP_WITHTZ"("BKT_LINE"."SALE_INV_DATE_SQL",'PST','yyyy-MM-dd'),'YYYY-MM-DD')>=TO_DATE(' 2016-01-01 00:00:00', 'syyyy-mm-dd hh24:mi:ss') AND TO_DATE("MN_GLOBAL_PKG"."FORMAT_TIMESTAMP_WITHTZ"("BKT_LINE"."SALE_INV_DATE_SQL",'PST',' yyyy-MM-dd'),'YYYY-MM-DD')<=TO_DATE(' 2017-09-30 00:00:00', 'syyyy-mm-dd hh24:mi:ss') AND "BKT_LINE"."INCLUSION_TYPE"='INC' AND "BKT_LINE"."PMT_BENEFIT_ID" IS NOT NULL) 261 - access("REB"."REBATE_PMT_ID"="ERP"."REBATE_PMT_ID") filter("REB"."REBATE_PMT_ID"="REBATE_PMT_ID") 262 - filter("REB"."PYMT_PKG_FK" IS NOT NULL AND "REB"."REV_REBATE_PMT_FK" IS NULL AND TO_DATE("MN_GLOBAL_PKG"."FORMAT_TIMESTAMP_WITHTZ"("REB"."START_DATE",'PST','yyyy-MM-dd'),'YYYY-MM-DD')>=TO_DATE(' 2016-01-01 00:00:00', 'syyyy-mm-dd hh24:mi:ss') AND TO_DATE("MN_GLOBAL_PKG"."FORMAT_TIMESTAMP_WITHTZ"("REB"."END_DATE",'PST','yyyy-MM-dd'),'YYYY-MM-DD')<=TO_DATE( ' 2017-09-30 00:00:00', 'syyyy-mm-dd hh24:mi:ss')) 265 - access("NS_ID"= (SELECT "DYN_ENUM_NS_ID" FROM "REVM_TRAN"."MN_DYN_ENUM_NS" "MN_DYN_ENUM_NS" WHERE "NS_NAME"='RebateSubType')) 266 - filter("NS_NAME"='RebateSubType') 267 - access("FLD_NAME"='tradeName' AND "MAP_FIELD"."CAT_MAP_ID"="SALE_ITEM_ID") filter("MAP_FIELD"."CAT_MAP_ID"="SALE_ITEM_ID") 269 - access("NS_ID"="DYN_ENUM_NS_ID") 270 - filter("NS_NAME"='ProgramType') 272 - filter("NS_NAME"='ERPPaymentType') 273 - access("NS_ID"="DYN_ENUM_NS_ID") 275 - access("REB"."CURR_PAY_PROG_ID"="PROG"."PAY_PROG_ID") 277 - access("PROG"."STRUCT_CONTRACT_ID"="DOC"."STRUCT_DOC_ID") 278 - filter("CONT"."CTRT_SUB_TYPE" IS NOT NULL) 279 - access("DOC"."STRUCT_DOC_ID"="CONT"."STRUCT_DOC_ID") 280 - access("NS_ID"= (SELECT "DYN_ENUM_NS_ID" FROM "REVM_TRAN"."MN_DYN_ENUM_NS" "MN_DYN_ENUM_NS" WHERE "NS_NAME"='ContractSubType')) 281 - filter("NS_NAME"='ContractSubType') 282 - filter("CONT"."CTRT_SUB_TYPE"="CODE") 284 - filter("NS_NAME"='ContractType') 285 - access("NS_ID"="DYN_ENUM_NS_ID") 287 - access("REB"."PYMT_PKG_FK"="PYMT_PKG"."PYMT_PKG_ID") 288 - access("ERP"."PAYEE_ID"="MEM"."MEMBER_ID") Note ----- - dynamic sampling used for this statement (level=4) - automatic DOP: Computed Degree of Parallelism is 1 because of parallel threshold ------- PLAN_TABLE_OUTPUT Plan hash value: 4263536952 -------------------------------------------------------------------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes |TempSpc| Cost (%CPU)| Time | -------------------------------------------------------------------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 3 | 11862 | | 99483 (2)| 00:00:04 | | 1 | HASH UNIQUE | | 3 | 11862 | | 99483 (2)| 00:00:04 | | 2 | VIEW | | 3 | 11862 | | 99482 (2)| 00:00:04 | | 3 | UNION-ALL | | | | | | | | 4 | VIEW | | 1 | 3942 | | 42240 (2)| 00:00:02 | | 5 | TEMP TABLE TRANSFORMATION | | | | | | | | 6 | LOAD AS SELECT | SYS_TEMP_0FD9D6D66_7EE0762F | | | | | | |* 7 | TABLE ACCESS FULL | MN_ERP_PAYMENT | 3917 | 833K| | 1079 (2)| 00:00:01 | | 8 | HASH GROUP BY | | 1 | 560 | | 41160 (2)| 00:00:02 | |* 9 | HASH JOIN OUTER | | 1 | 560 | | 41159 (2)| 00:00:02 | | 10 | VIEW | | 1 | 531 | | 8416 (1)| 00:00:01 | | 11 | NESTED LOOPS | | 1 | 787 | | 8416 (1)| 00:00:01 | | 12 | NESTED LOOPS | | 1 | 762 | | 8416 (1)| 00:00:01 | |* 13 | HASH JOIN | | 2670 | 1879K| | 8413 (1)| 00:00:01 | |* 14 | HASH JOIN | | 2670 | 1793K| | 6787 (1)| 00:00:01 | | 15 | TABLE ACCESS FULL | MN_DYN_ENUM_CONST | 6971 | 163K| | 97 (0)| 00:00:01 | |* 16 | HASH JOIN | | 971 | 629K| | 6690 (1)| 00:00:01 | | 17 | TABLE ACCESS BY INDEX ROWID | MN_DYN_ENUM_CONST | 12 | 288 | | 2 (0)| 00:00:01 | |* 18 | INDEX RANGE SCAN | MN_53101_IDX1 | 12 | | | 1 (0)| 00:00:01 | |* 19 | TABLE ACCESS FULL | MN_DYN_ENUM_NS | 1 | 21 | | 49 (0)| 00:00:01 | |* 20 | HASH JOIN | | 15061 | 9413K| | 6687 (1)| 00:00:01 | | 21 | NESTED LOOPS | | 121 | 74536 | | 6590 (1)| 00:00:01 | | 22 | NESTED LOOPS | | 230 | 74536 | | 6590 (1)| 00:00:01 | |* 23 | HASH JOIN | | 230 | 134K| | 6427 (1)| 00:00:01 | |* 24 | HASH JOIN RIGHT OUTER | | 230 | 131K| | 6291 (1)| 00:00:01 | | 25 | VIEW | | 12 | 2472 | | 2 (0)| 00:00:01 | | 26 | TABLE ACCESS BY INDEX ROWID | MN_DYN_ENUM_CONST | 12 | 288 | | 2 (0)| 00:00:01 | |* 27 | INDEX RANGE SCAN | MN_53101_IDX1 | 12 | | | 1 (0)| 00:00:01 | |* 28 | TABLE ACCESS FULL | MN_DYN_ENUM_NS | 1 | 21 | | 49 (0)| 00:00:01 | | 29 | NESTED LOOPS | | 230 | 87170 | | 6289 (1)| 00:00:01 | | 30 | NESTED LOOPS | | 230 | 87170 | | 6289 (1)| 00:00:01 | |* 31 | HASH JOIN | | 2 | 710 | | 6287 (1)| 00:00:01 | | 32 | NESTED LOOPS | | 866 | 273K| | 6190 (1)| 00:00:01 | | 33 | NESTED LOOPS | | 866 | 273K| | 6190 (1)| 00:00:01 | |* 34 | HASH JOIN | | 866 | 224K| | 5323 (1)| 00:00:01 | | 35 | NESTED LOOPS | | 866 | 215K| | 4676 (1)| 00:00:01 | | 36 | NESTED LOOPS | | 4449 | 215K| | 4676 (1)| 00:00:01 | | 37 | MERGE JOIN CARTESIAN | | 4449 | 690K| | 221 (1)| 00:00:01 | | 38 | MERGE JOIN CARTESIAN | | 1 | 84 | | 196 (0)| 00:00:01 | | 39 | MERGE JOIN CARTESIAN | | 1 | 63 | | 147 (0)| 00:00:01 | | 40 | MERGE JOIN CARTESIAN | | 1 | 42 | | 98 (0)| 00:00:01 | |* 41 | TABLE ACCESS FULL | MN_DYN_ENUM_NS | 1 | 21 | | 49 (0)| 00:00:01 | | 42 | BUFFER SORT | | 1 | 21 | | 49 (0)| 00:00:01 | |* 43 | TABLE ACCESS FULL | MN_DYN_ENUM_NS | 1 | 21 | | 49 (0)| 00:00:01 | | 44 | BUFFER SORT | | 1 | 21 | | 98 (0)| 00:00:01 | |* 45 | TABLE ACCESS FULL | MN_DYN_ENUM_NS | 1 | 21 | | 49 (0)| 00:00:01 | | 46 | BUFFER SORT | | 1 | 21 | | 147 (0)| 00:00:01 | |* 47 | TABLE ACCESS FULL | MN_DYN_ENUM_NS | 1 | 21 | | 49 (0)| 00:00:01 | | 48 | BUFFER SORT | | 3917 | 286K| | 172 (1)| 00:00:01 | | 49 | VIEW | | 3917 | 286K| | 24 (0)| 00:00:01 | | 50 | TABLE ACCESS FULL | SYS_TEMP_0FD9D6D66_7EE0762F | 3917 | 833K| | 24 (0)| 00:00:01 | |* 51 | INDEX UNIQUE SCAN | MN_11004_PK | 1 | | | 0 (0)| 00:00:01 | |* 52 | TABLE ACCESS BY INDEX ROWID| MN_REBATE_PAYMENT | 1 | 96 | | 1 (0)| 00:00:01 | | 53 | TABLE ACCESS FULL | MN_PAYMENT_PROG | 53390 | 521K| | 647 (1)| 00:00:01 | |* 54 | INDEX UNIQUE SCAN | MN_11034_PK | 1 | | | 0 (0)| 00:00:01 | | 55 | TABLE ACCESS BY INDEX ROWID | MN_PAYMENT_PKG | 1 | 58 | | 1 (0)| 00:00:01 | | 56 | TABLE ACCESS FULL | MN_DYN_ENUM_CONST | 6971 | 217K| | 97 (0)| 00:00:01 | |* 57 | INDEX RANGE SCAN | MN_53101_IDX1 | 12 | | | 0 (0)| 00:00:01 | |* 58 | TABLE ACCESS BY INDEX ROWID | MN_DYN_ENUM_CONST | 108 | 2592 | | 1 (0)| 00:00:01 | | 59 | VIEW | index$_join$_035 | 27953 | 436K| | 136 (2)| 00:00:01 | |* 60 | HASH JOIN | | | | | | | | 61 | INDEX FAST FULL SCAN | MN_10253_PK | 27953 | 436K| | 56 (2)| 00:00:01 | | 62 | INDEX FAST FULL SCAN | MN_10210_DOC_ID_NUM_IDX | 27953 | 436K| | 113 (0)| 00:00:01 | |* 63 | INDEX RANGE SCAN | MN_CF_STRUCT_CTRT_BKT_IDX | 1 | | | 0 (0)| 00:00:01 | |* 64 | TABLE ACCESS BY INDEX ROWID | MN_STRUCTURED_CONTRACT | 1 | 15 | | 1 (0)| 00:00:01 | | 65 | TABLE ACCESS FULL | MN_DYN_ENUM_CONST | 6971 | 163K| | 97 (0)| 00:00:01 | | 66 | TABLE ACCESS FULL | MN_MEMBER | 263K| 8501K| | 1624 (1)| 00:00:01 | |* 67 | VIEW | | 1 | 41 | | 1 (0)| 00:00:01 | | 68 | SORT UNIQUE | | | | | | | | 69 | UNION-ALL PARTITION | | | | | | | | 70 | NESTED LOOPS | | 1 | 114 | | 27 (0)| 00:00:01 | | 71 | NESTED LOOPS | | 1 | 114 | | 27 (0)| 00:00:01 | | 72 | NESTED LOOPS | | 1 | 74 | | 26 (0)| 00:00:01 | | 73 | TABLE ACCESS BY INDEX ROWID | MN_REBATE_PAYMENT | 1 | 22 | | 2 (0)| 00:00:01 | |* 74 | INDEX UNIQUE SCAN | MN_11004_PK | 1 | | | 1 (0)| 00:00:01 | |* 75 | VIEW | | 1 | 52 | | 24 (0)| 00:00:01 | |* 76 | TABLE ACCESS FULL | SYS_TEMP_0FD9D6D66_7EE0762F | 63 | 13734 | | 24 (0)| 00:00:01 | |* 77 | INDEX RANGE SCAN | REBATEPAYMENTGRP | 1 | | | 0 (0)| 00:00:01 | |* 78 | TABLE ACCESS BY INDEX ROWID | MN_BUCKET_LINE | 1 | 40 | | 1 (0)| 00:00:01 | | 79 | NESTED LOOPS | | 1 | 117 | | 27 (0)| 00:00:01 | | 80 | NESTED LOOPS | | 1 | 117 | | 27 (0)| 00:00:01 | | 81 | NESTED LOOPS | | 1 | 74 | | 26 (0)| 00:00:01 | | 82 | TABLE ACCESS BY INDEX ROWID | MN_REBATE_PAYMENT | 1 | 22 | | 2 (0)| 00:00:01 | |* 83 | INDEX UNIQUE SCAN | MN_11004_PK | 1 | | | 1 (0)| 00:00:01 | |* 84 | VIEW | | 1 | 52 | | 24 (0)| 00:00:01 | |* 85 | TABLE ACCESS FULL | SYS_TEMP_0FD9D6D66_7EE0762F | 63 | 13734 | | 24 (0)| 00:00:01 | |* 86 | INDEX RANGE SCAN | MN_11108_PMT_ID_IDX | 1 | | | 0 (0)| 00:00:01 | |* 87 | TABLE ACCESS BY INDEX ROWID | MN_MCO_BUCKET_LINE | 1 | 43 | | 1 (0)| 00:00:01 | |* 88 | INDEX RANGE SCAN | CATMAPFLDIDX6 | 1 | 25 | | 0 (0)| 00:00:01 | | 89 | VIEW | | 213K| 6053K| | 32741 (2)| 00:00:02 | | 90 | HASH GROUP BY | | 213K| 6053K| 8384K| 32741 (2)| 00:00:02 | | 91 | VIEW | | 213K| 6053K| | 31664 (2)| 00:00:02 | | 92 | UNION-ALL | | | | | | | |* 93 | HASH JOIN | | 146K| 9573K| | 21773 (1)| 00:00:01 | |* 94 | INDEX RANGE SCAN | CATMAPFLDIDX6 | 3677 | 91925 | | 14 (0)| 00:00:01 | | 95 | NESTED LOOPS | | 107K| 4394K| | 21758 (1)| 00:00:01 | | 96 | NESTED LOOPS | | 371K| 4394K| | 21758 (1)| 00:00:01 | |* 97 | TABLE ACCESS FULL | MN_REBATE_PAYMENT | 1275 | 35700 | | 9594 (2)| 00:00:01 | |* 98 | INDEX RANGE SCAN | REBATEPAYMENTGRP | 291 | | | 0 (0)| 00:00:01 | | 99 | TABLE ACCESS BY INDEX ROWID | MN_BUCKET_LINE | 84 | 1176 | | 33 (0)| 00:00:01 | |*100 | HASH JOIN | | 67423 | 4608K| | 9891 (2)| 00:00:01 | |*101 | INDEX RANGE SCAN | CATMAPFLDIDX6 | 3677 | 91925 | | 14 (0)| 00:00:01 | | 102 | NESTED LOOPS | | 39765 | 1747K| | 9877 (2)| 00:00:01 | | 103 | NESTED LOOPS | | 39765 | 1747K| | 9877 (2)| 00:00:01 | |*104 | TABLE ACCESS FULL | MN_REBATE_PAYMENT | 1275 | 35700 | | 9594 (2)| 00:00:01 | |*105 | INDEX RANGE SCAN | MN_11108_PMT_ID_IDX | 31 | | | 0 (0)| 00:00:01 | | 106 | TABLE ACCESS BY INDEX ROWID | MN_MCO_BUCKET_LINE | 31 | 527 | | 5 (0)| 00:00:01 | | 107 | VIEW | | 1 | 3942 | | 46286 (2)| 00:00:02 | | 108 | TEMP TABLE TRANSFORMATION | | | | | | | | 109 | LOAD AS SELECT | SYS_TEMP_0FD9D6D67_7EE0762F | | | | | | |*110 | TABLE ACCESS FULL | MN_ERP_PAYMENT | 1 | 218 | | 1072 (1)| 00:00:01 | | 111 | LOAD AS SELECT | SYS_TEMP_0FD9D6D68_7EE0762F | | | | | | |*112 | TABLE ACCESS FULL | MN_REBATE_PAYMENT | 137 | 79734 | | 9520 (2)| 00:00:01 | | 113 | HASH GROUP BY | | 1 | 1042 | | 35693 (2)| 00:00:02 | |*114 | HASH JOIN | | 1 | 1042 | | 35692 (2)| 00:00:02 | | 115 | NESTED LOOPS | | 1 | 1013 | | 3999 (1)| 00:00:01 | | 116 | NESTED LOOPS | | 11982 | 1013 | | 3999 (1)| 00:00:01 | | 117 | NESTED LOOPS | | 1 | 991 | | 216 (1)| 00:00:01 | | 118 | NESTED LOOPS | | 1 | 966 | | 216 (1)| 00:00:01 | | 119 | NESTED LOOPS | | 1 | 923 | | 215 (1)| 00:00:01 | | 120 | NESTED LOOPS | | 1 | 890 | | 214 (1)| 00:00:01 | | 121 | NESTED LOOPS | | 1 | 866 | | 213 (1)| 00:00:01 | | 122 | NESTED LOOPS | | 1 | 842 | | 212 (1)| 00:00:01 | | 123 | NESTED LOOPS | | 1 | 818 | | 211 (1)| 00:00:01 | | 124 | NESTED LOOPS | | 1 | 803 | | 210 (1)| 00:00:01 | |*125 | HASH JOIN OUTER | | 1 | 787 | | 209 (1)| 00:00:01 | | 126 | NESTED LOOPS | | 1 | 581 | | 207 (1)| 00:00:01 | | 127 | NESTED LOOPS | | 12 | 581 | | 207 (1)| 00:00:01 | | 128 | NESTED LOOPS | | 1 | 557 | | 206 (1)| 00:00:01 | | 129 | NESTED LOOPS | | 1 | 525 | | 205 (1)| 00:00:01 | | 130 | NESTED LOOPS | | 1 | 467 | | 204 (1)| 00:00:01 | |*131 | HASH JOIN | | 1 | 457 | | 203 (1)| 00:00:01 | | 132 | MERGE JOIN CARTESIAN | | 1 | 159 | | 198 (0)| 00:00:01 | | 133 | MERGE JOIN CARTESIAN | | 1 | 84 | | 196 (0)| 00:00:01 | | 134 | MERGE JOIN CARTESIAN | | 1 | 63 | | 147 (0)| 00:00:01 | | 135 | MERGE JOIN CARTESIAN | | 1 | 42 | | 98 (0)| 00:00:01 | |*136 | TABLE ACCESS FULL | MN_DYN_ENUM_NS | 1 | 21 | | 49 (0)| 00:00:01 | | 137 | BUFFER SORT | | 1 | 21 | | 49 (0)| 00:00:01 | |*138 | TABLE ACCESS FULL | MN_DYN_ENUM_NS | 1 | 21 | | 49 (0)| 00:00:01 | | 139 | BUFFER SORT | | 1 | 21 | | 98 (0)| 00:00:01 | |*140 | TABLE ACCESS FULL | MN_DYN_ENUM_NS | 1 | 21 | | 49 (0)| 00:00:01 | | 141 | BUFFER SORT | | 1 | 21 | | 147 (0)| 00:00:01 | |*142 | TABLE ACCESS FULL | MN_DYN_ENUM_NS | 1 | 21 | | 49 (0)| 00:00:01 | | 143 | BUFFER SORT | | 1 | 75 | | 149 (0)| 00:00:01 | | 144 | VIEW | | 1 | 75 | | 2 (0)| 00:00:01 | | 145 | TABLE ACCESS FULL | SYS_TEMP_0FD9D6D67_7EE0762F | 1 | 218 | | 2 (0)| 00:00:01 | | 146 | VIEW | | 137 | 40826 | | 4 (0)| 00:00:01 | | 147 | TABLE ACCESS FULL | SYS_TEMP_0FD9D6D68_7EE0762F | 137 | 79734 | | 4 (0)| 00:00:01 | | 148 | TABLE ACCESS BY INDEX ROWID | MN_PAYMENT_PROG | 1 | 10 | | 1 (0)| 00:00:01 | |*149 | INDEX UNIQUE SCAN | MN_11012_PK | 1 | | | 0 (0)| 00:00:01 | | 150 | TABLE ACCESS BY INDEX ROWID | MN_PAYMENT_PKG | 1 | 58 | | 1 (0)| 00:00:01 | |*151 | INDEX UNIQUE SCAN | MN_11034_PK | 1 | | | 0 (0)| 00:00:01 | |*152 | TABLE ACCESS BY INDEX ROWID | MN_DYN_ENUM_CONST | 1 | 32 | | 1 (0)| 00:00:01 | |*153 | INDEX RANGE SCAN | MN_53101_IDX1 | 12 | | | 0 (0)| 00:00:01 | |*154 | INDEX RANGE SCAN | MN_53101_IDX1 | 12 | | | 0 (0)| 00:00:01 | |*155 | TABLE ACCESS BY INDEX ROWID | MN_DYN_ENUM_CONST | 1 | 24 | | 1 (0)| 00:00:01 | | 156 | VIEW | | 12 | 2472 | | 2 (0)| 00:00:01 | | 157 | TABLE ACCESS BY INDEX ROWID | MN_DYN_ENUM_CONST | 12 | 288 | | 2 (0)| 00:00:01 | |*158 | INDEX RANGE SCAN | MN_53101_IDX1 | 12 | | | 1 (0)| 00:00:01 | |*159 | TABLE ACCESS FULL | MN_DYN_ENUM_NS | 1 | 21 | | 49 (0)| 00:00:01 | | 160 | TABLE ACCESS BY INDEX ROWID | MN_STRUCTURED_DOC | 1 | 16 | | 1 (0)| 00:00:01 | |*161 | INDEX UNIQUE SCAN | MN_10253_PK | 1 | | | 0 (0)| 00:00:01 | |*162 | TABLE ACCESS BY INDEX ROWID | MN_STRUCTURED_CONTRACT | 1 | 15 | | 1 (0)| 00:00:01 | |*163 | INDEX RANGE SCAN | MN_CF_STRUCT_CTRT_BKT_IDX | 1 | | | 0 (0)| 00:00:01 | |*164 | TABLE ACCESS BY INDEX ROWID | MN_DYN_ENUM_CONST | 124 | 2976 | | 1 (0)| 00:00:01 | |*165 | INDEX RANGE SCAN | MN_53101_IDX1 | 12 | | | 0 (0)| 00:00:01 | |*166 | TABLE ACCESS BY INDEX ROWID | MN_DYN_ENUM_CONST | 1 | 24 | | 1 (0)| 00:00:01 | |*167 | INDEX RANGE SCAN | MN_53101_IDX1 | 12 | | | 0 (0)| 00:00:01 | |*168 | TABLE ACCESS FULL | MN_DYN_ENUM_NS | 1 | 21 | | 49 (0)| 00:00:01 | |*169 | TABLE ACCESS BY INDEX ROWID | MN_DYN_ENUM_CONST | 3 | 72 | | 1 (0)| 00:00:01 | |*170 | INDEX RANGE SCAN | MN_53101_IDX1 | 12 | | | 0 (0)| 00:00:01 | | 171 | TABLE ACCESS BY INDEX ROWID | MN_MEMBER | 1 | 33 | | 1 (0)| 00:00:01 | |*172 | INDEX UNIQUE SCAN | MN_18815_PK | 1 | | | 0 (0)| 00:00:01 | |*173 | VIEW | | 1 | 43 | | 1 (0)| 00:00:01 | | 174 | UNION-ALL PARTITION | | | | | | | | 175 | NESTED LOOPS | | 1 | 95 | | 4 (0)| 00:00:01 | | 176 | NESTED LOOPS | | 1 | 95 | | 4 (0)| 00:00:01 | | 177 | NESTED LOOPS | | 1 | 58 | | 3 (0)| 00:00:01 | |*178 | INDEX UNIQUE SCAN | MN_11004_PK | 1 | 6 | | 1 (0)| 00:00:01 | |*179 | VIEW | | 1 | 52 | | 2 (0)| 00:00:01 | |*180 | TABLE ACCESS FULL | SYS_TEMP_0FD9D6D67_7EE0762F | 1 | 218 | | 2 (0)| 00:00:01 | |*181 | INDEX RANGE SCAN | REBATEPAYMENTGRP | 1 | | | 0 (0)| 00:00:01 | |*182 | TABLE ACCESS BY INDEX ROWID | MN_BUCKET_LINE | 1 | 37 | | 1 (0)| 00:00:01 | | 183 | NESTED LOOPS | | 1 | 95 | | 4 (0)| 00:00:01 | | 184 | NESTED LOOPS | | 1 | 95 | | 4 (0)| 00:00:01 | | 185 | NESTED LOOPS | | 1 | 58 | | 3 (0)| 00:00:01 | |*186 | INDEX UNIQUE SCAN | MN_11004_PK | 1 | 6 | | 1 (0)| 00:00:01 | |*187 | VIEW | | 1 | 52 | | 2 (0)| 00:00:01 | |*188 | TABLE ACCESS FULL | SYS_TEMP_0FD9D6D67_7EE0762F | 1 | 218 | | 2 (0)| 00:00:01 | |*189 | INDEX RANGE SCAN | MN_11108_PMT_ID_IDX | 1 | | | 0 (0)| 00:00:01 | |*190 | TABLE ACCESS BY INDEX ROWID | MN_MCO_BUCKET_LINE | 1 | 37 | | 1 (0)| 00:00:01 | |*191 | INDEX RANGE SCAN | CATMAPFLDIDX6 | 1 | 25 | | 0 (0)| 00:00:01 | |*192 | INDEX RANGE SCAN | MN_10726_IDX12 | 11982 | | | 0 (0)| 00:00:01 | |*193 | TABLE ACCESS BY INDEX ROWID | MN_RBTPMT_SALE_CLOSED | 1 | 22 | | 3783 (1)| 00:00:01 | | 194 | VIEW | | 2609 | 75661 | | 31693 (2)| 00:00:02 | | 195 | HASH GROUP BY | | 2609 | 75661 | | 31693 (2)| 00:00:02 | | 196 | VIEW | | 2609 | 75661 | | 31692 (2)| 00:00:02 | | 197 | UNION-ALL | | | | | | | |*198 | HASH JOIN | | 366 | 28548 | | 21801 (2)| 00:00:01 | | 199 | NESTED LOOPS | | 268 | 14204 | | 21787 (2)| 00:00:01 | | 200 | NESTED LOOPS | | 371K| 14204 | | 21787 (2)| 00:00:01 | |*201 | TABLE ACCESS FULL | MN_REBATE_PAYMENT | 1275 | 35700 | | 9594 (2)| 00:00:01 | |*202 | INDEX RANGE SCAN | REBATEPAYMENTGRP | 291 | | | 0 (0)| 00:00:01 | |*203 | TABLE ACCESS BY INDEX ROWID | MN_BUCKET_LINE | 1 | 25 | | 33 (0)| 00:00:01 | |*204 | INDEX RANGE SCAN | CATMAPFLDIDX6 | 3677 | 91925 | | 14 (0)| 00:00:01 | |*205 | HASH JOIN | | 2243 | 177K| | 9891 (2)| 00:00:01 | | 206 | NESTED LOOPS | | 1323 | 74088 | | 9877 (2)| 00:00:01 | | 207 | NESTED LOOPS | | 39525 | 74088 | | 9877 (2)| 00:00:01 | |*208 | TABLE ACCESS FULL | MN_REBATE_PAYMENT | 1275 | 35700 | | 9594 (2)| 00:00:01 | |*209 | INDEX RANGE SCAN | MN_11108_PMT_ID_IDX | 31 | | | 0 (0)| 00:00:01 | |*210 | TABLE ACCESS BY INDEX ROWID | MN_MCO_BUCKET_LINE | 1 | 28 | | 5 (0)| 00:00:01 | |*211 | INDEX RANGE SCAN | CATMAPFLDIDX6 | 3677 | 91925 | | 14 (0)| 00:00:01 | | 212 | VIEW | | 1 | 3942 | | 10957 (3)| 00:00:01 | | 213 | TEMP TABLE TRANSFORMATION | | | | | | | | 214 | LOAD AS SELECT | SYS_TEMP_0FD9D6D69_7EE0762F | | | | | | |*215 | TABLE ACCESS FULL | MN_ERP_PAYMENT | 1 | 218 | | 1072 (1)| 00:00:01 | | 216 | LOAD AS SELECT | SYS_TEMP_0FD9D6D6A_7EE0762F | | | | | | |*217 | TABLE ACCESS FULL | MN_REBATE_PAYMENT | 1138 | 646K| | 9653 (3)| 00:00:01 | | 218 | HASH GROUP BY | | 1 | 767 | | 232 (1)| 00:00:01 | | 219 | NESTED LOOPS | | 1 | 767 | | 231 (1)| 00:00:01 | | 220 | NESTED LOOPS | | 1 | 742 | | 231 (1)| 00:00:01 | | 221 | NESTED LOOPS | | 1 | 701 | | 230 (1)| 00:00:01 | | 222 | NESTED LOOPS | | 1 | 668 | | 229 (1)| 00:00:01 | | 223 | NESTED LOOPS | | 1 | 644 | | 228 (1)| 00:00:01 | | 224 | NESTED LOOPS | | 1 | 620 | | 227 (1)| 00:00:01 | | 225 | NESTED LOOPS | | 1 | 596 | | 226 (1)| 00:00:01 | | 226 | NESTED LOOPS | | 1 | 581 | | 225 (1)| 00:00:01 | |*227 | HASH JOIN OUTER | | 1 | 565 | | 224 (1)| 00:00:01 | | 228 | NESTED LOOPS | | 1 | 359 | | 222 (1)| 00:00:01 | | 229 | NESTED LOOPS | | 12 | 359 | | 222 (1)| 00:00:01 | | 230 | NESTED LOOPS | | 1 | 335 | | 221 (1)| 00:00:01 | | 231 | NESTED LOOPS | | 1 | 303 | | 220 (1)| 00:00:01 | | 232 | NESTED LOOPS | | 1 | 245 | | 219 (1)| 00:00:01 | |*233 | HASH JOIN | | 1 | 235 | | 218 (1)| 00:00:01 | | 234 | MERGE JOIN CARTESIAN | | 1 | 159 | | 198 (0)| 00:00:01 | | 235 | MERGE JOIN CARTESIAN | | 1 | 84 | | 196 (0)| 00:00:01 | | 236 | MERGE JOIN CARTESIAN | | 1 | 63 | | 147 (0)| 00:00:01 | | 237 | MERGE JOIN CARTESIAN | | 1 | 42 | | 98 (0)| 00:00:01 | |*238 | TABLE ACCESS FULL | MN_DYN_ENUM_NS | 1 | 21 | | 49 (0)| 00:00:01 | | 239 | BUFFER SORT | | 1 | 21 | | 49 (0)| 00:00:01 | |*240 | TABLE ACCESS FULL | MN_DYN_ENUM_NS | 1 | 21 | | 49 (0)| 00:00:01 | | 241 | BUFFER SORT | | 1 | 21 | | 98 (0)| 00:00:01 | |*242 | TABLE ACCESS FULL | MN_DYN_ENUM_NS | 1 | 21 | | 49 (0)| 00:00:01 | | 243 | BUFFER SORT | | 1 | 21 | | 147 (0)| 00:00:01 | |*244 | TABLE ACCESS FULL | MN_DYN_ENUM_NS | 1 | 21 | | 49 (0)| 00:00:01 | | 245 | BUFFER SORT | | 1 | 75 | | 149 (0)| 00:00:01 | | 246 | VIEW | | 1 | 75 | | 2 (0)| 00:00:01 | | 247 | TABLE ACCESS FULL | SYS_TEMP_0FD9D6D69_7EE0762F | 1 | 218 | | 2 (0)| 00:00:01 | | 248 | VIEW | | 1138 | 86488 | | 19 (0)| 00:00:01 | | 249 | TABLE ACCESS FULL | SYS_TEMP_0FD9D6D6A_7EE0762F | 1138 | 646K| | 19 (0)| 00:00:01 | | 250 | TABLE ACCESS BY INDEX ROWID | MN_PAYMENT_PROG | 1 | 10 | | 1 (0)| 00:00:01 | |*251 | INDEX UNIQUE SCAN | MN_11012_PK | 1 | | | 0 (0)| 00:00:01 | | 252 | TABLE ACCESS BY INDEX ROWID | MN_PAYMENT_PKG | 1 | 58 | | 1 (0)| 00:00:01 | |*253 | INDEX UNIQUE SCAN | MN_11034_PK | 1 | | | 0 (0)| 00:00:01 | |*254 | TABLE ACCESS BY INDEX ROWID | MN_DYN_ENUM_CONST | 1 | 32 | | 1 (0)| 00:00:01 | |*255 | INDEX RANGE SCAN | MN_53101_IDX1 | 12 | | | 0 (0)| 00:00:01 | |*256 | INDEX RANGE SCAN | MN_53101_IDX1 | 12 | | | 0 (0)| 00:00:01 | |*257 | TABLE ACCESS BY INDEX ROWID | MN_DYN_ENUM_CONST | 1 | 24 | | 1 (0)| 00:00:01 | | 258 | VIEW | | 12 | 2472 | | 2 (0)| 00:00:01 | | 259 | TABLE ACCESS BY INDEX ROWID | MN_DYN_ENUM_CONST | 12 | 288 | | 2 (0)| 00:00:01 | |*260 | INDEX RANGE SCAN | MN_53101_IDX1 | 12 | | | 1 (0)| 00:00:01 | |*261 | TABLE ACCESS FULL | MN_DYN_ENUM_NS | 1 | 21 | | 49 (0)| 00:00:01 | | 262 | TABLE ACCESS BY INDEX ROWID | MN_STRUCTURED_DOC | 1 | 16 | | 1 (0)| 00:00:01 | |*263 | INDEX UNIQUE SCAN | MN_10253_PK | 1 | | | 0 (0)| 00:00:01 | |*264 | TABLE ACCESS BY INDEX ROWID | MN_STRUCTURED_CONTRACT | 1 | 15 | | 1 (0)| 00:00:01 | |*265 | INDEX RANGE SCAN | MN_CF_STRUCT_CTRT_BKT_IDX | 1 | | | 0 (0)| 00:00:01 | |*266 | TABLE ACCESS BY INDEX ROWID | MN_DYN_ENUM_CONST | 124 | 2976 | | 1 (0)| 00:00:01 | |*267 | INDEX RANGE SCAN | MN_53101_IDX1 | 12 | | | 0 (0)| 00:00:01 | |*268 | TABLE ACCESS BY INDEX ROWID | MN_DYN_ENUM_CONST | 1 | 24 | | 1 (0)| 00:00:01 | |*269 | INDEX RANGE SCAN | MN_53101_IDX1 | 12 | | | 0 (0)| 00:00:01 | |*270 | TABLE ACCESS FULL | MN_DYN_ENUM_NS | 1 | 21 | | 49 (0)| 00:00:01 | |*271 | TABLE ACCESS BY INDEX ROWID | MN_DYN_ENUM_CONST | 3 | 72 | | 1 (0)| 00:00:01 | |*272 | INDEX RANGE SCAN | MN_53101_IDX1 | 12 | | | 0 (0)| 00:00:01 | | 273 | TABLE ACCESS BY INDEX ROWID | MN_MEMBER | 1 | 33 | | 1 (0)| 00:00:01 | |*274 | INDEX UNIQUE SCAN | MN_18815_PK | 1 | | | 0 (0)| 00:00:01 | |*275 | VIEW | | 1 | 41 | | 1 (0)| 00:00:01 | | 276 | UNION-ALL PARTITION | | | | | | | | 277 | NESTED LOOPS | | 1 | 92 | | 4 (0)| 00:00:01 | | 278 | NESTED LOOPS | | 1 | 92 | | 4 (0)| 00:00:01 | | 279 | NESTED LOOPS | | 1 | 58 | | 3 (0)| 00:00:01 | |*280 | INDEX UNIQUE SCAN | MN_11004_PK | 1 | 6 | | 1 (0)| 00:00:01 | |*281 | VIEW | | 1 | 52 | | 2 (0)| 00:00:01 | |*282 | TABLE ACCESS FULL | SYS_TEMP_0FD9D6D69_7EE0762F | 1 | 218 | | 2 (0)| 00:00:01 | |*283 | INDEX RANGE SCAN | REBATEPAYMENTGRP | 1 | | | 0 (0)| 00:00:01 | |*284 | TABLE ACCESS BY INDEX ROWID | MN_BUCKET_LINE | 1 | 34 | | 1 (0)| 00:00:01 | | 285 | NESTED LOOPS | | 1 | 96 | | 4 (0)| 00:00:01 | | 286 | NESTED LOOPS | | 1 | 96 | | 4 (0)| 00:00:01 | | 287 | NESTED LOOPS | | 1 | 58 | | 3 (0)| 00:00:01 | |*288 | INDEX UNIQUE SCAN | MN_11004_PK | 1 | 6 | | 1 (0)| 00:00:01 | |*289 | VIEW | | 1 | 52 | | 2 (0)| 00:00:01 | |*290 | TABLE ACCESS FULL | SYS_TEMP_0FD9D6D69_7EE0762F | 1 | 218 | | 2 (0)| 00:00:01 | |*291 | INDEX RANGE SCAN | MN_11108_PMT_ID_IDX | 1 | | | 0 (0)| 00:00:01 | |*292 | TABLE ACCESS BY INDEX ROWID | MN_MCO_BUCKET_LINE | 1 | 38 | | 1 (0)| 00:00:01 | |*293 | INDEX RANGE SCAN | CATMAPFLDIDX6 | 1 | 25 | | 0 (0)| 00:00:01 | -------------------------------------------------------------------------------------------------------------------------------------------- Predicate Information (identified by operation id): --------------------------------------------------- 7 - filter("ERP"."ORG_UNIT_ID"=10223 AND TRUNC(INTERNAL_FUNCTION("ERP"."ERP_PMT_DATE"))>=TO_DATE(' 2017-07-01 00:00:00', 'syyyy-mm-dd hh24:mi:ss') AND TRUNC(INTERNAL_FUNCTION("ERP"."ERP_PMT_DATE"))<=TO_DATE(' 2017-10-15 00:00:00', 'syyyy-mm-dd hh24:mi:ss') AND "ERP"."ERP_PMT_TYPE"=10) 9 - access("MAP_FIELD"."FLD_VALUE"="REV_PMT"."PRODUCT"(+) AND "REV_PMT"."REBATE_PMT_ID"(+)="REB"."REV_REBATE_PMT_FK") 13 - access("ERP"."PAYEE_ID"="MEM"."MEMBER_ID") 14 - access("CODE"="ERP"."ERP_PMT_TYPE" AND "NS_ID"="DYN_ENUM_NS_ID") 16 - access("CONT"."CTRT_SUB_TYPE"="CODE") 18 - access("NS_ID"= (SELECT "DYN_ENUM_NS_ID" FROM "REVM_TRAN"."MN_DYN_ENUM_NS" "MN_DYN_ENUM_NS" WHERE "NS_NAME"='ContractSubType')) 19 - filter("NS_NAME"='ContractSubType') 20 - access("CODE"="CONT"."STRUCT_DOC_TYPE" AND "NS_ID"="DYN_ENUM_NS_ID") 23 - access("PROG"."STRUCT_CONTRACT_ID"="DOC"."STRUCT_DOC_ID") 24 - access("REB"."REBATE_SUB_TYPE"=TO_NUMBER("RBT_SUB_TYPE"."CODE"(+))) 27 - access("NS_ID"= (SELECT "DYN_ENUM_NS_ID" FROM "REVM_TRAN"."MN_DYN_ENUM_NS" "MN_DYN_ENUM_NS" WHERE "NS_NAME"='RebateSubType')) 28 - filter("NS_NAME"='RebateSubType') 31 - access("ERP"."ERP_PMT_METHOD"="CONST_NAME" AND "NS_ID"="DYN_ENUM_NS_ID") 34 - access("REB"."CURR_PAY_PROG_ID"="PROG"."PAY_PROG_ID") 41 - filter("NS_NAME"='PaymentMethod') 43 - filter("NS_NAME"='ProgramType') 45 - filter("NS_NAME"='ContractType') 47 - filter("NS_NAME"='ERPPaymentType') 51 - access("REB"."REBATE_PMT_ID"="ERP"."REBATE_PMT_ID") 52 - filter("REB"."PYMT_PKG_FK" IS NOT NULL AND TO_DATE("MN_GLOBAL_PKG"."FORMAT_TIMESTAMP_WITHTZ"("REB"."START_DATE",'PST','yyyy-M M-dd'),'YYYY-MM-DD')>=TO_DATE(' 2017-01-01 00:00:00', 'syyyy-mm-dd hh24:mi:ss') AND TO_DATE("MN_GLOBAL_PKG"."FORMAT_TIMESTAMP_WITHTZ"("REB"."END_DATE",'PST','yyyy-MM-dd'),'YYYY-MM-DD')<=TO_DATE(' 2017-01-02 00:00:00', 'syyyy-mm-dd hh24:mi:ss')) 54 - access("REB"."PYMT_PKG_FK"="PYMT_PKG"."PYMT_PKG_ID") 57 - access("NS_ID"="DYN_ENUM_NS_ID") 58 - filter("REB"."PROGRAM_TYPE"="CODE") 60 - access(ROWID=ROWID) 63 - access("DOC"."STRUCT_DOC_ID"="CONT"."STRUCT_DOC_ID") 64 - filter("CONT"."CTRT_SUB_TYPE" IS NOT NULL) 67 - filter("ERP"."ERP_PMT_TYPE"="ERP_PMT_TYPE" AND "ERP"."ERP_PMT_DATE"="ERP_PMT_DATE") 74 - access("REB"."REBATE_PMT_ID"="REB"."REBATE_PMT_ID") 75 - filter("REB"."REBATE_PMT_ID"="ERP"."REBATE_PMT_ID" AND "ERP"."REBATE_PMT_ID"="REB"."REBATE_PMT_ID") 76 - filter("C16"=10223) 77 - access("REB"."REBATE_PMT_ID"="BKT_LINE"."REBATE_PMT_ID") filter("BKT_LINE"."REBATE_PMT_ID"="REB"."REBATE_PMT_ID") 78 - filter("BKT_LINE"."PMT_BENEFIT_ID" IS NOT NULL AND TO_DATE("MN_GLOBAL_PKG"."FORMAT_TIMESTAMP_WITHTZ"("BKT_LINE"."SALE_INV_DAT E_SQL",'PST','yyyy-MM-dd'),'YYYY-MM-DD')>=TO_DATE(' 2017-01-01 00:00:00', 'syyyy-mm-dd hh24:mi:ss') AND TO_DATE("MN_GLOBAL_PKG"."FORMAT_TIMESTAMP_WITHTZ"("BKT_LINE"."SALE_INV_DATE_SQL",'PST','yyyy-MM-dd'),'YYYY-MM-DD')<=TO_DATE(' 2017-01-02 00:00:00', 'syyyy-mm-dd hh24:mi:ss') AND "BKT_LINE"."INCLUSION_TYPE"='INC') 83 - access("REB"."REBATE_PMT_ID"="REB"."REBATE_PMT_ID") 84 - filter("REB"."REBATE_PMT_ID"="ERP"."REBATE_PMT_ID" AND "ERP"."REBATE_PMT_ID"="REB"."REBATE_PMT_ID") 85 - filter("C16"=10223) 86 - access("REB"."REBATE_PMT_ID"="BKT_LINE"."REBATE_PMT_ID") filter("BKT_LINE"."REBATE_PMT_ID"="REB"."REBATE_PMT_ID") 87 - filter(TO_DATE("MN_GLOBAL_PKG"."FORMAT_TIMESTAMP_WITHTZ"("BKT_LINE"."SALE_INV_DATE_SQL",'PST','yyyy-MM-dd'),'YYYY-MM-DD')>=TO _DATE(' 2017-01-01 00:00:00', 'syyyy-mm-dd hh24:mi:ss') AND TO_DATE("MN_GLOBAL_PKG"."FORMAT_TIMESTAMP_WITHTZ"("BKT_LINE"."SALE_INV_D ATE_SQL",'PST','yyyy-MM-dd'),'YYYY-MM-DD')<=TO_DATE(' 2017-01-02 00:00:00', 'syyyy-mm-dd hh24:mi:ss') AND "BKT_LINE"."INCLUSION_TYPE"='INC' AND "BKT_LINE"."PMT_BENEFIT_ID" IS NOT NULL) 88 - access("FLD_NAME"='tradeName' AND "MAP_FIELD"."CAT_MAP_ID"="SALE_ITEM_ID") filter("MAP_FIELD"."CAT_MAP_ID"="SALE_ITEM_ID") 93 - access("MAP_FIELD1"."CAT_MAP_ID"="BKT_LINE1"."SALE_ITEM_ID") 94 - access("FLD_NAME"='tradeName') 97 - filter(TO_DATE("MN_GLOBAL_PKG"."FORMAT_TIMESTAMP_WITHTZ"("RBT_PAY1"."START_DATE",'PST','yyyy-MM-dd'),'YYYY-MM-DD')>=TO_DATE(' 2017-01-01 00:00:00', 'syyyy-mm-dd hh24:mi:ss') AND TO_DATE("MN_GLOBAL_PKG"."FORMAT_TIMESTAMP_WITHTZ"("RBT_PAY1"."END_DATE",'PST',' yyyy-MM-dd'),'YYYY-MM-DD')<=TO_DATE(' 2017-01-02 00:00:00', 'syyyy-mm-dd hh24:mi:ss')) 98 - access("RBT_PAY1"."REBATE_PMT_ID"="BKT_LINE1"."REBATE_PMT_ID") 100 - access("MAP_FIELD1"."CAT_MAP_ID"="BKT_LINE1"."SALE_ITEM_ID") 101 - access("FLD_NAME"='tradeName') 104 - filter(TO_DATE("MN_GLOBAL_PKG"."FORMAT_TIMESTAMP_WITHTZ"("RBT_PAY1"."START_DATE",'PST','yyyy-MM-dd'),'YYYY-MM-DD')>=TO_DATE(' 2017-01-01 00:00:00', 'syyyy-mm-dd hh24:mi:ss') AND TO_DATE("MN_GLOBAL_PKG"."FORMAT_TIMESTAMP_WITHTZ"("RBT_PAY1"."END_DATE",'PST',' yyyy-MM-dd'),'YYYY-MM-DD')<=TO_DATE(' 2017-01-02 00:00:00', 'syyyy-mm-dd hh24:mi:ss')) 105 - access("RBT_PAY1"."REBATE_PMT_ID"="BKT_LINE1"."REBATE_PMT_ID") 110 - filter(("ERP"."ERP_PMT_TYPE"=20 OR "ERP"."ERP_PMT_TYPE"=30) AND "ERP"."ORG_UNIT_ID"=10223 AND TRUNC(INTERNAL_FUNCTION("ERP"."ERP_PMT_DATE"))>=TO_DATE(' 2017-07-01 00:00:00', 'syyyy-mm-dd hh24:mi:ss') AND TRUNC(INTERNAL_FUNCTION("ERP"."ERP_PMT_DATE"))<=TO_DATE(' 2017-10-15 00:00:00', 'syyyy-mm-dd hh24:mi:ss')) 112 - filter("REB"."REV_REBATE_PMT_FK" IS NOT NULL AND TO_DATE("MN_GLOBAL_PKG"."FORMAT_TIMESTAMP_WITHTZ"("REB"."START_DATE",'PST',' yyyy-MM-dd'),'YYYY-MM-DD')>=TO_DATE(' 2017-01-01 00:00:00', 'syyyy-mm-dd hh24:mi:ss') AND TO_DATE("MN_GLOBAL_PKG"."FORMAT_TIMESTAMP_WITHTZ"("REB"."END_DATE",'PST','yyyy-MM-dd'),'YYYY-MM-DD')<=TO_DATE(' 2017-01-02 00:00:00', 'syyyy-mm-dd hh24:mi:ss')) 114 - access("REV_PMT"."REBATE_PMT_ID"="REB"."REV_REBATE_PMT_FK" AND "MAP_FIELD"."FLD_VALUE"="REV_PMT"."PRODUCT") 125 - access("REB"."REBATE_SUB_TYPE"=TO_NUMBER("RBT_SUB_TYPE"."CODE"(+))) 131 - access("REB"."REBATE_PMT_ID"="ERP"."REBATE_PMT_ID") 136 - filter("NS_NAME"='PaymentMethod') 138 - filter("NS_NAME"='ProgramType') 140 - filter("NS_NAME"='ContractType') 142 - filter("NS_NAME"='ERPPaymentType') 149 - access("REB"."CURR_PAY_PROG_ID"="PROG"."PAY_PROG_ID") 151 - access("REB"."PYMT_PKG_FK"="PYMT_PKG"."PYMT_PKG_ID") 152 - filter("ERP"."ERP_PMT_METHOD"="CONST_NAME") 153 - access("NS_ID"="DYN_ENUM_NS_ID") 154 - access("NS_ID"="DYN_ENUM_NS_ID") 155 - filter("REB"."PROGRAM_TYPE"="CODE") 158 - access("NS_ID"= (SELECT "DYN_ENUM_NS_ID" FROM "REVM_TRAN"."MN_DYN_ENUM_NS" "MN_DYN_ENUM_NS" WHERE "NS_NAME"='RebateSubType')) 159 - filter("NS_NAME"='RebateSubType') 161 - access("PROG"."STRUCT_CONTRACT_ID"="DOC"."STRUCT_DOC_ID") 162 - filter("CONT"."CTRT_SUB_TYPE" IS NOT NULL) 163 - access("DOC"."STRUCT_DOC_ID"="CONT"."STRUCT_DOC_ID") 164 - filter("CODE"="CONT"."STRUCT_DOC_TYPE") 165 - access("NS_ID"="DYN_ENUM_NS_ID") 166 - filter("CONT"."CTRT_SUB_TYPE"="CODE") 167 - access("NS_ID"= (SELECT "DYN_ENUM_NS_ID" FROM "REVM_TRAN"."MN_DYN_ENUM_NS" "MN_DYN_ENUM_NS" WHERE "NS_NAME"='ContractSubType')) 168 - filter("NS_NAME"='ContractSubType') 169 - filter("CODE"="ERP"."ERP_PMT_TYPE") 170 - access("NS_ID"="DYN_ENUM_NS_ID") 172 - access("ERP"."PAYEE_ID"="MEM"."MEMBER_ID") 173 - filter("ERP"."ERP_PMT_TYPE"="ERP_PMT_TYPE" AND "ERP"."ERP_PMT_DATE"="ERP_PMT_DATE") 178 - access("REB"."REBATE_PMT_ID"="REB"."REBATE_PMT_ID") 179 - filter("REB"."REBATE_PMT_ID"="ERP"."REBATE_PMT_ID" AND "ERP"."REBATE_PMT_ID"="REB"."REBATE_PMT_ID") 180 - filter("C16"=10223) 181 - access("REB"."REBATE_PMT_ID"="BKT_LINE"."REBATE_PMT_ID") filter("BKT_LINE"."REBATE_PMT_ID"="REB"."REBATE_PMT_ID") 182 - filter("BKT_LINE"."PMT_BENEFIT_ID" IS NOT NULL AND TO_DATE("MN_GLOBAL_PKG"."FORMAT_TIMESTAMP_WITHTZ"("BKT_LINE"."SALE_INV_DAT E_SQL",'PST','yyyy-MM-dd'),'YYYY-MM-DD')>=TO_DATE(' 2017-01-01 00:00:00', 'syyyy-mm-dd hh24:mi:ss') AND TO_DATE("MN_GLOBAL_PKG"."FORMAT_TIMESTAMP_WITHTZ"("BKT_LINE"."SALE_INV_DATE_SQL",'PST','yyyy-MM-dd'),'YYYY-MM-DD')<=TO_DATE(' 2017-01-02 00:00:00', 'syyyy-mm-dd hh24:mi:ss') AND "BKT_LINE"."INCLUSION_TYPE"='INC') 186 - access("REB"."REBATE_PMT_ID"="REB"."REBATE_PMT_ID") 187 - filter("REB"."REBATE_PMT_ID"="ERP"."REBATE_PMT_ID" AND "ERP"."REBATE_PMT_ID"="REB"."REBATE_PMT_ID") 188 - filter("C16"=10223) 189 - access("REB"."REBATE_PMT_ID"="BKT_LINE"."REBATE_PMT_ID") filter("BKT_LINE"."REBATE_PMT_ID"="REB"."REBATE_PMT_ID") 190 - filter(TO_DATE("MN_GLOBAL_PKG"."FORMAT_TIMESTAMP_WITHTZ"("BKT_LINE"."SALE_INV_DATE_SQL",'PST','yyyy-MM-dd'),'YYYY-MM-DD')>=TO _DATE(' 2017-01-01 00:00:00', 'syyyy-mm-dd hh24:mi:ss') AND TO_DATE("MN_GLOBAL_PKG"."FORMAT_TIMESTAMP_WITHTZ"("BKT_LINE"."SALE_INV_D ATE_SQL",'PST','yyyy-MM-dd'),'YYYY-MM-DD')<=TO_DATE(' 2017-01-02 00:00:00', 'syyyy-mm-dd hh24:mi:ss') AND "BKT_LINE"."INCLUSION_TYPE"='INC' AND "BKT_LINE"."PMT_BENEFIT_ID" IS NOT NULL) 191 - access("FLD_NAME"='tradeName' AND "MAP_FIELD"."CAT_MAP_ID"="SALE_ITEM_ID") filter("MAP_FIELD"."CAT_MAP_ID"="SALE_ITEM_ID") 192 - access("RBTPMT"."ITEM_ID"="SALE_ITEM_ID") 193 - filter("RBTPMT"."REBATE_BUCKET_LINE_ID"="BUCKET_LINE_ID" AND (CASE WHEN ("REB"."PMT_STATUS"='REV' AND "ERP"."ERP_PMT_TYPE"=30) THEN "RBTPMT"."REBATE_REVERSAL_STATUS" ELSE 'NONE' END ='NONE' OR CASE WHEN ("REB"."PMT_STATUS"='REV' AND "ERP"."ERP_PMT_TYPE"=30) THEN "RBTPMT"."REBATE_REVERSAL_STATUS" ELSE 'NONE' END ='REPLCMNT') AND CASE "ERP"."ERP_PMT_TYPE" WHEN 20 THEN "RBTPMT"."REBATE_REVERSAL_STATUS" ELSE 'REVERSAL' END ='REVERSAL') 198 - access("MAP_FIELD1"."CAT_MAP_ID"="BKT_LINE1"."SALE_ITEM_ID") 201 - filter(TO_DATE("MN_GLOBAL_PKG"."FORMAT_TIMESTAMP_WITHTZ"("RBT_PAY1"."START_DATE",'PST','yyyy-MM-dd'),'YYYY-MM-DD')>=TO_DATE(' 2017-01-01 00:00:00', 'syyyy-mm-dd hh24:mi:ss') AND TO_DATE("MN_GLOBAL_PKG"."FORMAT_TIMESTAMP_WITHTZ"("RBT_PAY1"."END_DATE",'PST',' yyyy-MM-dd'),'YYYY-MM-DD')<=TO_DATE(' 2017-01-02 00:00:00', 'syyyy-mm-dd hh24:mi:ss')) 202 - access("RBT_PAY1"."REBATE_PMT_ID"="BKT_LINE1"."REBATE_PMT_ID") 203 - filter(TO_DATE("MN_GLOBAL_PKG"."FORMAT_TIMESTAMP_WITHTZ"("BKT_LINE1"."SALE_INV_DATE_SQL",'PST','yyyy-MM-dd'),'YYYY-MM-DD')>=T O_DATE(' 2017-01-01 00:00:00', 'syyyy-mm-dd hh24:mi:ss') AND TO_DATE("MN_GLOBAL_PKG"."FORMAT_TIMESTAMP_WITHTZ"("BKT_LINE1"."SALE_INV _DATE_SQL",'PST','yyyy-MM-dd'),'YYYY-MM-DD')<=TO_DATE(' 2017-01-02 00:00:00', 'syyyy-mm-dd hh24:mi:ss')) 204 - access("FLD_NAME"='tradeName') 205 - access("MAP_FIELD1"."CAT_MAP_ID"="BKT_LINE1"."SALE_ITEM_ID") 208 - filter(TO_DATE("MN_GLOBAL_PKG"."FORMAT_TIMESTAMP_WITHTZ"("RBT_PAY1"."START_DATE",'PST','yyyy-MM-dd'),'YYYY-MM-DD')>=TO_DATE(' 2017-01-01 00:00:00', 'syyyy-mm-dd hh24:mi:ss') AND TO_DATE("MN_GLOBAL_PKG"."FORMAT_TIMESTAMP_WITHTZ"("RBT_PAY1"."END_DATE",'PST',' yyyy-MM-dd'),'YYYY-MM-DD')<=TO_DATE(' 2017-01-02 00:00:00', 'syyyy-mm-dd hh24:mi:ss')) 209 - access("RBT_PAY1"."REBATE_PMT_ID"="BKT_LINE1"."REBATE_PMT_ID") 210 - filter(TO_DATE("MN_GLOBAL_PKG"."FORMAT_TIMESTAMP_WITHTZ"("BKT_LINE1"."SALE_INV_DATE_SQL",'PST','yyyy-MM-dd'),'YYYY-MM-DD')>=T O_DATE(' 2017-01-01 00:00:00', 'syyyy-mm-dd hh24:mi:ss') AND TO_DATE("MN_GLOBAL_PKG"."FORMAT_TIMESTAMP_WITHTZ"("BKT_LINE1"."SALE_INV _DATE_SQL",'PST','yyyy-MM-dd'),'YYYY-MM-DD')<=TO_DATE(' 2017-01-02 00:00:00', 'syyyy-mm-dd hh24:mi:ss')) 211 - access("FLD_NAME"='tradeName') 215 - filter(("ERP"."ERP_PMT_TYPE"=20 OR "ERP"."ERP_PMT_TYPE"=30) AND "ERP"."ORG_UNIT_ID"=10223 AND TRUNC(INTERNAL_FUNCTION("ERP"."ERP_PMT_DATE"))>=TO_DATE(' 2017-07-01 00:00:00', 'syyyy-mm-dd hh24:mi:ss') AND TRUNC(INTERNAL_FUNCTION("ERP"."ERP_PMT_DATE"))<=TO_DATE(' 2017-10-15 00:00:00', 'syyyy-mm-dd hh24:mi:ss')) 217 - filter("REB"."REV_REBATE_PMT_FK" IS NULL AND TO_DATE("MN_GLOBAL_PKG"."FORMAT_TIMESTAMP_WITHTZ"("REB"."START_DATE",'PST','yyyy -MM-dd'),'YYYY-MM-DD')>=TO_DATE(' 2017-01-01 00:00:00', 'syyyy-mm-dd hh24:mi:ss') AND TO_DATE("MN_GLOBAL_PKG"."FORMAT_TIMESTAMP_WITHTZ"("REB"."END_DATE",'PST','yyyy-MM-dd'),'YYYY-MM-DD')<=TO_DATE(' 2017-01-02 00:00:00', 'syyyy-mm-dd hh24:mi:ss')) 227 - access("REB"."REBATE_SUB_TYPE"=TO_NUMBER("RBT_SUB_TYPE"."CODE"(+))) 233 - access("REB"."REBATE_PMT_ID"="ERP"."REBATE_PMT_ID") 238 - filter("NS_NAME"='PaymentMethod') 240 - filter("NS_NAME"='ProgramType') 242 - filter("NS_NAME"='ContractType') 244 - filter("NS_NAME"='ERPPaymentType') 251 - access("REB"."CURR_PAY_PROG_ID"="PROG"."PAY_PROG_ID") 253 - access("REB"."PYMT_PKG_FK"="PYMT_PKG"."PYMT_PKG_ID") 254 - filter("ERP"."ERP_PMT_METHOD"="CONST_NAME") 255 - access("NS_ID"="DYN_ENUM_NS_ID") 256 - access("NS_ID"="DYN_ENUM_NS_ID") 257 - filter("REB"."PROGRAM_TYPE"="CODE") 260 - access("NS_ID"= (SELECT "DYN_ENUM_NS_ID" FROM "REVM_TRAN"."MN_DYN_ENUM_NS" "MN_DYN_ENUM_NS" WHERE "NS_NAME"='RebateSubType')) 261 - filter("NS_NAME"='RebateSubType') 263 - access("PROG"."STRUCT_CONTRACT_ID"="DOC"."STRUCT_DOC_ID") 264 - filter("CONT"."CTRT_SUB_TYPE" IS NOT NULL) 265 - access("DOC"."STRUCT_DOC_ID"="CONT"."STRUCT_DOC_ID") 266 - filter("CODE"="CONT"."STRUCT_DOC_TYPE") 267 - access("NS_ID"="DYN_ENUM_NS_ID") 268 - filter("CONT"."CTRT_SUB_TYPE"="CODE") 269 - access("NS_ID"= (SELECT "DYN_ENUM_NS_ID" FROM "REVM_TRAN"."MN_DYN_ENUM_NS" "MN_DYN_ENUM_NS" WHERE "NS_NAME"='ContractSubType')) 270 - filter("NS_NAME"='ContractSubType') 271 - filter("CODE"="ERP"."ERP_PMT_TYPE") 272 - access("NS_ID"="DYN_ENUM_NS_ID") 274 - access("ERP"."PAYEE_ID"="MEM"."MEMBER_ID") 275 - filter("ERP"."ERP_PMT_TYPE"="ERP_PMT_TYPE" AND "ERP"."ERP_PMT_DATE"="ERP_PMT_DATE") 280 - access("REB"."REBATE_PMT_ID"="REB"."REBATE_PMT_ID") 281 - filter("REB"."REBATE_PMT_ID"="ERP"."REBATE_PMT_ID" AND "ERP"."REBATE_PMT_ID"="REB"."REBATE_PMT_ID") 282 - filter("C16"=10223) 283 - access("REB"."REBATE_PMT_ID"="BKT_LINE"."REBATE_PMT_ID") filter("BKT_LINE"."REBATE_PMT_ID"="REB"."REBATE_PMT_ID") 284 - filter("BKT_LINE"."PMT_BENEFIT_ID" IS NOT NULL AND TO_DATE("MN_GLOBAL_PKG"."FORMAT_TIMESTAMP_WITHTZ"("BKT_LINE"."SALE_INV_DAT E_SQL",'PST','yyyy-MM-dd'),'YYYY-MM-DD')>=TO_DATE(' 2017-01-01 00:00:00', 'syyyy-mm-dd hh24:mi:ss') AND TO_DATE("MN_GLOBAL_PKG"."FORMAT_TIMESTAMP_WITHTZ"("BKT_LINE"."SALE_INV_DATE_SQL",'PST','yyyy-MM-dd'),'YYYY-MM-DD')<=TO_DATE(' 2017-01-02 00:00:00', 'syyyy-mm-dd hh24:mi:ss') AND "BKT_LINE"."INCLUSION_TYPE"='INC') 288 - access("REB"."REBATE_PMT_ID"="REB"."REBATE_PMT_ID") 289 - filter("REB"."REBATE_PMT_ID"="ERP"."REBATE_PMT_ID" AND "ERP"."REBATE_PMT_ID"="REB"."REBATE_PMT_ID") 290 - filter("C16"=10223) 291 - access("REB"."REBATE_PMT_ID"="BKT_LINE"."REBATE_PMT_ID") filter("BKT_LINE"."REBATE_PMT_ID"="REB"."REBATE_PMT_ID") 292 - filter(TO_DATE("MN_GLOBAL_PKG"."FORMAT_TIMESTAMP_WITHTZ"("BKT_LINE"."SALE_INV_DATE_SQL",'PST','yyyy-MM-dd'),'YYYY-MM-DD')>=TO _DATE(' 2017-01-01 00:00:00', 'syyyy-mm-dd hh24:mi:ss') AND TO_DATE("MN_GLOBAL_PKG"."FORMAT_TIMESTAMP_WITHTZ"("BKT_LINE"."SALE_INV_D ATE_SQL",'PST','yyyy-MM-dd'),'YYYY-MM-DD')<=TO_DATE(' 2017-01-02 00:00:00', 'syyyy-mm-dd hh24:mi:ss') AND "BKT_LINE"."INCLUSION_TYPE"='INC' AND "BKT_LINE"."PMT_BENEFIT_ID" IS NOT NULL) 293 - access("FLD_NAME"='tradeName' AND "MAP_FIELD"."CAT_MAP_ID"="SALE_ITEM_ID") filter("MAP_FIELD"."CAT_MAP_ID"="SALE_ITEM_ID") Note ----- - dynamic sampling used for this statement (level=4)