Query To Check Oracle EBS Version, OATM Status and other Basic Details

Download(ebsbasic.sql)

REM +======================================================================+
REM                    
REM File Name: ebsbasic.sql
REM 
REM Description:
REM   Query To Check Oracle EBS Version, OATM Status and other Basic Details
REM   
REM Notes:
REM   Usage: sqlplus <apps_user/apps_passwd> @ebsbasic.sql 
REM   
REM +======================================================================+

clear columns
set lines 180
 set pages 50
 col RELEASE_NAME for a12
 col MULTI_ORG_FLAG for a15
 col APPLICATIONS_SYSTEM_NAME for a25
 col "IS_NEW_TS_MODE(OATM_ENABLED)" for a30
 select APPLICATIONS_SYSTEM_NAME,RELEASE_NAME,version "DB_VERSION",MULTI_ORG_FLAG,IS_NEW_TS_MODE "IS_NEW_TS_MODE(OATM_ENABLED)" 
 from apps.fnd_product_groups,v$instance;