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'
Showing posts with label Query to find Patch Level for a product searching with application Name. Show all posts
Showing posts with label Query to find Patch Level for a product searching with application Name. Show all posts
Tuesday, October 6, 2009
Subscribe to:
Posts (Atom)