How to get the file versions of any file in oracle applications

-- get the file_id for appropriate file and dir

SELECT * FROM ad_files WHERE filename = '' 

Note : For Java files, instead of .java, use .class

Now , get the file version.

SELECT *
FROM ad_file_versions
WHERE file_id =
ORDER BY file_version_id DESC