Category: PIPER-Rx Reports (Free) Name: FOT003-10 Invalid Objects (OEBS objects only) ReportDefFileName: .\FOT003-10 Invalid Objects (OEBS objects only).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 -- ** -- ** Simple invalid object report (OEBS object only) -- ** -- ** ------------------------------------------------- -- ** Version 1.0 Jul-09 G.Piper Initial Creation -- **************************************************** SELECT database_name.db_sid, owner, substr(object_name, 1, 40) object_name, object_type, to_char(to_date(timestamp,'YYYY-MM-DD:HH24:MI:SS'), 'DD-Mon-YY HH24:MI') invalid_date, decode(trunc(months_between (sysdate, to_date(timestamp,'YYYY-MM-DD:HH24:MI:SS'))), 0, 'Warning', 1, 'Warning', null) warning_status FROM dba_objects, ( SELECT vd.name db_sid FROM gv$database vd WHERE vd.inst_id = 1 ) database_name WHERE status = 'INVALID' and exists (SELECT 'X' FROM applsys.fnd_oracle_userid fou WHERE fou.oracle_username = owner) ORDER by timestamp desc ===End SQL=== ===Begin Report Definition===