How to know which modules affected by a patch???


How to know which modules affected by a patch???

Query this sql…..

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 = ‘&PatchName’;


Nagulu Polagani

"We are all apprentices in a craft where no one ever becomes a master."