Plan
SELECT STATEMENT  ALL_ROWSCost: 48,747  Bytes: 686  Cardinality: 2  													
	48 HASH GROUP BY  Cost: 48,747  Bytes: 686  Cardinality: 2  												
		47 VIEW ARC. Cost: 48,746  Bytes: 686  Cardinality: 2  											
			46 UNION-ALL  										
				21 HASH GROUP BY  Cost: 45,617  Bytes: 163  Cardinality: 1  									
					20 NESTED LOOPS SEMI  Cost: 45,616  Bytes: 163  Cardinality: 1  								
						18 NESTED LOOPS  Cost: 45,616  Bytes: 155  Cardinality: 1  							
							15 NESTED LOOPS  Cost: 45,615  Bytes: 123  Cardinality: 1  						
								12 NESTED LOOPS  Cost: 45,613  Bytes: 108  Cardinality: 1  					
									9 NESTED LOOPS  Cost: 45,612  Bytes: 89  Cardinality: 1  				
										6 NESTED LOOPS  Cost: 45,610  Bytes: 74  Cardinality: 1  			
											3 HASH JOIN  Cost: 960  Bytes: 35,998  Cardinality: 878  		
												1 TABLE ACCESS FULL TABLE AR.HZ_CUST_ACCT_SITES_ALL Cost: 386  Bytes: 21,925  Cardinality: 877  	
												2 TABLE ACCESS FULL TABLE AR.HZ_CUST_SITE_USES_ALL Cost: 574  Bytes: 16,096  Cardinality: 1,006  	
											5 TABLE ACCESS BY INDEX ROWID TABLE AR.AR_PAYMENT_SCHEDULES_ALL Cost: 367  Bytes: 33  Cardinality: 1  		
												4 INDEX RANGE SCAN INDEX AR.AR_PAYMENT_SCHEDULES_N5 Cost: 5  Cardinality: 1,075  	
										8 TABLE ACCESS BY INDEX ROWID TABLE AR.RA_CUST_TRX_TYPES_ALL Cost: 2  Bytes: 15  Cardinality: 1  			
											7 INDEX RANGE SCAN INDEX (UNIQUE) AR.RA_CUST_TRX_TYPES_U1 Cost: 1  Cardinality: 1  		
									11 TABLE ACCESS BY INDEX ROWID TABLE AR.HZ_CUST_ACCOUNTS Cost: 1  Bytes: 19  Cardinality: 1  				
										10 INDEX UNIQUE SCAN INDEX (UNIQUE) AR.HZ_CUST_ACCOUNTS_U1 Cost: 0  Cardinality: 1  			
								14 TABLE ACCESS BY INDEX ROWID TABLE AR.RA_CUSTOMER_TRX_ALL Cost: 2  Bytes: 15  Cardinality: 1  					
									13 INDEX UNIQUE SCAN INDEX (UNIQUE) AR.RA_CUSTOMER_TRX_U1 Cost: 1  Cardinality: 1  				
							17 TABLE ACCESS BY INDEX ROWID TABLE AR.HZ_PARTIES Cost: 1  Bytes: 32  Cardinality: 1  						
								16 INDEX UNIQUE SCAN INDEX (UNIQUE) AR.HZ_PARTIES_U1 Cost: 0  Cardinality: 1  					
						19 INDEX RANGE SCAN INDEX ARC.ARC_ENTITY_MASTER_N1 Cost: 0  Bytes: 8  Cardinality: 1  							
				45 HASH GROUP BY  Cost: 3,129  Bytes: 180  Cardinality: 1  									
					44 NESTED LOOPS SEMI  Cost: 3,128  Bytes: 180  Cardinality: 1  								
						42 NESTED LOOPS  Cost: 3,128  Bytes: 172  Cardinality: 1  							
							39 NESTED LOOPS  Cost: 3,127  Bytes: 140  Cardinality: 1  						
								36 NESTED LOOPS  Cost: 3,124  Bytes: 119  Cardinality: 1  					
									32 NESTED LOOPS  Cost: 3,117  Bytes: 97  Cardinality: 1  				
										29 NESTED LOOPS  Cost: 3,115  Bytes: 86  Cardinality: 1  			
											26 HASH JOIN  Cost: 1,277  Bytes: 52,680  Cardinality: 878  		
												24 HASH JOIN  Cost: 960  Bytes: 35,998  Cardinality: 878  	
													22 TABLE ACCESS FULL TABLE AR.HZ_CUST_ACCT_SITES_ALL Cost: 386  Bytes: 21,925  Cardinality: 877  
													23 TABLE ACCESS FULL TABLE AR.HZ_CUST_SITE_USES_ALL Cost: 574  Bytes: 16,096  Cardinality: 1,006  
												25 TABLE ACCESS FULL TABLE AR.HZ_CUST_ACCOUNTS Cost: 316  Bytes: 926,725  Cardinality: 48,775  	
											28 TABLE ACCESS BY INDEX ROWID TABLE AR.AR_CASH_RECEIPTS_ALL Cost: 15  Bytes: 26  Cardinality: 1  		
												27 INDEX RANGE SCAN INDEX AR.AR_CASH_RECEIPTS_N2 Cost: 2  Cardinality: 17  	
										31 TABLE ACCESS BY INDEX ROWID TABLE AR.AR_PAYMENT_SCHEDULES_ALL Cost: 2  Bytes: 11  Cardinality: 1  			
											30 INDEX UNIQUE SCAN INDEX (UNIQUE) AR.AR_PAYMENT_SCHEDULES_U2 Cost: 1  Cardinality: 1  		
									35 INLIST ITERATOR  				
										34 TABLE ACCESS BY INDEX ROWID TABLE AR.AR_RECEIVABLE_APPLICATIONS_ALL Cost: 7  Bytes: 22  Cardinality: 1  			
											33 INDEX RANGE SCAN INDEX AR.AR_RECEIVABLE_APPLICATIONS_N1 Cost: 3  Cardinality: 31  		
								38 TABLE ACCESS BY INDEX ROWID TABLE AR.AR_DISTRIBUTIONS_ALL Cost: 3  Bytes: 21  Cardinality: 1  					
									37 INDEX RANGE SCAN INDEX AR.AR_DISTRIBUTIONS_N1 Cost: 2  Cardinality: 1  				
							41 TABLE ACCESS BY INDEX ROWID TABLE AR.HZ_PARTIES Cost: 1  Bytes: 32  Cardinality: 1  						
								40 INDEX UNIQUE SCAN INDEX (UNIQUE) AR.HZ_PARTIES_U1 Cost: 0  Cardinality: 1  					
						43 INDEX RANGE SCAN INDEX ARC.ARC_ENTITY_MASTER_N1 Cost: 0  Bytes: 8  Cardinality: 1