FND_APPLICATION

Applications registered with Oracle Application Object Library

Name Datatype Length Mandatory Comments
APPLICATION_ID NUMBER
Yes Application identifier
APPLICATION_SHORT_NAME VARCHAR2 (50) Yes Application short name
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
CREATED_BY NUMBER (15) Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
BASEPATH VARCHAR2 (20)
The variable that stores the directory path of the TOP directory for the application

Usage:


  cursor cur_apps is
  select application_id
  from fnd_application
  order by decode(application_short_name, 'SQLAP', 'AP'
                                        , 'SQLGL', 'GL'
                                        , application_short_name);

    cursor cur_app(n_appid in number)
    is
    select decode(app.application_short_name, 'SQLAP', 'AP'
                                            , 'SQLGL', 'GL'
                                            , app.application_short_name)
                                           || ' - '|| tl.application_name product_name
    from APPLSYS.FND_APPLICATION_TL tl
    ,    APPLSYS.FND_APPLICATION    app
    where app.application_id = tl.application_id
    and app.application_id = n_appid
    and tl.language =  userenv('LANG');

FND_APPLICATION_TL

FND_APPLICATION_TL stores translated information about all the applications registered with Oracle Application Object Library. Each row includes the language the row is translated to, the name and description of the application, and the application identifier which uniquely identifies the application. You need one row for each application in each of the installed languages.

Name Datatype Length Mandatory Comments
APPLICATION_ID NUMBER
Yes Application identifier
LANGUAGE VARCHAR2 (4) Yes Language
APPLICATION_NAME VARCHAR2 (240) Yes Name of application
CREATED_BY NUMBER (15) Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who column
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
DESCRIPTION VARCHAR2 (240)
Description
SOURCE_LANG VARCHAR2 (4) Yes The Language the text will mirror. If text is not yet translated into LANGUAGE then any changes to the text in the source language row will be reflected here as well.