SELECT SUBSTR (a.application_short_name, 1, 5) code,
SUBSTR (t.application_name, 1, 50) 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