Operation 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