DBA Data[Home] [Help] [Dependency Information]

TABLE: GL.GL_ROLLUP_GROUP_SCORES

Object Details
Object Name: GL_ROLLUP_GROUP_SCORES
Object Type: TABLE
Owner: GL
FND Design Data: TableSQLGL.GL_ROLLUP_GROUP_SCORES
Subobject Name:
Status: VALID


GL_ROLLUP_GROUP_SCORES stores selectivity information about your rollup groups. This table is automatically maintained whenever you run the GL Optimizer program.
The information in this table is used to enhance performance when posting or when maintaining summary accounts.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
GL_ROLLUP_GROUP_SCORES_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnAPPLICATION_COLUMN_NAME
ColumnFLEX_VALUE_SET_ID
ColumnROLLUP_GROUP_ID
Columns
Name Datatype Length Mandatory Comments
APPLICATION_COLUMN_NAME VARCHAR2 (30) Yes Key Flexfield segment column
AVG_SCORE_PER_CHILD_RANGE NUMBER (15) Yes Average selectivity score for each child range in the rollup group
FLEX_VALUE_SET_ID NUMBER (15) Yes Key Flexfield value set defining column
NUMBER_OF_PARENT_VALUES NUMBER (15) Yes Number of parent values that belong to the rollup group
SELECTIVITY_SCORE NUMBER (15) Yes Number of rows in GL_CODE_COMBINATIONS that fall within the child ranges of the rollup group
ROLLUP_GROUP_ID NUMBER (15) Yes Rollup group defining column
Query Text

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


SELECT APPLICATION_COLUMN_NAME
,      AVG_SCORE_PER_CHILD_RANGE
,      FLEX_VALUE_SET_ID
,      NUMBER_OF_PARENT_VALUES
,      SELECTIVITY_SCORE
,      ROLLUP_GROUP_ID
FROM GL.GL_ROLLUP_GROUP_SCORES;

Dependencies

[top of page]

GL.GL_ROLLUP_GROUP_SCORES does not reference any database object

GL.GL_ROLLUP_GROUP_SCORES is referenced by following:

SchemaGL
ViewGL_ROLLUP_GROUP_SCORES#