Sunday, October 4, 2009

Finding Oracle Apps Version

SELECT
a.application_short_name,
t.application_name,
p.product_version version
FROM
fnd_application a,
fnd_application_tl t,
fnd_product_installations p
WHERE
a.application_id = p.application_id AND
a.application_id = t.application_id AND
t.language = USERENV('LANG')

No comments:

Post a Comment

Blog Archive