Tuesday, July 2, 2013

How to find which are application patches installed from back end

SELECT fav.application_name,
DECODE (fpi.status, 'I', 'Installed', 'S', 'Shared', 'N/A') status,
patch_level
FROM apps.fnd_application_vl fav, apps.fnd_product_installations fpi
WHERE fav.application_id = fpi.application_id;

No comments:

Post a Comment