Oracle E-Business Suite: Belirli Bir Süreden Uzun Süren Concurrent'lar - Concurrents Lasting More Than X Minutes

Buradaki sorgumuzu çalıştırdığımızda bizden bir değer istenir. Bu değer ile belirli bir süreden uzun çalışan concurrentlar bulunur. 45 değerini girersek eğer 45 dakika ve üzerinde bir süre çalışan concurrent programları gösterilir.

 SELECT  
   fcr.request_id request_id,  
   TRUNC(((fcr.actual_completion_date-fcr.actual_start_date)/(1/24))*60) exec_time,  
   fcr.actual_start_date start_date,  
   fcp.concurrent_program_name conc_prog,  
   fcpt.user_concurrent_program_name user_conc_prog  
 FROM  
  fnd_concurrent_programs fcp,  
  fnd_concurrent_programs_tl fcpt,  
  fnd_concurrent_requests fcr  
 WHERE  
   TRUNC(((fcr.actual_completion_date-fcr.actual_start_date)/(1/24))*60) > NVL('&min',45)  
 and  
   fcr.concurrent_program_id = fcp.concurrent_program_id  
 and  
   fcr.program_application_id = fcp.application_id  
 and  
   fcr.concurrent_program_id = fcpt.concurrent_program_id  
 and  
   fcr.program_application_id = fcpt.application_id  
 and  
   fcpt.language = USERENV('Lang')  
 ORDER BY  
   TRUNC(((fcr.actual_completion_date-fcr.actual_start_date)/(1/24))*60) desc;