[Home] [Help] [Dependency Information]
Object Name: | FND_DESCR_FLEX_COL_USAGE_TL |
---|---|
Object Type: | TABLE |
Owner: | APPLSYS |
FND Design Data: | FND.FND_DESCR_FLEX_COL_USAGE_TL |
Subobject Name: | |
Status: | VALID |
FND_DESCR_FLEX_COL_USAGE_TL stores the correspondences between
application table columns and descriptive flexfield segments. Each
row includes an application identifier, the name of the descriptive
flexfield, the corresponding table column name, the context field
value (also know as structure name), and display prompts for the
segments. Each row also includes the language the information is
in. You need one row for every segment for each context value
(structure), including the global data element segments, of all
the existing descriptive flexfields in each of the installed
languages.
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
FND_DESCR_FLEX_COL_USAGE_TL_U1 | NORMAL | UNIQUE | APPS_TS_SEED |
APPLICATION_ID
DESCRIPTIVE_FLEXFIELD_NAME DESCRIPTIVE_FLEX_CONTEXT_CODE APPLICATION_COLUMN_NAME LANGUAGE ZD_EDITION_NAME |
FND_DESCR_FLEX_COL_USAGE_TL_N1 | NORMAL | NONUNIQUE | APPS_TS_SEED |
FORM_LEFT_PROMPT
FORM_ABOVE_PROMPT LANGUAGE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
APPLICATION_ID | NUMBER | (10) | Yes | Application identifier |
DESCRIPTIVE_FLEXFIELD_NAME | VARCHAR2 | (40) | Yes | Descriptive flexfield name |
DESCRIPTIVE_FLEX_CONTEXT_CODE | VARCHAR2 | (30) | Yes | Descriptive flexfield structure name |
APPLICATION_COLUMN_NAME | VARCHAR2 | (30) | Yes | Column name |
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 | |
FORM_LEFT_PROMPT | VARCHAR2 | (80) | Yes | The left prompt for the segment in the flexfield window |
FORM_ABOVE_PROMPT | VARCHAR2 | (80) | Yes | The above prompt for the segment in the flexfield window |
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
, DESCRIPTIVE_FLEXFIELD_NAME
, DESCRIPTIVE_FLEX_CONTEXT_CODE
, APPLICATION_COLUMN_NAME
, LANGUAGE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, FORM_LEFT_PROMPT
, FORM_ABOVE_PROMPT
, DESCRIPTION
, SOURCE_LANG
, ZD_EDITION_NAME
FROM APPLSYS.FND_DESCR_FLEX_COL_USAGE_TL;
APPLSYS.FND_DESCR_FLEX_COL_USAGE_TL does not reference any database object
APPLSYS.FND_DESCR_FLEX_COL_USAGE_TL is referenced by following:
|
|
|