[Home] [Help] [Dependency Information]
Object Name: | GL_SUMMARY_HIERARCHY_INT |
---|---|
Object Type: | TABLE |
Owner: | GL |
FND Design Data: | SQLGL.GL_SUMMARY_HIERARCHY_INT |
Subobject Name: | |
Status: | VALID |
GL_SUMMARY_HIERARCHY_INT contains segment value hierarchy changes for summary templates. When it is run, Incremental Add/Delete Summary Templates determines which changes have been made to the segment value hierarchy, and stores the changes into this interim table. These changes are then used by the Incremental Add/Delete Summary Templates program to update the summary accounts to reflect the new hierarchy.
Tablespace: | APPS_TS_NOLOGGING |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
GL_SUMMARY_HIERARCHY_INT_N1 | NORMAL | NONUNIQUE | APPS_TS_NOLOGGING |
TEMPLATE_ID
SEGMENT_POS FLEX_VALUE_SET_ID OLD_PARENT_FLEX_VALUE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TEMPLATE_ID | NUMBER | (15) | Yes | Summary template defining column |
SEGMENT_POS | NUMBER | Yes | Segment position which the range belongs to | |
FLEX_VALUE_SET_ID | NUMBER | (10) | Yes | Flexfield value set defining column |
PARENT_FLEX_VALUE | VARCHAR2 | (60) | Yes | New parent value to which the range belongs |
CHILD_FLEX_VALUE_LOW | VARCHAR2 | (60) | Yes | Low value of the range of child values |
CHILD_FLEX_VALUE_HIGH | VARCHAR2 | (60) | Yes | High value of the range of child values |
STATUS_CODE | VARCHAR2 | (1) | Yes | Status column used internally by summarization program |
LOW_INCL_FLAG | VARCHAR2 | (1) | Yes | Flag indicating if the low end of the range should be included when processing |
HIGH_INCL_FLAG | VARCHAR2 | (1) | Yes | Flag indicating if the high end of the range should be included when processing |
CREATION_DATE | DATE | Yes | Standard Who column | |
CREATED_BY | NUMBER | (15) | Yes | Standard Who column |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Yes | Standard Who column |
OLD_PARENT_FLEX_VALUE | VARCHAR2 | (60) | Old parent value to which the range used to belong |
Cut, paste (and edit) the following text to query this object:
SELECT TEMPLATE_ID
, SEGMENT_POS
, FLEX_VALUE_SET_ID
, PARENT_FLEX_VALUE
, CHILD_FLEX_VALUE_LOW
, CHILD_FLEX_VALUE_HIGH
, STATUS_CODE
, LOW_INCL_FLAG
, HIGH_INCL_FLAG
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, OLD_PARENT_FLEX_VALUE
FROM GL.GL_SUMMARY_HIERARCHY_INT;
GL.GL_SUMMARY_HIERARCHY_INT does not reference any database object
GL.GL_SUMMARY_HIERARCHY_INT is referenced by following:
|
|
|