Thursday, November 20, 2008

Print Oracle Apps versions

SELECT substr(a.application_short_name, 1, 5) code,substr(t.application_name, 1, 50) application_name, p.product_version versionFROM fnd_application a, fnd_application_tl t, fnd_product_installations pWHERE a.application_id = p.application_idAND a.application_id = t.application_idAND t.language = USERENV('LANG')

No comments: