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 ='&x'
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment