SQL query to find out Oracle patch has applied or not on Oracle applications enviornment

By running below query you can check that patch has been applied or not.


SELECT
BUG_NUMBER, --THIS IS PATCH NUMBER
ARU_RELEASE_NAME,
CREATION_DATE,
LAST_UPDATE_DATE
FROM APPS.AD_BUGS;


Also you can find more information by running Diagnostics: Apps Check program from application.