Program status check

 SELECT

    request_id,

    decode(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,

    decode(phase_code, 'C', 'Completed', 'I', 'Inactive',

           'P', 'Pending', 'R', 'Running', 'Others')          phase,

    to_char(request_date, 'DD-MON-YYYY HH24:MI:SS')           request_date,

    requestor,

    to_char(actual_start_date, 'DD-MON-YYYY HH24:MI:SS')      actual_start_date,

    to_char(actual_completion_date, 'DD-MON-YYYY HH24:MI:SS') actual_completion_date,

    to_char(round((actual_completion_date - actual_start_date) * 1440, 0))

    || ' Mins '

    || to_char(round(mod((actual_completion_date - actual_start_date) * 86400, 60),

                     2))

    || ' Secs'                                                duration,

    argument_text,

    rtl.responsibility_name,

    program,

    program_short_name,

    rtl.responsibility_id,

    concurrent_program_id,

    priority_request_id,

    priority,

    printer,

    print_style,

    user_print_style,

    requested_start_date

FROM

    apps.fnd_conc_req_summary_v conc,

    apps.fnd_responsibility_tl  rtl

WHERE

        conc.responsibility_id = rtl.responsibility_id

--and status_code = 'E'

    AND language = 'US'

    AND program LIKE '%OPQR%'

    AND request_date > sysdate - 9

ORDER BY

    request_date DESC;