Query to find submitted Concurrent requests

 

Query to find Concurrent Requests

SELECT

    user_concurrent_program_name,

    responsibility_name,

    request_date,

    argument_text,

    request_id,

    phase_code,

    status_code,

    logfile_name,

    outfile_name,

    output_file_type

FROM

    fnd_concurrent_requests fcr,

    fnd_concurrent_programs_tl fcp,

    fnd_responsibility_tl fr,

    fnd_user fu

WHERE

    fcr.CONCURRENT_PROGRAM_ID = fcp.concurrent_program_id

    and fcr.responsibility_id = fr.responsibility_id

    and fcr.requested_by = fu.user_id

ORDER BY REQUEST_DATE DESC;