Tuesday, 10 May 2011

Print Oracle Apps versions



Print Oracle Apps versions



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: