Script for finding oracle Forms and Self-Service page file versions

Finding file version from Oracle Forms and Self-Service page

select distinct app_short_name

,b.bug_number

,version,f.filename 

,to_char(prb.creation_date

,'dd-mon-yyyy

,hh24:mi:ss') Patch_date

from

apps.ad_file_versions v

,apps.ad_files f

,apps.ad_patch_run_bug_actions prba

,apps.ad_patch_run_bugs prb

,apps.ad_bugs b

where v.file_id=f.file_id

and f.file_id=prba.file_id

and prba.patch_run_bug_id = prb.patch_run_bug_id

and prb.bug_id=b.bug_id

and prba.patch_file_version_id=v.file_version_id

and lower(f.filename) like lower('<file name>')

order by filename;

Please provide your valuable feedback ............