Showing posts with label Script to print the Oracle Apps Version Number. Show all posts
Showing posts with label Script to print the Oracle Apps Version Number. Show all posts

Thursday, 7 April 2011

Script to print the Oracle Apps Version Number


Script to print the Oracle Apps Version Number

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')