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

TABLE: APPLSYS.FND_ID_FLEX_STRUCTURES

Object Details
Object Name: FND_ID_FLEX_STRUCTURES
Object Type: TABLE
Owner: APPLSYS
FND Design Data: TableFND.FND_ID_FLEX_STRUCTURES
Subobject Name:
Status: VALID


FND_ID_FLEX_STRUCTURES stores structure information about key
flexfields. Each row includes the flexfield code and the structure
number (ID_FLEX_NUM), which together identify the structure, and
the name and description of the structure. Each row also includes
values that indicate whether the flexfield structure is currently
frozen, whether rollup groups are frozen
(FREEZE_STRUCTURED_HIER_FLAG), whether users can dynamically insert
new combinations of segment values through the flexfield pop-up
window, and whether the flexfield should use segment
cross-validation rules. Each row also contains information about
shorthand flexfield entry for this structure, including whether
shorthand entry is enabled, the prompt for the shorthand window,
and the length of the shorthand alias field in the shorthand
window. You need one row for each structure of each key flexfield.
Oracle Application Object Library uses this information to generate
a compiled key flexfield definition to store in the
FND_COMPILED_ID_FLEXS table.
.
.


Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
FND_ID_FLEX_STRUCTURES_U1 NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnAPPLICATION_ID
ColumnID_FLEX_CODE
ColumnID_FLEX_NUM
FND_ID_FLEX_STRUCTURES_U2 NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnAPPLICATION_ID
ColumnID_FLEX_CODE
ColumnID_FLEX_STRUCTURE_CODE
Columns
Name Datatype Length Mandatory Comments
APPLICATION_ID NUMBER (10) Yes select t.application_id from fnd_tables t, fnd_id_flexs f where t.table_name = f.application_table_name and f.id_flex_code = fnd_id_flex_structures.id_flex_code and rownum = 1
ID_FLEX_CODE VARCHAR2 (4) Yes Key flexfield code
ID_FLEX_NUM NUMBER (15) Yes Key flexfield structure number
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
CONCATENATED_SEGMENT_DELIMITER VARCHAR2 (1) Yes The segment delimiter used to separate segments in concatenated segments
CROSS_SEGMENT_VALIDATION_FLAG VARCHAR2 (1) Yes Flag to indicate whether the flexfield should be validated by cross-validation rules
DYNAMIC_INSERTS_ALLOWED_FLAG VARCHAR2 (1) Yes Flag to indicate whether users can insert new flexfield combinations dynamically
ENABLED_FLAG VARCHAR2 (1) Yes Enabled flag
FREEZE_FLEX_DEFINITION_FLAG VARCHAR2 (1) Yes Flag to indicate if the flexfield structure is frozen
FREEZE_STRUCTURED_HIER_FLAG VARCHAR2 (1) Yes Flag to indicate if the flexfield rollup group is frozen
SHORTHAND_ENABLED_FLAG VARCHAR2 (1) Yes Flag to indicate whether shorthand alias is enabled for the flexfield structure
SHORTHAND_LENGTH NUMBER (3)
The display size of the shorthand alias field in the shorthand window
STRUCTURE_VIEW_NAME VARCHAR2 (30)
Key flexfield structure view name that a user specifies
ID_FLEX_STRUCTURE_CODE VARCHAR2 (30) Yes Developer key for key flexfield structure
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT APPLICATION_ID
,      ID_FLEX_CODE
,      ID_FLEX_NUM
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      CONCATENATED_SEGMENT_DELIMITER
,      CROSS_SEGMENT_VALIDATION_FLAG
,      DYNAMIC_INSERTS_ALLOWED_FLAG
,      ENABLED_FLAG
,      FREEZE_FLEX_DEFINITION_FLAG
,      FREEZE_STRUCTURED_HIER_FLAG
,      SHORTHAND_ENABLED_FLAG
,      SHORTHAND_LENGTH
,      STRUCTURE_VIEW_NAME
,      ID_FLEX_STRUCTURE_CODE
FROM APPLSYS.FND_ID_FLEX_STRUCTURES;

Dependencies

[top of page]

APPLSYS.FND_ID_FLEX_STRUCTURES does not reference any database object

APPLSYS.FND_ID_FLEX_STRUCTURES is referenced by following:

SchemaAPPS
SynonymFND_ID_FLEX_STRUCTURES