Query to find out modules which will be affected by a specific patch.

Query to find out modules which will be affected by a specific patch.

select distinct aprb.application_short_name as "Affected Modules"

from ad_applied_patches aap,

ad_patch_drivers apd,

ad_patch_runs apr,

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 in ('1234','5678')




Query to find out patches nodewise.

select aap.patch_name, aat.name, apr.end_date,apr.SUCCESS_FLAG

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 '%12345%'