SQL query to find file version in EBS

SQL> select * from ad_file_versions where file_id in
(select file_id from ad_files where upper(filename)=upper('appvndrb.pls')
) order by file_version_id desc;