Category: PIPER-Rx Reports (Free) Name: FWF004-11 Workflow Details ReportDefFileName: .\FWF004-11 Workflow Details.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 Details -- ** -- ** 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') report_date, report_headings.sid_name sid_name, upper(:WORKFLOW) workflow, substr(witt.display_name,1,30) wf_display_name, :WORKFLOW_KEY item_key, wiav.name attribute_name, wiat.display_name, substr( nvl(wiav.text_value, nvl(to_char(wiav.number_value),to_char(wiav.date_value))),1, 100) attribute_value FROM applsys.wf_item_attribute_values wiav, applsys.wf_item_attributes wia, applsys.wf_item_attributes_tl wiat, applsys.wf_item_types_tl witt, (SELECT vd.name sid_name FROM gv$database vd WHERE vd.inst_id = 1 ) report_headings WHERE wiav.item_type = wia.item_type and wiav.name = wia.name and wiav.item_type = wiat.item_type and wiav.name = wiat.name and wiat.language = userenv('LANG') and wiav.item_type = witt.name and witt.language = userenv('LANG') and wiav.item_type = upper(:WORKFLOW) and wiav.item_key = :WORKFLOW_KEY and wiav.text_value||wiav.number_value||wiav.date_value is not null ORDER by wia.sequence ===End SQL=== ParamName: WORKFLOW ParamType: String ParamValue: apexp ParamExp: ParamName: WORKFLOW_KEY ParamType: String ParamValue: 11647 ParamExp: ===Begin Report Definition===