Oracle Apps R12: Check if the patch applied or not

--Check if the patch applied or not

This table includes the defined bugs on the system:

SELECT    bug_number

       || '.'

       || aru_release_name

       || '.'

       || UPPER (trackable_entity_abbr)

       || '.'

       || baseline_name

          Patch

FROM     apps.ad_bugs
WHERE   bug_number LIKE '%' ||3594604 || '%';

This table includes patches applied on the system:

SELECT patch_name

FROM   apps.ad_applied_patches
WHERE patch_name LIKE '%' ||3594604 || '%'