Category: PIPER-Rx Reports (Free)
Name: FWF002-11 Aged Workflows By Workflow (Month)
ReportDefFileName: .\FWF002-11 Aged Workflows By Workflow (Month).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 2 Aged Workflows By Workflow (Month)
-- **
-- ** -------------------------------------------------
-- ** 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') report_date,
       report_headings.sid_name sid_name,
       wi.item_type workflow,
       substr(witt.display_name,1,60) display_name,
       wi.item_key ,
       to_char(wi.begin_date, 'DD-Mon-YY HH24:MI') begin_date,
       decode( trunc(months_between (sysdate, wi.begin_date)),
               0, 1,  0 ) "Current", 
       decode( trunc(months_between (sysdate, wi.begin_date)),
               1, 1,  0 ) "30 Day", 
       decode( trunc(months_between (sysdate, wi.begin_date)),
               2, 1,  0 ) "60 Day", 
       decode( trunc(months_between (sysdate, wi.begin_date)),
               3, 1,  0 ) "90 Day", 
       decode( trunc(months_between (sysdate, wi.begin_date)),
               null, 0, 0, 0, 1, 0, 2, 0, 3, 0, 1 ) "120 + Days",
       trunc(months_between (sysdate , wi.begin_date)) age_months               
  FROM applsys.wf_items wi,
       applsys.wf_item_types_tl witt,
       (SELECT vd.name sid_name
          FROM gv$database vd
         WHERE vd.inst_id = 1) report_headings 
 WHERE wi.end_date is null -- Active workflows
   and wi.item_type = witt.name 
   and witt.language = userenv('LANG')
   and wi.item_type = upper(:WORKFLOW)
 ORDER by wi.begin_date
