[Home] [Help] [Dependency Information]
Object Name: | FND_FLEX_VALUE_HIER_ALL |
---|---|
Object Type: | TABLE |
Owner: | APPLSYS |
FND Design Data: | FND.FND_FLEX_VALUE_HIER_ALL |
Subobject Name: | |
Status: | VALID |
FND_FLEX_VALUE_HIER_ALL stores information about all value
hierarchy ranges for key flexfield segment values. Each row includes
an identification of the parent value the range belongs to, as well
as the low and high values that make up the range values.
RANGE_ATTRIBUTE identifies whether the range is a child value range
or a parent value range. HIERARCHY_LEVEL identifies the depth of
the hierarchy tree from parent value to the value range.
FLEX_VALUE_SET_ID identifies the value set to which the parent
value belongs. You need one row for each value ranges
(you can have more than one row for each parent value). Oracle
Application Object Library provides this information for
applications reporting purposes.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
FND_FLEX_VALUE_HIER_ALL_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
FLEX_VALUE_SET_ID
CHILD_FLEX_VALUE_HIGH CHILD_FLEX_VALUE_LOW PARENT_FLEX_VALUE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
FLEX_VALUE_SET_ID | NUMBER | (10) | Yes | Flexfield value set identifier |
PARENT_FLEX_VALUE | VARCHAR2 | (60) | Yes | The parent value to which the range belongs |
RANGE_ATTRIBUTE | VARCHAR2 | (1) | Yes | Flag to distinguish a child value from a parent value. |
CHILD_FLEX_VALUE_LOW | VARCHAR2 | (60) | Yes | The low value of the range of child values |
CHILD_FLEX_VALUE_HIGH | VARCHAR2 | (60) | Yes | he high value of the range of child values |
HIERARCHY_LEVEL | NUMBER | (10) | Yes | The hierarchy tree depth from parent value to the value range. |
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 | |
START_DATE_ACTIVE | DATE | The date the value hierarchy becomes active | ||
END_DATE_ACTIVE | DATE | The date the value hierarchy expires |
Cut, paste (and edit) the following text to query this object:
SELECT FLEX_VALUE_SET_ID
, PARENT_FLEX_VALUE
, RANGE_ATTRIBUTE
, CHILD_FLEX_VALUE_LOW
, CHILD_FLEX_VALUE_HIGH
, HIERARCHY_LEVEL
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, START_DATE_ACTIVE
, END_DATE_ACTIVE
FROM APPLSYS.FND_FLEX_VALUE_HIER_ALL;
APPLSYS.FND_FLEX_VALUE_HIER_ALL does not reference any database object
APPLSYS.FND_FLEX_VALUE_HIER_ALL is referenced by following:
|
|
|