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. |