VRM_PO_REASSIGN_DETAILS_GT
Oracle internal use only. This global temporary table is used to identify customer contracts job during internal processing.
Details
-
Schema: FUSION
-
Object owner: VRM
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
VRM_PO_REASSIGN_DETAILS_GT_PK |
PO_REASSIGNMENT_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| PO_REASSIGNMENT_ID | NUMBER | 18 | Yes | The unique identifier of the performance obligation reassignment. | |
| PERF_OBLIGATION_ID | NUMBER | 18 | Yes | The unique identifier of the performance obligation. | |
| CUSTOMER_CONTRACT_HEADER_ID | NUMBER | 18 | Yes | The unique identifier of the customer contract. | |
| TARGET_CUST_CONTRACT_HEADER_ID | NUMBER | 18 | Yes | The unique identifier of the target customer contract. | |
| TARGET_PERF_OBLIGATION_ID | NUMBER | 18 | The unique identifier of the target performance obligation. | ||
| REASSIGNMENT_REASON_CODE | VARCHAR2 | 30 | Indicates the reason for performance obligation reassignment. | ||
| REASSIGNMENT_DATE | DATE | Indicates the date when the contract was modified. | |||
| SUBMISSION_DATE | DATE | Indicates the date when the performance obligation reassignment was initiated. | |||
| SUBMITTED_BY | VARCHAR2 | 64 | Indicates the user who submitted the performance obligation reassignment. | ||
| COMMENTS | VARCHAR2 | 1000 | The user entered comments for a performance obligation reassignment. | ||
| PROCESS_STATUS_CODE | VARCHAR2 | 30 | Indicates whether the performance obligation reassignment is processed. Values are from the ORA_VRM_RASSIGN_PROCESS_STATUS lookup. | ||
| IMMATERIAL_CHANGE_CODE | VARCHAR2 | 30 | Indicates the contract modification change type for the performance obligation reassignment. Valid values are from the ORA_IMMATERIAL_CHANGE_TYPE lookup type. | ||
| LATEST_IMMATERIAL_CHANGE_CODE | VARCHAR2 | 30 | Indicates the latest contract modification change type for the performance obligation reassignment. Valid values are from the ORA_IMMATERIAL_CHANGE_TYPE lookup type. | ||
| LEDGER_ID | NUMBER | 18 | The unique identifier of the ledger. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| VRM_PO_REASSIGN_DETAILS_GT_U1 | Unique | PO_REASSIGNMENT_ID |