首页 > 代码库 > Oracle EBS-SQL (SYS-11):查询系统已打的PATCH.sql

Oracle EBS-SQL (SYS-11):查询系统已打的PATCH.sql

2024-07-07 15:39:08   225人阅读

select a.patch_name,
         b.DRIVER_FILE_NAME,
         c.language,
         b.creation_date
from apps.ad_applied_patches    a,
        apps.ad_patch_drivers      b,
        apps.ad_patch_driver_langs c
 where a.applied_patch_id = b.applied_patch_id 
    and b.patch_driver_id = c.patch_driver_id
 order by a.patch_name,
          b.driver_file_name 


联系
我们