Category: PIPER-Rx Reports (Free) Name: FADM001-10 Installed Modules ReportDefFileName: .\FADM001-10 Installed Modules.fr3 ===Begin Comments=== Copyright (C) 2010 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) 2010 G.Piper -- ** -- ** Installed Application modules -- ** -- ** ------------------------------------------------- -- ** Version 1.0 Aug-10 G.Piper Initial Creation -- **************************************************** SELECT report_headings.report_date, report_headings.sid_name, fa.application_id appn_id, decode(fa.application_short_name, 'SQLAP', 'AP', 'SQLGL', 'GL', fa.application_short_name ) appn_short_name, substr(fat.application_name,1,50)|| decode(sign(length(fat.application_name) - 50), 1, '...') Application, fa.basepath Base_path, fl.meaning install_status, nvl(fpi.product_version, 'Not Available') product_version, nvl(fpi.patch_level, 'Not Available') patch_level, to_char(fa.last_update_date, 'DD-Mon-YY (Dy) HH24:MI') last_update_date, nvl(fu.user_name, '* Install *') Updated_by FROM applsys.fnd_application fa, applsys.fnd_application_tl fat, applsys.fnd_user fu, applsys.fnd_product_installations fpi, apps.fnd_lookups fl, ( SELECT to_char(sysdate, 'DD-Mon-YY HH24:MI') report_date, vd.name sid_name FROM v$database vd ) report_headings WHERE fa.application_id = fat.application_id and fat.language(+) = userenv('LANG') and fa.application_id = fpi.application_id and fpi.last_updated_by = fu.user_id(+) and fpi.status = fl.lookup_code and fl.lookup_type = 'FND_PRODUCT_STATUS' UNION ALL SELECT report_headings.report_date, report_headings.sid_name, fa.application_id, fa.application_short_name, substr(fat.application_name,1,50)|| decode(sign(length(fat.application_name) - 50), 1, '...'), fa.basepath, 'Not Available', 'Not Available', 'Not Available', to_char(fa.last_update_date, 'DD-Mon-YY (Dy) HH24:MI'), nvl(fu.user_name, '* Install *') FROM applsys.fnd_application fa, applsys.fnd_application_tl fat, applsys.fnd_user fu, ( SELECT to_char(sysdate, 'DD-Mon-YY HH24:MI') report_date, vd.name sid_name FROM v$database vd ) report_headings WHERE fa.application_id = fat.application_id and fat.language(+) = userenv('LANG') and fa.last_updated_by = fu.user_id(+) and fa.application_id not in ( SELECT fpi.application_id FROM applsys.fnd_product_installations fpi ) ORDER by 5 ===End SQL=== ===Begin Report Definition===