EBS find list of patches query

Oracle EBS find list of patches using SQL query

 SELECT APPLICATION_SHORT_NAME,
         BUG_NUMBER,
         ARU_RELEASE_NAME,
         TRACKABLE_ENTITY_ABBR,
         BASELINE_NAME,
         GENERIC_PATCH,
         LANGUAGE
    FROM apps.ad_bugs
ORDER BY bug_number,
         application_short_name,
         baseline_name,
         generic_patch,
         trackable_entity_abbr;

SELECT RAPID_INSTALLED_FLAG,
         PATCH_NAME,
         PATCH_TYPE,
         MAINT_PACK_LEVEL,
         SOURCE_CODE,
         IMPORTED_FLAG,
         IMPORTED_FROM_DB,
         DATA_MODEL_DONE_FLAG
    FROM apps.ad_applied_patches
ORDER BY patch_name, patch_type, data_model_done_flag;