Finding Patch Level of a Product in Oracle Application

If we need to find the latest patch level for a particular product then we can use the below query.

Syntax:

select patch_level
from fnd_product_installations where patch_level like upper('%&product_name%')

Output:

PATCH_LEVEL                  
------------------------------
11i.AD.I.7                    

 

Thanks 

Srini