File Version Help!

Need help determining a file verison in Oracle Apps. Here is a handy query that will assist you in detemining the current version a file.


SELECT afl.filename, max(afv.version),APP_SHORT_NAME, SUBDIR
FROM applsys.ad_file_versions afv, applsys.ad_files afl
WHERE afv.file_id = afl.file_ID
AND afl.filename in
('APXINWKB.fmb','APXHRUPD.rdf','CUSTOM.pll') -- insert your file names here
GROUP BY afl.filename, APP_SHORT_NAME,SUBDIR

Unix users:

If the file is not in the above tables, use the following commands to determine the version number of a file.

Change to the directory where file is:
cd $AP_TOP/reports/US

Run following command with file name:
strings -a APXHRUPD.rdf | grep '$Header'