alter session set nls_language = AMERICAN;

SELECT
    requester.user_name,
    DECODE (fcr.status_code,
                  'A', 'Waiting''B',
                  'Resuming''C', 'Normal''D',
                  'Cancelled''E', 'Error''F',
                  'Scheduled''G', 'Warning''H',
                  'On Hold''I', 'Normal''M',
                  'No Manager''Q', 'Standby''R',
                  'Normal''S', 'Suspended''T',
                  'Terminating''U', 'Disabled''W',
                  'Paused''X', 'Terminated''Z',
                  'Waiting') status,
                  fcr.Hold_Flag,
      fa.application_name,
    fcp.user_concurrent_program_name,
    fcr.request_id,
    fcr.argument_text,
    fcrc.user_release_class_name,
    TO_CHAR(fcr.resubmit_end_date,'DD-MON-YYYY') resubmit_end_date,
    nvl(TO_CHAR(fcr.resubmit_interval),fcrc.class_info) resubmit_interval,
    DECODE(fcr.resubmit_interval_unit_code,'MONTHS','Month(s)','WEEKS','Week(s)','DAYS','Day(s)','HOURS','Hour(s)','MINUTES','Minute(s)'
,fcr.resubmit_interval_unit_code) resubmit_unit,
    DECODE(fcr.resubmit_interval_type_code,'START','From the Start of the prior run','END','From the Completion of the prior run',fcr
.resubmit_interval_type_code) "Start From",
    DECODE(fcr.increment_dates,'Y','Yes','N','No',NULL,'No',fcr.increment_dates) "Increment Dates",
    TO_CHAR(fcr.last_update_date,'DD-MON-YYYY HH24:MI:SS') "Last Update Date",

    DECODE(sign(nvl(fcr.resubmit_end_date,TRUNC(SYSDATE) + 1) - TRUNC(SYSDATE) ),-1,'True','False'
) "Resubmit End Date",
 nvl(fu2.user_name,'UNKNOWN') "Last Updated By",
    fa.application_short_name
                             FROM
    fnd_user fu2,
    fnd_user requester,
    fnd_conc_release_classes_vl fcrc,
    fnd_concurrent_programs_vl fcp,
    fnd_application_vl fa,
    applsys.fnd_conc_request_arguments fcra,
    applsys.fnd_concurrent_requests fcr
   WHERE
            fcr.phase_code != 'C'
        AND fcp.application_id (+) = fcr.program_application_id
        AND fcp.concurrent_program_id (+) = fcr.concurrent_program_id
        AND fa.application_id (+) = fcr.program_application_id
        AND fcrc.application_id = fcr.release_class_app_id
        AND fcrc.release_class_id = fcr.release_class_id
        AND fcra.request_id (+) = fcr.request_id
        AND fu2.user_id (+) = fcr.last_updated_by
        AND fcr.requested_by  = requester.user_id
ORDER BY
    fa.application_name,
    fcp.user_concurrent_program_name,
    fcr.request_id