===End SQL===
ParamName: workflow
ParamType: String
ParamValue: apexp
ParamExp: 
===Begin Report Definition===
<?xml version="1.0" encoding="utf-8"?>
<TfrxReport Name="" Version="3.21" DotMatrixReport="False" IniFile="\Software\Fast Reports" PreviewOptions.Buttons="2047" PreviewOptions.Zoom="1" PrintOptions.Printer="Default" ReportOptions.CreateDate="38653.3379644213" ReportOptions.Description.Text="" ReportOptions.LastChange="40027.5071124884" ScriptLanguage="PascalScript" ScriptText.Text="&#13;&#10;begin&#13;&#10;&#13;&#10;end." PropData="044C656674020803546F70020E08446174617365747301010C2C00000020446174615365743D225265706F727473466F726D2E2220446174615365744E616D653D224D6173746572220000095661726961626C65730100055374796C650100">
  <TfrxReportPage Name="Page1" Orientation="poLandscape" PaperWidth="297" PaperHeight="210" PaperSize="9" LeftMargin="10" RightMargin="10" TopMargin="10" BottomMargin="10" ColumnWidth="0" ColumnPositions.Text="" HGuides.Text="" VGuides.Text="">
    <TfrxReportTitle Name="ReportTitle1" Height="102.04731" Left="0" Top="18.89765" Width="1046.92981">
      <TfrxMemoView Name="Memo2" Left="0" Top="0" Width="1046.92981" Height="98.26778" Font.Charset="1" Font.Color="0" Font.Height="-16" Font.Name="Arial" Font.Style="1" HAlign="haCenter" ParentFont="False" VAlign="vaCenter" Text="WORKFLOW - AGED WORKFLOWS&#13;&#10;(Active Workflows Only)&#13;&#10;For [Master.&#34;WORKFLOW&#34;] - [Master.&#34;DISPLAY_NAME&#34;]&#13;&#10;As at [Master.&#34;REPORT_DATE&#34;]&#13;&#10;For database [Master.&#34;SID_NAME&#34;]"/>
      <TfrxLineView Name="Line2" Left="0" Top="98.26778" Width="1046.92981" Height="0" Frame.Typ="4" Frame.Width="2"/>
      <TfrxMemoView Name="Memo3" Left="0" Top="0" Width="117.16543" Height="18.89765" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="1" ParentFont="False" Text="FWF002-11"/>
      <TfrxMemoView Name="Memo4" Left="941.10297" Top="3.77953" Width="75.5906" Height="26.45671" GroupIndex="2" Font.Charset="0" Font.Color="16711680" Font.Height="-16" Font.Name="Arial" Font.Style="1" ParentFont="False" Text="PIPER -"/>
      <TfrxMemoView Name="Memo5" Left="1005.35498" Top="3.77953" Width="37.7953" Height="26.45671" GroupIndex="2" Font.Charset="0" Font.Color="255" Font.Height="-16" Font.Name="Arial" Font.Style="1" ParentFont="False" Text="Rx"/>
    </TfrxReportTitle>
    <TfrxMasterData Name="MasterData1" Height="22.67718" Left="0" Top="230.55133" Width="1046.92981" ColumnWidth="0" ColumnGap="0" DataSet="ReportsForm." DataSetName="Master" RowCount="0">
      <TfrxMemoView Name="Memo16" Left="498.89796" Top="0" Width="79.37013" Height="18.89765" DataField="Current" DataSet="ReportsForm." DataSetName="Master" DisplayFormat.DecimalSeparator="." DisplayFormat.FormatStr="%2.0n" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" HAlign="haRight" ParentFont="False" Text="[Master.&#34;Current&#34;]"/>
      <TfrxMemoView Name="Memo17" Left="593.38621" Top="0" Width="83.14966" Height="18.89765" DataField="30 Day" DataSet="ReportsForm." DataSetName="Master" DisplayFormat.DecimalSeparator="." DisplayFormat.FormatStr="%2.0n" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" HAlign="haRight" ParentFont="False" Text="[Master.&#34;30 Day&#34;]"/>
      <TfrxMemoView Name="Memo18" Left="691.65399" Top="0" Width="79.37013" Height="18.89765" DataField="60 Day" DataSet="ReportsForm." DataSetName="Master" DisplayFormat.DecimalSeparator="." DisplayFormat.FormatStr="%2.0n" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" HAlign="haRight" ParentFont="False" Text="[Master.&#34;60 Day&#34;]"/>
      <TfrxMemoView Name="Memo19" Left="786.14224" Top="0" Width="79.37013" Height="18.89765" DataField="90 Day" DataSet="ReportsForm." DataSetName="Master" DisplayFormat.DecimalSeparator="." DisplayFormat.FormatStr="%2.0n" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" HAlign="haRight" ParentFont="False" Text="[Master.&#34;90 Day&#34;]"/>
      <TfrxMemoView Name="Memo20" Left="876.85096" Top="0" Width="79.37013" Height="18.89765" DataField="120 + Days" DataSet="ReportsForm." DataSetName="Master" DisplayFormat.DecimalSeparator="." DisplayFormat.FormatStr="%2.0n" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" HAlign="haRight" ParentFont="False" Text="[Master.&#34;120 + Days&#34;]"/>
      <TfrxMemoView Name="Memo12" Left="340.1577" Top="0" Width="143.62214" Height="18.89765" DataField="BEGIN_DATE" DataSet="ReportsForm." DataSetName="Master" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" ParentFont="False" Text="[Master.&#34;BEGIN_DATE&#34;]"/>
      <TfrxMemoView Name="Memo6" Left="0" Top="0" Width="332.59864" Height="18.89765" DataField="ITEM_KEY" DataSet="ReportsForm." DataSetName="Master" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" ParentFont="False" Text="[Master.&#34;ITEM_KEY&#34;]"/>
      <TfrxMemoView Name="Memo7" Left="967.55968" Top="0" Width="79.37013" Height="18.89765" DataField="AGE_MONTHS" DataSet="ReportsForm." DataSetName="Master" DisplayFormat.DecimalSeparator="." DisplayFormat.FormatStr="%2.0n" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" HAlign="haRight" ParentFont="False" Text="[Master.&#34;AGE_MONTHS&#34;]"/>
    </TfrxMasterData>
    <TfrxPageFooter Name="PageFooter1" Height="45.35436" Left="0" Top="351.49629" Width="1046.92981">
      <TfrxMemoView Name="Memo1" Left="854.17378" Top="22.67718" Width="188.9765" Height="18.89765" HAlign="haRight" Text="Page [Page#] of [TotalPages#]"/>
      <TfrxLineView Name="Line1" Left="0" Top="0" Width="1046.92981" Height="0" Frame.Typ="4" Frame.Width="2"/>
      <TfrxMemoView Name="Memo8" Left="0" Top="22.67718" Width="147.40167" Height="18.89765" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" ParentFont="False" Text="[Date] [Time]"/>
      <TfrxMemoView Name="Memo9" Left="411.96877" Top="26.45671" Width="351.49629" Height="18.89765" GroupIndex="5" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="1" HAlign="haCenter" ParentFont="False" Text="Home of The Oracle E-Busness Suite Resource Center"/>
      <TfrxMemoView Name="Memo10" Left="287.24428" Top="26.45671" Width="124.72449" Height="18.89765" GroupIndex="5" Font.Charset="1" Font.Color="16711680" Font.Height="-13" Font.Name="Arial" Font.Style="1" HAlign="haCenter" ParentFont="False" Text="www.piper-rx.com"/>
      <TfrxMemoView Name="Memo13" Left="427.08689" Top="3.77953000000002" Width="185.19697" Height="18.89765" GroupIndex="5" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="1" HAlign="haCenter" ParentFont="False" Text="Copyright © 2009 G.Piper"/>
    </TfrxPageFooter>
    <TfrxPageHeader Name="PageHeader1" Height="26.45671" Left="0" Top="143.62214" Width="1046.92981">
      <TfrxLineView Name="Line3" Left="0" Top="22.67718" Width="1046.92981" Height="0" Frame.Typ="4" Frame.Width="2"/>
      <TfrxMemoView Name="Memo14" Left="0" Top="0" Width="83.14966" Height="18.89765" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="1" ParentFont="False" Text="Item Key"/>
      <TfrxMemoView Name="Memo21" Left="517.79561" Top="0" Width="64.25201" Height="18.89765" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="1" HAlign="haRight" ParentFont="False" Text="Current"/>
      <TfrxMemoView Name="Memo22" Left="612.28386" Top="0" Width="64.25201" Height="18.89765" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="1" HAlign="haRight" ParentFont="False" Text="30 Day"/>
      <TfrxMemoView Name="Memo25" Left="340.1577" Top="0" Width="94.48825" Height="18.89765" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="1" ParentFont="False" Text="Start Date"/>
      <TfrxMemoView Name="Memo24" Left="702.99258" Top="0" Width="64.25201" Height="18.89765" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="1" HAlign="haRight" ParentFont="False" Text="60 Day"/>
      <TfrxMemoView Name="Memo23" Left="801.26036" Top="0" Width="64.25201" Height="18.89765" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="1" HAlign="haRight" ParentFont="False" Text="90 Day"/>
      <TfrxMemoView Name="Memo26" Left="891.96908" Top="0" Width="64.25201" Height="18.89765" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="1" HAlign="haRight" ParentFont="False" Text="120 +"/>
      <TfrxMemoView Name="Memo11" Left="963.78015" Top="0" Width="83.14966" Height="18.89765" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="1" HAlign="haRight" ParentFont="False" Text="Age Months"/>
    </TfrxPageHeader>
    <TfrxReportSummary Name="ReportSummary1" Height="15.11812" Left="0" Top="313.70099" Width="1046.92981">
      <TfrxLineView Name="Line4" Left="0" Top="7.55905999999999" Width="1046.92981" Height="0" Frame.Style="fsDouble" Frame.Typ="4" Frame.Width="2"/>
    </TfrxReportSummary>
  </TfrxReportPage>
</TfrxReport>