CST_ROLLUP_COMBINATIONS_GT
This is a temporary table used to cache the various combinations of ancestors and descendants used to check for circular references during cost rollup.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| SCENARIO_ID | NUMBER | 18 | Yes | Identifies the scenario for which the rollup combinations are being cached. | |
| ANCESTOR_ROLLUP_HEADER_KEY | NUMBER | 18 | Yes | Identifies the ancestor rollup header key for which the rollup combinations are being cached. | |
| ANCESTOR_ROLLUP_HEADER_TYPE | VARCHAR2 | 30 | Yes | Identifies the ancestor rollup header type for which the rollup combinations are being cached. | |
| ANCESTOR_INV_ORG_ID | NUMBER | 18 | Yes | Identifies the ancestor plant for which the rollup combinations are being cached. | |
| DESCENDANT_ROLLUP_HEADER_TYPE | VARCHAR2 | 30 | Yes | Identifies the descendant rollup header type for which the rollup combinations are being cached. | |
| DESCENDANT_ROLLUP_HEADER_KEY | NUMBER | 18 | Yes | Identifies the descendant rollup header key for which the rollup combinations are being cached. | |
| DESCENDANT_INV_ORG_ID | NUMBER | 18 | Yes | Identifies the descendant plant for which the rollup combinations are being cached. | |
| CIRCULAR_REFERENCE_FLAG | VARCHAR2 | 1 | Indicates the combination is repeated due to it being a circular reference. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| CST_ROLLUP_COMBINATIONS_N2 | Non Unique | SCENARIO_ID, DESCENDANT_ROLLUP_HEADER_KEY, DESCENDANT_ROLLUP_HEADER_TYPE, DESCENDANT_INV_ORG_ID |
| CST_ROLLUP_COMBINATIONS_U1 | Unique | SCENARIO_ID, ANCESTOR_ROLLUP_HEADER_KEY, ANCESTOR_ROLLUP_HEADER_TYPE, ANCESTOR_INV_ORG_ID, DESCENDANT_ROLLUP_HEADER_KEY, DESCENDANT_ROLLUP_HEADER_TYPE, DESCENDANT_INV_ORG_ID |