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_DESCRIPTIVE_FLEXS

Object Details

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

FND_DESCRIPTIVE_FLEXS stores setup information about descriptive
flexfields. Each row includes the name of the table that contains
the descriptive flexfield columns, the name and title of the
flexfield, the identifier of the application with which the
flexfield is registered, whether the flexfield is currently frozen,
whether this is a protected descriptive flexfield, the name of the
structure defining column for the flexfield (CONTEXT_COLUMN_NAME),
and other information about how the flexfield is defined.
You need one row for each descriptive flexfield in each application.
Oracle Application Object Library uses this information to generate
a compiled definition for a descriptive flexfield.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	20
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FND_DESCRIPTIVE_FLEXS_U1	NORMAL	UNIQUE	APPS_TS_SEED	APPLICATION_ID DESCRIPTIVE_FLEXFIELD_NAME ZD_EDITION_NAME
FND_DESCRIPTIVE_FLEXS_N1	NORMAL	NONUNIQUE	APPS_TS_SEED	TABLE_APPLICATION_ID APPLICATION_TABLE_NAME

Columns

Name	Datatype	Length	Mandatory	Comments
APPLICATION_ID	NUMBER	(10)	Yes	Application identifier
APPLICATION_TABLE_NAME	VARCHAR2	(30)	Yes	Table name
DESCRIPTIVE_FLEXFIELD_NAME	VARCHAR2	(40)	Yes	APPLICATION_TABLE_NAME
TABLE_APPLICATION_ID	NUMBER	(10)	Yes	Application to which table belongs
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
CONTEXT_REQUIRED_FLAG	VARCHAR2	(1)	Yes	Flag to indicate whether the descriptive flexfield requires a reference field
CONTEXT_COLUMN_NAME	VARCHAR2	(30)	Yes	The name of the structure defining column for the flexfield
CONTEXT_USER_OVERRIDE_FLAG	VARCHAR2	(1)	Yes	Flag to indicate if users can override the value in the reference field
CONCATENATED_SEGMENT_DELIMITER	VARCHAR2	(1)	Yes	The delimiter used to separate different segment values in the concatenated value
FREEZE_FLEX_DEFINITION_FLAG	VARCHAR2	(1)	Yes	Flag to indicate if the descriptive flexfield is frozen
PROTECTED_FLAG	VARCHAR2	(1)	Yes	Flag to indicate whether this is a protected descriptive flexfield
DEFAULT_CONTEXT_FIELD_NAME	VARCHAR2	(200)		The name of the reference field
DEFAULT_CONTEXT_VALUE	VARCHAR2	(30)		The default value for the reference field
CONTEXT_DEFAULT_TYPE	VARCHAR2	(1)		CONTEXT_DEFAULT_TYPE
CONTEXT_DEFAULT_VALUE	VARCHAR2	(2000)		CONTEXT_DEFAULT_VALUE
CONTEXT_OVERRIDE_VALUE_SET_ID	NUMBER	(10)		CONTEXT_OVERRIDE_VALUE
CONTEXT_RUNTIME_PROPERTY_FUNCT	VARCHAR2	(2000)		CONTEXT_RUNTIME_PROPERTY_FUNCT
CONCATENATED_SEGS_VIEW_NAME	VARCHAR2	(30)		DFV view name
CONTEXT_SYNCHRONIZATION_FLAG	VARCHAR2	(1)	Yes	Synchronize Context with Reference field value
ZD_EDITION_NAME	VARCHAR2	(30)	Yes

Query Text

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


SELECT APPLICATION_ID
,      APPLICATION_TABLE_NAME
,      DESCRIPTIVE_FLEXFIELD_NAME
,      TABLE_APPLICATION_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      CONTEXT_REQUIRED_FLAG
,      CONTEXT_COLUMN_NAME
,      CONTEXT_USER_OVERRIDE_FLAG
,      CONCATENATED_SEGMENT_DELIMITER
,      FREEZE_FLEX_DEFINITION_FLAG
,      PROTECTED_FLAG
,      DEFAULT_CONTEXT_FIELD_NAME
,      DEFAULT_CONTEXT_VALUE
,      CONTEXT_DEFAULT_TYPE
,      CONTEXT_DEFAULT_VALUE
,      CONTEXT_OVERRIDE_VALUE_SET_ID
,      CONTEXT_RUNTIME_PROPERTY_FUNCT
,      CONCATENATED_SEGS_VIEW_NAME
,      CONTEXT_SYNCHRONIZATION_FLAG
,      ZD_EDITION_NAME
FROM APPLSYS.FND_DESCRIPTIVE_FLEXS;

Dependencies

[top of page]

APPLSYS.FND_DESCRIPTIVE_FLEXS does not reference any database object

APPLSYS.FND_DESCRIPTIVE_FLEXS is referenced by following:

APPLSYS: FND_DESCRIPTIVE_FLEXS#