eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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:	FND.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:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FND_ID_FLEX_STRUCTURES_U1	NORMAL	UNIQUE	APPS_TS_SEED	APPLICATION_ID ID_FLEX_CODE ID_FLEX_NUM ZD_EDITION_NAME
FND_ID_FLEX_STRUCTURES_U2	NORMAL	UNIQUE	APPS_TS_SEED	APPLICATION_ID ID_FLEX_CODE ID_FLEX_STRUCTURE_CODE ZD_EDITION_NAME

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
ZD_EDITION_NAME	VARCHAR2	(30)	Yes

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
,      ZD_EDITION_NAME
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:

APPLSYS: FND_ID_FLEX_STRUCTURES#