12.2.5 required AD/TXK Delta 7, so you should only be missing AD/TXK Delta 11.
You need to determine the actual patch numbers for them, then query ad_bugs to determine if they are applied.
Applying the Latest AD and TXK Release Update Packs to Oracle E-Business Suite Release 12.2 (Doc ID 1617461.1)
select * from ad_bugs where bug_number = '26834480' --AD.C.Delta.11
select * from ad_bugs where bug_number = '28840822'; --TXK.C.Delta.11
You can also type those numbers in Oracle Applications Manager in Dashboard->Site Map->Maintenance->Applied Patches:
But I think there is a new query, ( I read something like) not all patches written in ad_bugs where successfully applied?
Some maybe aborted or rolled back or cancelled?
Please share the updated query
Aborted patches will not appear in ad_bugs. You can also use the following query to see what has been applied to 12.2 instances:
select distinct ap.patch_name, to_date(to_char(ap.creation_date,'DD-MON-YYYY')) date_applied,
ad_pa_validate_criteriaset.get_concat_mergepatches(ad.patch_driver_id ))) patch_description
from ad_applied_patches ap,
(select patch_abstract, replace(replace(driver_file_name,'.drv',''),'u','') patch_name,
patch_driver_id, applied_patch_id from ad_patch_drivers) ad
where ap.creation_date > sysdate -2000
and ap.applied_patch_id = ad.applied_patch_id order by 2 desc, 1 desc;
Adding a few more using which you can check for 12.2 instance -
set lines 1000
col APPLIED_FILE_SYSTEM_BASE for a40
SELECT b.bug_number, asp.adop_session_id, asp.bug_number patch#,
FROM ad_bugs b, ad_patch_run_bugs prb, ad_patch_runs pr,
ad_patch_drivers pd, ad_adop_session_patches asp
WHERE b.bug_id = prb.bug_id
AND prb.patch_run_id = pr.patch_run_id
AND pr.patch_driver_id = pd.patch_driver_id
AND pr.patch_run_id = asp.patchrun_id
AND prb.applied_flag = 'Y'
AND b.bug_number = '&bug_num';
SELECT adb.bug_number,ad_patch.is_patch_applied('122', 1045, adb.bug_number)
FROM ad_bugs adb
WHERE adb.bug_number in (29781255);
select ad_patch.is_patch_applied('R12',-1,29781255) from dual;