Select T.Language, T2.Patch_Name, T2.Last_Update_Date

  From Applsys.Ad_Patch_Driver_Langs t,

       Ad_Patch_Drivers              T1,

       Ad_Applied_Patches            T2

 Where T.Patch_Driver_Id = T1.Patch_Driver_Id

   And T1.Applied_Patch_Id = T2.Applied_Patch_Id

--   And T2.patch_Name = 'FA%'

Order By 2 Desc

 

select patch_name

  from apps.ad_applied_patches t

 where t.patch_name in ('3262159', '3384350')

union all

select bug_number patch_name

  from apps.ad_bugs a

 where a.bug_number in ('3262159', '3384350')