[Home] [Help] [Dependency Information]
Object Name: | GL_SEG_VAL_HIERARCHIES |
---|---|
Object Type: | TABLE |
Owner: | GL |
FND Design Data: | SQLGL.GL_SEG_VAL_HIERARCHIES |
Subobject Name: | |
Status: | VALID |
GL_SEG_VAL_HIERARCHIES stores information about key flexfield child segment values. Each row includes an identification of the parent value and the corresponding child values. It stores the flattened information from the FND_FLEX_VALUE_NORM_HIERARCHY and FND_FLEX_VALUE_HIERARCHY table.
Note that the GL_SEG_VAL_HIERARCHIES contains all descendants of a node whether the descendant is a parent or a child. Also, each parent value is considered to be a child of its own i.e. there will be a row in this table where the parent_flex_value is identical to the child_flex_value.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
GL_SEG_VAL_HIERARCHIES_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
FLEX_VALUE_SET_ID
PARENT_FLEX_VALUE CHILD_FLEX_VALUE |
GL_SEG_VAL_HIERARCHIES_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
FLEX_VALUE_SET_ID
CHILD_FLEX_VALUE |
GL_SEG_VAL_HIERARCHIES_N3 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
FLEX_VALUE_SET_ID
STATUS_CODE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
FLEX_VALUE_SET_ID | NUMBER | (10) | Yes | Flexfield value set defining column |
PARENT_FLEX_VALUE | VARCHAR2 | (60) | Yes | Parent value |
CHILD_FLEX_VALUE | VARCHAR2 | (60) | Yes | Child value |
SUMMARY_FLAG | VARCHAR2 | (1) | Yes | Summary flag |
CREATED_BY | NUMBER | (15) | Yes | Standard Who Column |
CREATION_DATE | DATE | Yes | Standard Who Column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who Column |
LAST_UPDATE_DATE | DATE | Yes | Standard Who Column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who Column | |
STATUS_CODE | VARCHAR2 | (1) | Status code |
Cut, paste (and edit) the following text to query this object:
SELECT FLEX_VALUE_SET_ID
, PARENT_FLEX_VALUE
, CHILD_FLEX_VALUE
, SUMMARY_FLAG
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, STATUS_CODE
FROM GL.GL_SEG_VAL_HIERARCHIES;
GL.GL_SEG_VAL_HIERARCHIES does not reference any database object
GL.GL_SEG_VAL_HIERARCHIES is referenced by following:
|
|
|