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_SEGMENTS

Object Details

Object Name:	FND_ID_FLEX_SEGMENTS
Object Type:	TABLE
Owner:	APPLSYS
FND Design Data:	FND.FND_ID_FLEX_SEGMENTS
Subobject Name:
Status:	VALID

FND_ID_FLEX_SEGMENTS stores setup information about key flexfield
segments, as well as the correspondences between application table
columns and the key flexfield segments the columns are used
for. Each
row includes a flexfield application identifier, the flexfield
code, which identifies the key flexfield, the structure number
(ID_FLEX_NUM), the value set application identifier, the segment
number (the segment's sequence in the flexfield window), the name
of the column the segment corresponds to (usually SEGMENTn,
where n is an integer).
Each row also includes the segment name, whether security is enabled
for the segment, whether the segment is required, whether the
segment is one of a high, low segment pair, whether the segment is
displayed, whether the segment is enabled (Y or N), type of default
value, display information about
the segment such as prompts and display size, and the value set the
segment uses. Each row also includes a flag for whether the table
column is indexed; this value is normally Y. You need one row for
each segment of each structure for each 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_SEGMENTS_U1	NORMAL	UNIQUE	APPS_TS_SEED	APPLICATION_ID ID_FLEX_CODE ID_FLEX_NUM APPLICATION_COLUMN_NAME ZD_EDITION_NAME
FND_ID_FLEX_SEGMENTS_U2	NORMAL	UNIQUE	APPS_TS_SEED	APPLICATION_ID ID_FLEX_CODE ID_FLEX_NUM SEGMENT_NAME ZD_EDITION_NAME
FND_ID_FLEX_SEGMENTS_N1	NORMAL	NONUNIQUE	APPS_TS_SEED	FLEX_VALUE_SET_ID

Columns

Name	Datatype	Length	Mandatory	Comments
APPLICATION_ID	NUMBER	(10)	Yes	Application identifier
ID_FLEX_CODE	VARCHAR2	(4)	Yes	Key flexfield code
ID_FLEX_NUM	NUMBER	(15)	Yes	Key flexfield structure number
APPLICATION_COLUMN_NAME	VARCHAR2	(30)	Yes	Flexfield column name
SEGMENT_NAME	VARCHAR2	(30)	Yes	Segment name
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	(15)		Standard Who column
SEGMENT_NUM	NUMBER	(3)	Yes	Segment number
APPLICATION_COLUMN_INDEX_FLAG	VARCHAR2	(1)	Yes	Flag to indicate if the flexfield column is indexed
ENABLED_FLAG	VARCHAR2	(1)	Yes	Flag to indicate if the segment is enabled
REQUIRED_FLAG	VARCHAR2	(1)	Yes	Flag to indicate if a value must be entered for this segment
DISPLAY_FLAG	VARCHAR2	(1)	Yes	Flag to indicate if the segment should be displayed
DISPLAY_SIZE	NUMBER	(3)	Yes	The display size of the segment
SECURITY_ENABLED_FLAG	VARCHAR2	(1)	Yes	Flag to indicate if security is enabled for the segment
MAXIMUM_DESCRIPTION_LEN	NUMBER	(3)	Yes	The maximum description size for the segment
CONCATENATION_DESCRIPTION_LEN	NUMBER	(3)	Yes	The size of the concatenated flexfield description
FLEX_VALUE_SET_ID	NUMBER	(10)		Flexfield value set identifier
RANGE_CODE	VARCHAR2	(1)		Range code can be High or Low
DEFAULT_TYPE	VARCHAR2	(1)		Type of default value
DEFAULT_VALUE	VARCHAR2	(2000)		The default value for the segment
RUNTIME_PROPERTY_FUNCTION	VARCHAR2	(2000)		RUNTIME_PROPERTY_FUNCTION
ADDITIONAL_WHERE_CLAUSE	VARCHAR2	(4000)		Additional where clause
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
,      APPLICATION_COLUMN_NAME
,      SEGMENT_NAME
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      SEGMENT_NUM
,      APPLICATION_COLUMN_INDEX_FLAG
,      ENABLED_FLAG
,      REQUIRED_FLAG
,      DISPLAY_FLAG
,      DISPLAY_SIZE
,      SECURITY_ENABLED_FLAG
,      MAXIMUM_DESCRIPTION_LEN
,      CONCATENATION_DESCRIPTION_LEN
,      FLEX_VALUE_SET_ID
,      RANGE_CODE
,      DEFAULT_TYPE
,      DEFAULT_VALUE
,      RUNTIME_PROPERTY_FUNCTION
,      ADDITIONAL_WHERE_CLAUSE
,      ZD_EDITION_NAME
FROM APPLSYS.FND_ID_FLEX_SEGMENTS;

Dependencies

[top of page]

APPLSYS.FND_ID_FLEX_SEGMENTS does not reference any database object

APPLSYS.FND_ID_FLEX_SEGMENTS is referenced by following:

APPLSYS: FND_ID_FLEX_SEGMENTS#