finding installed patches in apps

Hi

     If you want to find the installed patch detail in oracle apps then you have to run following queries.

 select DRIVER_FILE_NAME
from AD_PATCH_DRIVERS
where DRIVER_FILE_NAME like '%3258830%';

select BUG_NUMBER,CREATION_DATE,LAST_UPDATE_DATE from ad_bugs where BUG_NUMBER='10052153';

select PATCH_NAME,PATCH_TYPE,CREATION_DATE,LAST_UPDATE_DATE from ad_applied_patches where PATCH_NAME='10052153';

If you know about localization patch detail.

select PATCH_NUMBER,STATUS,LOG_FILE,PATCH_DATE from jai_applied_patches where PATCH_NUMBER='Patch no';