<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:11.2.0
.3.0
DBName:Oracle
DBVersion:Oracle Database 19c EE Extreme Perf Release 19.0.0.0.0 - Production
SQLQuery:EXPLAIN PLAN SET STATEMENT_ID = 'dm_plan_Q_210711_071003' FOR
SELECT /* QUERY_SRC('datamodel: _datamodel.xdm,dataset:Q') */ INVOICE_ID,
ROWNUM LINE_NUMBER,
LINE_TYPE,
AMOUNT,
QUANTITY,
UNIT_PRICE,
DESCRIPTION,
ACCOUNTING_DATE,
DISTRIBUTION_COMBINATION

FROM
(
(SELECT A.INVOICE_ID
,'ITEM' LINE_TYPE
,(A.UNIT_PRICE * A.QTY) AMOUNT
,A.QTY QUANTITY
,A.UNIT_PRICE
,A.PERSON_NUMBER||' '||A.FULL_NAME||' '||A.QTY||' HRS '||
A.UNIT_PRICE||' '||'USD'||' '||A.ACCOUNTING_DATE AS DESCRIPTION
,A.ACCOUNTING_DATE
,LE1||'.'||A.SEGMENT2||'.5260.00.'||NVL(SUBSTR(A.SEGMENT1, 0,
INSTR(A.SEGMENT1, '-')-1), A.SEGMENT1)||'.'||A.SEGMENT6||'.0000.0000' AS
DISTRIBUTION_COMBINATION
FROM
(SELECT
to_number(HTH.TM_REC_GRP_ID) Invoice_Id,
PRSL.RATE Unit_Price,
PAPF.PERSON_NUMBER
,PPNF.FULL_NAME
,TO_CHAR(HTH.STOP_TIME,'YYYY/MM/DD') Accounting_Date
,PPAB.SEGMENT1
,SUM (NVL(MEASURE,0)) QTY
,GLCC.SEGMENT2
,GLCC.SEGMENT6
,GLCC.SEGMENT1 LE1
FROM
HWM_TM_REC_GRP_SUM HTH,
PER_PERSON_NAMES_F PPNF,
PER_ALL_PEOPLE_F PAPF,
HR_ORGANIZATION_UNITS_F_TL HOUFT,
per_all_assignments_m PAAF,
PJF_RATE_SCHEDULE_LINES PRSL,
PJF_RATE_SCHEDULES_TL PRST,
gl_code_combinations glcc,
HWM_TM_REC HTR
,HWM_TM_REP_ATRBS atr
,HWM_TM_REP_ATRB_USAGES ausg
 ,PJF_EXP_TYPES_TL PEX
,HWM_TM_REP_ATRBS prjatr
,HWM_TM_REP_ATRB_USAGES prjausg
,PJF_PROJECTS_ALL_B PPAB
WHERE 1=1
and HTH.STATUS ='APPROVED'
and PAAF.BUSINESS_UNIT_ID=HOUFT.ORGANIZATION_ID
and HOUFT.NAME in ('SS US BU')
and HTH.RESOURCE_ID=PAPF.PERSON_ID
and PAPF.PERSON_ID=PPNF.PERSON_ID
and PPNF.NAME_TYPE='GLOBAL'
and PAAF.PERSON_ID=HTH.RESOURCE_ID
and PAAF.primary_flag='Y'
and PAAF.ASSIGNMENT_STATUS_TYPE='ACTIVE'
and PAAF.default_code_comb_id=glcc.code_combination_id
and PRSL.PERSON_ID=HTH.RESOURCE_ID
and PRSL.RATE_SCHEDULE_ID=PRST.RATE_SCHEDULE_ID
AND PRST.RATE_SCHEDULE_NAME='WORKER EXPENSES'
and PAAF.primary_flag='Y'
AND TRUNC(HTH.STOP_TIME) BETWEEN PAAF.effective_start_date AND
PAAF.effective_end_date
AND TRUNC(HTH.START_TIME) BETWEEN PAAF.effective_start_date AND
PAAF.effective_end_date
and PAAF.OBJECT_VERSION_NUMBER = (select max(b.OBJECT_VERSION_NUMBER )
from PER_ALL_ASSIGNMENTS_M b where b.PERSON_ID=HTH.RESOURCE_ID
and
b.PRIMARY_FLAG='Y'
and
b.BUSINESS_UNIT_ID=HOUFT.ORGANIZATION_ID
and
TRUNC(HTH.STOP_TIME) between b.effective_start_date and b.effective_end_date
and
TRUNC(HTH.START_TIME) between b.effective_start_date and b.effective_end_date
and
b.ASSIGNMENT_STATUS_TYPE='ACTIVE'
)
AND TRUNC(SYSDATE) BETWEEN PRSL.START_DATE_ACTIVE and
NVL(PRSL.END_DATE_ACTIVE,SYSDATE+1)
AND TRUNC(SYSDATE) BETWEEN PAPF.effective_start_date AND
PAPF.effective_end_date
AND TRUNC(SYSDATE) BETWEEN PPNF.effective_start_date AND
PPNF.effective_end_date
and TO_CHAR(HTH.STOP_TIME,'YYYY-MM-DD') >= '2020-05-02'
and trunc(sysdate)-trunc(HTH.STOP_TIME) <=180
AND TO_CHAR(HTH.START_TIME,'DAY') = '7'
AND TO_CHAR(HTH.STOP_TIME,'DAY') = '6'
AND NOT EXISTS
( SELECT 1
FROM AP_INVOICES_ALL AIA
WHERE to_char(nvl(AIA.attribute1,'0')) =
TO_CHAR(HTH.TM_REC_GRP_ID)
AND AIA.ORG_ID =HOUFT.ORGANIZATION_ID
AND SYSDATE - AIA.INVOICE_DATE <= 180
AND AIA.SOURCE = 'ELECTRONIC INVOICE'
)
AND NOT EXISTS
( SELECT 1
FROM AP_INVOICES_INTERFACE AIA
WHERE to_char(nvl(AIA.attribute1,'0')) =
TO_CHAR(HTH.TM_REC_GRP_ID)
AND AIA.ORG_ID = HOUFT.ORGANIZATION_ID
AND SYSDATE - AIA.INVOICE_DATE <= 180
AND AIA.SOURCE = 'ELECTRONIC INVOICE'
)

and atr.TM_REP_ATRB_ID = ausg.TM_REP_ATRB_ID

AND ausg.USAGES_SOURCE_ID = HTR.TM_REC_ID
AND ausg.USAGES_SOURCE_VERSION = HTR.TM_REC_VERSION
and HTR.RESOURCE_ID = HTH.RESOURCE_ID AND
HTR.GRP_TYPE_ID = 202
AND TO_CHAR(HTR.START_TIME,'YYYY-MM-DD')>=
TO_CHAR(HTH.START_TIME,'YYYY-MM-DD')
AND TO_CHAR(HTR.START_TIME,'YYYY-MM-DD')<= TO_CHAR(HTH.STOP_TIME,'YYYY-
MM-DD')
AND NVL(HTR.DELETE_FLAG,'N') <> 'Y'
AND HTR.LATEST_VERSION = 'Y'
AND atr.ATTRIBUTE_CATEGORY = TO_CHAR(PEX.EXPENDITURE_TYPE_ID)
AND PEX.EXPENDITURE_TYPE_NAME <>'Unpaid Leave (Hourly/Subcontractor
Only)'
and prjatr.ATTRIBUTE_CATEGORY = 'Projects'
and prjatr.TM_REP_ATRB_ID = prjausg.TM_REP_ATRB_ID
AND prjausg.USAGES_SOURCE_ID = HTR.TM_REC_ID
AND prjausg.USAGES_SOURCE_VERSION = HTR.TM_REC_VERSION
AND PPAB.PROJECT_ID = prjatr.ATTRIBUTE_NUMBER1
AND NVL(MEASURE,0) <> 0
GROUP BY to_number(HTH.TM_REC_GRP_ID) ,
PRSL.RATE ,
PAPF.PERSON_NUMBER
,PPNF.FULL_NAME
,TO_CHAR(HTH.STOP_TIME,'YYYY/MM/DD')
,PPAB.SEGMENT1
,GLCC.SEGMENT2
,GLCC.SEGMENT6
,GLCC.SEGMENT1
) A
)
UNION
(SELECT TO_NUMBER(TO_CHAR(A.TM_REC_GRP_ID)||TO_CHAR(TH.COUNT1)) Invoice_Id
,'ITEM' LINE_TYPE
,A.UNIT_PRICE * NVL(A.QTY-TO_NUMBER(TH.QTY),0) AMOUNT
,NVL(A.QTY-TO_NUMBER(TH.QTY),0) QUANTITY
,A.UNIT_PRICE
,A.PERSON_NUMBER||' '||A.FULL_NAME||' '||(A.QTY-TH.QTY)||' HRS '||
A.UNIT_PRICE||' '||'USD'||' '||A.ACCOUNTING_DATE AS DESCRIPTION
,A.ACCOUNTING_DATE
,LE1||'.'||A.SEGMENT2||'.5260.00.'||NVL(SUBSTR(A.SEGMENT1, 0,
INSTR(A.SEGMENT1, '-')-1), A.SEGMENT1)||'.'||A.SEGMENT6||'.0000.0000' AS
DISTRIBUTION_COMBINATION

FROM
(SELECT HTH.TM_REC_GRP_ID,
PRSL.RATE Unit_Price,
PAPF.PERSON_NUMBER
,PPNF.FULL_NAME
,TO_CHAR(HTH.STOP_TIME,'YYYY/MM/DD') Accounting_Date
,PPAB.SEGMENT1
,SUM (NVL(MEASURE,0)) QTY
,GLCC.SEGMENT2
 ,GLCC.SEGMENT6
,GLCC.SEGMENT1 LE1
FROM
HWM_TM_REC_GRP_SUM HTH,
PER_PERSON_NAMES_F PPNF,
PER_ALL_PEOPLE_F PAPF,
HR_ORGANIZATION_UNITS_F_TL HOUFT,
PER_ALL_ASSIGNMENTS_M PAAF,
PJF_RATE_SCHEDULE_LINES PRSL,
PJF_RATE_SCHEDULES_TL PRST,
GL_CODE_COMBINATIONS GLCC,
HWM_TM_REC HTR
,HWM_TM_REP_ATRBS atr
,HWM_TM_REP_ATRB_USAGES ausg
,PJF_EXP_TYPES_TL PEX
,HWM_TM_REP_ATRBS prjatr
,HWM_TM_REP_ATRB_USAGES prjausg
,PJF_PROJECTS_ALL_B PPAB
WHERE 1=1
and HTH.STATUS ='APPROVED'
and PAAF.BUSINESS_UNIT_ID=HOUFT.ORGANIZATION_ID
and HOUFT.NAME in ('SS US BU')
and HTH.RESOURCE_ID=PAPF.PERSON_ID
and PAPF.PERSON_ID=PPNF.PERSON_ID
and PPNF.NAME_TYPE='GLOBAL'
and PAAF.PERSON_ID=HTH.RESOURCE_ID
and PAAF.primary_flag='Y'
and PAAF.ASSIGNMENT_STATUS_TYPE='ACTIVE'
and PAAF.default_code_comb_id=glcc.code_combination_id
and PRSL.PERSON_ID=HTH.RESOURCE_ID
and PRSL.RATE_SCHEDULE_ID=PRST.RATE_SCHEDULE_ID
AND PRST.RATE_SCHEDULE_NAME='WORKER EXPENSES'
and PAAF.primary_flag='Y'
AND TRUNC(HTH.STOP_TIME) BETWEEN PAAF.effective_start_date AND
PAAF.effective_end_date
AND TRUNC(HTH.START_TIME) BETWEEN PAAF.effective_start_date AND
PAAF.effective_end_date
and PAAF.OBJECT_VERSION_NUMBER = (select max(b.OBJECT_VERSION_NUMBER )
from PER_ALL_ASSIGNMENTS_M b where b.PERSON_ID=HTH.RESOURCE_ID
and
b.PRIMARY_FLAG='Y'
and
b.BUSINESS_UNIT_ID=HOUFT.ORGANIZATION_ID
and
TRUNC(HTH.STOP_TIME) between b.effective_start_date and b.effective_end_date
and
TRUNC(HTH.START_TIME) between b.effective_start_date and b.effective_end_date
and
b.ASSIGNMENT_STATUS_TYPE='ACTIVE'
)
AND TRUNC(SYSDATE) BETWEEN PRSL.START_DATE_ACTIVE and
NVL(PRSL.END_DATE_ACTIVE,SYSDATE+1)
AND TRUNC(SYSDATE) BETWEEN PAPF.effective_start_date AND
PAPF.effective_end_date
AND TRUNC(SYSDATE) BETWEEN PPNF.effective_start_date AND
PPNF.effective_end_date
and TO_CHAR(HTH.STOP_TIME,'YYYY-MM-DD') >= '2020-05-02'
and atr.TM_REP_ATRB_ID = ausg.TM_REP_ATRB_ID
AND ausg.USAGES_SOURCE_ID = HTR.TM_REC_ID
 AND ausg.USAGES_SOURCE_VERSION = HTR.TM_REC_VERSION
and HTR.RESOURCE_ID = HTH.RESOURCE_ID AND
HTR.GRP_TYPE_ID = 202
AND TO_CHAR(HTR.START_TIME,'YYYY-MM-DD')>=
TO_CHAR(HTH.START_TIME,'YYYY-MM-DD')
AND TO_CHAR(HTR.START_TIME,'YYYY-MM-DD')<= TO_CHAR(HTH.STOP_TIME,'YYYY-
MM-DD')
AND NVL(HTR.DELETE_FLAG,'N') <> 'Y'
AND HTR.LATEST_VERSION = 'Y'
AND atr.ATTRIBUTE_CATEGORY = TO_CHAR(PEX.EXPENDITURE_TYPE_ID)
AND PEX.EXPENDITURE_TYPE_NAME <>'Unpaid Leave (Hourly/Subcontractor
Only)'
and prjatr.ATTRIBUTE_CATEGORY = 'Projects'
and prjatr.TM_REP_ATRB_ID = prjausg.TM_REP_ATRB_ID
AND prjausg.USAGES_SOURCE_ID = HTR.TM_REC_ID
AND prjausg.USAGES_SOURCE_VERSION = HTR.TM_REC_VERSION
AND PPAB.PROJECT_ID = prjatr.ATTRIBUTE_NUMBER1
AND NVL(MEASURE,0) <> 0
GROUP BY HTH.TM_REC_GRP_ID
,PRSL.RATE
,PAPF.PERSON_NUMBER
,PPNF.FULL_NAME
,TO_CHAR(HTH.STOP_TIME,'YYYY/MM/DD')
,PPAB.SEGMENT1
,GLCC.SEGMENT2
,GLCC.SEGMENT6
,GLCC.SEGMENT1
) A,
(SELECT SUM(INV_TAB.QTY) QTY,SUM(INV_TAB.COUNT1) COUNT1,
INV_TAB.ATTRIBUTE1,INV_TAB.SEGMENT5
FROM(
SELECT SUM(AILA.QUANTITY_INVOICED) QTY,COUNT(AIA.attribute1)
COUNT1,AIA.attribute1,substr(OVERLAY_DIST_CODE_CONCAT,16,5) SEGMENT5
FROM AP_INVOICES_ALL AIA,AP_INVOICE_LINES_ALL AILA
where AIA.INVOICE_ID=AILA.INVOICE_ID
AND AIA.ORG_ID = AILA.ORG_ID
AND SYSDATE - AIA.INVOICE_DATE <= 180
AND AIA.SOURCE = 'ELECTRONIC INVOICE'
AND AIA.attribute1 IS NOT NULL
GROUP BY AIA.attribute1,substr(OVERLAY_DIST_CODE_CONCAT,16,5)
UNION ALL
SELECT SUM(AILI.QUANTITY_INVOICED) QTY ,COUNT(AII.attribute1)
COUNT1,AII.attribute1,substr(DIST_CODE_CONCATENATED,16,5) SEGMENT5
from AP_INVOICES_INTERFACE AII,AP_INVOICE_LINES_INTERFACE AILI
where AII.INVOICE_ID=AILI.INVOICE_ID
and nvl(AII.STATUS,'a') <>'PROCESSED'
AND AII.ORG_ID = AILI.ORG_ID
AND SYSDATE - AII.INVOICE_DATE <= 180
AND AII.SOURCE = 'ELECTRONIC INVOICE'
AND AII.attribute1 IS NOT NULL
GROUP BY AII.attribute1,substr(DIST_CODE_CONCATENATED,16,5) )
INV_TAB
GROUP BY INV_TAB.ATTRIBUTE1,INV_TAB.SEGMENT5) TH
WHERE TO_CHAR(TH.ATTRIBUTE1)=TO_CHAR(A.TM_REC_GRP_ID)
AND NVL(SUBSTR(A.SEGMENT1, 0, INSTR(A.SEGMENT1, '-')-1), A.SEGMENT1) =
TH.SEGMENT5
AND TO_NUMBER(TH.QTY)!=A.QTY
)
)
SQL Query Timeout: 600
Number of SQL Executions: 1
PLAN_TABLE_OUTPUT
-----------------------------------------------------------------------------------
------------------
Plan hash value: 860830455

