Category: PIPER-Rx Reports (Free) Name: FWF006-10 Workflow BG Processes ReportDefFileName: .\FWF006-10 Workflow BG Processes.fr3 ===Begin Comments=== Copyright (C) 2009 G Piper This program is free software: you can redistribute it and/or modify it under the terms of the GNU Affero General Public License as published by the Free Software Foundation, either version 3 of the License, or (at your option) any later version. This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU Affero General Public License for more details. a copy of the GNU Affero General Public Licenses provided is part of the down load Terms and Conditions available on our site www.piper-rx.com or you can refere to www.gnu.org/licenses/gpl.html ===End Comments=== ===Begin SQL=== -- **************************************************** -- ** PIPER-RX - Free Reports -- ** -- ** Copyright (C) 2009 G.Piper -- ** -- ** Workflow: Background processes -- ** -- ** -- ** ------------------------------------------------- -- ** Version 1.0 2009 G.Piper - PIPER-Rx -- **************************************************** SELECT to_char(sysdate, 'DD-Mon-YY HH24:MI:SS') report_date, report_headings.sid_name sid_name, fcr.request_id, fcr.requested_by, fu.user_name, fcr.argument_text, fcr.resubmit_interval, fcr.resubmit_interval_unit_code, fcr.resubmit_interval_type_code, fcr.resubmit_end_date FROM applsys.fnd_concurrent_requests fcr, applsys.fnd_user fu, (SELECT vd.name sid_name FROM gv$database vd WHERE vd.inst_id = 1 ) report_headings WHERE fcr.requested_by = fu.user_id and fcr.program_application_id = 0 and fcr.concurrent_program_id = 36888 and fcr.phase_code = 'P' ORDER by fcr.request_id ===End SQL=== ===Begin Report Definition===