[Home] [Help] [Dependency Information]
Object Name: | FND_VAL_ATTRIBUTE_TYPES_TL |
---|---|
Object Type: | TABLE |
Owner: | APPLSYS |
FND Design Data: | FND.FND_VAL_ATTRIBUTE_TYPES_TL |
Subobject Name: | |
Status: | VALID |
FND_VAL_ATTRIBUTE_TYPES_TL stores translated information about
segment qualifiers for key flexfields. Each row includes the name
(VALUE_ATTRIBUTE_TYPE) and description of the segment qualifier,
as well as the name of the flexfield qualifier with which it is
associated (SEGMENT_ATTRIBUTE_TYPE). Each row also includes the
key flexfield code, the application identifier of the application
the key flexfield is defined with, and a prompt that a user sees
when defining key flexfield values. The Oracle internal language
code indicates what language the information in the row is in. You
need one row for each defined segment qualifier for each key
flexfield in each of the installed languages.
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
FND_VAL_ATTRIBUTE_TYPES_TL_U1 | NORMAL | UNIQUE | APPS_TS_SEED |
APPLICATION_ID
ID_FLEX_CODE SEGMENT_ATTRIBUTE_TYPE VALUE_ATTRIBUTE_TYPE LANGUAGE ZD_EDITION_NAME |
FND_VAL_ATTRIBUTE_TYPES_TL_N1 | NORMAL | NONUNIQUE | APPS_TS_SEED |
PROMPT
LANGUAGE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
APPLICATION_ID | NUMBER | (10) | Yes | Application identifier |
ID_FLEX_CODE | VARCHAR2 | (4) | Yes | Key flexfield code |
SEGMENT_ATTRIBUTE_TYPE | VARCHAR2 | (30) | Yes | Name of flexfield qualifier |
VALUE_ATTRIBUTE_TYPE | VARCHAR2 | (30) | Yes | Name of segment qualifier |
PROMPT | VARCHAR2 | (50) | Yes | Qualifier prompt |
LANGUAGE | VARCHAR2 | (4) | Yes | Language |
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 | (10) | 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. |
ZD_EDITION_NAME | VARCHAR2 | (30) | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT APPLICATION_ID
, ID_FLEX_CODE
, SEGMENT_ATTRIBUTE_TYPE
, VALUE_ATTRIBUTE_TYPE
, PROMPT
, LANGUAGE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, DESCRIPTION
, SOURCE_LANG
, ZD_EDITION_NAME
FROM APPLSYS.FND_VAL_ATTRIBUTE_TYPES_TL;
APPLSYS.FND_VAL_ATTRIBUTE_TYPES_TL does not reference any database object
APPLSYS.FND_VAL_ATTRIBUTE_TYPES_TL is referenced by following:
|
|
|