<SQL_EXPLAIN_PLAN>

<DATA_DS>
<![CDATA[
Datamodel SQL Explain Plan Report
================================================================
Driver Details:JDBC Driver:Oracle JDBC
driver:weblogic.jdbc.wrapper.PoolConnection_oracle_jdbc_driver_T4CConnection:23.5.0
.24.07
DBName:Oracle
DBVersion:Oracle Database 19c EE Extreme Perf Release 19.0.0.0.0 - Production
Version 19.26.0.0.0
SQLQuery:EXPLAIN PLAN SET STATEMENT_ID = 'dm_plan_G_ONHAND_250805_123659' FOR
select b.*

from cst_perpavg_cost a,
cst_item_cost_history_v b

where 1=1
and a.REC_TRXN_ID=b.transaction_id
and a.inventory_item_id=b.inventory_item_id
and b.cost_date=(select max(cost_date) from cst_item_cost_history_v where
transaction_id=b.transaction_id)
and a.inventory_item_id=100000015109336

SQL Query Timeout: 500

Number of SQL Executions: 1
PLAN_TABLE_OUTPUT
-----------------------------------------------------------------------------------
------------------
Plan hash value: 3535325778

-----------------------------------------------------------------------------------
---------------------------------------------------
| Id | Operation | Name
| Rows | Bytes | Cost (%CPU)| Time |
-----------------------------------------------------------------------------------
---------------------------------------------------
| 0 | SELECT STATEMENT |
| 1 | 1798 | 670 (6)| 00:00:01 |
| 1 | NESTED LOOPS |
| 1 | 1798 | 670 (6)| 00:00:01 |
| 2 | NESTED LOOPS |
| 1 | 1785 | 528 (4)| 00:00:01 |
| 3 | VIEW |
CST_ITEM_COST_HISTORY_V | 6 | 10614 | 510 (4)| 00:00:01 |
| 4 | UNION-ALL |
| | | | |
| 5 | HASH UNIQUE |
| 4 | 2824 | 434 (3)| 00:00:01 |
| 6 | NESTED LOOPS |
| 4 | 2824 | 433 (2)| 00:00:01 |
| 7 | NESTED LOOPS |
| 4 | 2824 | 433 (2)| 00:00:01 |
|* 8 | HASH JOIN |
| 4 | 2784 | 429 (2)| 00:00:01 |
| 9 | VIEW |
CST_ALL_TXN_TYPES_V | 38 | 7144 | 24 (13)| 00:00:01 |
| 10 | SORT UNIQUE |
| 38 | 8352 | 24 (13)| 00:00:01 |
| 11 | UNION-ALL |
| | | | |
|* 12 | HASH JOIN |
| 8 | 1056 | 8 (0)| 00:00:01 |
| 13 | JOIN FILTER CREATE | :BF0000
| 8 | 176 | 2 (0)| 00:00:01 |
| 14 | NESTED LOOPS |
| 8 | 176 | 2 (0)| 00:00:01 |
| 15 | NESTED LOOPS |
| 8 | 176 | 2 (0)| 00:00:01 |
|* 16 | INDEX RANGE SCAN |
CST_TXN_SOURCE_ACTIONS_U1 | 8 | 64 | 1 (0)| 00:00:01 |
|* 17 | INDEX UNIQUE SCAN |
CST_INTERNAL_TXN_TYPES_B_U2 | 1 | | 0 (0)| 00:00:01 |
| 18 | TABLE ACCESS BY INDEX ROWID |
cst_internal_txn_types_b | 1 | 14 | 1 (0)| 00:00:01 |
| 19 | JOIN FILTER USE | :BF0000
| 49 | 5390 | 6 (0)| 00:00:01 |
|* 20 | TABLE ACCESS STORAGE FULL |
cst_internal_txn_types_tl | 49 | 5390 | 6 (0)| 00:00:01 |
|* 21 | HASH JOIN |
| 30 | 3120 | 13 (0)| 00:00:01 |
| 22 | JOIN FILTER CREATE | :BF0001
| 22 | 748 | 6 (0)| 00:00:01 |
| 23 | NESTED LOOPS |
| 22 | 748 | 6 (0)| 00:00:01 |
|* 24 | TABLE ACCESS STORAGE FULL |
inv_transaction_types_b | 158 | 4108 | 6 (0)| 00:00:01 |
|* 25 | INDEX UNIQUE SCAN |
CST_TXN_SOURCE_ACTIONS_U1 | 1 | 8 | 0 (0)| 00:00:01 |
| 26 | JOIN FILTER USE | :BF0001
| 158 | 11060 | 7 (0)| 00:00:01 |
|* 27 | TABLE ACCESS STORAGE FULL |
inv_transaction_types_tl | 158 | 11060 | 7 (0)| 00:00:01 |
| 28 | NESTED LOOPS |
| 35 | 17780 | 405 (2)| 00:00:01 |
| 29 | NESTED LOOPS |
| 35 | 17780 | 405 (2)| 00:00:01 |
| 30 | VIEW |
| 35 | 16660 | 300 (2)| 00:00:01 |
| 31 | UNION-ALL |
| | | | |
| 32 | HASH GROUP BY |
| 34 | 11594 | 217 (1)| 00:00:01 |
| 33 | VIEW | VM_NWVW_4
| 34 | 11594 | 216 (1)| 00:00:01 |
| 34 | HASH GROUP BY |
| 34 | 11934 | 216 (1)| 00:00:01 |
| 35 | NESTED LOOPS OUTER |
| 34 | 11934 | 215 (0)| 00:00:01 |
| 36 | NESTED LOOPS OUTER |
| 24 | 7968 | 143 (0)| 00:00:01 |
| 37 | NESTED LOOPS |
| 24 | 7464 | 95 (0)| 00:00:01 |
|* 38 | HASH JOIN |
| 24 | 3528 | 47 (0)| 00:00:01 |
| 39 | TABLE ACCESS STORAGE FULL |
cst_cost_elements_b | 12 | 372 | 3 (0)| 00:00:01 |
| 40 | TABLE ACCESS BY INDEX ROWID BATCHED| cst_perpavg_cost
| 24 | 2784 | 44 (0)| 00:00:01 |
|* 41 | INDEX SKIP SCAN |
CST_PERPAVG_COST_N1 | 24 | | 21 (0)| 00:00:01 |
| 42 | TABLE ACCESS BY INDEX ROWID | cst_transactions
| 1 | 164 | 2 (0)| 00:00:01 |
|* 43 | INDEX UNIQUE SCAN |
CST_TRANSACTIONS_U1 | 1 | | 1 (0)| 00:00:01 |
| 44 | TABLE ACCESS BY INDEX ROWID |
cst_inv_transactions | 1 | 21 | 2 (0)| 00:00:01 |
|* 45 | INDEX UNIQUE SCAN |
CST_INV_TRANSACTIONS_U1 | 1 | | 1 (0)| 00:00:01 |
|* 46 | TABLE ACCESS BY INDEX ROWID BATCHED |
cst_transaction_costs | 1 | 19 | 3 (0)| 00:00:01 |
|* 47 | INDEX RANGE SCAN |
CST_TRANSACTION_COSTS_U1 | 1 | | 2 (0)| 00:00:01 |
| 48 | SORT UNIQUE |
| 1 | 63 | 7 (29)| 00:00:01 |
| 49 | WINDOW SORT |
| 1 | 63 | 7 (29)| 00:00:01 |
|* 50 | TABLE ACCESS BY INDEX ROWID BATCHED |
cst_transaction_layers | 1 | 63 | 5 (0)| 00:00:01 |
|* 51 | INDEX RANGE SCAN |
CST_TRANSACTION_LAYERS_N5 | 3 | | 3 (0)| 00:00:01 |
| 52 | HASH GROUP BY |
| 1 | 301 | 83 (4)| 00:00:01 |
| 53 | NESTED LOOPS |
| 1 | 301 | 75 (0)| 00:00:01 |
| 54 | NESTED LOOPS |
| 1 | 301 | 75 (0)| 00:00:01 |
| 55 | NESTED LOOPS |
| 1 | 282 | 74 (0)| 00:00:01 |
| 56 | NESTED LOOPS OUTER |
| 1 | 235 | 71 (0)| 00:00:01 |
|* 57 | TABLE ACCESS BY INDEX ROWID BATCHED | cst_transactions
| 1 | 226 | 69 (0)| 00:00:01 |
|* 58 | INDEX RANGE SCAN |
CST_TRANSACTIONS_N11 | 81 | | 3 (0)| 00:00:01 |
| 59 | TABLE ACCESS BY INDEX ROWID |
cst_inv_transactions | 1 | 9 | 2 (0)| 00:00:01 |
|* 60 | INDEX UNIQUE SCAN |
CST_INV_TRANSACTIONS_U1 | 1 | | 1 (0)| 00:00:01 |
|* 61 | TABLE ACCESS BY INDEX ROWID BATCHED |
cst_transaction_costs | 1 | 47 | 3 (0)| 00:00:01 |
|* 62 | INDEX RANGE SCAN |
CST_TRANSACTION_COSTS_U1 | 1 | | 2 (0)| 00:00:01 |
|* 63 | INDEX UNIQUE SCAN |
CST_COST_ELEMENTS_B_PK | 1 | | 0 (0)| 00:00:01 |
| 64 | TABLE ACCESS BY INDEX ROWID |
cst_cost_elements_b | 1 | 19 | 1 (0)| 00:00:01 |
|* 65 | INDEX RANGE SCAN |
CST_TRANSACTION_COSTS_U1 | 1 | | 2 (0)| 00:00:01 |
|* 66 | TABLE ACCESS BY INDEX ROWID |
cst_transaction_costs | 1 | 32 | 3 (0)| 00:00:01 |
|* 67 | INDEX UNIQUE SCAN |
CST_TXN_SOURCE_ACTIONS_U1 | 1 | | 0 (0)| 00:00:01 |
| 68 | TABLE ACCESS BY INDEX ROWID |
cst_txn_source_actions | 1 | 10 | 1 (0)| 00:00:01 |
| 69 | HASH UNIQUE |
| 1 | 680 | 32 (16)| 00:00:01 |
| 70 | NESTED LOOPS |
| 1 | 680 | 31 (13)| 00:00:01 |
| 71 | NESTED LOOPS |
| 1 | 680 | 31 (13)| 00:00:01 |
|* 72 | HASH JOIN |
| 1 | 670 | 30 (14)| 00:00:01 |
| 73 | VIEW |
| 1 | 469 | 6 (17)| 00:00:01 |
| 74 | HASH GROUP BY |
| 1 | 571 | 6 (17)| 00:00:01 |
| 75 | NESTED LOOPS |
| 1 | 571 | 5 (0)| 00:00:01 |
| 76 | NESTED LOOPS |
| 1 | 571 | 5 (0)| 00:00:01 |
| 77 | NESTED LOOPS |
| 1 | 550 | 3 (0)| 00:00:01 |
|* 78 | FILTER |
| | | | |
| 79 | NESTED LOOPS OUTER |
| 1 | 531 | 3 (0)| 00:00:01 |
| 80 | NESTED LOOPS |
| 1 | 466 | 2 (0)| 00:00:01 |
| 81 | NESTED LOOPS |
| 1 | 229 | 0 (0)| 00:00:01 |
|* 82 | TABLE ACCESS BY INDEX ROWID BATCHED | cst_std_costs
| 1 | 190 | 0 (0)| 00:00:01 |
|* 83 | INDEX RANGE SCAN | CST_STD_COSTS_N4
| 1 | | 0 (0)| 00:00:01 |
| 84 | TABLE ACCESS BY INDEX ROWID BATCHED |
cst_std_cost_details | 1 | 39 | 0 (0)| 00:00:01 |
|* 85 | INDEX RANGE SCAN |
CST_STD_COST_DETAILS_U1 | 1 | | 0 (0)| 00:00:01 |
|* 86 | TABLE ACCESS BY INDEX ROWID BATCHED | cst_transactions
| 1 | 237 | 2 (0)| 00:00:01 |
|* 87 | INDEX RANGE SCAN |
CST_TRANSACTIONS_N8 | 386 | | 2 (0)| 00:00:01 |
| 88 | TABLE ACCESS BY INDEX ROWID BATCHED | cst_variance_costs
| 1 | 65 | 1 (0)| 00:00:01 |
|* 89 | INDEX RANGE SCAN |
CST_VARIANCE_COSTS_U1 | 1 | | 1 (0)| 00:00:01 |
| 90 | TABLE ACCESS BY INDEX ROWID |
cst_cost_elements_b | 1 | 19 | 0 (0)| 00:00:01 |
|* 91 | INDEX UNIQUE SCAN |
CST_COST_ELEMENTS_B_PK | 1 | | 0 (0)| 00:00:01 |
|* 92 | INDEX UNIQUE SCAN |
CST_TRANSACTION_LAYERS_U1 | 1 | | 1 (0)| 00:00:01 |
| 93 | TABLE ACCESS BY INDEX ROWID |
cst_transaction_layers | 1 | 21 | 2 (0)| 00:00:01 |
| 94 | VIEW |
CST_ALL_TXN_TYPES_V | 38 | 7638 | 24 (13)| 00:00:01 |
| 95 | SORT UNIQUE |
| 38 | 8352 | 24 (13)| 00:00:01 |
| 96 | UNION-ALL |
| | | | |
|* 97 | HASH JOIN |
| 8 | 1056 | 8 (0)| 00:00:01 |
| 98 | JOIN FILTER CREATE | :BF0002
| 8 | 176 | 2 (0)| 00:00:01 |
| 99 | NESTED LOOPS |
| 8 | 176 | 2 (0)| 00:00:01 |
| 100 | NESTED LOOPS |
| 8 | 176 | 2 (0)| 00:00:01 |
|*101 | INDEX RANGE SCAN |
CST_TXN_SOURCE_ACTIONS_U1 | 8 | 64 | 1 (0)| 00:00:01 |
|*102 | INDEX UNIQUE SCAN |
CST_INTERNAL_TXN_TYPES_B_U2 | 1 | | 0 (0)| 00:00:01 |
| 103 | TABLE ACCESS BY INDEX ROWID |
cst_internal_txn_types_b | 1 | 14 | 1 (0)| 00:00:01 |
| 104 | JOIN FILTER USE | :BF0002
| 49 | 5390 | 6 (0)| 00:00:01 |
|*105 | TABLE ACCESS STORAGE FULL |
cst_internal_txn_types_tl | 49 | 5390 | 6 (0)| 00:00:01 |
|*106 | HASH JOIN |
| 30 | 3120 | 13 (0)| 00:00:01 |
| 107 | JOIN FILTER CREATE | :BF0003
| 22 | 748 | 6 (0)| 00:00:01 |
| 108 | NESTED LOOPS |
| 22 | 748 | 6 (0)| 00:00:01 |
|*109 | TABLE ACCESS STORAGE FULL |
inv_transaction_types_b | 158 | 4108 | 6 (0)| 00:00:01 |
|*110 | INDEX UNIQUE SCAN |
CST_TXN_SOURCE_ACTIONS_U1 | 1 | 8 | 0 (0)| 00:00:01 |
| 111 | JOIN FILTER USE | :BF0003
| 158 | 11060 | 7 (0)| 00:00:01 |
|*112 | TABLE ACCESS STORAGE FULL |
inv_transaction_types_tl | 158 | 11060 | 7 (0)| 00:00:01 |
|*113 | INDEX UNIQUE SCAN |
CST_TXN_SOURCE_ACTIONS_U1 | 1 | | 0 (0)| 00:00:01 |
| 114 | TABLE ACCESS BY INDEX ROWID |
cst_txn_source_actions | 1 | 10 | 1 (0)| 00:00:01 |
| 115 | HASH UNIQUE |
| 1 | 733 | 44 (14)| 00:00:01 |
|*116 | HASH JOIN |
| 12 | 8796 | 43 (12)| 00:00:01 |
|*117 | HASH JOIN |
| 6 | 1266 | 30 (10)| 00:00:01 |
| 118 | VIEW |
CST_ALL_TXN_TYPES_V | 38 | 7638 | 24 (13)| 00:00:01 |
| 119 | SORT UNIQUE |
| 38 | 8352 | 24 (13)| 00:00:01 |
| 120 | UNION-ALL |
| | | | |
|*121 | HASH JOIN |
| 8 | 1056 | 8 (0)| 00:00:01 |
| 122 | JOIN FILTER CREATE | :BF0004
| 8 | 176 | 2 (0)| 00:00:01 |
| 123 | NESTED LOOPS |
| 8 | 176 | 2 (0)| 00:00:01 |
| 124 | NESTED LOOPS |
| 8 | 176 | 2 (0)| 00:00:01 |
|*125 | INDEX RANGE SCAN |
CST_TXN_SOURCE_ACTIONS_U1 | 8 | 64 | 1 (0)| 00:00:01 |
|*126 | INDEX UNIQUE SCAN |
CST_INTERNAL_TXN_TYPES_B_U2 | 1 | | 0 (0)| 00:00:01 |
| 127 | TABLE ACCESS BY INDEX ROWID |
cst_internal_txn_types_b | 1 | 14 | 1 (0)| 00:00:01 |
| 128 | JOIN FILTER USE | :BF0004
| 49 | 5390 | 6 (0)| 00:00:01 |
|*129 | TABLE ACCESS STORAGE FULL |
cst_internal_txn_types_tl | 49 | 5390 | 6 (0)| 00:00:01 |
|*130 | HASH JOIN |
| 30 | 3120 | 13 (0)| 00:00:01 |
| 131 | JOIN FILTER CREATE | :BF0005
| 22 | 748 | 6 (0)| 00:00:01 |
| 132 | NESTED LOOPS |
| 22 | 748 | 6 (0)| 00:00:01 |
|*133 | TABLE ACCESS STORAGE FULL |
inv_transaction_types_b | 158 | 4108 | 6 (0)| 00:00:01 |
|*134 | INDEX UNIQUE SCAN |
CST_TXN_SOURCE_ACTIONS_U1 | 1 | 8 | 0 (0)| 00:00:01 |
| 135 | JOIN FILTER USE | :BF0005
| 158 | 11060 | 7 (0)| 00:00:01 |
|*136 | TABLE ACCESS STORAGE FULL |
inv_transaction_types_tl | 158 | 11060 | 7 (0)| 00:00:01 |
|*137 | TABLE ACCESS STORAGE FULL |
cst_txn_source_actions | 118 | 1180 | 6 (0)| 00:00:01 |
| 138 | VIEW |
| 2 | 1044 | 13 (16)| 00:00:01 |
| 139 | UNION-ALL |
| | | | |
| 140 | HASH GROUP BY |
| 1 | 556 | 7 (15)| 00:00:01 |
| 141 | NESTED LOOPS |
| 1 | 556 | 6 (0)| 00:00:01 |
| 142 | NESTED LOOPS |
| 1 | 556 | 6 (0)| 00:00:01 |
| 143 | NESTED LOOPS |
| 1 | 484 | 3 (0)| 00:00:01 |
| 144 | NESTED LOOPS |
| 1 | 235 | 1 (0)| 00:00:01 |
| 145 | NESTED LOOPS |
| 1 | 200 | 1 (0)| 00:00:01 |
| 146 | TABLE ACCESS BY INDEX ROWID BATCHED |
cst_periodic_avg_costs | 1 | 181 | 1 (0)| 00:00:01 |
|*147 | INDEX SKIP SCAN |
CST_PERIODIC_AVG_COSTS_U2 | 1 | | 1 (0)| 00:00:01 |
| 148 | TABLE ACCESS BY INDEX ROWID |
cst_cost_elements_b | 1 | 19 | 0 (0)| 00:00:01 |
|*149 | INDEX UNIQUE SCAN |
CST_COST_ELEMENTS_B_PK | 1 | | 0 (0)| 00:00:01 |
| 150 | TABLE ACCESS BY INDEX ROWID |
cst_period_statuses | 1 | 35 | 0 (0)| 00:00:01 |
|*151 | INDEX UNIQUE SCAN |
CST_PERIOD_STATUSES_U1 | 1 | | 0 (0)| 00:00:01 |
|*152 | TABLE ACCESS BY INDEX ROWID BATCHED | cst_transactions
| 1 | 249 | 2 (0)| 00:00:01 |
|*153 | INDEX RANGE SCAN |
CST_TRANSACTIONS_N8 | 386 | | 2 (0)| 00:00:01 |
|*154 | INDEX RANGE SCAN |
CST_TRANSACTION_COSTS_U1 | 1 | | 2 (0)| 00:00:01 |
|*155 | TABLE ACCESS BY INDEX ROWID |
cst_transaction_costs | 1 | 72 | 3 (0)| 00:00:01 |
| 156 | HASH GROUP BY |
| 1 | 551 | 6 (17)| 00:00:01 |
| 157 | NESTED LOOPS |
| 1 | 551 | 5 (0)| 00:00:01 |
| 158 | NESTED LOOPS |
| 1 | 551 | 5 (0)| 00:00:01 |
| 159 | NESTED LOOPS |
| 1 | 433 | 3 (0)| 00:00:01 |
| 160 | NESTED LOOPS |
| 1 | 235 | 1 (0)| 00:00:01 |
| 161 | NESTED LOOPS |
| 1 | 200 | 1 (0)| 00:00:01 |
| 162 | TABLE ACCESS BY INDEX ROWID BATCHED |
cst_periodic_avg_costs | 1 | 181 | 1 (0)| 00:00:01 |
|*163 | INDEX SKIP SCAN |
CST_PERIODIC_AVG_COSTS_U2 | 1 | | 1 (0)| 00:00:01 |
| 164 | TABLE ACCESS BY INDEX ROWID |
cst_cost_elements_b | 1 | 19 | 0 (0)| 00:00:01 |
|*165 | INDEX UNIQUE SCAN |
CST_COST_ELEMENTS_B_PK | 1 | | 0 (0)| 00:00:01 |
| 166 | TABLE ACCESS BY INDEX ROWID |
cst_period_statuses | 1 | 35 | 0 (0)| 00:00:01 |
|*167 | INDEX UNIQUE SCAN |
CST_PERIOD_STATUSES_U1 | 1 | | 0 (0)| 00:00:01 |
|*168 | TABLE ACCESS BY INDEX ROWID BATCHED | cst_transactions
| 1 | 198 | 2 (0)| 00:00:01 |
|*169 | INDEX RANGE SCAN |
CST_TRANSACTIONS_N8 | 386 | | 2 (0)| 00:00:01 |
|*170 | INDEX RANGE SCAN |
CST_TRANSACTION_COSTS_N5 | 1 | | 2 (0)| 00:00:01 |
|*171 | TABLE ACCESS BY INDEX ROWID |
cst_transaction_costs | 1 | 118 | 2 (0)| 00:00:01 |
|*172 | TABLE ACCESS BY INDEX ROWID BATCHED | cst_perpavg_cost
| 1 | 16 | 3 (0)| 00:00:01 |
|*173 | INDEX RANGE SCAN |
CST_PERPAVG_COST_N2 | 1 | | 2 (0)| 00:00:01 |
|*174 | VIEW PUSHED PREDICATE | VW_SQ_1
| 1 | 13 | 141 (14)| 00:00:01 |
|*175 | FILTER |
| | | | |
| 176 | SORT AGGREGATE |
| 1 | 26 | | |
| 177 | VIEW |
CST_ITEM_COST_HISTORY_V | 3 | 78 | 141 (14)| 00:00:01 |
| 178 | UNION-ALL |
| | | | |
| 179 | SORT UNIQUE |
| 1 | 577 | 61 (14)| 00:00:01 |
|*180 | HASH JOIN |
| 1 | 577 | 60 (12)| 00:00:01 |
| 181 | NESTED LOOPS |
| 1 | 389 | 36 (12)| 00:00:01 |
| 182 | NESTED LOOPS |
| 1 | 389 | 36 (12)| 00:00:01 |
|*183 | HASH JOIN |
| 1 | 379 | 35 (12)| 00:00:01 |
|*184 | TABLE ACCESS BY INDEX ROWID BATCHED |
cst_transaction_costs | 1 | 32 | 4 (0)| 00:00:01 |
|*185 | INDEX RANGE SCAN |
CST_TRANSACTION_COSTS_U1 | 1 | | 3 (0)| 00:00:01 |
| 186 | VIEW |
| 2 | 694 | 31 (13)| 00:00:01 |
| 187 | UNION-ALL |
| | | | |
| 188 | SORT GROUP BY |
| 1 | 314 | 14 (8)| 00:00:01 |
| 189 | NESTED LOOPS |
| 1 | 314 | 13 (0)| 00:00:01 |
| 190 | NESTED LOOPS |
| 1 | 314 | 13 (0)| 00:00:01 |
|*191 | HASH JOIN OUTER |
| 1 | 295 | 12 (0)| 00:00:01 |
| 192 | NESTED LOOPS |
| 1 | 265 | 8 (0)| 00:00:01 |
| 193 | NESTED LOOPS OUTER |
| 1 | 161 | 5 (0)| 00:00:01 |
| 194 | TABLE ACCESS BY INDEX ROWID | cst_transactions
| 1 | 152 | 3 (0)| 00:00:01 |
|*195 | INDEX UNIQUE SCAN |
CST_TRANSACTIONS_U1 | 1 | | 2 (0)| 00:00:01 |
| 196 | TABLE ACCESS BY INDEX ROWID |
cst_inv_transactions | 1 | 9 | 2 (0)| 00:00:01 |
|*197 | INDEX UNIQUE SCAN |
CST_INV_TRANSACTIONS_U1 | 1 | | 1 (0)| 00:00:01 |
| 198 | TABLE ACCESS BY INDEX ROWID BATCHED | cst_perpavg_cost
| 1 | 104 | 3 (0)| 00:00:01 |
|*199 | INDEX RANGE SCAN |
CST_PERPAVG_COST_U3 | 1 | | 2 (0)| 00:00:01 |
| 200 | VIEW | VW_SSQ_3
| 1 | 30 | 4 (0)| 00:00:01 |
| 201 | SORT GROUP BY |
| 1 | 19 | 4 (0)| 00:00:01 |
|*202 | TABLE ACCESS BY INDEX ROWID BATCHED|
cst_transaction_costs | 1 | 19 | 4 (0)| 00:00:01 |
|*203 | INDEX RANGE SCAN |
CST_TRANSACTION_COSTS_U1 | 1 | | 3 (0)| 00:00:01 |
|*204 | INDEX UNIQUE SCAN |
CST_COST_ELEMENTS_B_PK | 1 | | 0 (0)| 00:00:01 |
| 205 | TABLE ACCESS BY INDEX ROWID |
cst_cost_elements_b | 1 | 19 | 1 (0)| 00:00:01 |
| 206 | SORT UNIQUE |
| 1 | 63 | 7 (29)| 00:00:01 |
| 207 | WINDOW SORT |
| 1 | 63 | 7 (29)| 00:00:01 |
|*208 | TABLE ACCESS BY INDEX ROWID BATCHED |
cst_transaction_layers | 1 | 63 | 5 (0)| 00:00:01 |
|*209 | INDEX RANGE SCAN |
CST_TRANSACTION_LAYERS_N5 | 3 | | 3 (0)| 00:00:01 |
| 210 | SORT GROUP BY |
| 1 | 301 | 17 (18)| 00:00:01 |
| 211 | NESTED LOOPS |
| 1 | 301 | 9 (0)| 00:00:01 |
| 212 | NESTED LOOPS |
| 1 | 301 | 9 (0)| 00:00:01 |
| 213 | NESTED LOOPS |
| 1 | 282 | 8 (0)| 00:00:01 |
| 214 | NESTED LOOPS OUTER |
| 1 | 235 | 5 (0)| 00:00:01 |
|*215 | TABLE ACCESS BY INDEX ROWID | cst_transactions
| 1 | 226 | 3 (0)| 00:00:01 |
|*216 | INDEX UNIQUE SCAN |
CST_TRANSACTIONS_U1 | 1 | | 2 (0)| 00:00:01 |
| 217 | TABLE ACCESS BY INDEX ROWID |
cst_inv_transactions | 1 | 9 | 2 (0)| 00:00:01 |
|*218 | INDEX UNIQUE SCAN |
CST_INV_TRANSACTIONS_U1 | 1 | | 1 (0)| 00:00:01 |
|*219 | TABLE ACCESS BY INDEX ROWID BATCHED |
cst_transaction_costs | 1 | 47 | 3 (0)| 00:00:01 |
|*220 | INDEX RANGE SCAN |
CST_TRANSACTION_COSTS_U1 | 1 | | 2 (0)| 00:00:01 |
|*221 | INDEX UNIQUE SCAN |
CST_COST_ELEMENTS_B_PK | 1 | | 0 (0)| 00:00:01 |
| 222 | TABLE ACCESS BY INDEX ROWID |
cst_cost_elements_b | 1 | 19 | 1 (0)| 00:00:01 |
|*223 | INDEX UNIQUE SCAN |
CST_TXN_SOURCE_ACTIONS_U1 | 1 | | 0 (0)| 00:00:01 |
| 224 | TABLE ACCESS BY INDEX ROWID |
cst_txn_source_actions | 1 | 10 | 1 (0)| 00:00:01 |
| 225 | VIEW |
CST_ALL_TXN_TYPES_V | 38 | 7144 | 24 (13)| 00:00:01 |
| 226 | SORT UNIQUE |
| 38 | 8352 | 24 (13)| 00:00:01 |
| 227 | UNION-ALL |
| | | | |
|*228 | HASH JOIN |
| 8 | 1056 | 8 (0)| 00:00:01 |
| 229 | NESTED LOOPS |
| 8 | 176 | 2 (0)| 00:00:01 |
| 230 | NESTED LOOPS |
| 8 | 176 | 2 (0)| 00:00:01 |
|*231 | INDEX RANGE SCAN |
CST_TXN_SOURCE_ACTIONS_U1 | 8 | 64 | 1 (0)| 00:00:01 |
|*232 | INDEX UNIQUE SCAN |
CST_INTERNAL_TXN_TYPES_B_U2 | 1 | | 0 (0)| 00:00:01 |
| 233 | TABLE ACCESS BY INDEX ROWID |
cst_internal_txn_types_b | 1 | 14 | 1 (0)| 00:00:01 |
|*234 | TABLE ACCESS STORAGE FULL |
cst_internal_txn_types_tl | 49 | 5390 | 6 (0)| 00:00:01 |
|*235 | HASH JOIN |
| 30 | 3120 | 13 (0)| 00:00:01 |
| 236 | NESTED LOOPS |
| 22 | 748 | 6 (0)| 00:00:01 |
|*237 | TABLE ACCESS STORAGE FULL |
inv_transaction_types_b | 158 | 4108 | 6 (0)| 00:00:01 |
|*238 | INDEX UNIQUE SCAN |
CST_TXN_SOURCE_ACTIONS_U1 | 1 | 8 | 0 (0)| 00:00:01 |
|*239 | TABLE ACCESS STORAGE FULL |
inv_transaction_types_tl | 158 | 11060 | 7 (0)| 00:00:01 |
| 240 | SORT UNIQUE |
| 1 | 680 | 33 (16)| 00:00:01 |
| 241 | NESTED LOOPS |
| 1 | 680 | 32 (13)| 00:00:01 |
| 242 | NESTED LOOPS |
| 1 | 680 | 32 (13)| 00:00:01 |
|*243 | HASH JOIN |
| 1 | 670 | 31 (13)| 00:00:01 |
| 244 | VIEW |
| 1 | 469 | 7 (15)| 00:00:01 |
| 245 | SORT GROUP BY |
| 1 | 571 | 7 (15)| 00:00:01 |
| 246 | NESTED LOOPS |
| 1 | 571 | 6 (0)| 00:00:01 |
| 247 | NESTED LOOPS |
| 1 | 571 | 6 (0)| 00:00:01 |
|*248 | FILTER |
| | | | |
| 249 | NESTED LOOPS OUTER |
| 1 | 552 | 6 (0)| 00:00:01 |
| 250 | NESTED LOOPS |
| 1 | 487 | 5 (0)| 00:00:01 |
|*251 | HASH JOIN |
| 1 | 448 | 5 (0)| 00:00:01 |
| 252 | NESTED LOOPS |
| 1 | 258 | 5 (0)| 00:00:01 |
|*253 | TABLE ACCESS BY INDEX ROWID | cst_transactions
| 1 | 237 | 3 (0)| 00:00:01 |
|*254 | INDEX UNIQUE SCAN |
CST_TRANSACTIONS_U1 | 1 | | 2 (0)| 00:00:01 |
| 255 | TABLE ACCESS BY INDEX ROWID |
cst_transaction_layers | 1 | 21 | 2 (0)| 00:00:01 |
|*256 | INDEX UNIQUE SCAN |
CST_TRANSACTION_LAYERS_U1 | 1 | | 1 (0)| 00:00:01 |
| 257 | TABLE ACCESS BY INDEX ROWID BATCHED | cst_std_costs
| 1 | 190 | 0 (0)| 00:00:01 |
|*258 | INDEX RANGE SCAN | CST_STD_COSTS_N5
| 1 | | 0 (0)| 00:00:01 |
| 259 | TABLE ACCESS BY INDEX ROWID BATCHED |
cst_std_cost_details | 1 | 39 | 0 (0)| 00:00:01 |
|*260 | INDEX RANGE SCAN |
CST_STD_COST_DETAILS_U1 | 1 | | 0 (0)| 00:00:01 |
| 261 | TABLE ACCESS BY INDEX ROWID BATCHED | cst_variance_costs
| 1 | 65 | 1 (0)| 00:00:01 |
|*262 | INDEX RANGE SCAN |
CST_VARIANCE_COSTS_U1 | 1 | | 1 (0)| 00:00:01 |
|*263 | INDEX UNIQUE SCAN |
CST_COST_ELEMENTS_B_PK | 1 | | 0 (0)| 00:00:01 |
| 264 | TABLE ACCESS BY INDEX ROWID |
cst_cost_elements_b | 1 | 19 | 0 (0)| 00:00:01 |
| 265 | VIEW |
CST_ALL_TXN_TYPES_V | 38 | 7638 | 24 (13)| 00:00:01 |
| 266 | SORT UNIQUE |
| 38 | 8352 | 24 (13)| 00:00:01 |
| 267 | UNION-ALL |
| | | | |
|*268 | HASH JOIN |
| 8 | 1056 | 8 (0)| 00:00:01 |
| 269 | NESTED LOOPS |
| 8 | 176 | 2 (0)| 00:00:01 |
| 270 | NESTED LOOPS |
| 8 | 176 | 2 (0)| 00:00:01 |
|*271 | INDEX RANGE SCAN |
CST_TXN_SOURCE_ACTIONS_U1 | 8 | 64 | 1 (0)| 00:00:01 |
|*272 | INDEX UNIQUE SCAN |
CST_INTERNAL_TXN_TYPES_B_U2 | 1 | | 0 (0)| 00:00:01 |
| 273 | TABLE ACCESS BY INDEX ROWID |
cst_internal_txn_types_b | 1 | 14 | 1 (0)| 00:00:01 |
|*274 | TABLE ACCESS STORAGE FULL |
cst_internal_txn_types_tl | 49 | 5390 | 6 (0)| 00:00:01 |
|*275 | HASH JOIN |
| 30 | 3120 | 13 (0)| 00:00:01 |
| 276 | NESTED LOOPS |
| 22 | 748 | 6 (0)| 00:00:01 |
|*277 | TABLE ACCESS STORAGE FULL |
inv_transaction_types_b | 158 | 4108 | 6 (0)| 00:00:01 |
|*278 | INDEX UNIQUE SCAN |
CST_TXN_SOURCE_ACTIONS_U1 | 1 | 8 | 0 (0)| 00:00:01 |
|*279 | TABLE ACCESS STORAGE FULL |
inv_transaction_types_tl | 158 | 11060 | 7 (0)| 00:00:01 |
|*280 | INDEX UNIQUE SCAN |
CST_TXN_SOURCE_ACTIONS_U1 | 1 | | 0 (0)| 00:00:01 |
| 281 | TABLE ACCESS BY INDEX ROWID |
cst_txn_source_actions | 1 | 10 | 1 (0)| 00:00:01 |
| 282 | SORT UNIQUE |
| 1 | 733 | 47 (13)| 00:00:01 |
|*283 | HASH JOIN |
| 12 | 8796 | 46 (11)| 00:00:01 |
|*284 | HASH JOIN |
| 6 | 1266 | 30 (10)| 00:00:01 |
| 285 | VIEW |
CST_ALL_TXN_TYPES_V | 38 | 7638 | 24 (13)| 00:00:01 |
| 286 | SORT UNIQUE |
| 38 | 8352 | 24 (13)| 00:00:01 |
| 287 | UNION-ALL |
| | | | |
|*288 | HASH JOIN |
| 8 | 1056 | 8 (0)| 00:00:01 |
| 289 | NESTED LOOPS |
| 8 | 176 | 2 (0)| 00:00:01 |
| 290 | NESTED LOOPS |
| 8 | 176 | 2 (0)| 00:00:01 |
|*291 | INDEX RANGE SCAN |
CST_TXN_SOURCE_ACTIONS_U1 | 8 | 64 | 1 (0)| 00:00:01 |
|*292 | INDEX UNIQUE SCAN |
CST_INTERNAL_TXN_TYPES_B_U2 | 1 | | 0 (0)| 00:00:01 |
| 293 | TABLE ACCESS BY INDEX ROWID |
cst_internal_txn_types_b | 1 | 14 | 1 (0)| 00:00:01 |
|*294 | TABLE ACCESS STORAGE FULL |
cst_internal_txn_types_tl | 49 | 5390 | 6 (0)| 00:00:01 |
|*295 | HASH JOIN |
| 30 | 3120 | 13 (0)| 00:00:01 |
| 296 | NESTED LOOPS |
| 22 | 748 | 6 (0)| 00:00:01 |
|*297 | TABLE ACCESS STORAGE FULL |
inv_transaction_types_b | 158 | 4108 | 6 (0)| 00:00:01 |
|*298 | INDEX UNIQUE SCAN |
CST_TXN_SOURCE_ACTIONS_U1 | 1 | 8 | 0 (0)| 00:00:01 |
|*299 | TABLE ACCESS STORAGE FULL |
inv_transaction_types_tl | 158 | 11060 | 7 (0)| 00:00:01 |
|*300 | TABLE ACCESS STORAGE FULL |
cst_txn_source_actions | 118 | 1180 | 6 (0)| 00:00:01 |
| 301 | VIEW |
| 2 | 1044 | 16 (13)| 00:00:01 |
| 302 | UNION-ALL |
| | | | |
| 303 | SORT GROUP BY |
| 1 | 556 | 8 (13)| 00:00:01 |
| 304 | NESTED LOOPS |
| 1 | 556 | 7 (0)| 00:00:01 |
| 305 | NESTED LOOPS |
| 1 | 556 | 7 (0)| 00:00:01 |
| 306 | NESTED LOOPS |
| 1 | 484 | 4 (0)| 00:00:01 |
| 307 | NESTED LOOPS |
| 1 | 449 | 4 (0)| 00:00:01 |
| 308 | NESTED LOOPS |
| 1 | 430 | 4 (0)| 00:00:01 |
|*309 | TABLE ACCESS BY INDEX ROWID | cst_transactions
| 1 | 249 | 3 (0)| 00:00:01 |
|*310 | INDEX UNIQUE SCAN |
CST_TRANSACTIONS_U1 | 1 | | 2 (0)| 00:00:01 |
| 311 | TABLE ACCESS BY INDEX ROWID BATCHED |
cst_periodic_avg_costs | 1 | 181 | 1 (0)| 00:00:01 |
|*312 | INDEX RANGE SCAN |
CST_PERIODIC_AVG_COSTS_U2 | 1 | | 1 (0)| 00:00:01 |
| 313 | TABLE ACCESS BY INDEX ROWID |
cst_cost_elements_b | 1 | 19 | 0 (0)| 00:00:01 |
|*314 | INDEX UNIQUE SCAN |
CST_COST_ELEMENTS_B_PK | 1 | | 0 (0)| 00:00:01 |
| 315 | TABLE ACCESS BY INDEX ROWID |
cst_period_statuses | 1 | 35 | 0 (0)| 00:00:01 |
|*316 | INDEX UNIQUE SCAN |
CST_PERIOD_STATUSES_U1 | 1 | | 0 (0)| 00:00:01 |
|*317 | INDEX RANGE SCAN |
CST_TRANSACTION_COSTS_U1 | 1 | | 2 (0)| 00:00:01 |
|*318 | TABLE ACCESS BY INDEX ROWID |
cst_transaction_costs | 1 | 72 | 3 (0)| 00:00:01 |
| 319 | SORT GROUP BY |
| 1 | 551 | 8 (13)| 00:00:01 |
| 320 | NESTED LOOPS |
| 1 | 551 | 7 (0)| 00:00:01 |
| 321 | NESTED LOOPS |
| 1 | 551 | 7 (0)| 00:00:01 |
| 322 | NESTED LOOPS |
| 1 | 516 | 7 (0)| 00:00:01 |
| 323 | NESTED LOOPS |
| 1 | 497 | 7 (0)| 00:00:01 |
| 324 | NESTED LOOPS |
| 1 | 316 | 6 (0)| 00:00:01 |
|*325 | TABLE ACCESS BY INDEX ROWID | cst_transactions
| 1 | 198 | 3 (0)| 00:00:01 |
|*326 | INDEX UNIQUE SCAN |
CST_TRANSACTIONS_U1 | 1 | | 2 (0)| 00:00:01 |
|*327 | TABLE ACCESS BY INDEX ROWID BATCHED |
cst_transaction_costs | 1 | 118 | 3 (0)| 00:00:01 |
|*328 | INDEX RANGE SCAN |
CST_TRANSACTION_COSTS_U1 | 1 | | 2 (0)| 00:00:01 |
| 329 | TABLE ACCESS BY INDEX ROWID BATCHED |
cst_periodic_avg_costs | 1 | 181 | 1 (0)| 00:00:01 |
|*330 | INDEX RANGE SCAN |
CST_PERIODIC_AVG_COSTS_U2 | 1 | | 1 (0)| 00:00:01 |
| 331 | TABLE ACCESS BY INDEX ROWID |
cst_cost_elements_b | 1 | 19 | 0 (0)| 00:00:01 |
|*332 | INDEX UNIQUE SCAN |
CST_COST_ELEMENTS_B_PK | 1 | | 0 (0)| 00:00:01 |
|*333 | INDEX UNIQUE SCAN |
CST_PERIOD_STATUSES_U1 | 1 | | 0 (0)| 00:00:01 |
| 334 | TABLE ACCESS BY INDEX ROWID |
cst_period_statuses | 1 | 35 | 0 (0)| 00:00:01 |
-----------------------------------------------------------------------------------
---------------------------------------------------

Predicate Information (identified by operation id):

---------------------------------------------------

8 - access("B"."BASE_TXN_TYPE_ID"="C"."BASE_TXN_TYPE_ID" AND
"B"."BASE_TXN_SOURCE_TYPE_ID"="C"."BASE_TXN_SOURCE_TYPE_ID")
12 - access("BASE_TXN_TYPE_ID"="BASE_TXN_TYPE_ID")
16 - access("BASE_TXN_SOURCE_TYPE_ID"=0 AND "ORA_SEED_SET1"='Y')
filter("ORA_SEED_SET1"='Y')
17 - access("BASE_TXN_SOURCE_TYPE_ID"=0 AND
"BASE_TXN_ACTION_ID"="BASE_TXN_ACTION_ID" AND "ORA_SEED_SET1"='Y')
20 - storage("LANGUAGE"=USERENV('LANG') AND "ORA_SEED_SET1"='Y' AND
SYS_OP_BLOOM_FILTER(:BF0000,"BASE_TXN_TYPE_ID"))
filter("LANGUAGE"=USERENV('LANG') AND "ORA_SEED_SET1"='Y' AND
SYS_OP_BLOOM_FILTER(:BF0000,"BASE_TXN_TYPE_ID"))
21 - access("TRANSACTION_TYPE_ID"="TRANSACTION_TYPE_ID")
24 - storage("ORA_SEED_SET2"='Y' AND CASE WHEN "TRANSACTION_SOURCE_TYPE_ID">100
THEN 13 ELSE "TRANSACTION_SOURCE_TYPE_ID"
END <>0)
filter("ORA_SEED_SET2"='Y' AND CASE WHEN "TRANSACTION_SOURCE_TYPE_ID">100
THEN 13 ELSE "TRANSACTION_SOURCE_TYPE_ID"
END <>0)
25 - access("BASE_TXN_SOURCE_TYPE_ID"=CASE WHEN
("TRANSACTION_SOURCE_TYPE_ID">100) THEN 13 ELSE
"TRANSACTION_SOURCE_TYPE_ID" END AND
"BASE_TXN_ACTION_ID"=TO_NUMBER("TRANSACTION_ACTION_ID") AND "ORA_SEED_SET1"='Y')
filter("BASE_TXN_SOURCE_TYPE_ID"<>0)
27 - storage("LANGUAGE"=USERENV('LANG') AND "ORA_SEED_SET2"='Y' AND
SYS_OP_BLOOM_FILTER(:BF0001,"TRANSACTION_TYPE_ID"))
filter("LANGUAGE"=USERENV('LANG') AND "ORA_SEED_SET2"='Y' AND
SYS_OP_BLOOM_FILTER(:BF0001,"TRANSACTION_TYPE_ID"))
38 - access("CCE"."COST_ELEMENT_ID"="CPC"."COST_ELEMENT_ID")
41 - access("CPC"."INVENTORY_ITEM_ID"=100000015109336)
filter("CPC"."INVENTORY_ITEM_ID"=100000015109336)
43 - access("CT"."TRANSACTION_ID"="CPC"."TRANSACTION_ID")
45 - access("CSIT"."CST_INV_TRANSACTION_ID"(+)="CT"."CST_INV_TRANSACTION_ID")
46 - filter("CTC2"."ADJUSTMENT_DATE"(+) IS NOT NULL)
47 - access("CTC2"."TRANSACTION_ID"(+)="CPC"."TRANSACTION_ID" AND
"CTC2"."EFF_DATE"(+)="CPC"."EFF_DATE")
50 - filter("L"."INVENTORY_ITEM_ID"=:B1 AND "L"."VAL_UNIT_ID"=:B2 AND
"L"."COST_BOOK_ID"=:B3 AND "L"."COST_ORG_ID"=:B4 AND
"L"."QUANTITY_ONHAND" IS NOT NULL AND "L"."POSTED_FLAG"='Y')
51 - access("L"."REC_TRXN_ID"=:B1)
57 - filter("CT"."COST_METHOD_CODE"='ACTUAL' AND
"CT"."COST_TRANSACTION_TYPE"='RECEIPT')
58 - access("CT"."INVENTORY_ITEM_ID"=100000015109336)
60 - access("CSIT"."CST_INV_TRANSACTION_ID"(+)="CT"."CST_INV_TRANSACTION_ID")
61 - filter("CTC"."VALID_COST_FLAG"='Y')
62 - access("CT"."TRANSACTION_ID"="CTC"."TRANSACTION_ID")
filter("CTC"."EXPENSE_POOL_ID"<>(-5))
63 - access("CCE"."COST_ELEMENT_ID"="CTC"."COST_ELEMENT_ID")
65 - access("A"."TRANSACTION_ID"="B"."TRANSACTION_ID" AND
"A"."EFF_DATE"="B"."EFF_DATE")
filter("B"."EXPENSE_POOL_ID"<>(-5))
66 - filter("B"."VALID_COST_FLAG"='Y')
67 - access("B"."BASE_TXN_SOURCE_TYPE_ID"="BASE_TXN_SOURCE_TYPE_ID" AND
"B"."BASE_TXN_ACTION_ID"="BASE_TXN_ACTION_ID" AND
 "ORA_SEED_SET1"='Y')
72 - access("A"."BASE_TXN_TYPE_ID"="C"."BASE_TXN_TYPE_ID" AND
"A"."BASE_TXN_SOURCE_TYPE_ID"="C"."BASE_TXN_SOURCE_TYPE_ID")
78 - filter("CVC"."COST_ELEMENT_ID" IS NULL OR
"CVC"."COST_ELEMENT_ID"="CSCD"."COST_ELEMENT_ID")
82 - filter("CSC"."STATUS_CODE"='PUBLISHED')
83 - access("CSC"."INVENTORY_ITEM_ID"=100000015109336)
85 - access("CSC"."STD_COST_ID"="CSCD"."STD_COST_ID")
86 - filter("CT"."COST_ORG_ID"="CSC"."COST_ORG_ID" AND
"CT"."COST_BOOK_ID"="CSC"."COST_BOOK_ID" AND
"CT"."INVENTORY_ITEM_ID"=100000015109336 AND
"CT"."COST_METHOD_CODE"='STANDARD' AND "CT"."COST_TRANSACTION_TYPE"='RECEIPT'
AND "CSC"."EFFECTIVE_END_DATE">=TRUNC(INTERNAL_FUNCTION("COST_DATE"))
AND
"CSC"."EFFECTIVE_START_DATE"<=TRUNC(INTERNAL_FUNCTION("COST_DATE")))
87 - access("CT"."VAL_UNIT_ID"="CSC"."VAL_UNIT_ID")
filter("CT"."VAL_UNIT_ID" IS NOT NULL)
89 - access("CT"."TRANSACTION_ID"="CVC"."TRANSACTION_ID"(+) AND
"CT"."TRANSACTION_ID"="CVC"."REC_TRXN_ID"(+) AND
"CVC"."DEP_TRXN_ID"(+)=0)
91 - access("CCE"."COST_ELEMENT_ID"="CSCD"."COST_ELEMENT_ID")
92 - access("CT"."TRANSACTION_ID"="CTL"."TRANSACTION_ID" AND
"CT"."TRANSACTION_ID"="CTL"."REC_TRXN_ID" AND
"CTL"."DEP_TRXN_ID"=0)
97 - access("BASE_TXN_TYPE_ID"="BASE_TXN_TYPE_ID")
101 - access("BASE_TXN_SOURCE_TYPE_ID"=0 AND "ORA_SEED_SET1"='Y')
filter("ORA_SEED_SET1"='Y')
102 - access("BASE_TXN_SOURCE_TYPE_ID"=0 AND
"BASE_TXN_ACTION_ID"="BASE_TXN_ACTION_ID" AND "ORA_SEED_SET1"='Y')
105 - storage("LANGUAGE"=USERENV('LANG') AND "ORA_SEED_SET1"='Y' AND
SYS_OP_BLOOM_FILTER(:BF0002,"BASE_TXN_TYPE_ID"))
filter("LANGUAGE"=USERENV('LANG') AND "ORA_SEED_SET1"='Y' AND
SYS_OP_BLOOM_FILTER(:BF0002,"BASE_TXN_TYPE_ID"))
106 - access("TRANSACTION_TYPE_ID"="TRANSACTION_TYPE_ID")
109 - storage("ORA_SEED_SET2"='Y' AND CASE WHEN "TRANSACTION_SOURCE_TYPE_ID">100
THEN 13 ELSE "TRANSACTION_SOURCE_TYPE_ID"
END <>0)
filter("ORA_SEED_SET2"='Y' AND CASE WHEN "TRANSACTION_SOURCE_TYPE_ID">100
THEN 13 ELSE "TRANSACTION_SOURCE_TYPE_ID"
END <>0)
110 - access("BASE_TXN_SOURCE_TYPE_ID"=CASE WHEN
("TRANSACTION_SOURCE_TYPE_ID">100) THEN 13 ELSE
"TRANSACTION_SOURCE_TYPE_ID" END AND
"BASE_TXN_ACTION_ID"=TO_NUMBER("TRANSACTION_ACTION_ID") AND "ORA_SEED_SET1"='Y')
filter("BASE_TXN_SOURCE_TYPE_ID"<>0)
112 - storage("LANGUAGE"=USERENV('LANG') AND "ORA_SEED_SET2"='Y' AND
SYS_OP_BLOOM_FILTER(:BF0003,"TRANSACTION_TYPE_ID"))
filter("LANGUAGE"=USERENV('LANG') AND "ORA_SEED_SET2"='Y' AND
SYS_OP_BLOOM_FILTER(:BF0003,"TRANSACTION_TYPE_ID"))
113 - access("C"."BASE_TXN_SOURCE_TYPE_ID"="BASE_TXN_SOURCE_TYPE_ID" AND
"C"."BASE_TXN_ACTION_ID"="BASE_TXN_ACTION_ID" AND
"ORA_SEED_SET1"='Y')
116 - access("A"."BASE_TXN_TYPE_ID"="C"."BASE_TXN_TYPE_ID" AND
"A"."BASE_TXN_SOURCE_TYPE_ID"="C"."BASE_TXN_SOURCE_TYPE_ID")
117 - access("C"."BASE_TXN_SOURCE_TYPE_ID"="BASE_TXN_SOURCE_TYPE_ID" AND
"C"."BASE_TXN_ACTION_ID"="BASE_TXN_ACTION_ID")
121 - access("BASE_TXN_TYPE_ID"="BASE_TXN_TYPE_ID")
125 - access("BASE_TXN_SOURCE_TYPE_ID"=0 AND "ORA_SEED_SET1"='Y')
filter("ORA_SEED_SET1"='Y')
 126 - access("BASE_TXN_SOURCE_TYPE_ID"=0 AND
"BASE_TXN_ACTION_ID"="BASE_TXN_ACTION_ID" AND "ORA_SEED_SET1"='Y')
129 - storage("LANGUAGE"=USERENV('LANG') AND "ORA_SEED_SET1"='Y' AND
SYS_OP_BLOOM_FILTER(:BF0004,"BASE_TXN_TYPE_ID"))
filter("LANGUAGE"=USERENV('LANG') AND "ORA_SEED_SET1"='Y' AND
SYS_OP_BLOOM_FILTER(:BF0004,"BASE_TXN_TYPE_ID"))
130 - access("TRANSACTION_TYPE_ID"="TRANSACTION_TYPE_ID")
133 - storage("ORA_SEED_SET2"='Y' AND CASE WHEN "TRANSACTION_SOURCE_TYPE_ID">100
THEN 13 ELSE "TRANSACTION_SOURCE_TYPE_ID"
END <>0)
filter("ORA_SEED_SET2"='Y' AND CASE WHEN "TRANSACTION_SOURCE_TYPE_ID">100
THEN 13 ELSE "TRANSACTION_SOURCE_TYPE_ID"
END <>0)
134 - access("BASE_TXN_SOURCE_TYPE_ID"=CASE WHEN
("TRANSACTION_SOURCE_TYPE_ID">100) THEN 13 ELSE
"TRANSACTION_SOURCE_TYPE_ID" END AND
"BASE_TXN_ACTION_ID"=TO_NUMBER("TRANSACTION_ACTION_ID") AND "ORA_SEED_SET1"='Y')
filter("BASE_TXN_SOURCE_TYPE_ID"<>0)
136 - storage("LANGUAGE"=USERENV('LANG') AND "ORA_SEED_SET2"='Y' AND
SYS_OP_BLOOM_FILTER(:BF0005,"TRANSACTION_TYPE_ID"))
filter("LANGUAGE"=USERENV('LANG') AND "ORA_SEED_SET2"='Y' AND
SYS_OP_BLOOM_FILTER(:BF0005,"TRANSACTION_TYPE_ID"))
137 - storage("ORA_SEED_SET1"='Y')
filter("ORA_SEED_SET1"='Y')
147 - access("PAC"."INVENTORY_ITEM_ID"=100000015109336)
filter("PAC"."INVENTORY_ITEM_ID"=100000015109336)
149 - access("CCE"."COST_ELEMENT_ID"="PAC"."COST_ELEMENT_ID")
151 - access("CPS"."COST_ORG_ID"="PAC"."COST_ORG_ID" AND
"CPS"."COST_BOOK_ID"="PAC"."COST_BOOK_ID" AND
"CPS"."PERIOD_NAME"="PAC"."PERIOD_NAME")
152 - filter("CT"."PERIOD_NAME" IS NOT NULL AND
"CT"."COST_ORG_ID"="PAC"."COST_ORG_ID" AND
"CT"."COST_BOOK_ID"="PAC"."COST_BOOK_ID" AND
"CT"."PERIOD_NAME"="PAC"."PERIOD_NAME" AND
"CT"."INVENTORY_ITEM_ID"=100000015109336 AND
"CT"."USE_ITEM_COST_FLAG"='N' AND "CT"."INTRANSIT_FLAG"='N' AND
"CT"."COST_TRANSACTION_TYPE"<>'ADJUST' AND "CT"."LOGICAL_FLAG"='N')
153 - access("CT"."VAL_UNIT_ID"="PAC"."VAL_UNIT_ID")
filter("CT"."VAL_UNIT_ID" IS NOT NULL)
154 - access("CT"."TRANSACTION_ID"="CTC"."TRANSACTION_ID" AND
"CCE"."COST_ELEMENT_ID"="CTC"."COST_ELEMENT_ID")
filter("CCE"."COST_ELEMENT_ID"="CTC"."COST_ELEMENT_ID")
155 - filter("CTC"."PERIOD_NAME" IS NOT NULL AND
"CTC"."PERIOD_NAME"="CT"."PERIOD_NAME" AND
NVL("CTC"."ADJUSTMENT_TRANSACTION_ID",0)=0 AND
NVL("CTC"."USER_ADJUSTMENT_ID",0)=0)
163 - access("PAC"."INVENTORY_ITEM_ID"=100000015109336)
filter("PAC"."INVENTORY_ITEM_ID"=100000015109336)
165 - access("CCE"."COST_ELEMENT_ID"="PAC"."COST_ELEMENT_ID")
167 - access("CPS"."COST_ORG_ID"="PAC"."COST_ORG_ID" AND
"CPS"."COST_BOOK_ID"="PAC"."COST_BOOK_ID" AND
"CPS"."PERIOD_NAME"="PAC"."PERIOD_NAME")
168 - filter("CT"."PERIOD_NAME" IS NOT NULL AND
"CT"."INVENTORY_ITEM_ID"=100000015109336 AND "CT"."USE_ITEM_COST_FLAG"='N')
169 - access("CT"."VAL_UNIT_ID"="PAC"."VAL_UNIT_ID")
filter("CT"."VAL_UNIT_ID" IS NOT NULL)
170 - access("CTC"."PERIOD_NAME"="CT"."PERIOD_NAME" AND
"CTC"."COST_ORG_ID"="PAC"."COST_ORG_ID")
filter("CTC"."PERIOD_NAME" IS NOT NULL AND
"CTC"."PERIOD_NAME"="PAC"."PERIOD_NAME")
171 - filter("CTC"."COST_BOOK_ID"="PAC"."COST_BOOK_ID" AND
"CCE"."COST_ELEMENT_ID"="CTC"."COST_ELEMENT_ID" AND
(NVL("CTC"."ADJUSTMENT_TRANSACTION_ID",0)<>0 OR
NVL("CTC"."USER_ADJUSTMENT_ID",0)<>0) AND
"CTC"."TRANSACTION_ID"="CT"."TRANSACTION_ID")
172 - filter("A"."INVENTORY_ITEM_ID"=100000015109336)
173 - access("A"."REC_TRXN_ID"="B"."TRANSACTION_ID")
174 - filter("B"."COST_DATE"="MAX(COST_DATE)")
175 - filter(COUNT(*)>0 AND 1=1)
180 - access("B"."BASE_TXN_TYPE_ID"="C"."BASE_TXN_TYPE_ID" AND
"B"."BASE_TXN_SOURCE_TYPE_ID"="C"."BASE_TXN_SOURCE_TYPE_ID")
183 - access("A"."TRANSACTION_ID"="B"."TRANSACTION_ID" AND
"A"."EFF_DATE"="B"."EFF_DATE")
184 - filter("B"."VALID_COST_FLAG"='Y')
185 - access("B"."TRANSACTION_ID"="B"."TRANSACTION_ID")
filter("B"."EXPENSE_POOL_ID"<>(-5))
191 - access("ITEM_4"(+)="CPC"."TRANSACTION_ID" AND "ITEM_5"(+)="CPC"."EFF_DATE")
195 - access("CT"."TRANSACTION_ID"="B"."TRANSACTION_ID")
197 - access("CSIT"."CST_INV_TRANSACTION_ID"(+)="CT"."CST_INV_TRANSACTION_ID")
199 - access("CPC"."TRANSACTION_ID"="B"."TRANSACTION_ID")
filter("CT"."TRANSACTION_ID"="CPC"."TRANSACTION_ID")
202 - filter("CTC2"."ADJUSTMENT_DATE" IS NOT NULL)
203 - access("CTC2"."TRANSACTION_ID"="B"."TRANSACTION_ID")
204 - access("CCE"."COST_ELEMENT_ID"="CPC"."COST_ELEMENT_ID")
208 - filter("L"."INVENTORY_ITEM_ID"=:B1 AND "L"."VAL_UNIT_ID"=:B2 AND
"L"."COST_BOOK_ID"=:B3 AND "L"."COST_ORG_ID"=:B4 AND
"L"."QUANTITY_ONHAND" IS NOT NULL AND "L"."POSTED_FLAG"='Y')
209 - access("L"."REC_TRXN_ID"=:B1)
215 - filter("CT"."COST_METHOD_CODE"='ACTUAL' AND
"CT"."COST_TRANSACTION_TYPE"='RECEIPT')
216 - access("CT"."TRANSACTION_ID"="B"."TRANSACTION_ID")
218 - access("CSIT"."CST_INV_TRANSACTION_ID"(+)="CT"."CST_INV_TRANSACTION_ID")
219 - filter("CTC"."VALID_COST_FLAG"='Y')
220 - access("CTC"."TRANSACTION_ID"="B"."TRANSACTION_ID")
filter("CTC"."EXPENSE_POOL_ID"<>(-5) AND
"CT"."TRANSACTION_ID"="CTC"."TRANSACTION_ID")
221 - access("CCE"."COST_ELEMENT_ID"="CTC"."COST_ELEMENT_ID")
223 - access("B"."BASE_TXN_SOURCE_TYPE_ID"="BASE_TXN_SOURCE_TYPE_ID" AND
"B"."BASE_TXN_ACTION_ID"="BASE_TXN_ACTION_ID" AND
"ORA_SEED_SET1"='Y')
228 - access("BASE_TXN_TYPE_ID"="BASE_TXN_TYPE_ID")
231 - access("BASE_TXN_SOURCE_TYPE_ID"=0 AND "ORA_SEED_SET1"='Y')
filter("ORA_SEED_SET1"='Y')
232 - access("BASE_TXN_SOURCE_TYPE_ID"=0 AND
"BASE_TXN_ACTION_ID"="BASE_TXN_ACTION_ID" AND "ORA_SEED_SET1"='Y')
234 - storage("LANGUAGE"=USERENV('LANG') AND "ORA_SEED_SET1"='Y')
filter("LANGUAGE"=USERENV('LANG') AND "ORA_SEED_SET1"='Y')
235 - access("TRANSACTION_TYPE_ID"="TRANSACTION_TYPE_ID")
237 - storage("ORA_SEED_SET2"='Y' AND CASE WHEN "TRANSACTION_SOURCE_TYPE_ID">100
THEN 13 ELSE "TRANSACTION_SOURCE_TYPE_ID"
END <>0)
filter("ORA_SEED_SET2"='Y' AND CASE WHEN "TRANSACTION_SOURCE_TYPE_ID">100
THEN 13 ELSE "TRANSACTION_SOURCE_TYPE_ID"
END <>0)
238 - access("BASE_TXN_SOURCE_TYPE_ID"=CASE WHEN
("TRANSACTION_SOURCE_TYPE_ID">100) THEN 13 ELSE
"TRANSACTION_SOURCE_TYPE_ID" END AND
"BASE_TXN_ACTION_ID"=TO_NUMBER("TRANSACTION_ACTION_ID") AND "ORA_SEED_SET1"='Y')
 filter("BASE_TXN_SOURCE_TYPE_ID"<>0)
239 - storage("LANGUAGE"=USERENV('LANG') AND "ORA_SEED_SET2"='Y')
filter("LANGUAGE"=USERENV('LANG') AND "ORA_SEED_SET2"='Y')
243 - access("A"."BASE_TXN_TYPE_ID"="C"."BASE_TXN_TYPE_ID" AND
"A"."BASE_TXN_SOURCE_TYPE_ID"="C"."BASE_TXN_SOURCE_TYPE_ID")
248 - filter("CVC"."COST_ELEMENT_ID" IS NULL OR
"CVC"."COST_ELEMENT_ID"="CSCD"."COST_ELEMENT_ID")
251 - access("CT"."COST_ORG_ID"="CSC"."COST_ORG_ID" AND
"CT"."COST_BOOK_ID"="CSC"."COST_BOOK_ID" AND
"CT"."VAL_UNIT_ID"="CSC"."VAL_UNIT_ID" AND
"CT"."INVENTORY_ITEM_ID"="CSC"."INVENTORY_ITEM_ID")
filter("CSC"."EFFECTIVE_END_DATE">=TRUNC(INTERNAL_FUNCTION("COST_DATE")) AND
"CSC"."EFFECTIVE_START_DATE"<=TRUNC(INTERNAL_FUNCTION("COST_DATE")))
253 - filter("CT"."COST_METHOD_CODE"='STANDARD' AND
"CT"."COST_TRANSACTION_TYPE"='RECEIPT' AND "CT"."VAL_UNIT_ID" IS NOT
NULL)
254 - access("CT"."TRANSACTION_ID"="B"."TRANSACTION_ID")
256 - access("CT"."TRANSACTION_ID"="CTL"."TRANSACTION_ID" AND
"CT"."TRANSACTION_ID"="CTL"."REC_TRXN_ID" AND
"CTL"."DEP_TRXN_ID"=0)
258 - access("CSC"."STATUS_CODE"='PUBLISHED')
260 - access("CSC"."STD_COST_ID"="CSCD"."STD_COST_ID")
262 - access("CT"."TRANSACTION_ID"="CVC"."TRANSACTION_ID"(+) AND
"CT"."TRANSACTION_ID"="CVC"."REC_TRXN_ID"(+) AND
"CVC"."DEP_TRXN_ID"(+)=0)
263 - access("CCE"."COST_ELEMENT_ID"="CSCD"."COST_ELEMENT_ID")
268 - access("BASE_TXN_TYPE_ID"="BASE_TXN_TYPE_ID")
271 - access("BASE_TXN_SOURCE_TYPE_ID"=0 AND "ORA_SEED_SET1"='Y')
filter("ORA_SEED_SET1"='Y')
272 - access("BASE_TXN_SOURCE_TYPE_ID"=0 AND
"BASE_TXN_ACTION_ID"="BASE_TXN_ACTION_ID" AND "ORA_SEED_SET1"='Y')
274 - storage("LANGUAGE"=USERENV('LANG') AND "ORA_SEED_SET1"='Y')
filter("LANGUAGE"=USERENV('LANG') AND "ORA_SEED_SET1"='Y')
275 - access("TRANSACTION_TYPE_ID"="TRANSACTION_TYPE_ID")
277 - storage("ORA_SEED_SET2"='Y' AND CASE WHEN "TRANSACTION_SOURCE_TYPE_ID">100
THEN 13 ELSE "TRANSACTION_SOURCE_TYPE_ID"
END <>0)
filter("ORA_SEED_SET2"='Y' AND CASE WHEN "TRANSACTION_SOURCE_TYPE_ID">100
THEN 13 ELSE "TRANSACTION_SOURCE_TYPE_ID"
END <>0)
278 - access("BASE_TXN_SOURCE_TYPE_ID"=CASE WHEN
("TRANSACTION_SOURCE_TYPE_ID">100) THEN 13 ELSE
"TRANSACTION_SOURCE_TYPE_ID" END AND
"BASE_TXN_ACTION_ID"=TO_NUMBER("TRANSACTION_ACTION_ID") AND "ORA_SEED_SET1"='Y')
filter("BASE_TXN_SOURCE_TYPE_ID"<>0)
279 - storage("LANGUAGE"=USERENV('LANG') AND "ORA_SEED_SET2"='Y')
filter("LANGUAGE"=USERENV('LANG') AND "ORA_SEED_SET2"='Y')
280 - access("C"."BASE_TXN_SOURCE_TYPE_ID"="BASE_TXN_SOURCE_TYPE_ID" AND
"C"."BASE_TXN_ACTION_ID"="BASE_TXN_ACTION_ID" AND
"ORA_SEED_SET1"='Y')
283 - access("A"."BASE_TXN_TYPE_ID"="C"."BASE_TXN_TYPE_ID" AND
"A"."BASE_TXN_SOURCE_TYPE_ID"="C"."BASE_TXN_SOURCE_TYPE_ID")
284 - access("C"."BASE_TXN_SOURCE_TYPE_ID"="BASE_TXN_SOURCE_TYPE_ID" AND
"C"."BASE_TXN_ACTION_ID"="BASE_TXN_ACTION_ID")
288 - access("BASE_TXN_TYPE_ID"="BASE_TXN_TYPE_ID")
291 - access("BASE_TXN_SOURCE_TYPE_ID"=0 AND "ORA_SEED_SET1"='Y')
filter("ORA_SEED_SET1"='Y')
292 - access("BASE_TXN_SOURCE_TYPE_ID"=0 AND
"BASE_TXN_ACTION_ID"="BASE_TXN_ACTION_ID" AND "ORA_SEED_SET1"='Y')
 294 - storage("LANGUAGE"=USERENV('LANG') AND "ORA_SEED_SET1"='Y')
filter("LANGUAGE"=USERENV('LANG') AND "ORA_SEED_SET1"='Y')
295 - access("TRANSACTION_TYPE_ID"="TRANSACTION_TYPE_ID")
297 - storage("ORA_SEED_SET2"='Y' AND CASE WHEN "TRANSACTION_SOURCE_TYPE_ID">100
THEN 13 ELSE "TRANSACTION_SOURCE_TYPE_ID"
END <>0)
filter("ORA_SEED_SET2"='Y' AND CASE WHEN "TRANSACTION_SOURCE_TYPE_ID">100
THEN 13 ELSE "TRANSACTION_SOURCE_TYPE_ID"
END <>0)
298 - access("BASE_TXN_SOURCE_TYPE_ID"=CASE WHEN
("TRANSACTION_SOURCE_TYPE_ID">100) THEN 13 ELSE
"TRANSACTION_SOURCE_TYPE_ID" END AND
"BASE_TXN_ACTION_ID"=TO_NUMBER("TRANSACTION_ACTION_ID") AND "ORA_SEED_SET1"='Y')
filter("BASE_TXN_SOURCE_TYPE_ID"<>0)
299 - storage("LANGUAGE"=USERENV('LANG') AND "ORA_SEED_SET2"='Y')
filter("LANGUAGE"=USERENV('LANG') AND "ORA_SEED_SET2"='Y')
300 - storage("ORA_SEED_SET1"='Y')
filter("ORA_SEED_SET1"='Y')
309 - filter("CT"."PERIOD_NAME" IS NOT NULL AND "CT"."USE_ITEM_COST_FLAG"='N' AND
"CT"."VAL_UNIT_ID" IS NOT NULL AND
"CT"."INTRANSIT_FLAG"='N' AND "CT"."COST_TRANSACTION_TYPE"<>'ADJUST'
AND "CT"."LOGICAL_FLAG"='N')
310 - access("CT"."TRANSACTION_ID"="B"."TRANSACTION_ID")
312 - access("CT"."PERIOD_NAME"="PAC"."PERIOD_NAME" AND
"CT"."COST_ORG_ID"="PAC"."COST_ORG_ID" AND
"CT"."COST_BOOK_ID"="PAC"."COST_BOOK_ID" AND
"CT"."INVENTORY_ITEM_ID"="PAC"."INVENTORY_ITEM_ID" AND
"CT"."VAL_UNIT_ID"="PAC"."VAL_UNIT_ID")
314 - access("CCE"."COST_ELEMENT_ID"="PAC"."COST_ELEMENT_ID")
316 - access("CPS"."COST_ORG_ID"="PAC"."COST_ORG_ID" AND
"CPS"."COST_BOOK_ID"="PAC"."COST_BOOK_ID" AND
"CPS"."PERIOD_NAME"="PAC"."PERIOD_NAME")
317 - access("CTC"."TRANSACTION_ID"="B"."TRANSACTION_ID" AND
"CCE"."COST_ELEMENT_ID"="CTC"."COST_ELEMENT_ID")
filter("CCE"."COST_ELEMENT_ID"="CTC"."COST_ELEMENT_ID")
318 - filter("CTC"."PERIOD_NAME" IS NOT NULL AND
"CTC"."PERIOD_NAME"="CT"."PERIOD_NAME" AND
NVL("CTC"."ADJUSTMENT_TRANSACTION_ID",0)=0 AND
NVL("CTC"."USER_ADJUSTMENT_ID",0)=0)
325 - filter("CT"."PERIOD_NAME" IS NOT NULL AND "CT"."USE_ITEM_COST_FLAG"='N' AND
"CT"."VAL_UNIT_ID" IS NOT NULL)
326 - access("CT"."TRANSACTION_ID"="B"."TRANSACTION_ID")
327 - filter("CTC"."PERIOD_NAME" IS NOT NULL AND
"CTC"."PERIOD_NAME"="CT"."PERIOD_NAME" AND
(NVL("CTC"."ADJUSTMENT_TRANSACTION_ID",0)<>0 OR
NVL("CTC"."USER_ADJUSTMENT_ID",0)<>0))
328 - access("CTC"."TRANSACTION_ID"="B"."TRANSACTION_ID")
330 - access("CTC"."PERIOD_NAME"="PAC"."PERIOD_NAME" AND
"CTC"."COST_ORG_ID"="PAC"."COST_ORG_ID" AND
"CTC"."COST_BOOK_ID"="PAC"."COST_BOOK_ID" AND
"CT"."INVENTORY_ITEM_ID"="PAC"."INVENTORY_ITEM_ID" AND
"CT"."VAL_UNIT_ID"="PAC"."VAL_UNIT_ID")
332 - access("CCE"."COST_ELEMENT_ID"="CTC"."COST_ELEMENT_ID")
filter("CCE"."COST_ELEMENT_ID"="PAC"."COST_ELEMENT_ID")
333 - access("CPS"."COST_ORG_ID"="PAC"."COST_ORG_ID" AND
"CPS"."COST_BOOK_ID"="PAC"."COST_BOOK_ID" AND
"CPS"."PERIOD_NAME"="PAC"."PERIOD_NAME")

Note
-----
- this is an adaptive plan

]]>
</DATA_DS>
</SQL_EXPLAIN_PLAN>

]]>
</DATA_PROCESSOR_LOG>
</DIAGNOSTIC_OUT>