Oracle Applications: Finding Files And/Or Object Versions

Oracle Applications: Finding Files And/Or Object Versions

SELECT FILE_ID FROM FND_FILES WHERE FILENAME LIKE 'FILE_NAME.extenstion' ;

SELECT * FROM AD_FILE_VERSIONS WHERE FILE_ID = ________

ORDER BY CREATION_DATE DESC;

Finding the files in the file system

Lets say you are looking for a form executable
#cd $APPL_TOP
#find ./ -name 'GLXSTEAL.fmx'

The output will be
          ./gl/12.0.0/forms/US/GLXSTEAL.fmx


Plsql Package/Package Body version

select * from all_source where type='PACKAGE BODY' and name in ('<Package Name>')
and text like '%$Header%';

select * from all_source where type='PACKAGE' and name in ('<Package Name>')
and text like '%$Header%';

OR
Unix version

# cd $GL_TOP/patch/115/sql
# grep -ir 'CREATE OR REPLACE PACKAGE <Package_Name>' *

Forms

#cd $GL_TOP/forms/US
#adident Header <form_name>.fmx

Reports
#cd $GL_TOP/reports/US
#adident Header <report_name>.rdf

Pro*C
#cd $GL_TOP/bin
#adident Header <EXE_NAME>

Oracle Application Framework

Pages/Regions
#cd $GL_TOP/mds/webadi/webui
#adident Header <Page/Region>.xml
 OR (#grep -ir Header <Page/Region>.xml

Controller/Model Objects
#cd $JAVA_TOP/oracle/apps/gl/budgetwizard/query
#adident Header <File_name>.class