XCC_CB_FILTER_USAGES_GT
Temporary table used by the budgetary control engine to store the filter conditions that can be applied.
Details
-
Schema: FUSION
-
Object owner: XCC
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
XCC_CB_FILTER_USAGES_GT_PK |
FILTER_CONDITION_TYPE, FILTER_CONDITION_CODE |
Columns
| Name | Datatype | Length | Not-null | Comments |
|---|---|---|---|---|
| FILTER_CONDITION_TYPE | VARCHAR2 | 30 | Yes | Indicates whether this condition is associated with budget segment or GLCOA or project segment or project planning element or transaction attribute. The valid values are: BUDGET_GL_COA_SEGMENT, BUDGET_PROJECT_SEGMENT, BUDGET_PROJECT_ELEMENT, GL_COA_SEGMENT, PROJECT_SEGMENT, PROJECT_ELEMENT, or TRANSACTION_ATTRIBUTE. |
| FILTER_CONDITION_CODE | VARCHAR2 | 30 | Yes | The valid values for the filter condition are: Budget COA segment column name, GL COA segment column , project segment code specific to XCC such as PRJ_PROJECT_ID, project planning element code specific to XCC such as PJC_ORGANIZATION_ID, Transaction attribute code specific to XCC. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| XCC_CB_FILTER_USAGES_GT_U1 | Unique | FILTER_CONDITION_TYPE, FILTER_CONDITION_CODE |