Query to get Appied patch details in Oracle Applications

SELECT AP.PATCH_NAME,
       AP.PATCH_TYPE,
       AD.DRIVER_FILE_NAME,
       AD.CREATION_DATE,
       AD.PLATFORM,
       AL.LANGUAGE
  FROM AD_APPLIED_PATCHES AP, AD_PATCH_DRIVERS AD, AD_PATCH_DRIVER_LANGS AL
 WHERE     AP.APPLIED_PATCH_ID = AD.APPLIED_PATCH_ID
       AND AD.PATCH_DRIVER_ID = AL.PATCH_DRIVER_ID
       AND AP.PATCH_NAME IN ('9868229', '12958998', '12541337');