Query to find the patch status what we will apply to fix some bugs in the applications.

----Give the patch_name here to find whether patch has been applied in the instance or not.
select
faav.application_short_name,
faav.application_name,
aap.patch_name,
aap.patch_type,
aap.source_code,
aap.creation_date,
aap.created_by,
aap.last_update_date,
aap.last_updated_by
from
AD_APPLIED_PATCHES aap,
apps.fnd_application_all_view faav
where
aap.applied_patch_id=faav.application_id and
aap.patch_name='5117525';----give the patch name or number here as per your request.