Plan
SELECT STATEMENT  HINT: RULE																
	61 SORT ORDER BY  															
		60 VIEW VIEW APPWORX.AW_JOB_ACTIVITY 														
			59 SORT UNIQUE  													
				58 UNION-ALL  												
					27 NESTED LOOPS OUTER  											
						24 NESTED LOOPS OUTER  										
							21 NESTED LOOPS OUTER  									
								18 NESTED LOOPS OUTER  								
									15 FILTER  							
										14 NESTED LOOPS OUTER  						
											11 NESTED LOOPS OUTER  					
												8 NESTED LOOPS OUTER  				
													5 NESTED LOOPS  			
														2 TABLE ACCESS BY INDEX ROWID TABLE APPWORX.AW_JOB_QUEUE_ACTIVITY 		
															1 INDEX RANGE SCAN INDEX APPWORX.AW_JOB_QUEUE_ACTIVITY_IDX1 	
														4 TABLE ACCESS BY INDEX ROWID TABLE APPWORX.SO_JOB_HISTORY 		
															3 INDEX RANGE SCAN INDEX APPWORX.SO_JOB_HISTORY_IDX1 	
													7 TABLE ACCESS BY INDEX ROWID TABLE APPWORX.SO_USER_TABLE 			
														6 INDEX UNIQUE SCAN INDEX (UNIQUE) APPWORX.SO_USER_TABLE_IDX 		
												10 TABLE ACCESS BY INDEX ROWID TABLE APPWORX.SO_JOB_TABLE 				
													9 INDEX UNIQUE SCAN INDEX (UNIQUE) APPWORX.SO_JOB_TABLE_IDX 			
											13 TABLE ACCESS BY INDEX ROWID TABLE APPWORX.SO_JOB_TABLE 					
												12 INDEX UNIQUE SCAN INDEX (UNIQUE) APPWORX.SO_JOB_TABLE_IDX 				
									17 TABLE ACCESS BY INDEX ROWID TABLE APPWORX.AW_MODULE_SCHED 							
										16 INDEX UNIQUE SCAN INDEX (UNIQUE) APPWORX.PK_AW_MODULE_SCHED 						
								20 TABLE ACCESS BY INDEX ROWID TABLE APPWORX.SO_APPLS 								
									19 INDEX UNIQUE SCAN INDEX (UNIQUE) APPWORX.SO_APPLS_IDX 							
							23 TABLE ACCESS BY INDEX ROWID TABLE APPWORX.SO_COMMAND_PATHS 									
								22 INDEX UNIQUE SCAN INDEX (UNIQUE) APPWORX.SO_COMMAND_PATHS_IDX 								
						26 TABLE ACCESS BY INDEX ROWID TABLE APPWORX.SO_CHAIN_DETAIL 										
							25 INDEX RANGE SCAN INDEX APPWORX.SO_CHAIN_DETAIL_IDX2 									
					57 NESTED LOOPS OUTER  											
						54 NESTED LOOPS OUTER  										
							51 NESTED LOOPS OUTER  									
								48 NESTED LOOPS OUTER  								
									45 NESTED LOOPS OUTER  							
										42 FILTER  						
											41 NESTED LOOPS OUTER  					
												38 NESTED LOOPS OUTER  				
													35 NESTED LOOPS OUTER  			
														32 NESTED LOOPS  		
															29 TABLE ACCESS BY INDEX ROWID TABLE APPWORX.AW_JOB_QUEUE_ACTIVITY 	
																28 INDEX RANGE SCAN INDEX APPWORX.AW_JOB_QUEUE_ACTIVITY_IDX1 
															31 TABLE ACCESS BY INDEX ROWID TABLE APPWORX.SO_JOB_QUEUE 	
																30 INDEX UNIQUE SCAN INDEX (UNIQUE) APPWORX.SO_JOB_QUEUE_IDX 
														34 TABLE ACCESS BY INDEX ROWID TABLE APPWORX.SO_USER_TABLE 		
															33 INDEX UNIQUE SCAN INDEX (UNIQUE) APPWORX.SO_USER_TABLE_IDX 	
													37 TABLE ACCESS BY INDEX ROWID TABLE APPWORX.SO_JOB_TABLE 			
														36 INDEX UNIQUE SCAN INDEX (UNIQUE) APPWORX.SO_JOB_TABLE_IDX 		
												40 TABLE ACCESS BY INDEX ROWID TABLE APPWORX.SO_JOB_TABLE 				
													39 INDEX UNIQUE SCAN INDEX (UNIQUE) APPWORX.SO_JOB_TABLE_IDX 			
										44 TABLE ACCESS BY INDEX ROWID TABLE APPWORX.AW_MODULE_SCHED 						
											43 INDEX UNIQUE SCAN INDEX (UNIQUE) APPWORX.PK_AW_MODULE_SCHED 					
									47 TABLE ACCESS BY INDEX ROWID TABLE APPWORX.SO_JOB_QUEUE 							
										46 INDEX UNIQUE SCAN INDEX (UNIQUE) APPWORX.SO_JOB_QUEUE_IDX 						
								50 TABLE ACCESS BY INDEX ROWID TABLE APPWORX.SO_APPLS 								
									49 INDEX UNIQUE SCAN INDEX (UNIQUE) APPWORX.SO_APPLS_IDX 							
							53 TABLE ACCESS BY INDEX ROWID TABLE APPWORX.SO_COMMAND_PATHS 									
								52 INDEX UNIQUE SCAN INDEX (UNIQUE) APPWORX.SO_COMMAND_PATHS_IDX 								
						56 TABLE ACCESS BY INDEX ROWID TABLE APPWORX.SO_CHAIN_DETAIL 										
							55 INDEX RANGE SCAN INDEX APPWORX.SO_CHAIN_DETAIL_IDX2