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