[Home] [Help] [Dependency Information]
Object Name: | FND_COMPILED_DESCRIPTIVE_FLEXS |
---|---|
Object Type: | TABLE |
Owner: | APPLSYS |
FND Design Data: | FND.FND_COMPILED_DESCRIPTIVE_FLEXS |
Subobject Name: | |
Status: | VALID |
FND_COMPILED_DESCRIPTIVE_FLEXS stores compiled information about
descriptive flexfields. Each row includes values that identify the
descriptive flexfield (DESCRIPTIVE_FLEXFIELD_NAME), the application
that owns the descriptive flexfield, and the flexfield compiler
version. Each row also includes the actual compiled definition
of the descriptive flexfield, and the sequence of the compiled
definition of the flexfield. You need at least
one row for each descriptive flexfield that has been defined,
frozen and saved. You may have additional rows for flexfields that
you compile using different versions of the flexfield compiler.
Oracle Application Object Library uses this information to display
and validate descriptive flexfield pop-up windows.
.
.
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 5 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
FND_COMPILED_DESCR_FLEXS_U1 | NORMAL | UNIQUE | APPS_TS_SEED |
APPLICATION_ID
DESCRIPTIVE_FLEXFIELD_NAME COMPILER_VERSION_NUM SEQUENCE LANGUAGE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
APPLICATION_ID | NUMBER | (10) | Yes | Application identifier |
DESCRIPTIVE_FLEXFIELD_NAME | VARCHAR2 | (40) | Yes | Descriptive flexfield name |
COMPILER_VERSION_NUM | NUMBER | (10) | Yes | Descriptive flexfield compiler version |
SEQUENCE | NUMBER | (10) | Yes | Sequence of compiled definition |
CREATION_DATE | DATE | Yes | Standard Who column | |
CREATED_BY | NUMBER | (10) | Yes | Standard Who column |
LANGUAGE | VARCHAR2 | (30) | Language | |
COMPILED_DEFINITION | LONG | (0) | Yes | Compiled definition of the descriptive flexfield |
Cut, paste (and edit) the following text to query this object:
SELECT APPLICATION_ID
, DESCRIPTIVE_FLEXFIELD_NAME
, COMPILER_VERSION_NUM
, SEQUENCE
, CREATION_DATE
, CREATED_BY
, LANGUAGE
, COMPILED_DEFINITION
FROM APPLSYS.FND_COMPILED_DESCRIPTIVE_FLEXS;
APPLSYS.FND_COMPILED_DESCRIPTIVE_FLEXS does not reference any database object
APPLSYS.FND_COMPILED_DESCRIPTIVE_FLEXS is referenced by following:
|
|
|