rem ********************************************************************
rem * Author            : Rick Kupcunas
rem * Original          : 2000-May-02
rem * Description       : Save the Orcle Finapp passwords in the event 
rem *                     they may be needed in the future
rem *
rem ********************************************************************

spool save_finapp_passwords_&&INSTANCE;
set pagesize 100;
set linesize 132;
set long 300;

select name "INSTANCE" from v$database;
select to_char(sysdate, 'YYYY-MON-DD HH:MI:SS am') from dual;

select * from applsys.FND_ORACLE_USERID where oracle_username like 'APP%';

select * from fnd_user where user_name like 'SYS%';

spool off;
undefine INSTANCE;




