Query a Language Patch

SQL> col PATCH_NAME format a15
SQL> col PATCH_TYPE format a10
SQL> col DRIVER_FILE_NAME format a20
SQL> col PLATFORM format a10
SQL> select AP.PATCH_NAME, AP.PATCH_TYPE, AD.DRIVER_FILE_NAME, AD.CREATION_DATE,  AD.PLATFORM,AL.LANGUAGE
  2  from AD_APPLIED_PATCHES AP, AD_PATCH_DRIVERS AD, AD_PATCH_DRIVER_LANGS AL
where AP.APPLIED_PATCH_ID = AD.APPLIED_PATCH_ID
  3    4  and AD.PATCH_DRIVER_ID = AL.PATCH_DRIVER_ID
  5  and AP.PATCH_NAME = '17666002';

PATCH_NAME      PATCH_TYPE DRIVER_FILE_NAME     CREATION_DATE   PLATFORM   LANG
--------------- ---------- -------------------- --------------- ---------- ----
17666002        ONE-OFF    u17666002.drv        11-MAR-11       LINUX      US
17666002        ONE-OFF    u17666002.drv        11-MAR-11       GENERIC    FRC
17666002        ONE-OFF    u17666002.drv        11-MAR-11       GENERIC    F

SQL>