Re: Oracle Apps: Setup Reports

From: LGAARD <lgaard_at_aol.com>
Date: 1995/04/25
Message-ID: <3ni9u1$4n9_at_newsbf02.news.aol.com>#1/1

Paulette,
  You can determine the release version by the version of AOL. Use something like the script below to query the FND_APPLICATION, and FND_PRODUCT_INSTALLATIONS tables. Use decode to "translate" from the AOL version number that comes up to the Release version that corresponds.

Laurel

---

def fndname = &&ORACLE_ID_owning_FND_tables

col appname format a22 heading 'Application Name' justify c

 col oracleid   format  a8 heading 'ORACLE|Userid'    justify c
 col version    format a10 heading 'Version'          justify c
 col prodstatus format  a6 heading 'Status'           justify c
 col datats     format a10 heading 'Data|Tablespace'  justify c
 col indxts     format a10 heading 'Index|Tablespace' justify c
 col sfactor    format 999 heading 'Sizing|Factor'    justify c
select
   substr(application_name,1,22)                            appname,
   oracle_username                                          oracleid,
   product_version                                          version,
   decode(y.status,'I','Inst''d','S','Shared','L','Local')  prodstatus,
   tablespace                                               datats,
   index_tablespace                                         indxts,
   sizing_factor                                            sfactor
 from


   &fndname..fnd_application            x,

   &fndname..fnd_product_installations  y,


   &fndname..fnd_oracle_userid          z

 where
   (x.application_id=y.application_id)
     and
   (z.oracle_id=y.oracle_id)
 order by
   application_name
 / Received on Tue Apr 25 1995 - 00:00:00 CEST