Query to find Patches and bugs for R12
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 '%' ||15880118|| '%';
This table includes patches applied on the system:
SELECT patch_name
FROM apps.ad_applied_patches
WHERE patch_name LIKE '%' ||15880118|| '%'
This table includes the defined bugs on the system:
SELECT bug_number
FROM apps.ad_bugs
WHERE bug_number LIKE '%' ||15880118|| '%';
This table includes patches applied on the system:
SELECT patch_name
FROM apps.ad_applied_patches
WHERE patch_name LIKE '%' ||15880118|| '%'
No comments:
Post a Comment