APPS.FND_OAM_COLLECTION dependencies on AD_PATCH_DRIVERS

Line 1544: from ad_patch_drivers d, ad_patch_runs r

1540: -- Get the number of patches applied within last 24 hours
1541:
1542: -- Modified query for bug 3835667
1543: select count(*) into ct_patches
1544: from ad_patch_drivers d, ad_patch_runs r
1545: where r.end_date >= sysdate - 1
1546: and d.patch_driver_id = r.patch_driver_id;
1547:
1548: --select count(distinct(PATCH_NAME))

Line 1551: -- (select APPLIED_PATCH_ID from ad_patch_drivers where PATCH_DRIVER_ID in

1547:
1548: --select count(distinct(PATCH_NAME))
1549: -- into ct_patches
1550: -- from ad_applied_patches where APPLIED_PATCH_ID in
1551: -- (select APPLIED_PATCH_ID from ad_patch_drivers where PATCH_DRIVER_ID in
1552: -- (select PATCH_DRIVER_ID from ad_patch_runs where sysdate-START_DATE <=1));
1553:
1554: -- Update the number of patches applied within last 24 hours
1555: update_metric_internal('PATCHES', to_char(ct_patches), -1);