Find a patch that modified a file in EBS R12.2

Retrieve the file details from the apps.ad_files table

SELECT file_id, filename, subdir
FROM apps.ad_files
WHERE filename LIKE '%afcpprog%'
FETCH FIRST 1 ROWS ONLY;

Get the patch_run_bug_id using the below query

SELECT file_id, patch_run_bug_id, patch_file_version_id, last_update_date
FROM ad_patch_run_bug_actions
WHERE file_id = '&file_id'
ORDER BY last_update_date;

Get the bug_number/patch_number using below query

SELECT patch_run_id, bug_id, orig_bug_number
FROM ad_patch_run_bugs
WHERE patch_run_bug_id = '&patch_run_bug_id';