Today, i want to post about concurrent listing query. It will be used to find concurrent name, with some additional field about executable name, executable path name. And also RTP template name, while the concurrent have related with XML publisher.
/* Created by = Andreas Victor (www.andreasvictor.net) 20151212 Purpose = Query concurrent list with some fields about executable name and rtf template */ SELECT fcpt.user_concurrent_program_name, fcpt.description, fcp.output_file_type type, fcp.output_print_style style, fa.application_short_name app, fe.executable_name, fe.execution_file_name, ( select template_code from XDO_DS_DEFINITIONS_TL xdt, XDO_TEMPLATES_B xtb where xdt.data_source_code = xtb.data_source_code and xdt.data_source_code = fe.executable_name and rownum=1 )rtf_template, fcp.creation_date, fu.user_name created_by, fcp.last_update_date FROM fnd_concurrent_programs fcp, fnd_concurrent_programs_tl fcpt, fnd_application fa, fnd_executables_form_v fe, fnd_user fu WHERE 1=1 AND fcpt.concurrent_program_id = fcp.concurrent_program_id AND fa.application_id = fcp.application_id AND fcp.executable_id = fe.executable_id AND fcp.created_by = fu.user_id AND UPPER(fcp.concurrent_program_name) = :p_concurrent_name AND fcp.enabled_flag = 'Y' ORDER BY fcp.creation_date DESC;
When i need to monitor the running concurrent, i have used this query.
SELECT * FROM ( SELECT fcr.request_id, fcr.request_date, fcpt.user_concurrent_program_name, fcp.concurrent_program_name, fcpt.description, fa.application_short_name app_short_name, fcr.phase_code, fcr.status_code -- fcp.* -- fcr.* FROM fnd_concurrent_requests fcr, fnd_concurrent_programs fcp, fnd_concurrent_programs_tl fcpt, fnd_application fa WHERE 1=1 AND fcp.concurrent_program_id = fcr.concurrent_program_id AND fcpt.concurrent_program_id = fcp.concurrent_program_id AND fa.application_id = fcp.application_id AND UPPER(fcp.concurrent_program_name) like '%ACCOUNTING%' )aa ORDER BY aa.request_date DESC ;
I hope it can be used to my blog reader. Thanks.