DEV Community 👩‍💻👨‍💻

Hilton Meyer
Hilton Meyer

Posted on • Originally published at hiltonmeyer.com on

EBS Installed Applications

Scripts for find EBS Installed Applications

SELECT
fa.application_short_name,
fa.application_name,
fpi.patch_level,
DECODE(fpi.status, 'I', 'Installed', 'S', 'Shared', 'N', 'Inactive', fpi.status) status,
fpi.db_status
FROM
fnd_product_installations fpi,
fnd_application_vl fa
WHERE
1 = 1
AND fa.application_id = fpi.application_id
ORDER BY
fa.application_short_name;

Top comments (0)

🌚 Friends don't let friends browse without dark mode.

Sorry, it's true.