SELECT fa.application_short_name
,fa.application_name
,fpi.patch_level
,fpi.product_version
,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 fa.application_id = fpi.application_id
AND fpi.application_id IN (
SELECT application_id
FROM fnd_application
WHERE application_short_name IN
('SQLAP', 'AR', 'SQLGL'));
REF:
1. How to check if certain Oracle Applications product/module is implemented? [ID 443699.1]
2. https://blogs.oracle.com/stevenChan/entry/products_and_families_and_vers