-----------------------------------------------------------------------------------
----------------------------------------------------------
| Id | Operation | Name
| Rows | Bytes | Cost (%CPU)| Time |
-----------------------------------------------------------------------------------
----------------------------------------------------------
| 0 | SELECT STATEMENT |
| 2 | 4676 | 2674 (1)| 00:00:01 |
| 1 | COUNT |
| | | | |
| 2 | VIEW |
| 2 | 4676 | 2674 (1)| 00:00:01 |
| 3 | SORT UNIQUE |
| 2 | 6608 | 2674 (1)| 00:00:01 |
| 4 | UNION-ALL |
| | | | |
| 5 | HASH GROUP BY |
| 1 | 631 | 332 (1)| 00:00:01 |
|* 6 | HASH JOIN |
| 1 | 631 | 327 (0)| 00:00:01 |
| 7 | NESTED LOOPS |
| 1 | 600 | 325 (0)| 00:00:01 |
| 8 | NESTED LOOPS |
| 1 | 573 | 323 (0)| 00:00:01 |
| 9 | NESTED LOOPS |
| 1 | 554 | 322 (0)| 00:00:01 |
| 10 | NESTED LOOPS ANTI |
| 1 | 522 | 320 (0)| 00:00:01 |
|* 11 | HASH JOIN ANTI |
| 1 | 477 | 97 (0)| 00:00:01 |
| 12 | NESTED LOOPS |
| 1 | 431 | 29 (0)| 00:00:01 |
| 13 | NESTED LOOPS |
| 1 | 405 | 27 (0)| 00:00:01 |
| 14 | NESTED LOOPS |
| 1 | 379 | 24 (0)| 00:00:01 |
| 15 | NESTED LOOPS |
| 1 | 331 | 20 (0)| 00:00:01 |
| 16 | NESTED LOOPS |
| 1 | 310 | 19 (0)| 00:00:01 |
| 17 | NESTED LOOPS |
| 1 | 259 | 17 (0)| 00:00:01 |
| 18 | NESTED LOOPS |
| 1 | 222 | 15 (0)| 00:00:01 |
| 19 | NESTED LOOPS |
| 1 | 184 | 13 (0)| 00:00:01 |
| 20 | NESTED LOOPS |
| 1 | 127 | 8 (0)| 00:00:01 |
| 21 | NESTED LOOPS |
| 1 | 57 | 5 (0)| 00:00:01 |
| 22 | TABLE ACCESS BY INDEX ROWID BATCHED |
pjf_rate_schedules_tl | 1 | 22 | 3 (0)| 00:00:01 |
|* 23 | INDEX RANGE SCAN |
PJF_RATE_SCHEDULES_TL_U1 | 1 | | 2 (0)| 00:00:01 |
|* 24 | TABLE ACCESS BY INDEX ROWID BATCHED |
pjf_rate_schedule_lines | 1 | 35 | 2 (0)| 00:00:01 |
|* 25 | INDEX RANGE SCAN |
PJF_RATE_SCHEDULE_LINES_N6 | 2 | | 1 (0)| 00:00:01 |
|* 26 | TABLE ACCESS BY INDEX ROWID BATCHED |
hwm_tm_rec_grp_sum | 1 | 70 | 3 (0)| 00:00:01 |
|* 27 | INDEX RANGE SCAN |
HWM_TM_REC_GRP_SUM_N1 | 1 | | 2 (0)| 00:00:01 |
|* 28 | TABLE ACCESS BY INDEX ROWID BATCHED |
per_all_assignments_m | 1 | 57 | 5 (0)| 00:00:01 |
|* 29 | INDEX RANGE SCAN |
PER_ALL_ASSIGNMENTS_M_N12 | 3 | | 2 (0)| 00:00:01 |
|* 30 | TABLE ACCESS BY INDEX ROWID BATCHED |
hr_organization_units_f_tl | 1 | 38 | 2 (0)| 00:00:01 |
|* 31 | INDEX RANGE SCAN |
HR_ORGANIZATION_UNITS_F_TL_PK | 1 | | 1 (0)| 00:00:01 |
| 32 | SORT AGGREGATE |
| 1 | 53 | | |
|* 33 | TABLE ACCESS BY INDEX ROWID BATCHED |
per_all_assignments_m | 1 | 53 | 4 (0)| 00:00:01 |
|* 34 | INDEX RANGE SCAN |
PER_ALL_ASSIGNMENTS_M_N12 | 1 | | 3 (0)| 00:00:01 |
|* 35 | TABLE ACCESS BY INDEX ROWID BATCHED |
per_all_people_f | 1 | 37 | 2 (0)| 00:00:01 |
|* 36 | INDEX RANGE SCAN |
PER_PEOPLE_F_PK | 1 | | 1 (0)| 00:00:01 |
|* 37 | TABLE ACCESS BY INDEX ROWID BATCHED |
per_person_names_f | 1 | 51 | 2 (0)| 00:00:01 |
|* 38 | INDEX RANGE SCAN |
PER_PERSON_NAMES_F_N12 | 1 | | 1 (0)| 00:00:01 |
| 39 | TABLE ACCESS BY INDEX ROWID |
gl_code_combinations | 1 | 21 | 1 (0)| 00:00:01 |
|* 40 | INDEX UNIQUE SCAN |
GL_CODE_COMBINATIONS_U1 | 1 | | 0 (0)| 00:00:01 |
|* 41 | TABLE ACCESS BY INDEX ROWID BATCHED | hwm_tm_rec
| 1 | 48 | 4 (0)| 00:00:01 |
|* 42 | INDEX RANGE SCAN | HWM_TM_REC_N4
| 1 | | 3 (0)| 00:00:01 |
|* 43 | TABLE ACCESS BY INDEX ROWID BATCHED |
hwm_tm_rep_atrb_usages | 8 | 208 | 3 (0)| 00:00:01 |
|* 44 | INDEX RANGE SCAN |
HWM_TM_REP_ATRB_USAGES_N1 | 4 | | 2 (0)| 00:00:01 |
|* 45 | TABLE ACCESS BY INDEX ROWID BATCHED |
hwm_tm_rep_atrb_usages | 8 | 208 | 2 (0)| 00:00:01 |
|* 46 | INDEX RANGE SCAN |
HWM_TM_REP_ATRB_USAGES_N1 | 4 | | 2 (0)| 00:00:01 |
|* 47 | TABLE ACCESS STORAGE FULL |
ap_invoices_interface | 47 | 2162 | 68 (0)| 00:00:01 |
|* 48 | TABLE ACCESS BY INDEX ROWID BATCHED |
ap_invoices_all | 1 | 45 | 223 (0)| 00:00:01 |
|* 49 | INDEX SKIP SCAN |
AP_INVOICES_N3 | 54 | | 212 (0)| 00:00:01 |
|* 50 | TABLE ACCESS BY INDEX ROWID |
hwm_tm_rep_atrbs | 1 | 32 | 2 (0)| 00:00:01 |
|* 51 | INDEX UNIQUE SCAN |
HWM_TM_REP_ATRBS_U1 | 1 | | 1 (0)| 00:00:01 |
| 52 | TABLE ACCESS BY INDEX ROWID |
pjf_projects_all_b | 1 | 19 | 1 (0)| 00:00:01 |
|* 53 | INDEX UNIQUE SCAN |
PJF_PROJECTS_ALL_B_PK | 1 | | 0 (0)| 00:00:01 |
|* 54 | TABLE ACCESS BY INDEX ROWID |
hwm_tm_rep_atrbs | 1 | 27 | 2 (0)| 00:00:01 |
|* 55 | INDEX UNIQUE SCAN |
HWM_TM_REP_ATRBS_U1 | 1 | | 1 (0)| 00:00:01 |
| 56 | VIEW |
index$_join$_014 | 33 | 1023 | 2 (0)| 00:00:01 |
|* 57 | HASH JOIN |
| | | | |
| 58 | INDEX STORAGE FAST FULL SCAN |
PJF_EXP_TYPES_TL_U1 | 33 | 1023 | 1 (0)| 00:00:01 |
|* 59 | INDEX STORAGE FAST FULL SCAN |
PJF_EXP_TYPES_TL_U2 | 33 | 1023 | 1 (0)| 00:00:01 |
|* 60 | HASH JOIN |
| 1 | 2673 | 2341 (1)| 00:00:01 |
| 61 | JOIN FILTER CREATE | :BF0000
| 1 | 2333 | 60 (7)| 00:00:01 |
| 62 | VIEW |
| 1 | 2333 | 60 (7)| 00:00:01 |
| 63 | HASH GROUP BY |
| 1 | 582 | 60 (7)| 00:00:01 |
|* 64 | HASH JOIN |
| 1 | 582 | 59 (6)| 00:00:01 |
| 65 | NESTED LOOPS |
| 1 | 551 | 57 (6)| 00:00:01 |
| 66 | NESTED LOOPS |
| 1 | 524 | 55 (6)| 00:00:01 |
| 67 | NESTED LOOPS |
| 1 | 505 | 54 (6)| 00:00:01 |
| 68 | NESTED LOOPS |
| 1 | 473 | 52 (6)| 00:00:01 |
| 69 | NESTED LOOPS |
| 1 | 447 | 50 (6)| 00:00:01 |
| 70 | NESTED LOOPS |
| 1 | 421 | 47 (7)| 00:00:01 |
| 71 | NESTED LOOPS |
| 1 | 373 | 43 (7)| 00:00:01 |
| 72 | NESTED LOOPS |
| 1 | 352 | 42 (8)| 00:00:01 |
| 73 | NESTED LOOPS |
| 1 | 301 | 40 (8)| 00:00:01 |
| 74 | NESTED LOOPS |
| 1 | 264 | 38 (8)| 00:00:01 |
| 75 | NESTED LOOPS |
| 1 | 207 | 33 (10)| 00:00:01 |
| 76 | NESTED LOOPS |
| 1 | 169 | 31 (10)| 00:00:01 |
| 77 | NESTED LOOPS |
| 3 | 417 | 10 (0)| 00:00:01 |
| 78 | NESTED LOOPS |
| 1 | 57 | 5 (0)| 00:00:01 |
| 79 | TABLE ACCESS BY INDEX ROWID BATCHED |
pjf_rate_schedules_tl | 1 | 22 | 3 (0)| 00:00:01 |
|* 80 | INDEX RANGE SCAN |
PJF_RATE_SCHEDULES_TL_U1 | 1 | | 2 (0)| 00:00:01 |
|* 81 | TABLE ACCESS BY INDEX ROWID BATCHED |
pjf_rate_schedule_lines | 1 | 35 | 2 (0)| 00:00:01 |
|* 82 | INDEX RANGE SCAN |
PJF_RATE_SCHEDULE_LINES_N6 | 2 | | 1 (0)| 00:00:01 |
|* 83 | TABLE ACCESS BY INDEX ROWID BATCHED |
hwm_tm_rec_grp_sum | 2 | 164 | 5 (0)| 00:00:01 |
|* 84 | INDEX RANGE SCAN |
HWM_TM_REC_GRP_SUM_N1 | 2 | | 2 (0)| 00:00:01 |
| 85 | VIEW PUSHED PREDICATE | VW_SQ_1
| 1 | 30 | 7 (15)| 00:00:01 |
| 86 | SORT GROUP BY |
| 2 | 202 | 7 (15)| 00:00:01 |
| 87 | NESTED LOOPS |
| 3 | 303 | 6 (0)| 00:00:01 |
|* 88 | TABLE ACCESS BY USER ROWID |
hwm_tm_rec_grp_sum | 1 | 48 | 1 (0)| 00:00:01 |
|* 89 | TABLE ACCESS BY INDEX ROWID BATCHED|
per_all_assignments_m | 3 | 159 | 5 (0)| 00:00:01 |
|* 90 | INDEX RANGE SCAN |
PER_ALL_ASSIGNMENTS_M_N12 | 3 | | 2 (0)| 00:00:01 |
|* 91 | TABLE ACCESS BY INDEX ROWID BATCHED |
hr_organization_units_f_tl | 1 | 38 | 2 (0)| 00:00:01 |
|* 92 | INDEX RANGE SCAN |
HR_ORGANIZATION_UNITS_F_TL_PK | 1 | | 1 (0)| 00:00:01 |
|* 93 | TABLE ACCESS BY INDEX ROWID BATCHED |
per_all_assignments_m | 1 | 57 | 5 (0)| 00:00:01 |
|* 94 | INDEX RANGE SCAN |
PER_ALL_ASSIGNMENTS_M_N12 | 3 | | 2 (0)| 00:00:01 |
|* 95 | TABLE ACCESS BY INDEX ROWID BATCHED |
per_all_people_f | 1 | 37 | 2 (0)| 00:00:01 |
|* 96 | INDEX RANGE SCAN |
PER_PEOPLE_F_PK | 1 | | 1 (0)| 00:00:01 |
|* 97 | TABLE ACCESS BY INDEX ROWID BATCHED |
per_person_names_f | 1 | 51 | 2 (0)| 00:00:01 |
|* 98 | INDEX RANGE SCAN |
PER_PERSON_NAMES_F_N12 | 1 | | 1 (0)| 00:00:01 |
| 99 | TABLE ACCESS BY INDEX ROWID |
gl_code_combinations | 1 | 21 | 1 (0)| 00:00:01 |
|*100 | INDEX UNIQUE SCAN |
GL_CODE_COMBINATIONS_U1 | 1 | | 0 (0)| 00:00:01 |
|*101 | TABLE ACCESS BY INDEX ROWID BATCHED | hwm_tm_rec
| 1 | 48 | 4 (0)| 00:00:01 |
|*102 | INDEX RANGE SCAN | HWM_TM_REC_N4
| 1 | | 3 (0)| 00:00:01 |
|*103 | TABLE ACCESS BY INDEX ROWID BATCHED |
hwm_tm_rep_atrb_usages | 8 | 208 | 3 (0)| 00:00:01 |
|*104 | INDEX RANGE SCAN |
HWM_TM_REP_ATRB_USAGES_N1 | 4 | | 2 (0)| 00:00:01 |
|*105 | TABLE ACCESS BY INDEX ROWID BATCHED |
hwm_tm_rep_atrb_usages | 8 | 208 | 2 (0)| 00:00:01 |
|*106 | INDEX RANGE SCAN |
HWM_TM_REP_ATRB_USAGES_N1 | 4 | | 2 (0)| 00:00:01 |
|*107 | TABLE ACCESS BY INDEX ROWID |
hwm_tm_rep_atrbs | 1 | 32 | 2 (0)| 00:00:01 |
|*108 | INDEX UNIQUE SCAN |
HWM_TM_REP_ATRBS_U1 | 1 | | 1 (0)| 00:00:01 |
| 109 | TABLE ACCESS BY INDEX ROWID |
pjf_projects_all_b | 1 | 19 | 1 (0)| 00:00:01 |
|*110 | INDEX UNIQUE SCAN |
PJF_PROJECTS_ALL_B_PK | 1 | | 0 (0)| 00:00:01 |
|*111 | TABLE ACCESS BY INDEX ROWID |
hwm_tm_rep_atrbs | 1 | 27 | 2 (0)| 00:00:01 |
|*112 | INDEX UNIQUE SCAN |
HWM_TM_REP_ATRBS_U1 | 1 | | 1 (0)| 00:00:01 |
| 113 | VIEW |
index$_join$_033 | 33 | 1023 | 2 (0)| 00:00:01 |
|*114 | HASH JOIN |
| | | | |
| 115 | INDEX STORAGE FAST FULL SCAN |
PJF_EXP_TYPES_TL_U1 | 33 | 1023 | 1 (0)| 00:00:01 |
|*116 | INDEX STORAGE FAST FULL SCAN |
PJF_EXP_TYPES_TL_U2 | 33 | 1023 | 1 (0)| 00:00:01 |
| 117 | VIEW |
| 444 | 147K| 2281 (1)| 00:00:01 |
| 118 | HASH GROUP BY |
| 444 | 21312 | 2281 (1)| 00:00:01 |
| 119 | VIEW |
| 1605 | 77040 | 2279 (1)| 00:00:01 |
| 120 | JOIN FILTER USE | :BF0000
| | | | |
| 121 | UNION-ALL |
| | | | |
| 122 | HASH GROUP BY |
| 447 | 38889 | 2193 (1)| 00:00:01 |
| 123 | NESTED LOOPS |
| 447 | 38889 | 2192 (1)| 00:00:01 |
| 124 | NESTED LOOPS |
| 894 | 38889 | 2192 (1)| 00:00:01 |
|*125 | TABLE ACCESS STORAGE FULL |
ap_invoices_all | 447 | 22797 | 1299 (1)| 00:00:01 |
|*126 | INDEX RANGE SCAN |
AP_INVOICE_LINES_N14 | 2 | | 1 (0)| 00:00:01 |
|*127 | TABLE ACCESS BY INDEX ROWID |
ap_invoice_lines_all | 1 | 36 | 2 (0)| 00:00:01 |
| 128 | HASH GROUP BY |
| 1158 | 117K| 87 (2)| 00:00:01 |
| 129 | NESTED LOOPS |
| 1158 | 117K| 86 (0)| 00:00:01 |
| 130 | NESTED LOOPS |
| 1158 | 117K| 86 (0)| 00:00:01 |
|*131 | TABLE ACCESS STORAGE FULL |
ap_invoices_interface | 9 | 567 | 68 (0)| 00:00:01 |
|*132 | INDEX RANGE SCAN |
AP_INVOICE_LINES_INTERFACE_N1 | 1 | | 1 (0)| 00:00:01 |
|*133 | TABLE ACCESS BY INDEX ROWID |
ap_invoice_lines_interface | 133 | 5453 | 2 (0)| 00:00:01 |
-----------------------------------------------------------------------------------
----------------------------------------------------------

