Category: PIPER-Rx Reports (Free) Name: FWF003-11 Workflow Activity By Workflow ReportDefFileName: .\FWF003-11 Workflow Activity By Workflow.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 -- ** -- ** From AUSOAUG eTraining Webcast By G.Piper - November 2008 -- ** -- ** Step 3 - Workflows Activity by Workflow -- ** -- ** NOTE: Workflow key is case sensitive -- ** -- ** ------------------------------------------------- -- ** Version 1.0 Nov-08 G.Piper - PIPER-Rx -- ** Version 1.1 Aug-09 G.Piper Referenced GV$DATABASE -- **************************************************** SELECT to_char(sysdate, 'DD-Mon-YY HH24:MI:SS') report_date, report_headings.sid_name sid_name, upper(:WORKFLOW) workflow, substr(witt.display_name,1,30) display_name, :WORKFLOW_KEY item_key, wais.activity_id, wais.activity_display_name, wais.execution_time, wais.activity_status_code, wais.activity_result_display_name, wais.assigned_user, wais.notification_id, to_char(wais.activity_begin_date, 'DD-Mon-YY HH24:MI') activity_begin_date, nvl(to_char(wais.activity_end_date, 'DD-Mon-YY HH24:MI'), 'Active') activity_end_date, round(( wais.activity_end_date - wais.activity_begin_date ),1) item_age_days FROM apps.wf_item_activity_statuses_v wais, applsys.wf_item_types_tl witt, (SELECT vd.name sid_name FROM gv$database vd WHERE vd.inst_id = 1) report_headings WHERE wais.item_type = witt.name and witt.language = userenv('LANG') and wais.item_type = upper(:WORKFLOW) and wais.item_key = :WORKFLOW_KEY ORDER by wais.activity_begin_date, wais.execution_time ===End SQL=== ParamName: WORKFLOW ParamType: String ParamValue: apexp ParamExp: ParamName: WORKFLOW_KEY ParamType: String ParamValue: 11647 ParamExp: ===Begin Report Definition===