Applied Patches Query

PROMPT Shows ALL application patch levels ...
break on application_us
col patch_level for A20;
col application_us for A55;
col application_hr for A55;
select distinct patch_level,
(select application_name from apps.fnd_application_tl tl where tl.application_id=fpi.application_id and language='US') application_us,
(select application_name from apps.fnd_application_tl tl where tl.application_id=fpi.application_id and language='HR') application_hr
from apps.fnd_product_installations fpi
order by 2,1
;
or:
accept PatchName char prompt 'Input Patch number to check (% for all) : ';
col patch_name for A20;
col application_short_name for A20;
select distinct aprb.application_short_name as "Affected Modules", aap.patch_name
from apps.ad_applied_patches aap,
apps.ad_patch_drivers apd,
apps.ad_patch_runs apr,
apps.ad_patch_run_bugs aprb
where
aap.applied_patch_id = apd.applied_patch_id
and apd.patch_driver_id = apr.patch_driver_id
and apr.patch_run_id = aprb.patch_run_id
and aprb.applied_flag = 'Y'
and aap.patch_name like '&PatchName%'
;
or:
accept PatchName char prompt 'Input Patch number to check (Enter for all): ';
col patch_name for A20;
col node_name for A20;
col end_date_ for A20;
break on patch_name on node_name;
select aap.patch_name, aat.name node_name, to_char(apr.end_date,'DD.MM.YYYY HH24:MI:SS') end_date
from ad_applied_patches aap,
ad_patch_drivers apd,
ad_patch_runs apr,
ad_appl_tops aat
where aap.applied_patch_id = apd.applied_patch_id
and apd.patch_driver_id = apr.patch_driver_id
and aat.appl_top_id = apr.appl_top_id
and aap.patch_name like '&PatchName%'
;
To Find out the India Localization Patch details

Use
select * from jai_applied_patches.