Predicate Information (identified by operation id):

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

6 - access("ATTRIBUTE_CATEGORY"=TO_CHAR("PEX"."EXPENDITURE_TYPE_ID"))
11 - access(NVL("AIA"."ATTRIBUTE1",'0')=TO_CHAR("TM_REC_GRP_ID") AND
"AIA"."ORG_ID"="ORGANIZATION_ID")
23 - access("PRST"."RATE_SCHEDULE_NAME"='WORKER EXPENSES')
24 - filter("PRSL"."PERSON_ID" IS NOT NULL AND
NVL("PRSL"."END_DATE_ACTIVE",SYSDATE@!+1)>=TRUNC(SYSDATE@!) AND
"PRSL"."START_DATE_ACTIVE"<=TRUNC(SYSDATE@!))
25 - access("PRSL"."RATE_SCHEDULE_ID"="PRST"."RATE_SCHEDULE_ID")
 26 - filter("ENTERPRISE_ID"=0 OR "ENTERPRISE_ID"=1 OR
"ENTERPRISE_ID"=DECODE(SYS_CONTEXT('FND_VPD_CTX','FND_ENTERPRISE_ID'),NULL,"E

NTERPRISE_ID",TO_NUMBER(SYS_CONTEXT('FND_VPD_CTX','FND_ENTERPRISE_ID'))))
27 - access("PRSL"."PERSON_ID"="RESOURCE_ID" AND "STATUS"='APPROVED')
filter(TO_CHAR(INTERNAL_FUNCTION("START_TIME"),'DAY')='7' AND
TO_CHAR(INTERNAL_FUNCTION("STOP_TIME"),'DAY')='6' AND
TO_CHAR(INTERNAL_FUNCTION("STOP_TIME"),'YYYY-MM-DD')>='2020-05-02'
AND TRUNC(SYSDATE@!)-TRUNC(INTERNAL_FUNCTION("STOP_TIME"))<=180
AND "STATUS"='APPROVED')
28 - filter("DEFAULT_CODE_COMB_ID" IS NOT NULL AND
"ASSIGNMENT_STATUS_TYPE"='ACTIVE' AND (("BUSINESS_GROUP_ID"=0 OR
"BUSINESS_GROUP_ID"=1) OR
"BUSINESS_GROUP_ID"=DECODE(SYS_CONTEXT('FND_VPD_CTX','FND_ENTERPRISE_ID'),NULL,"BUS
INESS_GROUP_ID",TO_NUMBE
R(SYS_CONTEXT('FND_VPD_CTX','FND_ENTERPRISE_ID')))))
29 - access("PERSON_ID"="RESOURCE_ID" AND "PRIMARY_FLAG"='Y' AND
"EFFECTIVE_END_DATE">=TRUNC(INTERNAL_FUNCTION("STOP_TIME")) AND
"EFFECTIVE_START_DATE"<=TRUNC(INTERNAL_FUNCTION("STOP_TIME")))
filter("PRIMARY_FLAG"='Y' AND
"EFFECTIVE_START_DATE"<=TRUNC(INTERNAL_FUNCTION("START_TIME")) AND
"EFFECTIVE_START_DATE"<=TRUNC(INTERNAL_FUNCTION("STOP_TIME")) AND
"EFFECTIVE_END_DATE">=TRUNC(INTERNAL_FUNCTION("STOP_TIME")) AND
"EFFECTIVE_END_DATE">=TRUNC(INTERNAL_FUNCTION("START_TIME")))
30 - filter("NAME"='SS US BU' AND (("BUSINESS_GROUP_ID"=0 OR
"BUSINESS_GROUP_ID"=1) OR

"BUSINESS_GROUP_ID"=DECODE(SYS_CONTEXT('FND_VPD_CTX','FND_ENTERPRISE_ID'),NULL,"BUS
INESS_GROUP_ID",TO_NUMBER(SYS_CONTEXT('FND_VPD_CTX
','FND_ENTERPRISE_ID')))))
31 - access("BUSINESS_UNIT_ID"="ORGANIZATION_ID")
filter("OBJECT_VERSION_NUMBER"= (SELECT MAX("OBJECT_VERSION_NUMBER") FROM
"FUSION"."per_all_assignments_m"
"per_all_assignments_m" WHERE "PERSON_ID"=:B1 AND
"BUSINESS_UNIT_ID"=:B2 AND "ASSIGNMENT_STATUS_TYPE"='ACTIVE' AND
(("BUSINESS_GROUP_ID"=0 OR "BUSINESS_GROUP_ID"=1) OR
"BUSINESS_GROUP_ID"=DECODE(SYS_CONTEXT('FND_VPD_CTX','FND_ENTERPRISE_ID'),NULL,"

BUSINESS_GROUP_ID",TO_NUMBER(SYS_CONTEXT('FND_VPD_CTX','FND_ENTERPRISE_ID')))) AND
"PRIMARY_FLAG"='Y' AND
"EFFECTIVE_START_DATE"<=TRUNC(:B3) AND
"EFFECTIVE_END_DATE">=TRUNC(:B4) AND "EFFECTIVE_START_DATE"<=TRUNC(:B5) AND
"EFFECTIVE_END_DATE">=TRUNC(:B6)))
33 - filter("BUSINESS_UNIT_ID"=:B1 AND "ASSIGNMENT_STATUS_TYPE"='ACTIVE' AND
(("BUSINESS_GROUP_ID"=0 OR "BUSINESS_GROUP_ID"=1) OR

"BUSINESS_GROUP_ID"=DECODE(SYS_CONTEXT('FND_VPD_CTX','FND_ENTERPRISE_ID'),NULL,"BUS
INESS_GROUP_ID",TO_NUMBER(SYS_CONTEXT('FND_VPD_CTX
','FND_ENTERPRISE_ID')))))
34 - access("PERSON_ID"=:B1 AND "PRIMARY_FLAG"='Y' AND
"EFFECTIVE_END_DATE">=TRUNC(:B2) AND "EFFECTIVE_START_DATE"<=TRUNC(:B3))
filter("PRIMARY_FLAG"='Y' AND "EFFECTIVE_START_DATE"<=TRUNC(:B1) AND
"EFFECTIVE_END_DATE">=TRUNC(:B2) AND
"EFFECTIVE_START_DATE"<=TRUNC(:B3) AND
"EFFECTIVE_END_DATE">=TRUNC(:B4))
35 - filter("BUSINESS_GROUP_ID"=0 OR "BUSINESS_GROUP_ID"=1 OR
"BUSINESS_GROUP_ID"=DECODE(SYS_CONTEXT('FND_VPD_CTX','FND_ENTERPRISE_

ID'),NULL,"BUSINESS_GROUP_ID",TO_NUMBER(SYS_CONTEXT('FND_VPD_CTX','FND_ENTERPRISE_I
D'))))
36 - access("RESOURCE_ID"="PERSON_ID" AND "EFFECTIVE_END_DATE">=TRUNC(SYSDATE@!)
AND "EFFECTIVE_START_DATE"<=TRUNC(SYSDATE@!))
filter("EFFECTIVE_END_DATE">=TRUNC(SYSDATE@!))
37 - filter("BUSINESS_GROUP_ID"=0 OR "BUSINESS_GROUP_ID"=1 OR
"BUSINESS_GROUP_ID"=DECODE(SYS_CONTEXT('FND_VPD_CTX','FND_ENTERPRISE_

ID'),NULL,"BUSINESS_GROUP_ID",TO_NUMBER(SYS_CONTEXT('FND_VPD_CTX','FND_ENTERPRISE_I
D'))))
38 - access("PERSON_ID"="PERSON_ID" AND "NAME_TYPE"='GLOBAL' AND
"EFFECTIVE_END_DATE">=TRUNC(SYSDATE@!) AND
"EFFECTIVE_START_DATE"<=TRUNC(SYSDATE@!))
filter("EFFECTIVE_END_DATE">=TRUNC(SYSDATE@!))
40 - access("DEFAULT_CODE_COMB_ID"="GLCC"."CODE_COMBINATION_ID")
41 - filter(NVL("MEASURE",0)<>0 AND NVL("DELETE_FLAG",'N')<>'Y' AND
"LATEST_VERSION"='Y' AND (("ENTERPRISE_ID"=0 OR
"ENTERPRISE_ID"=1) OR
"ENTERPRISE_ID"=DECODE(SYS_CONTEXT('FND_VPD_CTX','FND_ENTERPRISE_ID'),NULL,"ENTERPR
ISE_ID",TO_NUMBER(SYS_CONTEX
T('FND_VPD_CTX','FND_ENTERPRISE_ID')))))
42 - access("RESOURCE_ID"="RESOURCE_ID" AND "GRP_TYPE_ID"=202)
filter(TO_CHAR(INTERNAL_FUNCTION("START_TIME"),'YYYY-MM-
DD')>=TO_CHAR(INTERNAL_FUNCTION("START_TIME"),'YYYY-MM-DD') AND
TO_CHAR(INTERNAL_FUNCTION("START_TIME"),'YYYY-MM-
DD')<=TO_CHAR(INTERNAL_FUNCTION("STOP_TIME"),'YYYY-MM-DD'))
43 - filter("USAGES_SOURCE_VERSION"="TM_REC_VERSION" AND (("ENTERPRISE_ID"=0 OR
"ENTERPRISE_ID"=1) OR

"ENTERPRISE_ID"=DECODE(SYS_CONTEXT('FND_VPD_CTX','FND_ENTERPRISE_ID'),NULL,"ENTERPR
ISE_ID",TO_NUMBER(SYS_CONTEXT('FND_VPD_CTX','FND_E
NTERPRISE_ID')))))
44 - access("USAGES_SOURCE_ID"="TM_REC_ID")
45 - filter("USAGES_SOURCE_VERSION"="TM_REC_VERSION" AND (("ENTERPRISE_ID"=0 OR
"ENTERPRISE_ID"=1) OR

"ENTERPRISE_ID"=DECODE(SYS_CONTEXT('FND_VPD_CTX','FND_ENTERPRISE_ID'),NULL,"ENTERPR
ISE_ID",TO_NUMBER(SYS_CONTEXT('FND_VPD_CTX','FND_E
NTERPRISE_ID')))))
46 - access("USAGES_SOURCE_ID"="TM_REC_ID")
47 - storage("AIA"."SOURCE"='ELECTRONIC INVOICE' AND "AIA"."ORG_ID" IS NOT NULL)
filter("AIA"."SOURCE"='ELECTRONIC INVOICE' AND "AIA"."ORG_ID" IS NOT NULL
AND SYSDATE@!-"AIA"."INVOICE_DATE"<=180)
48 - filter("AIA"."SOURCE"='ELECTRONIC INVOICE' AND
NVL("AIA"."ATTRIBUTE1",'0')=TO_CHAR("TM_REC_GRP_ID") AND
SYSDATE@!-"AIA"."INVOICE_DATE"<=180)
49 - access("AIA"."ORG_ID"="ORGANIZATION_ID")
filter("AIA"."ORG_ID"="ORGANIZATION_ID")
50 - filter("ATTRIBUTE_NUMBER1" IS NOT NULL AND "ATTRIBUTE_CATEGORY"='Projects'
AND (("ENTERPRISE_ID"=0 OR "ENTERPRISE_ID"=1) OR

"ENTERPRISE_ID"=DECODE(SYS_CONTEXT('FND_VPD_CTX','FND_ENTERPRISE_ID'),NULL,"ENTERPR
ISE_ID",TO_NUMBER(SYS_CONTEXT('FND_VPD_CTX','FND_E
NTERPRISE_ID')))))
51 - access("TM_REP_ATRB_ID"="TM_REP_ATRB_ID")
53 - access("PPAB"."PROJECT_ID"="ATTRIBUTE_NUMBER1")
54 - filter("ENTERPRISE_ID"=0 OR "ENTERPRISE_ID"=1 OR
"ENTERPRISE_ID"=DECODE(SYS_CONTEXT('FND_VPD_CTX','FND_ENTERPRISE_ID'),NULL,"E

NTERPRISE_ID",TO_NUMBER(SYS_CONTEXT('FND_VPD_CTX','FND_ENTERPRISE_ID'))))
 55 - access("TM_REP_ATRB_ID"="TM_REP_ATRB_ID")
57 - access(ROWID=ROWID)
59 - storage("PEX"."EXPENDITURE_TYPE_NAME"<>'Unpaid Leave (Hourly/Subcontractor
Only)')
filter("PEX"."EXPENDITURE_TYPE_NAME"<>'Unpaid Leave (Hourly/Subcontractor
Only)')
60 - access("TH"."ATTRIBUTE1"=TO_CHAR("A"."TM_REC_GRP_ID") AND
"TH"."SEGMENT5"=NVL(SUBSTR("A"."SEGMENT1",0,INSTR("A"."SEGMENT1",'-'
)-1),"A"."SEGMENT1"))
filter("A"."QTY"<>TO_NUMBER(TO_CHAR("TH"."QTY")))
64 - access("ATTRIBUTE_CATEGORY"=TO_CHAR("PEX"."EXPENDITURE_TYPE_ID"))
80 - access("PRST"."RATE_SCHEDULE_NAME"='WORKER EXPENSES')
81 - filter("PRSL"."PERSON_ID" IS NOT NULL AND
NVL("PRSL"."END_DATE_ACTIVE",SYSDATE@!+1)>=TRUNC(SYSDATE@!) AND
"PRSL"."START_DATE_ACTIVE"<=TRUNC(SYSDATE@!))
82 - access("PRSL"."RATE_SCHEDULE_ID"="PRST"."RATE_SCHEDULE_ID")
83 - filter("ENTERPRISE_ID"=0 OR "ENTERPRISE_ID"=1 OR
"ENTERPRISE_ID"=DECODE(SYS_CONTEXT('FND_VPD_CTX','FND_ENTERPRISE_ID'),NULL,"E

NTERPRISE_ID",TO_NUMBER(SYS_CONTEXT('FND_VPD_CTX','FND_ENTERPRISE_ID'))))
84 - access("PRSL"."PERSON_ID"="RESOURCE_ID" AND "STATUS"='APPROVED')
filter(TO_CHAR(INTERNAL_FUNCTION("STOP_TIME"),'YYYY-MM-DD')>='2020-05-02'
AND "STATUS"='APPROVED')
88 - filter(TO_CHAR(INTERNAL_FUNCTION("STOP_TIME"),'YYYY-MM-DD')>='2020-05-02'
AND "STATUS"='APPROVED')
89 - filter("ASSIGNMENT_STATUS_TYPE"='ACTIVE' AND (("BUSINESS_GROUP_ID"=0 OR
"BUSINESS_GROUP_ID"=1) OR

"BUSINESS_GROUP_ID"=DECODE(SYS_CONTEXT('FND_VPD_CTX','FND_ENTERPRISE_ID'),NULL,"BUS
INESS_GROUP_ID",TO_NUMBER(SYS_CONTEXT('FND_VPD_CTX
','FND_ENTERPRISE_ID')))))
90 - access("PERSON_ID"="RESOURCE_ID" AND "PRIMARY_FLAG"='Y' AND
"EFFECTIVE_END_DATE">=TRUNC(INTERNAL_FUNCTION("STOP_TIME")) AND
"EFFECTIVE_START_DATE"<=TRUNC(INTERNAL_FUNCTION("STOP_TIME")))
filter("PRIMARY_FLAG"='Y' AND
"EFFECTIVE_START_DATE"<=TRUNC(INTERNAL_FUNCTION("START_TIME")) AND
"EFFECTIVE_START_DATE"<=TRUNC(INTERNAL_FUNCTION("STOP_TIME")) AND
"EFFECTIVE_END_DATE">=TRUNC(INTERNAL_FUNCTION("STOP_TIME")) AND
"EFFECTIVE_END_DATE">=TRUNC(INTERNAL_FUNCTION("START_TIME")))
91 - filter("NAME"='SS US BU' AND (("BUSINESS_GROUP_ID"=0 OR
"BUSINESS_GROUP_ID"=1) OR

"BUSINESS_GROUP_ID"=DECODE(SYS_CONTEXT('FND_VPD_CTX','FND_ENTERPRISE_ID'),NULL,"BUS
INESS_GROUP_ID",TO_NUMBER(SYS_CONTEXT('FND_VPD_CTX
','FND_ENTERPRISE_ID')))))
92 - access("ITEM_2"="ORGANIZATION_ID")
93 - filter("DEFAULT_CODE_COMB_ID" IS NOT NULL AND
"OBJECT_VERSION_NUMBER"="MAX(B.OBJECT_VERSION_NUMBER)" AND
"BUSINESS_UNIT_ID"="ORGANIZATION_ID" AND
"ASSIGNMENT_STATUS_TYPE"='ACTIVE' AND (("BUSINESS_GROUP_ID"=0 OR
"BUSINESS_GROUP_ID"=1) OR

"BUSINESS_GROUP_ID"=DECODE(SYS_CONTEXT('FND_VPD_CTX','FND_ENTERPRISE_ID'),NULL,"BUS
INESS_GROUP_ID",TO_NUMBER(SYS_CONTEXT('FND_VPD_CTX
','FND_ENTERPRISE_ID')))))
94 - access("PERSON_ID"="RESOURCE_ID" AND "PRIMARY_FLAG"='Y' AND
"EFFECTIVE_END_DATE">=TRUNC(INTERNAL_FUNCTION("STOP_TIME")) AND
"EFFECTIVE_START_DATE"<=TRUNC(INTERNAL_FUNCTION("STOP_TIME")))
filter("PRIMARY_FLAG"='Y' AND
"EFFECTIVE_START_DATE"<=TRUNC(INTERNAL_FUNCTION("START_TIME")) AND
"EFFECTIVE_START_DATE"<=TRUNC(INTERNAL_FUNCTION("STOP_TIME")) AND
"EFFECTIVE_END_DATE">=TRUNC(INTERNAL_FUNCTION("STOP_TIME")) AND
"EFFECTIVE_END_DATE">=TRUNC(INTERNAL_FUNCTION("START_TIME")))
95 - filter("BUSINESS_GROUP_ID"=0 OR "BUSINESS_GROUP_ID"=1 OR
"BUSINESS_GROUP_ID"=DECODE(SYS_CONTEXT('FND_VPD_CTX','FND_ENTERPRISE_

ID'),NULL,"BUSINESS_GROUP_ID",TO_NUMBER(SYS_CONTEXT('FND_VPD_CTX','FND_ENTERPRISE_I
D'))))
96 - access("RESOURCE_ID"="PERSON_ID" AND "EFFECTIVE_END_DATE">=TRUNC(SYSDATE@!)
AND "EFFECTIVE_START_DATE"<=TRUNC(SYSDATE@!))
filter("EFFECTIVE_END_DATE">=TRUNC(SYSDATE@!))
97 - filter("BUSINESS_GROUP_ID"=0 OR "BUSINESS_GROUP_ID"=1 OR
"BUSINESS_GROUP_ID"=DECODE(SYS_CONTEXT('FND_VPD_CTX','FND_ENTERPRISE_

ID'),NULL,"BUSINESS_GROUP_ID",TO_NUMBER(SYS_CONTEXT('FND_VPD_CTX','FND_ENTERPRISE_I
D'))))
98 - access("PERSON_ID"="PERSON_ID" AND "NAME_TYPE"='GLOBAL' AND
"EFFECTIVE_END_DATE">=TRUNC(SYSDATE@!) AND
"EFFECTIVE_START_DATE"<=TRUNC(SYSDATE@!))
filter("EFFECTIVE_END_DATE">=TRUNC(SYSDATE@!))
100 - access("DEFAULT_CODE_COMB_ID"="GLCC"."CODE_COMBINATION_ID")
101 - filter(NVL("MEASURE",0)<>0 AND NVL("DELETE_FLAG",'N')<>'Y' AND
"LATEST_VERSION"='Y' AND (("ENTERPRISE_ID"=0 OR
"ENTERPRISE_ID"=1) OR
"ENTERPRISE_ID"=DECODE(SYS_CONTEXT('FND_VPD_CTX','FND_ENTERPRISE_ID'),NULL,"ENTERPR
ISE_ID",TO_NUMBER(SYS_CONTEX
T('FND_VPD_CTX','FND_ENTERPRISE_ID')))))
102 - access("RESOURCE_ID"="RESOURCE_ID" AND "GRP_TYPE_ID"=202)
filter(TO_CHAR(INTERNAL_FUNCTION("START_TIME"),'YYYY-MM-
DD')>=TO_CHAR(INTERNAL_FUNCTION("START_TIME"),'YYYY-MM-DD') AND
TO_CHAR(INTERNAL_FUNCTION("START_TIME"),'YYYY-MM-
DD')<=TO_CHAR(INTERNAL_FUNCTION("STOP_TIME"),'YYYY-MM-DD'))
103 - filter("USAGES_SOURCE_VERSION"="TM_REC_VERSION" AND (("ENTERPRISE_ID"=0 OR
"ENTERPRISE_ID"=1) OR

"ENTERPRISE_ID"=DECODE(SYS_CONTEXT('FND_VPD_CTX','FND_ENTERPRISE_ID'),NULL,"ENTERPR
ISE_ID",TO_NUMBER(SYS_CONTEXT('FND_VPD_CTX','FND_E
NTERPRISE_ID')))))
104 - access("USAGES_SOURCE_ID"="TM_REC_ID")
105 - filter("USAGES_SOURCE_VERSION"="TM_REC_VERSION" AND (("ENTERPRISE_ID"=0 OR
"ENTERPRISE_ID"=1) OR

"ENTERPRISE_ID"=DECODE(SYS_CONTEXT('FND_VPD_CTX','FND_ENTERPRISE_ID'),NULL,"ENTERPR
ISE_ID",TO_NUMBER(SYS_CONTEXT('FND_VPD_CTX','FND_E
NTERPRISE_ID')))))
106 - access("USAGES_SOURCE_ID"="TM_REC_ID")
107 - filter("ATTRIBUTE_NUMBER1" IS NOT NULL AND "ATTRIBUTE_CATEGORY"='Projects'
AND (("ENTERPRISE_ID"=0 OR "ENTERPRISE_ID"=1) OR

"ENTERPRISE_ID"=DECODE(SYS_CONTEXT('FND_VPD_CTX','FND_ENTERPRISE_ID'),NULL,"ENTERPR
ISE_ID",TO_NUMBER(SYS_CONTEXT('FND_VPD_CTX','FND_E
NTERPRISE_ID')))))
108 - access("TM_REP_ATRB_ID"="TM_REP_ATRB_ID")
110 - access("PPAB"."PROJECT_ID"="ATTRIBUTE_NUMBER1")
111 - filter("ENTERPRISE_ID"=0 OR "ENTERPRISE_ID"=1 OR
"ENTERPRISE_ID"=DECODE(SYS_CONTEXT('FND_VPD_CTX','FND_ENTERPRISE_ID'),NULL,"E

NTERPRISE_ID",TO_NUMBER(SYS_CONTEXT('FND_VPD_CTX','FND_ENTERPRISE_ID'))))
 112 - access("TM_REP_ATRB_ID"="TM_REP_ATRB_ID")
114 - access(ROWID=ROWID)
116 - storage("PEX"."EXPENDITURE_TYPE_NAME"<>'Unpaid Leave (Hourly/Subcontractor
Only)')
filter("PEX"."EXPENDITURE_TYPE_NAME"<>'Unpaid Leave (Hourly/Subcontractor
Only)')
125 - storage("AIA"."ATTRIBUTE1" IS NOT NULL AND "AIA"."SOURCE"='ELECTRONIC
INVOICE')
filter("AIA"."ATTRIBUTE1" IS NOT NULL AND "AIA"."SOURCE"='ELECTRONIC
INVOICE' AND SYSDATE@!-"AIA"."INVOICE_DATE"<=180)
126 - access("AIA"."INVOICE_ID"="AILA"."INVOICE_ID")
127 - filter("AIA"."ORG_ID"="AILA"."ORG_ID")
131 - storage("AII"."ATTRIBUTE1" IS NOT NULL AND "AII"."SOURCE"='ELECTRONIC
INVOICE' AND "AII"."ORG_ID" IS NOT NULL AND
NVL("AII"."STATUS",'a')<>'PROCESSED')
filter("AII"."ATTRIBUTE1" IS NOT NULL AND "AII"."SOURCE"='ELECTRONIC
INVOICE' AND "AII"."ORG_ID" IS NOT NULL AND
NVL("AII"."STATUS",'a')<>'PROCESSED' AND
SYSDATE@!-"AII"."INVOICE_DATE"<=180)
132 - access("AII"."INVOICE_ID"="AILI"."INVOICE_ID")
133 - filter("AII"."ORG_ID"="AILI"."ORG_ID")

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

]]>
</DATA_DS>
</SQL_EXPLAIN_PLAN>