Please provide a query to find out product / module name for a particular bug_number

Problem Summary---------------------------------------------------
Please provide a query to find out product / module name for a particular bug_number

Problem Description
---------------------------------------------------
Please provide a query to find out product / module name for a particular bug_number, the application_short_name in ad_bugs table is mostly null.


I have checked all following tables, but they do not have application_id or product_id to link to fnd_product_installations ,
or  apps.fnd_application_tl.

ad_applied_patches app, AD_PATCH_DRIVERS apd, AD_COMPRISING_PATCHES acp, ad_bugs ab

Please help to provide a query that will list product names (short, or long) for a given ad_bugs.bug_number.