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 =''

0 comments:

Post a Comment