Category: PIPER-Rx Reports (Free) Name: FWF005-11 WF Purgable Estimate ReportDefFileName: .\FWF005-11 WF Purgable Estimate.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: Purgable Estimate -- ** -- ** From the paper "The Hidden Cost of Workflow" by Gary Piper -- ** -- ** ------------------------------------------------- -- ** Version 1.0 2005 G.Piper - PIPER-Rx -- ** Aug-09 G.Piper Referenced GV$DATABASE -- **************************************************** SELECT report_headings.report_date, report_headings.db_sid, witt.display_name, wit.name, wit.persistence_type, wit.persistence_days, count(wi.item_key) workflows, apps.wf_purge.getpurgeablecount(wit.name) purgable FROM applsys.wf_item_types wit, applsys.wf_item_types_tl witt, applsys.wf_items wi, ( SELECT to_char(sysdate, 'DD-Mon-YY HH24:MI') report_date, vd.name db_sid FROM gv$database vd WHERE vd.inst_id = 1 ) report_headings WHERE wit.name = witt.name and witt.language = userenv('LANG') and wit.name = wi.item_type GROUP by report_headings.report_date, report_headings.db_sid, witt.display_name, wit.name, wit.persistence_type, wit.persistence_days ORDER by count(wi.item_key) desc ===End SQL=== ===Begin Report Definition===