Two tables to check if the patch is applied or not:
This table includes the defined bugs on the system:
SELECT bug_number
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 || ‘%’
This table includes the defined bugs on the system:
SELECT bug_number
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 || ‘%’