To find patches applied in R12

Run the following query

SELECT AAP.patch_name, AAP.patch_type, AAP.maint_pack_level, TO_CHAR(AAP.creation_date,'DD-MON-YYYY HH:MI:SS') Applied_date, APD.driver_file_name, APD.platformFROM ad_applied_patches AAP, ad_patch_drivers APDWHERE AAP.applied_patch_id = APD.applied_patch_idORDER BY AAP.creation_date ;