Query to get Concurrent Programs that are Errored or Warning in Oracle APPS

  SELECT fcr.request_id

        ,fcp.user_concurrent_program_name

        ,TO_CHAR (TRUNC (actual_start_date), 'DD-MON-RRRR') start_date

        ,ROUND (

            ( (NVL (fcr.actual_completion_date, SYSDATE)

               - fcr.actual_start_date)

             * 60

             * 24),

            2) time_in_min

        ,phase.meaning phase

        ,status.meaning status

    FROM fnd_concurrent_requests fcr

        ,fnd_concurrent_programs_tl fcp

        ,fnd_lookup_values status

        ,fnd_lookup_values phase

   WHERE 1 = 1 

     AND fcr.concurrent_program_id = fcp.concurrent_program_id

     AND (fcr.status_code <> 'C' 

         OR fcr.phase_code <> 'C')

     AND fcr.status_code = status.lookup_code

     AND status.lookup_type = 'CP_STATUS_CODE'

     AND status.view_application_id = 0

     AND fcr.phase_code = phase.lookup_code

     AND phase.lookup_type = 'CP_PHASE_CODE'

     AND phase.view_application_id = 0

ORDER BY fcp.user_concurrent_program_name, fcr.request_id