[Home] [Help] [Dependency Information]
Object Name: | FND_LOOKUP_TYPES_TL |
---|---|
Object Type: | TABLE |
Owner: | APPLSYS |
FND Design Data: | FND.FND_LOOKUP_TYPES_TL |
Subobject Name: | |
Status: | VALID |
FND_LOOKUP_TYPES_TL stores translated information about the lookup types in FND_LOOKUP_TYPES.
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
FND_LOOKUP_TYPES_TL_U1 | NORMAL | UNIQUE | APPS_TS_SEED |
LOOKUP_TYPE
VIEW_APPLICATION_ID SECURITY_GROUP_ID LANGUAGE ZD_EDITION_NAME |
FND_LOOKUP_TYPES_TL_U2 | NORMAL | UNIQUE | APPS_TS_SEED |
MEANING
VIEW_APPLICATION_ID SECURITY_GROUP_ID LANGUAGE ZD_EDITION_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LOOKUP_TYPE | VARCHAR2 | (30) | Yes | QuickCode lookup type (FK to fnd_lookup_types.lookup_type) |
SECURITY_GROUP_ID | NUMBER | (15) | Yes | Security group identifier |
VIEW_APPLICATION_ID | NUMBER | (15) | Yes | Application identifier of view ( |
LANGUAGE | VARCHAR2 | (4) | Yes | Language |
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. |
MEANING | VARCHAR2 | (80) | Yes | Lookup type user meaning |
DESCRIPTION | VARCHAR2 | (240) | Description of the lookup type | |
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 | |
ZD_EDITION_NAME | VARCHAR2 | (30) | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT LOOKUP_TYPE
, SECURITY_GROUP_ID
, VIEW_APPLICATION_ID
, LANGUAGE
, SOURCE_LANG
, MEANING
, DESCRIPTION
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, ZD_EDITION_NAME
FROM APPLSYS.FND_LOOKUP_TYPES_TL;
APPLSYS.FND_LOOKUP_TYPES_TL does not reference any database object
APPLSYS.FND_LOOKUP_TYPES_TL is referenced by following:
|
|
|