alter session set nls_date_format = 'DD-MON-YY HH24:MI:SS';set pages 10000set lines 150col USER_NAME form a20col USER_CONCURRENT_PROGRAM_NAME form a60spo GSS.lstselect fcr.request_id, fu.user_name, fcpt.user_concurrent_program_name, fcr.PHASE_CODE, fcr.STATUS_CODE, fcr.actual_start_date, ACTUAL_COMPLETION_DATE, (ACTUAL_COMPLETION_DATE-fcr.actual_start_date)*60*24 "Delta in Mins", argument_text, fcr.parent_request_idfrom fnd_concurrent_requests fcr, fnd_concurrent_programs_tl fcpt, fnd_user fuwhere (fcr.PROGRAM_APPLICATION_ID = fcpt.APPLICATION_IDand fcr.CONCURRENT_PROGRAM_ID = fcpt.CONCURRENT_PROGRAM_ID)and fcr.requested_by = fu.user_idand fcr.actual_start_date > sysdate - 30and fcpt.user_concurrent_program_name = 'Gather Schema Statistics'order by 6;spo offspo WBP.lstselect fcr.request_id, fu.user_name, fcpt.user_concurrent_program_name, fcr.PHASE_CODE, fcr.STATUS_CODE, fcr.actual_start_date, ACTUAL_COMPLETION_DATE, (ACTUAL_COMPLETION_DATE-fcr.actual_start_date)*60*24 "Delta in Mins", argument_text, fcr.parent_request_idfrom fnd_concurrent_requests fcr, fnd_concurrent_programs_tl fcpt, fnd_user fuwhere (fcr.PROGRAM_APPLICATION_ID = fcpt.APPLICATION_IDand fcr.CONCURRENT_PROGRAM_ID = fcpt.CONCURRENT_PROGRAM_ID)and fcr.requested_by = fu.user_idand fcr.actual_start_date > sysdate - 30and fcpt.user_concurrent_program_name = 'Workflow Background Process'and argument_text = ' , , , Y, N, N'order by 6;spo offspo WCQC.lstselect fcr.request_id, fu.user_name, fcpt.user_concurrent_program_name, fcr.PHASE_CODE, fcr.STATUS_CODE, fcr.actual_start_date, ACTUAL_COMPLETION_DATE, (ACTUAL_COMPLETION_DATE-fcr.actual_start_date)*60*24 "Delta in Mins", argument_text, fcr.parent_request_idfrom fnd_concurrent_requests fcr, fnd_concurrent_programs_tl fcpt, fnd_user fuwhere (fcr.PROGRAM_APPLICATION_ID = fcpt.APPLICATION_IDand fcr.CONCURRENT_PROGRAM_ID = fcpt.CONCURRENT_PROGRAM_ID)and fcr.requested_by = fu.user_idand fcr.actual_start_date > sysdate - 30and fcpt.user_concurrent_program_name = 'Workflow Control Queue Cleanup'order by 6;spo offspo PCRMD.lstselect fcr.request_id, fu.user_name, fcpt.user_concurrent_program_name, fcr.PHASE_CODE, fcr.STATUS_CODE, fcr.actual_start_date, ACTUAL_COMPLETION_DATE, (ACTUAL_COMPLETION_DATE-fcr.actual_start_date)*60*24 "Delta in Mins", argument_text, fcr.parent_request_idfrom fnd_concurrent_requests fcr, fnd_concurrent_programs_tl fcpt, fnd_user fuwhere (fcr.PROGRAM_APPLICATION_ID = fcpt.APPLICATION_IDand fcr.CONCURRENT_PROGRAM_ID = fcpt.CONCURRENT_PROGRAM_ID)and fcr.requested_by = fu.user_idand fcr.actual_start_date > sysdate - 30and fcpt.user_concurrent_program_name = 'Purge Concurrent Request and/or Manager Data'order by 6;spo offspo POWRD.lstselect fcr.request_id, fu.user_name, fcpt.user_concurrent_program_name, fcr.PHASE_CODE, fcr.STATUS_CODE, fcr.actual_start_date, ACTUAL_COMPLETION_DATE, (ACTUAL_COMPLETION_DATE-fcr.actual_start_date)*60*24 "Delta in Mins", argument_text, fcr.parent_request_idfrom fnd_concurrent_requests fcr, fnd_concurrent_programs_tl fcpt, fnd_user fuwhere (fcr.PROGRAM_APPLICATION_ID = fcpt.APPLICATION_IDand fcr.CONCURRENT_PROGRAM_ID = fcpt.CONCURRENT_PROGRAM_ID)and fcr.requested_by = fu.user_idand fcr.actual_start_date > sysdate - 30and fcpt.user_concurrent_program_name = 'Purge Obsolete Workflow Runtime Data'order by 6;spo off