Query: To find Patch Level for a product searching with application Name

Query to find Patch Level for a product searching with application Name(Product)/application (Product) short name

select fav.application_name,
fav.application_id,
fav.application_short_name,
fpi.status,fpi.patch_level 

from fnd_application_vl fav, 
fnd_product_installations fpi
where fpi.application_id=fav.application_id 
and fav.application_short_name =''