To Find USER Concurrent Request in Oracle

Currently running concurrent program details along with user and responsibility

SELECT fcp.user_concurrent_program_name,

  fcr.request_id,

  fcr.request_date,

  fu.user_name Requested_By ,

  fr.responsibility_name,

  TO_CHAR(fcr.actual_start_date,'DD-MON-YYYY HH24:MI:SS') actual_start_date

FROM fnd_concurrent_requests fcr ,

  fnd_concurrent_programs_tl fcp ,

  fnd_user fu ,

  fnd_responsibility_tl fr

WHERE 1                       =1

AND fcr.phase_code            ='R'

AND fcr.concurrent_program_id = fcp.concurrent_program_id

AND fcr.requested_by          = fu.user_id

AND FCR.RESPONSIBILITY_ID     = FR.RESPONSIBILITY_ID

Query To Find Concurrent Request,Requester,Parameter And Completion Time

 

SELECT   request_id, phase_code, status_code, responsibility_id,

         actual_start_date, actual_completion_date, completion_text,

         argument_text, program_short_name, requestor

    FROM apps.fnd_conc_req_summary_v

   WHERE program_short_name LIKE 'INV_STORE_STOCK_CONS_SUMM'

ORDER BY request_id DESC;

 

This query is based on oracle standard view.If you still want to drill down whats exactly joins and which tables are present, sharing below query with all details :

 

 SELECT r.ROWID row_id,

        r.request_id,

        r.phase_code,

        r.status_code,

        r.priority_request_id,

        r.priority,

        r.request_date,

        r.requested_by,

        r.requested_start_date,

        r.hold_flag,

        r.has_sub_request,

        r.is_sub_request,

        r.update_protected,

        r.queue_method_code,

        r.responsibility_application_id,

        r.responsibility_id,

        r.save_output_flag,

        r.last_update_date,

        r.last_updated_by,

        r.last_update_login,

        r.printer,

        r.print_style,

        r.parent_request_id,

        r.controlling_manager,

        r.actual_start_date,

        r.actual_completion_date,

        r.completion_text,

        r.argument_text,

        r.implicit_code,

        r.request_type,

        r.program_application_id,

        r.concurrent_program_id,

        pb.concurrent_program_name program_short_name,

        pb.execution_method_code,

        pb.enabled_flag enabled,

        DECODE(r.description,

               NULL,

               pt.user_concurrent_program_name,

               r.description || ' (' || pt.user_concurrent_program_name || ')') program,

        pb.printer_name fcp_printer,

        pb.output_print_style fcp_print_style,

        pb.required_style fcp_required_style,

        u.user_name requestor,

        s.user_printer_style_name user_print_style,

        r.description description,

        pt.user_concurrent_program_name user_concurrent_program_name

   FROM fnd_concurrent_programs_tl pt,

        fnd_concurrent_programs    pb,

        fnd_user                   u,

        fnd_printer_styles_tl      s,

        fnd_concurrent_requests    r

  WHERE pb.application_id = r.program_application_id

    AND pb.concurrent_program_id = r.concurrent_program_id

    AND pb.application_id = pt.application_id

    AND pb.concurrent_program_id = pt.concurrent_program_id

    AND pt.LANGUAGE = USERENV('LANG')

    AND u.user_id = r.requested_by

    AND s.printer_style_name(+) = r.print_style

    AND s.LANGUAGE(+) = USERENV('LANG');