DBA Data[Home] [Help] [Dependency Information]


TABLE: APPLSYS.FND_COMPILED_DESCRIPTIVE_FLEXS

Object Details
Object Name: FND_COMPILED_DESCRIPTIVE_FLEXS
Object Type: TABLE
Owner: APPLSYS
FND Design Data: TableFND.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.
.
.


Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 5
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
FND_COMPILED_DESCR_FLEXS_U1 NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnAPPLICATION_ID
ColumnDESCRIPTIVE_FLEXFIELD_NAME
ColumnCOMPILER_VERSION_NUM
ColumnSEQUENCE
ColumnLANGUAGE
Columns
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
Query Text

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;

Dependencies

[top of page]

APPLSYS.FND_COMPILED_DESCRIPTIVE_FLEXS does not reference any database object

APPLSYS.FND_COMPILED_DESCRIPTIVE_FLEXS is referenced by following:

SchemaAPPS
SynonymFND_COMPILED_DESCRIPTIVE_FLEXS