[Home] [Help] [Dependency Information]

TABLE: APPLSYS.FND_FLEX_VALUES

Object Details

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

FND_FLEX_VALUES stores valid values for key and descriptive
flexfield segments.
Oracle Application Object Library uses this table when users define
values for independent or dependent type value sets. Oracle
Application Object Library also uses this table when users define
parent values for ranges of child values that exist in a validation
table (Oracle Application Object Library stores the parent values
in this table). Each row includes the value (FLEX_VALUE) and its
hierarchy level if applicable
as well as the identifier of the value set the value
belongs to. If the value is a dependent value,
PARENT_FLEX_VALUE_LOW contains the independent value this value
depends upon. Oracle Application Object Library does not use the
PARENT_FLEX_VALUE_HIGH column. If ENABLED_FLAG contains N, this
value is currently invalid, regardless of the start and end dates.
If ENABLED_FLAG contains Y, the start and end dates indicate if
this value is currently valid. SUMMARY_FLAG indicates if this
value is a parent value that has child values, and
STRUCTURED_HIERARCHY_LEVEL contains the rollup group the parent
value belongs to, if any (1 through 9). COMPILED_VALUE_ATTRIBUTES
contains the compiled values of any segment qualifiers assigned to
this value. These values are in a special Oracle Application
Object Library format, and you should never modify them.
VALUE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE50 are descriptive
flexfield columns, where VALUE_CATEGORY is the context (structure
defining) column. These descriptive flexfield columns do not
contain values unless you have defined the descriptive flexfield
at your site. You need one row for each independent, dependent or
parent value belonging to a value set. Oracle
Application Object Library uses this information to ensure that
users enter valid values in flexfield segments.
.
.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FND_FLEX_VALUES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	FLEX_VALUE_ID
FND_FLEX_VALUES_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	FLEX_VALUE_SET_ID PARENT_FLEX_VALUE_LOW FLEX_VALUE
FND_FLEX_VALUES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	FLEX_VALUE_SET_ID FLEX_VALUE
FND_FLEX_VALUES_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	FLEX_VALUE_SET_ID STRUCTURED_HIERARCHY_LEVEL

Columns

Query Text

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

SELECT FLEX_VALUE_SET_ID
,      FLEX_VALUE_ID
,      FLEX_VALUE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      ENABLED_FLAG
,      SUMMARY_FLAG
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      PARENT_FLEX_VALUE_LOW
,      PARENT_FLEX_VALUE_HIGH
,      STRUCTURED_HIERARCHY_LEVEL
,      HIERARCHY_LEVEL
,      COMPILED_VALUE_ATTRIBUTES
,      VALUE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      ATTRIBUTE21
,      ATTRIBUTE22
,      ATTRIBUTE23
,      ATTRIBUTE24
,      ATTRIBUTE25
,      ATTRIBUTE26
,      ATTRIBUTE27
,      ATTRIBUTE28
,      ATTRIBUTE29
,      ATTRIBUTE30
,      ATTRIBUTE31
,      ATTRIBUTE32
,      ATTRIBUTE33
,      ATTRIBUTE34
,      ATTRIBUTE35
,      ATTRIBUTE36
,      ATTRIBUTE37
,      ATTRIBUTE38
,      ATTRIBUTE39
,      ATTRIBUTE40
,      ATTRIBUTE41
,      ATTRIBUTE42
,      ATTRIBUTE43
,      ATTRIBUTE44
,      ATTRIBUTE45
,      ATTRIBUTE46
,      ATTRIBUTE47
,      ATTRIBUTE48
,      ATTRIBUTE49
,      ATTRIBUTE50
,      ATTRIBUTE_SORT_ORDER
FROM APPLSYS.FND_FLEX_VALUES;

Dependencies

[top of page]

APPLSYS.FND_FLEX_VALUES does not reference any database object

APPLSYS.FND_FLEX_VALUES is referenced by following:

APPS

FND_FLEX_VALUES