Query to Get Concurrent Program that has ended with an Error

SELECT a.request_id
      ,a.concurrent_program_id
      ,a.actual_start_date
      ,b.concurrent_program_name concurrent_program_short_name
      ,c.user_concurrent_program_name concurrent_program_name
      ,a.status_code
      ,a.phase_code
  FROM fnd_concurrent_requests a
      ,fnd_concurrent_programs b
      ,fnd_concurrent_programs_tl c
 WHERE a.status_code = 'E'
   AND phase_code = 'C'
   AND a.concurrent_program_id = b.concurrent_program_id
   AND b.concurrent_program_id = c.concurrent_program_id