Query to fetch concurrent program duration and user details

Query to fetch concurrent program duration and user details

SELECT fcr.request_id,
         fcr.actual_start_date,
         fcr.actual_completion_date,
           (NVL (fcr.actual_completion_date, SYSDATE) - fcr.actual_start_date)
         * 24
         * 60
            duration_in_mins,
         SYSDATE now,
         fct.user_concurrent_program_name,
         phase_code,
         status_code,
         fcr.completion_text,
         fcr.argument_text,
         frt.responsibility_name,
         logfile_name,
         outfile_name,
         fu.user_name
    FROM apps.fnd_concurrent_requests fcr,
         apps.fnd_concurrent_programs_tl fct,
         apps.fnd_responsibility_tl frt,
         apps.fnd_user fu
   WHERE     fct.concurrent_program_id = fcr.concurrent_program_id
         AND fct.application_id = fcr.program_application_id
         AND fcr.requested_by = fu.user_id
         AND fct.language = 'US'
         AND frt.responsibility_id = fcr.responsibility_id
         AND fct.user_concurrent_program_name = '&p_user_conc_program'
         AND fcr.request_id = &request
ORDER BY actual_start_date DESC

API to purge records from advance queue

How to clear a queue in Oracle AQ

DECLARE
 t_purge_q dbms_aqadm.aq$_purge_options_t;
BEGIN
  dbms_aqadm.purge_queue_table('XXQUEUE', NULL, t_purge_q);
END;
 /

XXQUEUE is your queue name