Concurrent Program Details Query

select request_id,        
fcpt.user_concurrent_program_name,      
  completion_text,        
actual_start_date,        
actual_completion_date,
  to_date((actual_completion_date - actual_start_date), 'HH:MM:SS') duration
  from fnd_concurrent_requests fcr,  
  fnd_concurrent_programs fcp,        
  fnd_concurrent_programs_tl fcpt
  where fcr.concurrent_program_id = fcp.concurrent_program_id  
  and fcp.concurrent_program_id = fcpt.concurrent_program_id  
  and fcr.actual_start_date > sysdate - 1  
  order by actual_completion_date - actual_start_date desc;