DW_CXS_SUBSCRIPTION_RELATIONSHIP_F

This table stores the subscription relationship details.

Details

Module: Subscription Management

Key Columns

OPERATION_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
OPERATION_ID NUMBER 38 0 True The unique identifier of the operation associated with the relation.    
SOURCE_RECORD_ID VARCHAR2 64     System    
OPERATION_CODE VARCHAR2 32     The code of the operation that resulted in this relationship record. Stores values such as Renewal, Amendment, Upgrade. DW_CXS_SUBSCRIPTION_OPERATION_D_TL CODE
SOURCE_SUBSCRIPTION_ID NUMBER 38 0   The unique identifier of the source subscription associated with the relationship.    
SOURCE_SUBSCRIPTION_PRODUCT_ID NUMBER 38 0   The unique identifier of the source subscription product associated with the relationship    
TARGET_SUBSCRIPTION_ID NUMBER 38 0   The unique identifier of the target subscription associated with the relationship.    
TARGET_SUBSCRIPTION_PRODUCT_ID NUMBER 38 0   The unique identifier of the target subscription product associated with the relationship.    
CREATION_DATE DATE       The date on which the subscription relationship record was created.    
LAST_UPDATE_DATE DATE       The date on which the subscription relationship record was last updated.    
CREATION_TIMESTAMP TIMESTAMP       The date and time on which the subscription relationship record was created.    
LAST_UPDATE_TIMESTAMP TIMESTAMP       The date and time on which the subscription relationship record was last updated.    

Copyright © 2019, 2023, Oracle and/or its affiliates.