Patch detail Query

SELECT A.APPLIED_PATCH_ID,

  A.PATCH_NAME,

  A.PATCH_TYPE,

  B.PATCH_DRiVER_ID,

  B.DRIVER_FILE_NAME,

  B.ORIG_PATCH_NAME,

  B.CREATION_DATE,

  B.PLATFORM,

  B.SOURCE_CODE,

--  B.CREATION_DATE,

  B.FILE_SIZE,

  B.MERGED_DRIVER_FLAG,

  B.MERGE_DATE

FROM AD_APPLIED_PATCHES A,

  AD_PATCH_DRIVERS B

WHERE A.APPLIED_PATCH_ID = B.APPLIED_PATCH_ID;