PLAN_TABLE_OUTPUT --------------------------------------------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes | Cost | --------------------------------------------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 480 | 430K| 888 | | 1 | SORT GROUP BY | | 480 | 430K| 888 | |* 2 | HASH JOIN | | 480 | 430K| 805 | | 3 | TABLE ACCESS FULL | FND_PROFILE_OPTION_VALUES | 4377 | 43770 | 9 | |* 4 | HASH JOIN OUTER | | 381 | 337K| 794 | |* 5 | HASH JOIN OUTER | | 381 | 226K| 59 | |* 6 | HASH JOIN | | 381 | 213K| 54 | | 7 | TABLE ACCESS FULL | HZ_PARTIES | 383 | 4979 | 5 | | 8 | NESTED LOOPS OUTER | | 381 | 208K| 48 | |* 9 | FILTER | | | | | |* 10 | HASH JOIN OUTER | | 381 | 206K| 48 | | 11 | NESTED LOOPS OUTER | | 381 | 198K| 41 | |* 12 | FILTER | | | | | | 13 | NESTED LOOPS OUTER | | 381 | 180K| 41 | | 14 | NESTED LOOPS OUTER | | 381 | 159K| 41 | | 15 | NESTED LOOPS | | 381 | 141K| 41 | |* 16 | HASH JOIN | | 381 | 140K| 41 | |* 17 | TABLE ACCESS FULL | HZ_CUSTOMER_PROFILES | 381 | 8001 | 4 | |* 18 | HASH JOIN OUTER | | 381 | 132K| 36 | |* 19 | HASH JOIN OUTER | | 381 | 119K| 31 | |* 20 | HASH JOIN OUTER | | 381 | 105K| 27 | |* 21 | HASH JOIN OUTER | | 381 | 104K| 23 | |* 22 | HASH JOIN OUTER | | 381 | 92964 | 19 | | 23 | NESTED LOOPS OUTER | | 381 | 79248 | 15 | | 24 | NESTED LOOPS OUTER | | 381 | 74295 | 15 | |* 25 | HASH JOIN OUTER | | 381 | 69342 | 15 | | 26 | NESTED LOOPS OUTER | | 381 | 55626 | 11 | |* 27 | HASH JOIN | | 381 | 54102 | 11 | | 28 | NESTED LOOPS | | 381 | 13716 | 6 | | 29 | TABLE ACCESS BY INDEX ROWID| FND_PROFILE_OPTIONS | 1 | 28 | 2 | |* 30 | INDEX UNIQUE SCAN | FND_PROFILE_OPTIONS_U2 | 1 | | 1 | | 31 | TABLE ACCESS FULL | HZ_CUST_ACCOUNTS | 381 | 3048 | 4 | | 32 | TABLE ACCESS FULL | HZ_CUST_ACCOUNTS | 381 | 40386 | 4 | |* 33 | INDEX UNIQUE SCAN | HR_ORGANIZATION_UNITS_PK | 1 | 4 | | |* 34 | INDEX RANGE SCAN | FND_LOOKUP_VALUES_U1 | 1 | 36 | 3 | | 35 | VIEW PUSHED PREDICATE | OE_ORDER_TYPES_115 | 1 | 13 | | | 36 | NESTED LOOPS | | 1 | 43 | 1 | |* 37 | TABLE ACCESS BY INDEX ROWID | OE_TRANSACTION_TYPES_ALL | 1 | 26 | 1 | |* 38 | INDEX UNIQUE SCAN | OE_TRANSACTION_TYPES_ALL_U1 | 1 | | | |* 39 | INDEX UNIQUE SCAN | OE_TRANSACTION_TYPES_TL_U1 | 1 | 17 | | | 40 | VIEW PUSHED PREDICATE | OE_PRICE_LISTS_115_VL | 1 | 13 | | | 41 | NESTED LOOPS | | 1 | 62 | 1 | |* 42 | TABLE ACCESS BY INDEX ROWID | QP_LIST_HEADERS_B | 1 | 45 | 1 | |* 43 | INDEX UNIQUE SCAN | QP_LIST_HEADERS_B_PK | 1 | | | |* 44 | INDEX UNIQUE SCAN | QP_LIST_HEADERS_TL_PK | 1 | 17 | | |* 45 | INDEX RANGE SCAN | FND_LOOKUP_VALUES_U1 | 1 | 36 | 3 | |* 46 | INDEX RANGE SCAN | FND_LOOKUP_VALUES_U1 | 1 | 36 | 3 | | 47 | VIEW | RA_SALESREPS | 1 | 4 | 1 | | 48 | NESTED LOOPS | | 1 | 37 | 3 | | 49 | NESTED LOOPS | | 1 | 23 | 3 | |* 50 | TABLE ACCESS FULL | JTF_RS_SALESREPS | 1 | 12 | 2 | |* 51 | TABLE ACCESS BY INDEX ROWID | JTF_RS_RESOURCE_EXTNS | 1 | 11 | 1 | |* 52 | INDEX UNIQUE SCAN | JTF_RS_RESOURCE_EXTNS_U1 | 1 | | | | 53 | INLIST ITERATOR | | | | | |* 54 | INDEX UNIQUE SCAN | JTF_RS_EXTNS_U1 | 1 | 14 | | |* 55 | INDEX RANGE SCAN | FND_LOOKUP_VALUES_U1 | 1 | 36 | 3 | |* 56 | INDEX RANGE SCAN | FND_LOOKUP_VALUES_U1 | 1 | 36 | 3 | |* 57 | INDEX UNIQUE SCAN | HZ_PARTIES_U1 | 1 | 4 | | |* 58 | INDEX RANGE SCAN | HZ_CONTACT_POINTS_N6 | 1 | 49 | | |* 59 | TABLE ACCESS BY INDEX ROWID | HZ_PERSON_PROFILES | 1 | 56 | | |* 60 | INDEX RANGE SCAN | HZ_PERSON_PROFILES_N1 | 1 | | | |* 61 | TABLE ACCESS BY INDEX ROWID | HZ_CONTACT_PREFERENCES | 1 | 47 | | |* 62 | INDEX RANGE SCAN | HZ_CONTACT_PREFERENCES_N1 | 1 | | | |* 63 | TABLE ACCESS FULL | HZ_ORGANIZATION_PROFILES | 4 | 92 | 5 | |* 64 | INDEX UNIQUE SCAN | HZ_CUST_PROFILE_CLASSES_U1 | 1 | 4 | | |* 65 | INDEX RANGE SCAN | FND_LOOKUP_VALUES_U1 | 1 | 36 | 3 | | 66 | VIEW | CISO_EAL_SUMMARY_B | 27 | 8073 | 733 | | 67 | SORT GROUP BY | | 27 | 8073 | 733 | | 68 | VIEW | | 27 | 8073 | 714 | | 69 | UNION-ALL | | | | | | 70 | VIEW | CISO_EAL_INVOICED | 2 | 80 | 105 | | 71 | SORT UNIQUE | | 2 | 477 | 105 | | 72 | UNION-ALL | | | | | | 73 | SORT GROUP BY | | 1 | 224 | 50 | | 74 | NESTED LOOPS | | 1 | 224 | 1 | | 75 | NESTED LOOPS | | 1 | 201 | 1 | | 76 | NESTED LOOPS | | 1 | 85 | 1 | |* 77 | TABLE ACCESS BY INDEX ROWID | AP_PAYMENT_SCHEDULES_ALL | 1 | 36 | 1 | |* 78 | INDEX RANGE SCAN | AP_PAYMENT_SCHEDULES_N2 | 1 | | 1 | |* 79 | TABLE ACCESS BY INDEX ROWID | AP_INVOICES_ALL | 1 | 49 | | |* 80 | INDEX UNIQUE SCAN | AP_INVOICES_U1 | 1 | | | | 81 | TABLE ACCESS BY INDEX ROWID | AP_INVOICE_DISTRIBUTIONS_ALL | 1 | 116 | | |* 82 | INDEX RANGE SCAN | AP_INVOICE_DISTRIBUTIONS_U1 | 1 | | | | 83 | TABLE ACCESS BY INDEX ROWID | GL_CODE_COMBINATIONS | 1 | 23 | | |* 84 | INDEX UNIQUE SCAN | GL_CODE_COMBINATIONS_U1 | 1 | | | | 85 | SORT GROUP BY | | 1 | 253 | 55 | |* 86 | TABLE ACCESS BY INDEX ROWID | RA_CUST_TRX_TYPES_ALL | 1 | 17 | 1 | | 87 | NESTED LOOPS | | 1 | 253 | 3 | | 88 | NESTED LOOPS | | 1 | 236 | 2 | | 89 | NESTED LOOPS | | 1 | 191 | 2 | | 90 | NESTED LOOPS | | 1 | 165 | 2 | | 91 | NESTED LOOPS | | 1 | 49 | 2 | | 92 | TABLE ACCESS FULL | RA_CUST_TRX_LINE_GL_DIST_ALL | 1 | 26 | 2 | | 93 | TABLE ACCESS BY INDEX ROWID | GL_CODE_COMBINATIONS | 1 | 23 | | |* 94 | INDEX UNIQUE SCAN | GL_CODE_COMBINATIONS_U1 | 1 | | | | 95 | TABLE ACCESS BY INDEX ROWID | RA_CUSTOMER_TRX_LINES_ALL | 1 | 116 | | |* 96 | INDEX UNIQUE SCAN | RA_CUSTOMER_TRX_LINES_U1 | 1 | | | | 97 | TABLE ACCESS BY INDEX ROWID | RA_CUSTOMER_TRX_ALL | 1 | 26 | | |* 98 | INDEX UNIQUE SCAN | RA_CUSTOMER_TRX_U1 | 1 | | | |* 99 | TABLE ACCESS BY INDEX ROWID | AR_RECEIVABLES_TRX_ALL | 1 | 27 | 2 | | 100 | NESTED LOOPS | | 1 | 53 | 3 | | 101 | TABLE ACCESS BY INDEX ROWID | AR_ADJUSTMENTS_ALL | 1 | 26 | 1 | |*102 | INDEX RANGE SCAN | AR_ADJUSTMENTS_N2 | 1 | | 1 | |*103 | INDEX RANGE SCAN | AR_RECEIVABLES_TRX_U1 | 2 | | 1 | |*104 | TABLE ACCESS BY INDEX ROWID | AR_PAYMENT_SCHEDULES_ALL | 1 | 45 | | |*105 | INDEX RANGE SCAN | AR_PAYMENT_SCHEDULES_N2 | 8 | | | |*106 | INDEX RANGE SCAN | RA_CUST_TRX_TYPES_U1 | 2 | | 1 | | 107 | SORT GROUP BY | | 1 | 156 | 28 | | 108 | NESTED LOOPS | | 1 | 156 | 3 | | 109 | NESTED LOOPS | | 1 | 133 | 2 | | 110 | INLIST ITERATOR | | | | | |*111 | TABLE ACCESS BY INDEX ROWID | GL_JE_LINES | 1 | 122 | 1 | |*112 | INDEX RANGE SCAN | CISO_GL_JE_LINES_N1 | 1 | | | |*113 | TABLE ACCESS BY INDEX ROWID | GL_SETS_OF_BOOKS | 1 | 11 | 1 | |*114 | INDEX UNIQUE SCAN | GL_SETS_OF_BOOKS_U2 | 1 | | | |*115 | TABLE ACCESS BY INDEX ROWID | GL_CODE_COMBINATIONS | 1 | 23 | 1 | |*116 | INDEX UNIQUE SCAN | GL_CODE_COMBINATIONS_U1 | 1 | | | | 117 | NESTED LOOPS | | 1 | 151 | 3 | | 118 | NESTED LOOPS | | 1 | 133 | 2 | | 119 | INLIST ITERATOR | | | | | |*120 | TABLE ACCESS BY INDEX ROWID | GL_JE_LINES | 1 | 122 | 1 | |*121 | INDEX RANGE SCAN | CISO_GL_JE_LINES_N1 | 1 | | | |*122 | TABLE ACCESS BY INDEX ROWID | GL_SETS_OF_BOOKS | 1 | 11 | 1 | |*123 | INDEX UNIQUE SCAN | GL_SETS_OF_BOOKS_U2 | 1 | | | |*124 | TABLE ACCESS BY INDEX ROWID | GL_CODE_COMBINATIONS | 1 | 18 | 1 | |*125 | INDEX UNIQUE SCAN | GL_CODE_COMBINATIONS_U1 | 1 | | | | 126 | SORT GROUP BY | | 2 | 154 | 111 | | 127 | VIEW | | 2 | 154 | 87 | | 128 | UNION-ALL | | | | | | 129 | SORT GROUP BY | | 1 | 284 | 47 | | 130 | NESTED LOOPS | | 1 | 284 | 22 | |*131 | HASH JOIN | | 1 | 280 | 22 | | 132 | NESTED LOOPS | | 1 | 270 | 12 | | 133 | NESTED LOOPS | | 1 | 184 | 11 | |*134 | HASH JOIN | | 1 | 161 | 10 | | 135 | NESTED LOOPS | | 1 | 39 | 4 | | 136 | TABLE ACCESS BY INDEX ROWID | FND_PROFILE_OPTIONS | 1 | 28 | 2 | |*137 | INDEX UNIQUE SCAN | FND_PROFILE_OPTIONS_U2 | 1 | | 1 | |*138 | TABLE ACCESS FULL | GL_SETS_OF_BOOKS | 1 | 11 | 2 | |*139 | TABLE ACCESS FULL | GL_JE_LINES | 15 | 1830 | 5 | |*140 | TABLE ACCESS BY INDEX ROWID | GL_CODE_COMBINATIONS | 1 | 23 | 1 | |*141 | INDEX UNIQUE SCAN | GL_CODE_COMBINATIONS_U1 | 1 | | | | 142 | TABLE ACCESS BY INDEX ROWID | HZ_CUST_ACCOUNTS | 1 | 86 | 1 | |*143 | INDEX UNIQUE SCAN | HZ_CUST_ACCOUNTS_U2 | 1 | | | | 144 | TABLE ACCESS FULL | FND_PROFILE_OPTION_VALUES | 4377 | 43770 | 9 | |*145 | INDEX UNIQUE SCAN | HZ_PARTIES_U1 | 1 | 4 | | | 146 | SORT GROUP BY | | 1 | 284 | 40 | |*147 | HASH JOIN | | 1 | 284 | 15 | | 148 | NESTED LOOPS | | 1 | 274 | 5 | | 149 | NESTED LOOPS | | 1 | 263 | 4 | | 150 | NESTED LOOPS | | 1 | 259 | 4 | | 151 | NESTED LOOPS | | 1 | 173 | 3 | | 152 | NESTED LOOPS | | 1 | 150 | 2 | | 153 | TABLE ACCESS BY INDEX ROWID | FND_PROFILE_OPTIONS | 1 | 28 | 2 | |*154 | INDEX UNIQUE SCAN | FND_PROFILE_OPTIONS_U2 | 1 | | 1 | | 155 | INLIST ITERATOR | | | | | |*156 | TABLE ACCESS BY INDEX ROWID | GL_JE_LINES | 1 | 122 | | |*157 | INDEX RANGE SCAN | CISO_GL_JE_LINES_N1 | 1 | | | |*158 | TABLE ACCESS BY INDEX ROWID | GL_CODE_COMBINATIONS | 1 | 23 | 1 | |*159 | INDEX UNIQUE SCAN | GL_CODE_COMBINATIONS_U1 | 1 | | | | 160 | TABLE ACCESS BY INDEX ROWID | HZ_CUST_ACCOUNTS | 1 | 86 | 1 | |*161 | INDEX UNIQUE SCAN | HZ_CUST_ACCOUNTS_U2 | 1 | | | |*162 | INDEX UNIQUE SCAN | HZ_PARTIES_U1 | 1 | 4 | | |*163 | TABLE ACCESS BY INDEX ROWID | GL_SETS_OF_BOOKS | 1 | 11 | 1 | |*164 | INDEX UNIQUE SCAN | GL_SETS_OF_BOOKS_U2 | 1 | | | | 165 | TABLE ACCESS FULL | FND_PROFILE_OPTION_VALUES | 4377 | 43770 | 9 | |*166 | FILTER | | | | | | 167 | SORT GROUP BY | | 2 | 372 | 34 | | 168 | TABLE ACCESS BY INDEX ROWID | GL_JE_LINES | 11 | 176 | 2 | | 169 | NESTED LOOPS | | 4 | 744 | 9 | | 170 | NESTED LOOPS | | 1 | 170 | 7 | | 171 | MERGE JOIN CARTESIAN | | 1 | 48 | 5 | |*172 | TABLE ACCESS FULL | GL_SETS_OF_BOOKS | 1 | 18 | 2 | | 173 | BUFFER SORT | | 2 | 60 | 3 | |*174 | TABLE ACCESS FULL | GL_CODE_COMBINATIONS | 2 | 60 | 3 | |*175 | TABLE ACCESS BY INDEX ROWID | GL_JE_LINES | 11 | 1342 | 2 | |*176 | INDEX RANGE SCAN | GL_JE_LINES_N1 | 11 | | 1 | |*177 | INDEX RANGE SCAN | GL_JE_LINES_N1 | 11 | | 1 | |*178 | FILTER | | | | | | 179 | SORT GROUP BY | | 1 | 186 | 34 | | 180 | TABLE ACCESS BY INDEX ROWID | GL_JE_LINES | 11 | 176 | 2 | | 181 | NESTED LOOPS | | 1 | 186 | 9 | | 182 | NESTED LOOPS | | 1 | 170 | 7 | | 183 | MERGE JOIN CARTESIAN | | 1 | 48 | 5 | |*184 | TABLE ACCESS FULL | GL_SETS_OF_BOOKS | 1 | 18 | 2 | | 185 | BUFFER SORT | | 2 | 60 | 3 | |*186 | TABLE ACCESS FULL | GL_CODE_COMBINATIONS | 2 | 60 | 3 | |*187 | TABLE ACCESS BY INDEX ROWID | GL_JE_LINES | 1 | 122 | 2 | |*188 | INDEX RANGE SCAN | GL_JE_LINES_N1 | 11 | | 1 | |*189 | INDEX RANGE SCAN | GL_JE_LINES_N1 | 11 | | 1 | |*190 | FILTER | | | | | | 191 | SORT GROUP BY | | 1 | 186 | 34 | | 192 | TABLE ACCESS BY INDEX ROWID | GL_JE_LINES | 11 | 176 | 2 | | 193 | NESTED LOOPS | | 1 | 186 | 9 | | 194 | NESTED LOOPS | | 1 | 170 | 7 | | 195 | MERGE JOIN CARTESIAN | | 1 | 48 | 5 | |*196 | TABLE ACCESS FULL | GL_SETS_OF_BOOKS | 1 | 18 | 2 | | 197 | BUFFER SORT | | 2 | 60 | 3 | |*198 | TABLE ACCESS FULL | GL_CODE_COMBINATIONS | 2 | 60 | 3 | |*199 | TABLE ACCESS BY INDEX ROWID | GL_JE_LINES | 1 | 122 | 2 | |*200 | INDEX RANGE SCAN | GL_JE_LINES_N1 | 11 | | 1 | |*201 | INDEX RANGE SCAN | GL_JE_LINES_N1 | 11 | | 1 | | 202 | VIEW | CISO_EAL_PASTDUE | 2 | 80 | 105 | | 203 | SORT UNIQUE | | 2 | 490 | 105 | | 204 | UNION-ALL | | | | | | 205 | SORT GROUP BY | | 1 | 237 | 50 | | 206 | NESTED LOOPS | | 1 | 237 | 1 | | 207 | NESTED LOOPS | | 1 | 214 | 1 | | 208 | NESTED LOOPS | | 1 | 98 | 1 | |*209 | TABLE ACCESS BY INDEX ROWID | AP_PAYMENT_SCHEDULES_ALL | 1 | 36 | 1 | |*210 | INDEX RANGE SCAN | AP_PAYMENT_SCHEDULES_N2 | 1 | | 1 | |*211 | TABLE ACCESS BY INDEX ROWID | AP_INVOICES_ALL | 1 | 62 | | |*212 | INDEX UNIQUE SCAN | AP_INVOICES_U1 | 1 | | | | 213 | TABLE ACCESS BY INDEX ROWID | AP_INVOICE_DISTRIBUTIONS_ALL | 1 | 116 | | |*214 | INDEX RANGE SCAN | AP_INVOICE_DISTRIBUTIONS_U1 | 1 | | | | 215 | TABLE ACCESS BY INDEX ROWID | GL_CODE_COMBINATIONS | 1 | 23 | | |*216 | INDEX UNIQUE SCAN | GL_CODE_COMBINATIONS_U1 | 1 | | | | 217 | SORT GROUP BY | | 1 | 253 | 55 | |*218 | TABLE ACCESS BY INDEX ROWID | RA_CUST_TRX_TYPES_ALL | 1 | 17 | 1 | | 219 | NESTED LOOPS | | 1 | 253 | 3 | | 220 | NESTED LOOPS | | 1 | 236 | 2 | | 221 | NESTED LOOPS | | 1 | 191 | 2 | | 222 | NESTED LOOPS | | 1 | 165 | 2 | | 223 | NESTED LOOPS | | 1 | 49 | 2 | | 224 | TABLE ACCESS FULL | RA_CUST_TRX_LINE_GL_DIST_ALL | 1 | 26 | 2 | | 225 | TABLE ACCESS BY INDEX ROWID | GL_CODE_COMBINATIONS | 1 | 23 | | |*226 | INDEX UNIQUE SCAN | GL_CODE_COMBINATIONS_U1 | 1 | | | | 227 | TABLE ACCESS BY INDEX ROWID | RA_CUSTOMER_TRX_LINES_ALL | 1 | 116 | | |*228 | INDEX UNIQUE SCAN | RA_CUSTOMER_TRX_LINES_U1 | 1 | | | | 229 | TABLE ACCESS BY INDEX ROWID | RA_CUSTOMER_TRX_ALL | 1 | 26 | | |*230 | INDEX UNIQUE SCAN | RA_CUSTOMER_TRX_U1 | 1 | | | |*231 | TABLE ACCESS BY INDEX ROWID | AR_RECEIVABLES_TRX_ALL | 1 | 27 | 2 | | 232 | NESTED LOOPS | | 1 | 53 | 3 | | 233 | TABLE ACCESS BY INDEX ROWID | AR_ADJUSTMENTS_ALL | 1 | 26 | 1 | |*234 | INDEX RANGE SCAN | AR_ADJUSTMENTS_N2 | 1 | | 1 | |*235 | INDEX RANGE SCAN | AR_RECEIVABLES_TRX_U1 | 2 | | 1 | |*236 | TABLE ACCESS BY INDEX ROWID | AR_PAYMENT_SCHEDULES_ALL | 1 | 45 | | |*237 | INDEX RANGE SCAN | AR_PAYMENT_SCHEDULES_N2 | 8 | | | |*238 | INDEX RANGE SCAN | RA_CUST_TRX_TYPES_U1 | 2 | | 1 | | 239 | VIEW | CISO_EAL_FERCANNUAL | 6 | 240 | 145 | | 240 | UNION-ALL | | | | | | 241 | NESTED LOOPS | | 1 | 156 | 3 | | 242 | NESTED LOOPS | | 1 | 133 | 2 | |*243 | TABLE ACCESS BY INDEX ROWID | GL_JE_LINES | 1 | 122 | 1 | |*244 | INDEX RANGE SCAN | CISO_GL_JE_LINES_N1 | 1 | | 1 | |*245 | TABLE ACCESS BY INDEX ROWID | GL_SETS_OF_BOOKS | 1 | 11 | 1 | |*246 | INDEX UNIQUE SCAN | GL_SETS_OF_BOOKS_U2 | 1 | | | |*247 | TABLE ACCESS BY INDEX ROWID | GL_CODE_COMBINATIONS | 1 | 23 | 1 | |*248 | INDEX UNIQUE SCAN | GL_CODE_COMBINATIONS_U1 | 1 | | | | 249 | SORT GROUP BY | | 1 | 156 | 28 | | 250 | NESTED LOOPS | | 1 | 156 | 3 | | 251 | NESTED LOOPS | | 1 | 133 | 2 | | 252 | INLIST ITERATOR | | | | | |*253 | TABLE ACCESS BY INDEX ROWID | GL_JE_LINES | 1 | 122 | 1 | |*254 | INDEX RANGE SCAN | CISO_GL_JE_LINES_N1 | 1 | | | |*255 | TABLE ACCESS BY INDEX ROWID | GL_SETS_OF_BOOKS | 1 | 11 | 1 | |*256 | INDEX UNIQUE SCAN | GL_SETS_OF_BOOKS_U2 | 1 | | | |*257 | TABLE ACCESS BY INDEX ROWID | GL_CODE_COMBINATIONS | 1 | 23 | 1 | |*258 | INDEX UNIQUE SCAN | GL_CODE_COMBINATIONS_U1 | 1 | | | | 259 | SORT UNIQUE | | 6 | 1266 | 145 | | 260 | UNION-ALL | | | | | | 261 | SORT GROUP BY | | 1 | 224 | 26 | | 262 | NESTED LOOPS | | 1 | 224 | 1 | | 263 | NESTED LOOPS | | 1 | 201 | 1 | | 264 | NESTED LOOPS | | 1 | 85 | 1 | |*265 | TABLE ACCESS BY INDEX ROWID | AP_PAYMENT_SCHEDULES_ALL | 1 | 36 | 1 | |*266 | INDEX RANGE SCAN | AP_PAYMENT_SCHEDULES_N2 | 1 | | 1 | |*267 | TABLE ACCESS BY INDEX ROWID | AP_INVOICES_ALL | 1 | 49 | | |*268 | INDEX UNIQUE SCAN | AP_INVOICES_U1 | 1 | | | | 269 | TABLE ACCESS BY INDEX ROWID | AP_INVOICE_DISTRIBUTIONS_ALL | 1 | 116 | | |*270 | INDEX RANGE SCAN | AP_INVOICE_DISTRIBUTIONS_U1 | 1 | | | | 271 | TABLE ACCESS BY INDEX ROWID | GL_CODE_COMBINATIONS | 1 | 23 | | |*272 | INDEX UNIQUE SCAN | GL_CODE_COMBINATIONS_U1 | 1 | | | | 273 | SORT GROUP BY | | 1 | 253 | 31 | |*274 | TABLE ACCESS BY INDEX ROWID | RA_CUST_TRX_TYPES_ALL | 1 | 17 | 1 | | 275 | NESTED LOOPS | | 1 | 253 | 3 | | 276 | NESTED LOOPS | | 1 | 236 | 2 | | 277 | NESTED LOOPS | | 1 | 191 | 2 | | 278 | NESTED LOOPS | | 1 | 165 | 2 | | 279 | NESTED LOOPS | | 1 | 49 | 2 | | 280 | TABLE ACCESS FULL | RA_CUST_TRX_LINE_GL_DIST_ALL | 1 | 26 | 2 | | 281 | TABLE ACCESS BY INDEX ROWID | GL_CODE_COMBINATIONS | 1 | 23 | | |*282 | INDEX UNIQUE SCAN | GL_CODE_COMBINATIONS_U1 | 1 | | | | 283 | TABLE ACCESS BY INDEX ROWID | RA_CUSTOMER_TRX_LINES_ALL | 1 | 116 | | |*284 | INDEX UNIQUE SCAN | RA_CUSTOMER_TRX_LINES_U1 | 1 | | | | 285 | TABLE ACCESS BY INDEX ROWID | RA_CUSTOMER_TRX_ALL | 1 | 26 | | |*286 | INDEX UNIQUE SCAN | RA_CUSTOMER_TRX_U1 | 1 | | | |*287 | TABLE ACCESS BY INDEX ROWID | AR_RECEIVABLES_TRX_ALL | 1 | 27 | 2 | | 288 | NESTED LOOPS | | 1 | 53 | 3 | | 289 | TABLE ACCESS BY INDEX ROWID | AR_ADJUSTMENTS_ALL | 1 | 26 | 1 | |*290 | INDEX RANGE SCAN | AR_ADJUSTMENTS_N2 | 1 | | 1 | |*291 | INDEX RANGE SCAN | AR_RECEIVABLES_TRX_U1 | 2 | | 1 | |*292 | TABLE ACCESS BY INDEX ROWID | AR_PAYMENT_SCHEDULES_ALL | 1 | 45 | | |*293 | INDEX RANGE SCAN | AR_PAYMENT_SCHEDULES_N2 | 8 | | | |*294 | INDEX RANGE SCAN | RA_CUST_TRX_TYPES_U1 | 2 | | 1 | | 295 | SORT UNIQUE | | 6 | 1266 | 145 | | 296 | UNION-ALL | | | | | | 297 | SORT GROUP BY | | 1 | 224 | 26 | | 298 | NESTED LOOPS | | 1 | 224 | 1 | | 299 | NESTED LOOPS | | 1 | 201 | 1 | | 300 | NESTED LOOPS | | 1 | 85 | 1 | |*301 | TABLE ACCESS BY INDEX ROWID | AP_PAYMENT_SCHEDULES_ALL | 1 | 36 | 1 | |*302 | INDEX RANGE SCAN | AP_PAYMENT_SCHEDULES_N2 | 1 | | 1 | |*303 | TABLE ACCESS BY INDEX ROWID | AP_INVOICES_ALL | 1 | 49 | | |*304 | INDEX UNIQUE SCAN | AP_INVOICES_U1 | 1 | | | | 305 | TABLE ACCESS BY INDEX ROWID | AP_INVOICE_DISTRIBUTIONS_ALL | 1 | 116 | | |*306 | INDEX RANGE SCAN | AP_INVOICE_DISTRIBUTIONS_U1 | 1 | | | | 307 | TABLE ACCESS BY INDEX ROWID | GL_CODE_COMBINATIONS | 1 | 23 | | |*308 | INDEX UNIQUE SCAN | GL_CODE_COMBINATIONS_U1 | 1 | | | | 309 | SORT GROUP BY | | 1 | 253 | 31 | |*310 | TABLE ACCESS BY INDEX ROWID | RA_CUST_TRX_TYPES_ALL | 1 | 17 | 1 | | 311 | NESTED LOOPS | | 1 | 253 | 3 | | 312 | NESTED LOOPS | | 1 | 236 | 2 | | 313 | NESTED LOOPS | | 1 | 191 | 2 | | 314 | NESTED LOOPS | | 1 | 165 | 2 | | 315 | NESTED LOOPS | | 1 | 49 | 2 | | 316 | TABLE ACCESS FULL | RA_CUST_TRX_LINE_GL_DIST_ALL | 1 | 26 | 2 | | 317 | TABLE ACCESS BY INDEX ROWID | GL_CODE_COMBINATIONS | 1 | 23 | | |*318 | INDEX UNIQUE SCAN | GL_CODE_COMBINATIONS_U1 | 1 | | | | 319 | TABLE ACCESS BY INDEX ROWID | RA_CUSTOMER_TRX_LINES_ALL | 1 | 116 | | |*320 | INDEX UNIQUE SCAN | RA_CUSTOMER_TRX_LINES_U1 | 1 | | | | 321 | TABLE ACCESS BY INDEX ROWID | RA_CUSTOMER_TRX_ALL | 1 | 26 | | |*322 | INDEX UNIQUE SCAN | RA_CUSTOMER_TRX_U1 | 1 | | | |*323 | TABLE ACCESS BY INDEX ROWID | AR_RECEIVABLES_TRX_ALL | 1 | 27 | 2 | | 324 | NESTED LOOPS | | 1 | 53 | 3 | | 325 | TABLE ACCESS BY INDEX ROWID | AR_ADJUSTMENTS_ALL | 1 | 26 | 1 | |*326 | INDEX RANGE SCAN | AR_ADJUSTMENTS_N2 | 1 | | 1 | |*327 | INDEX RANGE SCAN | AR_RECEIVABLES_TRX_U1 | 2 | | 1 | |*328 | TABLE ACCESS BY INDEX ROWID | AR_PAYMENT_SCHEDULES_ALL | 1 | 45 | | |*329 | INDEX RANGE SCAN | AR_PAYMENT_SCHEDULES_N2 | 8 | | | |*330 | INDEX RANGE SCAN | RA_CUST_TRX_TYPES_U1 | 2 | | 1 | |*331 | FILTER | | | | | | 332 | SORT GROUP BY | | 2 | 372 | 34 | | 333 | TABLE ACCESS BY INDEX ROWID | GL_JE_LINES | 11 | 176 | 2 | | 334 | NESTED LOOPS | | 4 | 744 | 9 | | 335 | NESTED LOOPS | | 1 | 170 | 7 | | 336 | MERGE JOIN CARTESIAN | | 1 | 48 | 5 | |*337 | TABLE ACCESS FULL | GL_SETS_OF_BOOKS | 1 | 18 | 2 | | 338 | BUFFER SORT | | 2 | 60 | 3 | |*339 | TABLE ACCESS FULL | GL_CODE_COMBINATIONS | 2 | 60 | 3 | |*340 | TABLE ACCESS BY INDEX ROWID | GL_JE_LINES | 11 | 1342 | 2 | |*341 | INDEX RANGE SCAN | GL_JE_LINES_N1 | 11 | | 1 | |*342 | INDEX RANGE SCAN | GL_JE_LINES_N1 | 11 | | 1 | |*343 | FILTER | | | | | | 344 | SORT GROUP BY | | 2 | 372 | 34 | | 345 | TABLE ACCESS BY INDEX ROWID | GL_JE_LINES | 11 | 176 | 2 | | 346 | NESTED LOOPS | | 4 | 744 | 9 | | 347 | NESTED LOOPS | | 1 | 170 | 7 | | 348 | MERGE JOIN CARTESIAN | | 1 | 48 | 5 | |*349 | TABLE ACCESS FULL | GL_SETS_OF_BOOKS | 1 | 18 | 2 | | 350 | BUFFER SORT | | 2 | 60 | 3 | |*351 | TABLE ACCESS FULL | GL_CODE_COMBINATIONS | 2 | 60 | 3 | |*352 | TABLE ACCESS BY INDEX ROWID | GL_JE_LINES | 11 | 1342 | 2 | |*353 | INDEX RANGE SCAN | GL_JE_LINES_N1 | 11 | | 1 | |*354 | INDEX RANGE SCAN | GL_JE_LINES_N1 | 11 | | 1 | |*355 | TABLE ACCESS BY INDEX ROWID | GL_JE_LINES | 11 | 1342 | 2 | | 356 | NESTED LOOPS | | 1 | 156 | 7 | | 357 | MERGE JOIN CARTESIAN | | 1 | 34 | 5 | |*358 | TABLE ACCESS FULL | GL_SETS_OF_BOOKS | 1 | 11 | 2 | | 359 | BUFFER SORT | | 2 | 46 | 3 | |*360 | TABLE ACCESS FULL | GL_CODE_COMBINATIONS | 2 | 46 | 3 | |*361 | INDEX RANGE SCAN | GL_JE_LINES_N1 | 11 | | 1 | |*362 | TABLE ACCESS FULL | CISO_VB_LIABILITIES | 1 | 78 | 2 | |*363 | TABLE ACCESS FULL | CISO_DA_LIABILITIES | 1 | 78 | 2 | |*364 | TABLE ACCESS FULL | CISO_RT_LIABILITIES | 1 | 78 | 2 | |*365 | FILTER | | | | | | 366 | SORT GROUP BY | | 1 | 186 | 34 | | 367 | TABLE ACCESS BY INDEX ROWID | GL_JE_LINES | 11 | 176 | 2 | | 368 | NESTED LOOPS | | 1 | 186 | 9 | | 369 | NESTED LOOPS | | 1 | 170 | 7 | | 370 | MERGE JOIN CARTESIAN | | 1 | 48 | 5 | |*371 | TABLE ACCESS FULL | GL_SETS_OF_BOOKS | 1 | 18 | 2 | | 372 | BUFFER SORT | | 2 | 60 | 3 | |*373 | TABLE ACCESS FULL | GL_CODE_COMBINATIONS | 2 | 60 | 3 | |*374 | TABLE ACCESS BY INDEX ROWID | GL_JE_LINES | 1 | 122 | 2 | |*375 | INDEX RANGE SCAN | GL_JE_LINES_N1 | 11 | | 1 | |*376 | INDEX RANGE SCAN | GL_JE_LINES_N1 | 11 | | 1 | --------------------------------------------------------------------------------------------------------------------- Predicate Information (identified by operation id): --------------------------------------------------- 2 - access("FPO"."PROFILE_OPTION_ID"="FPOV"."PROFILE_OPTION_ID") 4 - access("CUST"."ACCOUNT_NUMBER"="CESB"."BAID"(+)) 5 - access("CUST_PARTY"."CATEGORY_CODE"="LV"."LOOKUP_CODE"(+)) 6 - access("CUST"."PARTY_ID"="CUST_PARTY"."PARTY_ID") 9 - filter("EFFECTIVE_END_DATE" IS NULL) 10 - access("PARTY"."PARTY_ID"="PARTY_ID"(+)) 12 - filter("EFFECTIVE_END_DATE" IS NULL) 16 - access("CP"."CUST_ACCOUNT_ID"="CUST"."CUST_ACCOUNT_ID") 17 - filter("CP"."SITE_USE_ID" IS NULL) 18 - access("CUST"."CUSTOMER_CLASS_CODE"="LV"."LOOKUP_CODE"(+)) 19 - access("CUST"."CUSTOMER_TYPE"="LV"."LOOKUP_CODE"(+)) 20 - access("CUST"."PRIMARY_SALESREP_ID"="REP"."SALESREP_ID"(+)) 21 - access("CUST"."FREIGHT_TERM"="LOOKUP_CODE"(+)) 22 - access("CUST"."SALES_CHANNEL_CODE"="LOOKUP_CODE"(+)) 25 - access("CUST"."FOB_POINT"="LV"."LOOKUP_CODE"(+)) 27 - access("CUST_ACCT"."CUST_ACCOUNT_ID"="CUST"."CUST_ACCOUNT_ID") 30 - access("FPO"."PROFILE_OPTION_NAME"='CISO_EXTRAPOLATED_HISTORY_DAYS') 33 - access("CUST"."WAREHOUSE_ID"="ORG"."ORGANIZATION_ID"(+)) 34 - access("LV"."LOOKUP_TYPE"(+)='FOB' AND "LV"."VIEW_APPLICATION_ID"(+)=222 AND "LV"."SECURITY_GROUP_ID"(+)=0 AND "LV"."LANGUAGE"(+)=USERENV('LANG')) filter("LV"."LANGUAGE"(+)=USERENV('LANG') AND "LV"."SECURITY_GROUP_ID"(+)=0) 37 - filter(NVL("B"."ORG_ID",NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1),' ',NULL,SUBSTRB(USERENV('CLIENT_INFO'),1,10))),(-99)))=NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1 ),' ',NULL,SUBSTRB(USERENV('CLIENT_INFO'),1,10))),(-99))) 38 - access("B"."TRANSACTION_TYPE_ID"="CUST"."ORDER_TYPE_ID") 39 - access("B"."TRANSACTION_TYPE_ID"="T"."TRANSACTION_TYPE_ID" AND "T"."LANGUAGE"=USERENV('LANG')) 42 - filter(("B"."LIST_TYPE_CODE"='AGR' OR "B"."LIST_TYPE_CODE"='PRL') AND (NVL("FND_PROFILE"."VALUE"('QP_SECURITY_CONTROL'),'OFF')='ON' AND "B"."ORIG_ORG_ID"=TO_NUMBER("FND_PROFILE"."VALUE"('ORG_ID')) OR NVL("B"."GLOBAL_FLAG",'Y')='Y' AND NVL("FND_PROFILE"."VALUE"('QP_SECURITY_CONTROL'),'OFF')='ON' OR NVL("FND_PROFILE"."VALUE"('QP_SECURITY_CONTROL'),'OFF')='OFF')) 43 - access("B"."LIST_HEADER_ID"="CUST"."PRICE_LIST_ID") 44 - access("B"."LIST_HEADER_ID"="T"."LIST_HEADER_ID" AND "T"."LANGUAGE"=USERENV('LANG')) 45 - access("LOOKUP_TYPE"(+)='SALES_CHANNEL' AND "VIEW_APPLICATION_ID"(+)=660 AND "LANGUAGE"(+)=USERENV('LANG')) filter("LANGUAGE"(+)=USERENV('LANG') AND "SECURITY_GROUP_ID"(+)="FND_GLOBAL"."LOOKUP_SECURITY_GROUP"(" LV"."LOOKUP_TYPE"(+),"LV"."VIEW_APPLICATION_ID"(+))) 46 - access("LOOKUP_TYPE"(+)='FREIGHT_TERMS' AND "VIEW_APPLICATION_ID"(+)=660 AND "LANGUAGE"(+)=USERENV('LANG')) filter("LANGUAGE"(+)=USERENV('LANG') AND "SECURITY_GROUP_ID"(+)="FND_GLOBAL"."LOOKUP_SECURITY_GROUP"(" LV"."LOOKUP_TYPE"(+),"LV"."VIEW_APPLICATION_ID"(+))) 50 - filter(NVL("JRS"."ORG_ID",NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1),' ',NULL,SUBSTRB(USERENV('CLIENT_INFO'),1,10))),(-99)))=NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1 ),' ',NULL,SUBSTRB(USERENV('CLIENT_INFO'),1,10))),(-99))) 51 - filter("B"."CATEGORY"='EMPLOYEE' OR "B"."CATEGORY"='OTHER' OR "B"."CATEGORY"='PARTNER' OR "B"."CATEGORY"='PARTY' OR "B"."CATEGORY"='SUPPLIER_CONTACT') 52 - access("JRS"."RESOURCE_ID"="B"."RESOURCE_ID") 54 - access("B"."RESOURCE_ID"="T"."RESOURCE_ID" AND "T"."LANGUAGE"=USERENV('LANG') AND ("T"."CATEGORY"='EMPLOYEE' OR "T"."CATEGORY"='OTHER' OR "T"."CATEGORY"='PARTNER' OR "T"."CATEGORY"='PARTY' OR "T"."CATEGORY"='SUPPLIER_CONTACT')) filter("B"."CATEGORY"="T"."CATEGORY") 55 - access("LV"."LOOKUP_TYPE"(+)='CUSTOMER_TYPE' AND "LV"."VIEW_APPLICATION_ID"(+)=222 AND "LV"."SECURITY_GROUP_ID"(+)=0 AND "LV"."LANGUAGE"(+)=USERENV('LANG')) filter("LV"."LANGUAGE"(+)=USERENV('LANG') AND "LV"."SECURITY_GROUP_ID"(+)=0) 56 - access("LV"."LOOKUP_TYPE"(+)='CUSTOMER CLASS' AND "LV"."VIEW_APPLICATION_ID"(+)=222 AND "LV"."SECURITY_GROUP_ID"(+)=0 AND "LV"."LANGUAGE"(+)=USERENV('LANG')) filter("LV"."LANGUAGE"(+)=USERENV('LANG') AND "LV"."SECURITY_GROUP_ID"(+)=0) 57 - access("CUST_ACCT"."PARTY_ID"="PARTY"."PARTY_ID") 58 - access("PARTY"."PARTY_ID"="CONT_POINT"."OWNER_TABLE_ID"(+) AND "CONT_POINT"."OWNER_TABLE_NAME"(+)='HZ_PARTIES' AND "CONT_POINT"."CONTACT_POINT_TYPE"(+)='WEB' AND "CONT_POINT"."PRIMARY_FLAG"(+)='Y') 59 - filter("CONTENT_SOURCE_TYPE"(+)='USER_ENTERED' AND NVL("ACTUAL_CONTENT_SOURCE"(+),"CONTENT_SOURCE_TYPE"(+))='SST') 60 - access("PARTY"."PARTY_ID"="PARTY_ID"(+)) 61 - filter("CONTACT_LEVEL_TABLE"(+)='HZ_PARTIES' AND "PREFERENCE_CODE"(+)='DO_NOT' AND "CONTACT_LEVEL_TABLE"(+)<>'HZ_CONTACT_POINTS') 62 - access("PARTY"."PARTY_ID"="CONTACT_LEVEL_TABLE_ID"(+)) 63 - filter("CONTENT_SOURCE_TYPE"(+)='USER_ENTERED' AND NVL("ACTUAL_CONTENT_SOURCE"(+),"CONTENT_SOURCE_TYPE"(+))='SST') 64 - access("CP"."PROFILE_CLASS_ID"="CPC"."PROFILE_CLASS_ID"(+)) 65 - access("LV"."LOOKUP_TYPE"(+)='CUSTOMER_CATEGORY' AND "LV"."VIEW_APPLICATION_ID"(+)=222 AND "LV"."SECURITY_GROUP_ID"(+)=0 AND "LV"."LANGUAGE"(+)=USERENV('LANG')) filter("LV"."LANGUAGE"(+)=USERENV('LANG') AND "LV"."SECURITY_GROUP_ID"(+)=0) 77 - filter(TRUNC(INTERNAL_FUNCTION("APS"."DUE_DATE"))>=TRUNC(SYSDATE@!)) 78 - access("APS"."PAYMENT_STATUS_FLAG"='N') 79 - filter("AI"."PAY_GROUP_LOOKUP_CODE"='MARKET' AND "AI"."CANCELLED_DATE" IS NULL AND "AI"."INVOICE_AMOUNT"<>0) 80 - access("APS"."INVOICE_ID"="AI"."INVOICE_ID") 82 - access("AID"."INVOICE_ID"="AI"."INVOICE_ID") 84 - access("GLCC"."CODE_COMBINATION_ID"="AID"."DIST_CODE_COMBINATION_ID") 86 - filter(UPPER("CTT"."NAME")='MARKET') 94 - access("GLCC"."CODE_COMBINATION_ID"="RCTD"."CODE_COMBINATION_ID") 96 - access("RCTD"."CUSTOMER_TRX_LINE_ID"="RCTL"."CUSTOMER_TRX_LINE_ID") 98 - access("RCTL"."CUSTOMER_TRX_ID"="RCT"."CUSTOMER_TRX_ID") filter( NOT EXISTS (SELECT /*+ */ 0 FROM "AR"."AR_RECEIVABLES_TRX_ALL" "ART","AR"."AR_ADJUSTMENTS_ALL" "ADJ" WHERE "ADJ"."CUSTOMER_TRX_ID"=:B1 AND "ART"."RECEIVABLES_TRX_ID"="ADJ"."RECEIVABLES_TRX_ID" AND UPPER("ART"."NAME")='CANCEL/REBILL ADJUSTMENT' AND "ART"."STATUS"='A')) 99 - filter(UPPER("ART"."NAME")='CANCEL/REBILL ADJUSTMENT' AND "ART"."STATUS"='A') 102 - access("ADJ"."CUSTOMER_TRX_ID"=:B1) 103 - access("ART"."RECEIVABLES_TRX_ID"="ADJ"."RECEIVABLES_TRX_ID") 104 - filter("ARPS"."CLASS"='INV' AND "ARPS"."STATUS"='OP' AND TRUNC(INTERNAL_FUNCTION("ARPS"."DUE_DATE"))>=TRUNC(SYSDATE@!)) 105 - access("ARPS"."CUSTOMER_TRX_ID"="RCT"."CUSTOMER_TRX_ID") 106 - access("CTT"."CUST_TRX_TYPE_ID"="RCT"."CUST_TRX_TYPE_ID") 111 - filter("GB"."ATTRIBUTE15"='N') 112 - access("GB"."ATTRIBUTE12"='MARKET_INITIAL' OR "GB"."ATTRIBUTE12"='MARKET_RECALC' OR "GB"."ATTRIBUTE12"='MARKET_REISSUE' OR "GB"."ATTRIBUTE12"='MONTHLY_INITIAL' OR "GB"."ATTRIBUTE12"='MONTHLY_RECALC') 113 - filter(UPPER("SOB"."SHORT_NAME")='MKTEST') 114 - access("SOB"."SET_OF_BOOKS_ID"="GB"."SET_OF_BOOKS_ID") 115 - filter("GLCC"."SEGMENT3"<>'RMR' AND "GLCC"."SEGMENT3"<>'CRRVALUE' AND "GLCC"."SEGMENT3"<>'CRRBIDRESERVE' AND "GLCC"."SEGMENT3"<>'CRRWINBID' AND "GLCC"."SEGMENT3"<>'WACCURRENT' AND "GLCC"."SEGMENT3"<>'WACFUTURE' AND "GLCC"."SEGMENT3"<>'EAL_ADJUSTMENT' AND "GLCC"."SEGMENT3"<>'FERC_FEE_DUE_ANNUALLY') 116 - access("GLCC"."CODE_COMBINATION_ID"="GB"."CODE_COMBINATION_ID") 120 - filter("GB"."ATTRIBUTE15"='N') 121 - access("GB"."ATTRIBUTE12"='CREDIT' OR "GB"."ATTRIBUTE12"='MONTHLY_CREDIT') 122 - filter(UPPER("SOB"."SHORT_NAME")='MKTEST') 123 - access("SOB"."SET_OF_BOOKS_ID"="GB"."SET_OF_BOOKS_ID") 124 - filter("GLCC"."SEGMENT3"<>'RMR' AND "GLCC"."SEGMENT3"<>'CRRVALUE' AND "GLCC"."SEGMENT3"<>'CRRBIDRESERVE' AND "GLCC"."SEGMENT3"<>'CRRWINBID' AND "GLCC"."SEGMENT3"<>'WACCURRENT' AND "GLCC"."SEGMENT3"<>'WACFUTURE' AND "GLCC"."SEGMENT3"<>'EAL_ADJUSTMENT' AND "GLCC"."SEGMENT3"<>'FERC_FEE_DUE_ANNUALLY') 125 - access("GLCC"."CODE_COMBINATION_ID"="GB"."CODE_COMBINATION_ID") 131 - access("FPO"."PROFILE_OPTION_ID"="FPOV"."PROFILE_OPTION_ID") filter("GB"."EFFECTIVE_DATE">=TRUNC(SYSDATE@!-TO_NUMBER(NVL("CUST"."ATTRIBUTE5","FPOV"."PROFILE_OPTION _VALUE"))-13) AND TRUNC(SYSDATE@!-TO_NUMBER(NVL("CUST"."ATTRIBUTE5","FPOV"."PROFILE_OPTION_VALUE"))-13)<=TRUN C(SYSDATE@!-13)) 134 - access("SOB"."SET_OF_BOOKS_ID"="GB"."SET_OF_BOOKS_ID") 137 - access("FPO"."PROFILE_OPTION_NAME"='CISO_EXTRAPOLATED_HISTORY_DAYS') 138 - filter(UPPER("SOB"."SHORT_NAME")='MKTEST') 139 - filter((("GB"."ATTRIBUTE12"='CREDIT' OR "GB"."ATTRIBUTE12"='MARKET_REISSUE') AND "GB"."ATTRIBUTE15"='N' OR ("GB"."ATTRIBUTE12"='MARKET_INITIAL' OR "GB"."ATTRIBUTE12"='MARKET_RECALC') AND "GB"."ATTRIBUTE15"<>'V' AND "GB"."ATTRIBUTE15"<>'Q') AND "GB"."EFFECTIVE_DATE"<=TRUNC(SYSDATE@!-13)) 140 - filter("GLCC"."SEGMENT3"<>'RMR' AND "GLCC"."SEGMENT3"<>'CRRVALUE' AND "GLCC"."SEGMENT3"<>'CRRBIDRESERVE' AND "GLCC"."SEGMENT3"<>'CRRWINBID' AND "GLCC"."SEGMENT3"<>'WACCURRENT' AND "GLCC"."SEGMENT3"<>'WACFUTURE' AND "GLCC"."SEGMENT3"<>'EAL_ADJUSTMENT' AND "GLCC"."SEGMENT3"<>'FERC_FEE_DUE_ANNUALLY' AND "GLCC"."SEGMENT4"<>'6798') 141 - access("GLCC"."CODE_COMBINATION_ID"="GB"."CODE_COMBINATION_ID") 143 - access("GLCC"."SEGMENT2"="CUST"."ACCOUNT_NUMBER") 145 - access("CUST"."PARTY_ID"="PARTY"."PARTY_ID") 147 - access("FPO"."PROFILE_OPTION_ID"="FPOV"."PROFILE_OPTION_ID") filter("GB"."EFFECTIVE_DATE">=TRUNC(SYSDATE@!-TO_NUMBER(NVL("CUST"."ATTRIBUTE5","FPOV"."PROFILE_OPTION _VALUE"))-13) AND TRUNC(SYSDATE@!-TO_NUMBER(NVL("CUST"."ATTRIBUTE5","FPOV"."PROFILE_OPTION_VALUE"))-13)<=TRUN C(SYSDATE@!-13)) 154 - access("FPO"."PROFILE_OPTION_NAME"='CISO_EXTRAPOLATED_HISTORY_DAYS') 156 - filter("GB"."ATTRIBUTE15"<>'V' AND "GB"."ATTRIBUTE15"<>'Q' AND "GB"."EFFECTIVE_DATE"<=TRUNC(SYSDATE@!-13)) 157 - access("GB"."ATTRIBUTE12"='MONTHLY_INITIAL' OR "GB"."ATTRIBUTE12"='MONTHLY_RECALC') 158 - filter("GLCC"."SEGMENT3"<>'RMR' AND "GLCC"."SEGMENT3"<>'CRRVALUE' AND "GLCC"."SEGMENT3"<>'CRRBIDRESERVE' AND "GLCC"."SEGMENT3"<>'CRRWINBID' AND "GLCC"."SEGMENT3"<>'WACCURRENT' AND "GLCC"."SEGMENT3"<>'WACFUTURE' AND "GLCC"."SEGMENT3"<>'EAL_ADJUSTMENT' AND "GLCC"."SEGMENT3"<>'FERC_FEE_DUE_ANNUALLY' AND "GLCC"."SEGMENT4"<>'6798') 159 - access("GLCC"."CODE_COMBINATION_ID"="GB"."CODE_COMBINATION_ID") 161 - access("GLCC"."SEGMENT2"="CUST"."ACCOUNT_NUMBER") 162 - access("CUST"."PARTY_ID"="PARTY"."PARTY_ID") 163 - filter(UPPER("SOB"."SHORT_NAME")='MKTEST') 164 - access("SOB"."SET_OF_BOOKS_ID"="GB"."SET_OF_BOOKS_ID") 166 - filter("GB"."EFFECTIVE_DATE"=MAX("GB2"."EFFECTIVE_DATE")) 172 - filter(UPPER("SOB"."SHORT_NAME")='MKTEST') 174 - filter("GLCC"."SEGMENT3"='CRRVALUE' AND "GLCC"."SEGMENT4"='0000') 175 - filter("GB"."SET_OF_BOOKS_ID"="SOB"."SET_OF_BOOKS_ID" AND ("GB"."ATTRIBUTE4" IS NULL OR TRUNC(TO_DATE("GB"."ATTRIBUTE4",'YYYY/MM/DD HH24:MI:SS'))TRUNC(SYSDATE@!)-1)) 176 - access("GLCC"."CODE_COMBINATION_ID"="GB"."CODE_COMBINATION_ID") 177 - access("GB2"."CODE_COMBINATION_ID"="GB"."CODE_COMBINATION_ID") 178 - filter("GB"."EFFECTIVE_DATE"=MAX("GB2"."EFFECTIVE_DATE")) 184 - filter(UPPER("SOB"."SHORT_NAME")='MKTEST') 186 - filter("GLCC"."SEGMENT3"='CRRBIDRESERVE' AND "GLCC"."SEGMENT4"='0000') 187 - filter("GB"."SET_OF_BOOKS_ID"="SOB"."SET_OF_BOOKS_ID" AND "GB"."ATTRIBUTE7" IS NOT NULL AND "GB"."ATTRIBUTE8" IS NOT NULL AND "GB"."ATTRIBUTE9" IS NULL) 188 - access("GLCC"."CODE_COMBINATION_ID"="GB"."CODE_COMBINATION_ID") 189 - access("GB2"."CODE_COMBINATION_ID"="GB"."CODE_COMBINATION_ID") 190 - filter("GB"."EFFECTIVE_DATE"=MAX("GB2"."EFFECTIVE_DATE")) 196 - filter(UPPER("SOB"."SHORT_NAME")='MKTEST') 198 - filter("GLCC"."SEGMENT3"='CRRWINBID' AND "GLCC"."SEGMENT4"='0000') 199 - filter("GB"."SET_OF_BOOKS_ID"="SOB"."SET_OF_BOOKS_ID" AND "GB"."ATTRIBUTE7" IS NOT NULL AND "GB"."ATTRIBUTE8" IS NOT NULL AND "GB"."ATTRIBUTE9" IS NULL) 200 - access("GLCC"."CODE_COMBINATION_ID"="GB"."CODE_COMBINATION_ID") 201 - access("GB2"."CODE_COMBINATION_ID"="GB"."CODE_COMBINATION_ID") 209 - filter(TRUNC(INTERNAL_FUNCTION("APS"."DUE_DATE"))0 AND "AI"."CANCELLED_DATE" IS NULL) 212 - access("APS"."INVOICE_ID"="AI"."INVOICE_ID") 214 - access("AID"."INVOICE_ID"="AI"."INVOICE_ID") 216 - access("GLCC"."CODE_COMBINATION_ID"="AID"."DIST_CODE_COMBINATION_ID") 218 - filter(UPPER("CTT"."NAME")='MARKET') 226 - access("GLCC"."CODE_COMBINATION_ID"="RCTD"."CODE_COMBINATION_ID") 228 - access("RCTD"."CUSTOMER_TRX_LINE_ID"="RCTL"."CUSTOMER_TRX_LINE_ID") 230 - access("RCTL"."CUSTOMER_TRX_ID"="RCT"."CUSTOMER_TRX_ID") filter( NOT EXISTS (SELECT /*+ */ 0 FROM "AR"."AR_RECEIVABLES_TRX_ALL" "ART","AR"."AR_ADJUSTMENTS_ALL" "ADJ" WHERE "ADJ"."CUSTOMER_TRX_ID"=:B1 AND "ART"."RECEIVABLES_TRX_ID"="ADJ"."RECEIVABLES_TRX_ID" AND UPPER("ART"."NAME")='CANCEL/REBILL ADJUSTMENT' AND "ART"."STATUS"='A')) 231 - filter(UPPER("ART"."NAME")='CANCEL/REBILL ADJUSTMENT' AND "ART"."STATUS"='A') 234 - access("ADJ"."CUSTOMER_TRX_ID"=:B1) 235 - access("ART"."RECEIVABLES_TRX_ID"="ADJ"."RECEIVABLES_TRX_ID") 236 - filter("ARPS"."CLASS"='INV' AND "ARPS"."STATUS"='OP' AND TRUNC(INTERNAL_FUNCTION("ARPS"."DUE_DATE"))=TRUNC(SYSDATE@!)) 266 - access("APS"."PAYMENT_STATUS_FLAG"='N') 267 - filter("AI"."PAY_GROUP_LOOKUP_CODE"='ANNUAL_FERC' AND "AI"."CANCELLED_DATE" IS NULL AND "AI"."INVOICE_AMOUNT"<>0) 268 - access("APS"."INVOICE_ID"="AI"."INVOICE_ID") 270 - access("AID"."INVOICE_ID"="AI"."INVOICE_ID") 272 - access("GLCC"."CODE_COMBINATION_ID"="AID"."DIST_CODE_COMBINATION_ID") 274 - filter(UPPER("CTT"."NAME")='ANNUAL_FERC') 282 - access("GLCC"."CODE_COMBINATION_ID"="RCTD"."CODE_COMBINATION_ID") 284 - access("RCTD"."CUSTOMER_TRX_LINE_ID"="RCTL"."CUSTOMER_TRX_LINE_ID") 286 - access("RCTL"."CUSTOMER_TRX_ID"="RCT"."CUSTOMER_TRX_ID") filter( NOT EXISTS (SELECT /*+ */ 0 FROM "AR"."AR_RECEIVABLES_TRX_ALL" "ART","AR"."AR_ADJUSTMENTS_ALL" "ADJ" WHERE "ADJ"."CUSTOMER_TRX_ID"=:B1 AND "ART"."RECEIVABLES_TRX_ID"="ADJ"."RECEIVABLES_TRX_ID" AND UPPER("ART"."NAME")='CANCEL/REBILL ADJUSTMENT' AND "ART"."STATUS"='A')) 287 - filter(UPPER("ART"."NAME")='CANCEL/REBILL ADJUSTMENT' AND "ART"."STATUS"='A') 290 - access("ADJ"."CUSTOMER_TRX_ID"=:B1) 291 - access("ART"."RECEIVABLES_TRX_ID"="ADJ"."RECEIVABLES_TRX_ID") 292 - filter("ARPS"."CLASS"='INV' AND "ARPS"."STATUS"='OP' AND TRUNC(INTERNAL_FUNCTION("ARPS"."DUE_DATE"))>=TRUNC(SYSDATE@!)) 293 - access("ARPS"."CUSTOMER_TRX_ID"="RCT"."CUSTOMER_TRX_ID") 294 - access("CTT"."CUST_TRX_TYPE_ID"="RCT"."CUST_TRX_TYPE_ID") 301 - filter(TRUNC(INTERNAL_FUNCTION("APS"."DUE_DATE"))0) 304 - access("APS"."INVOICE_ID"="AI"."INVOICE_ID") 306 - access("AID"."INVOICE_ID"="AI"."INVOICE_ID") 308 - access("GLCC"."CODE_COMBINATION_ID"="AID"."DIST_CODE_COMBINATION_ID") 310 - filter(UPPER("CTT"."NAME")='ANNUAL_FERC') 318 - access("GLCC"."CODE_COMBINATION_ID"="RCTD"."CODE_COMBINATION_ID") 320 - access("RCTD"."CUSTOMER_TRX_LINE_ID"="RCTL"."CUSTOMER_TRX_LINE_ID") 322 - access("RCTL"."CUSTOMER_TRX_ID"="RCT"."CUSTOMER_TRX_ID") filter( NOT EXISTS (SELECT /*+ */ 0 FROM "AR"."AR_RECEIVABLES_TRX_ALL" "ART","AR"."AR_ADJUSTMENTS_ALL" "ADJ" WHERE "ADJ"."CUSTOMER_TRX_ID"=:B1 AND "ART"."RECEIVABLES_TRX_ID"="ADJ"."RECEIVABLES_TRX_ID" AND UPPER("ART"."NAME")='CANCEL/REBILL ADJUSTMENT' AND "ART"."STATUS"='A')) 323 - filter(UPPER("ART"."NAME")='CANCEL/REBILL ADJUSTMENT' AND "ART"."STATUS"='A') 326 - access("ADJ"."CUSTOMER_TRX_ID"=:B1) 327 - access("ART"."RECEIVABLES_TRX_ID"="ADJ"."RECEIVABLES_TRX_ID") 328 - filter("ARPS"."CLASS"='INV' AND "ARPS"."STATUS"='OP' AND TRUNC(INTERNAL_FUNCTION("ARPS"."DUE_DATE"))TRUNC(SYSDATE@!)-1)) 341 - access("GLCC"."CODE_COMBINATION_ID"="GB"."CODE_COMBINATION_ID") 342 - access("GB2"."CODE_COMBINATION_ID"="GB"."CODE_COMBINATION_ID") 343 - filter("GB"."EFFECTIVE_DATE"=MAX("GB2"."EFFECTIVE_DATE")) 349 - filter(UPPER("SOB"."SHORT_NAME")='MKTEST') 351 - filter("GLCC"."SEGMENT3"='WACFUTURE' AND "GLCC"."SEGMENT4"='0000') 352 - filter("GB"."SET_OF_BOOKS_ID"="SOB"."SET_OF_BOOKS_ID" AND ("GB"."ATTRIBUTE4" IS NULL OR TRUNC(TO_DATE("GB"."ATTRIBUTE4",'YYYY/MM/DD HH24:MI:SS'))TRUNC(SYSDATE@!)-1)) 353 - access("GLCC"."CODE_COMBINATION_ID"="GB"."CODE_COMBINATION_ID") 354 - access("GB2"."CODE_COMBINATION_ID"="GB"."CODE_COMBINATION_ID") 355 - filter("SOB"."SET_OF_BOOKS_ID"="GB"."SET_OF_BOOKS_ID" AND ("GB"."ATTRIBUTE4" IS NULL OR TRUNC(TO_DATE("GB"."ATTRIBUTE4",'YYYY/MM/DD HH24:MI:SS'))TRUNC(SYSDATE@!)-1)) 358 - filter(UPPER("SOB"."SHORT_NAME")='MKTEST') 360 - filter("GLCC"."SEGMENT3"='EAL_ADJUSTMENT' AND "GLCC"."SEGMENT4"='0000') 361 - access("GLCC"."CODE_COMBINATION_ID"="GB"."CODE_COMBINATION_ID") 362 - filter("REVERSE_FLAG"='N' AND "START_DATE" IS NOT NULL AND "END_DATE" IS NOT NULL AND "SEQUENCE_ID" IS NOT NULL) 363 - filter("REVERSE_FLAG"='N' AND "START_DATE" IS NOT NULL AND "END_DATE" IS NOT NULL AND "SEQUENCE_ID" IS NOT NULL) 364 - filter("REVERSE_FLAG"='N' AND "START_DATE" IS NOT NULL AND "END_DATE" IS NOT NULL AND "SEQUENCE_ID" IS NOT NULL) 365 - filter("GB"."EFFECTIVE_DATE"=MAX("GB2"."EFFECTIVE_DATE")) 371 - filter(UPPER("SOB"."SHORT_NAME")='MKTEST') 373 - filter("GLCC"."SEGMENT3"='CRRLIABILITY' AND "GLCC"."SEGMENT4"='0000') 374 - filter("GB"."SET_OF_BOOKS_ID"="SOB"."SET_OF_BOOKS_ID" AND "GB"."ATTRIBUTE7" IS NOT NULL AND "GB"."ATTRIBUTE8" IS NOT NULL AND "GB"."ATTRIBUTE9" IS NULL) 375 - access("GLCC"."CODE_COMBINATION_ID"="GB"."CODE_COMBINATION_ID") 376 - access("GB2"."CODE_COMBINATION_ID"="GB"."CODE_COMBINATION_ID") Note ----- - 'PLAN_TABLE' is old version - cpu costing is off (consider enabling it)