Stuff
public text v1 · immutableOperation Object Name Rows Bytes Cost Object Node In/Out PStart PStop
SELECT STATEMENT Optimizer Mode=CHOOSE 1 58327
SORT ORDER BY 1 218 58327
SORT GROUP BY 1 218 58327
HASH JOIN 1 218 58320
NESTED LOOPS 1 210 58317
NESTED LOOPS 1 181 58315
NESTED LOOPS 1 158 58314
HASH JOIN OUTER 1 153 58314
NESTED LOOPS 1 132 1993
NESTED LOOPS 1 128 1993
NESTED LOOPS OUTER 1 104 1990
NESTED LOOPS 1 94 1989
NESTED LOOPS 1 76 1987
HASH JOIN 1 63 1986
NESTED LOOPS 11 319 26
TABLE ACCESS BY INDEX ROWID APPLSYS.FND_FLEX_VALUES 11 176 4
INDEX RANGE SCAN APPLSYS.FND_FLEX_VALUES_N2 11 3
TABLE ACCESS BY INDEX ROWID HR.HR_ALL_ORGANIZATION_UNITS 4 K 53 K 2
INDEX RANGE SCAN HR.HR_ORGANIZATION_UNITS_UK2 4 K 1
INLIST ITERATOR
TABLE ACCESS BY INDEX ROWID XXST.XXST_PA_INDIC_AMTS 31 1 K 1959
INDEX RANGE SCAN XXST.XXST_PA_INDIC_AMTS_N12 31 15
TABLE ACCESS BY INDEX ROWID HR.HR_ALL_ORGANIZATION_UNITS 4 K 53 K 1
INDEX UNIQUE SCAN HR.HR_ORGANIZATION_UNITS_PK 4 K
TABLE ACCESS BY INDEX ROWID PA.PA_PROJECT_CUSTOMERS 27 K 479 K 2
INDEX RANGE SCAN PA.PA_PROJECT_CUSTOMERS_U1 27 K 1
TABLE ACCESS BY INDEX ROWID AR.HZ_CUST_ACCOUNTS 17 K 172 K 1
INDEX UNIQUE SCAN AR.HZ_CUST_ACCOUNTS_U1 17 K
TABLE ACCESS BY INDEX ROWID XXST.XXST_PA_INDIC_AMTS 36 K 858 K 3
INDEX RANGE SCAN XXST.XXST_PA_INDIC_AMTS_N4 36 K 2
INDEX UNIQUE SCAN HR.HR_ORGANIZATION_UNITS_PK 4 K 16 K
VIEW 70 K 1 M 56320
SORT GROUP BY 70 K 2 M 56320
HASH JOIN 70 K 2 M 55793
TABLE ACCESS FULL AR.AR_RECEIVABLE_APPLICATIONS_ALL 70 K 1 M 3162
TABLE ACCESS FULL GL.GL_CODE_COMBINATIONS 15 M 206 M 35487
INDEX UNIQUE SCAN PA.PA_PROJECTS_U1 95 K 468 K
TABLE ACCESS BY INDEX ROWID AR.HZ_PARTIES 208 K 4 M 1
INDEX UNIQUE SCAN AR.HZ_PARTIES_U1 208 K
TABLE ACCESS BY INDEX ROWID APPLSYS.FND_FLEX_VALUES_TL 241 K 6 M 2
INDEX UNIQUE SCAN APPLSYS.FND_FLEX_VALUES_TL_U1 241 K 1
TABLE ACCESS FULL GL.GL_SETS_OF_BOOKS 50 400 2