Query to find Installed Applications in Oracle
SELECT fatl.application_name,
SUBSTR (fa.application_short_name, 1, 8) product,
SUBSTR (fpi.product_version, 1, 14) VERSION,
SUBSTR (fpi.patch_level, 1, 11) patch_level, fpi.status,
flv.meaning status_meaning
FROM fnd_application fa,
fnd_product_installations fpi,
fnd_application_tl fatl,
fnd_lookup_values flv
WHERE fa.application_id = fpi.application_id
AND fatl.application_id = fa.application_id
AND UPPER (flv.lookup_type) = 'APP_INSTALL_STATUS'
AND fpi.status = flv.lookup_code
AND flv.LANGUAGE = 'US'
AND flv.lookup_type = 'APP_INSTALL_STATUS'
AND fatl.LANGUAGE = 'US'
ORDER BY fa.application_short_name
SUBSTR (fa.application_short_name, 1, 8) product,
SUBSTR (fpi.product_version, 1, 14) VERSION,
SUBSTR (fpi.patch_level, 1, 11) patch_level, fpi.status,
flv.meaning status_meaning
FROM fnd_application fa,
fnd_product_installations fpi,
fnd_application_tl fatl,
fnd_lookup_values flv
WHERE fa.application_id = fpi.application_id
AND fatl.application_id = fa.application_id
AND UPPER (flv.lookup_type) = 'APP_INSTALL_STATUS'
AND fpi.status = flv.lookup_code
AND flv.LANGUAGE = 'US'
AND flv.lookup_type = 'APP_INSTALL_STATUS'
AND fatl.LANGUAGE = 'US'
ORDER BY fa.application_short_name
No comments:
Post a Comment