VRM_CONTRACT_ACTIVITIES_GT
This is a temporary table which is used internally by Oracle.
Details
-
Schema: FUSION
-
Object owner: VRM
-
Object type: TABLE
-
Tablespace: TRANSACTION_TABLES
Primary Key
| Name | Columns |
|---|---|
|
VRM_CONTR_ACTIVITIES_GT_PK |
CONTRACT_ACTIVITY_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| CONTRACT_ACTIVITY_ID | NUMBER | 18 | Yes | Customer contract activity unique identifier. | |
| CONTRACT_ACTIVITY_TYPE | VARCHAR2 | 30 | Customer contract activity type. Values are from the lookup ORA_REV_CONTRACT_ACTIVITY_TYPE. | ||
| CONTRACT_ACTIVITY_DATE | DATE | Customer contract activity date. | |||
| CONTRACT_ACTIVITY_GROUP_ID | NUMBER | 18 | Customer contract activity group identifier. | ||
| PERF_OBLIGATION_ID | NUMBER | 18 | Performance obligation unique identifier. | ||
| PERF_OBLIGATION_LINE_ID | NUMBER | 18 | Performance obligation line unique identifier. | ||
| CUSTOMER_CONTRACT_HEADER_ID | NUMBER | 18 | Customer contract header unique identifier. | ||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| VRM_CONTR_ACTIVITIES_GT_N1 | Non Unique | REQUEST_ID |
| VRM_CONTR_ACTIVITIES_GT_N2 | Non Unique | CUSTOMER_CONTRACT_HEADER_ID |
| VRM_CONTR_ACTIVITIES_GT_U1 | Unique | CONTRACT_ACTIVITY_ID |