Oracle E-Business Suite: En Son Fail Eden Concurrent Programlar

 select a.concurrent_program_name, b.REQUEST_ID, a.description,  
 b.status_code, b.phase_code,b.actual_completion_date
 ,b.concurrent_program_id
 ,b.logfile_name,b.logfile_node_name,b.outfile_name
 from APPS.FND_CONCURRENT_PROGRAMS_VL a,  
 APPS.FND_CONCURRENT_REQUESTS b  
 where a.CONCURRENT_PROGRAM_ID = b.CONCURRENT_PROGRAM_ID  
 and a.APPLICATION_ID = b.PROGRAM_APPLICATION_ID  
 and b.STATUS_CODE IN ('E')  
 and b.actual_completion_date > sysdate - 100  
 order by b.actual_completion_date desc;