SQL_ID 9uk1h228m3m6x, child number 0
-------------------------------------
SELECT/*+oudar*/ a.STATIS_DATE, a.BENEF_CODE,
a.PROJECT_ID, a.SUBSYS_ID, a.TECHNO_SERVICE_CODE,
a.SERVICE_TYPE, a.UNIT_PRICE,
a.UNADJUST_QUANTITY, a.ADJUST_QUANTITY,
a.UNADJUST_ACTUAL_AMOUNT, a.YTD_UNADJUST_ACTUAL_AMOUNT,
a.ADJUST_AMOUNT, a.YTD_ADJUST_AMOUNT,
a.LATEST_BUDGET_AMOUNT, a.FIRST_BUDGET_AMOUNT,
a.HEPS_ORI_UNIT_PRICE, a.FEE_TYPE, a.UNIT_PRICE_TYPE,
a.UNIT, a.YTD_UNADJUST_QUANTITY,
a.YTD_ADJUST_QUANTITY, a.PROJECT_FLAG,
a.FEE_CATEGORY, a.BEF_BENEF_TYPE_CODE,
a.AFT_BENEF_TYPE_CODE, a.PACK_TYPE, case
when a.techno_service_code in ('ser105', 'ser106', 'ser167') then
'·t??' when a.techno_service_code not in ('ser105',
'ser106', 'ser167') and b.fee_type = '·t??' then '·t??'
when a.techno_service_
Plan hash value: 29892368
---------------------------------------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |
---------------------------------------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | | | 231 (100)| |
| 1 | WINDOW SORT | | 1 | 184 | 231 (2)| 00:00:04 |
| 2 | HASH GROUP BY | | 1 | 184 | 231 (2)| 00:00:04 |
|* 3 | HASH JOIN OUTER | | 1 | 184 | 229 (1)| 00:00:04 |
|* 4 | TABLE ACCESS BY INDEX ROWID| D_FIN_MGT_MILD_SUM | 1 | 157 | 153 (0)| 00:00:03 |
|* 5 | INDEX RANGE SCAN | D_FIN_MGT_MILD_SUM_N1 | 166 | | 3 (0)| 00:00:01 |
|* 6 | TABLE ACCESS FULL | D_FIN_HAND_SERV_QUANTITY_FEE | 8002 | 210K| 76 (2)| 00:00:02 |
---------------------------------------------------------------------------------------------------------------
Predicate Information (identified by operation id):
---------------------------------------------------
3 - access("A"."SERVICE_TYPE"="B"."SERVICE_TYPE" AND
NVL("A"."PROJECT_FLAG",'NULL')="B"."PROJECT_FLAG" AND
"A"."TECHNO_SERVICE_CODE"="B"."TECHNO_SERVICE_CODE" AND
SUBSTR("A"."STATIS_DATE",1,4)=SUBSTR("B"."STATIS_DATE",1,4))
4 - filter(("A"."SUBSYS_ID"='215953' AND "A"."BEF_BENEF_TYPE_CODE"='1' AND "A"."FEE_TYPE"='êμ?êê?·?'))
5 - access("A"."STATIS_DATE"='201607' AND "A"."BENEF_CODE"='sponsor006' AND
"A"."TECHNO_SERVICE_CODE" LIKE 'ser%')
filter("A"."TECHNO_SERVICE_CODE" LIKE 'ser%')
6 - filter(("B"."FEE_TYPE" IS NOT NULL AND "B"."TECHNO_SERVICE_CODE" LIKE 'ser%'))