OSS_RENEWAL_PARTIES_GT
Global temporary table to process party of Subscriptions entities.
Details
-
Schema: FUSION
-
Object owner: OSS
-
Object type: TABLE
-
Tablespace: Default
Primary Key
Name | Columns |
---|---|
OSS_R_PARTIES_GT_PK |
TARGET_SUBSCRIPTION_PARTY_ID |
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
SUBSCRIPTION_PARTY_ID | NUMBER | 18 | Source Subscription party id | ||
SUBSCRIPTION_ID | NUMBER | 18 | Source Subscription Id | ||
TARGET_SUBSCRIPTION_PARTY_ID | NUMBER | 18 | Yes | Primary Key | |
TARGET_PARTY_PUID | VARCHAR2 | 120 | TARGET_PARTY_PUID | ||
TARGET_SUBSCRIPTION_ID | NUMBER | 18 | Target Subscription Id | ||
TARGET_SUBSCRIPTION_NUMBER | VARCHAR2 | 120 | Target Subscription Number | ||
TARGET_PARTY_ROLE | VARCHAR2 | 30 | Target Party Role | ||
TARGET_START_DATE | DATE | Target Subscription Start Date | |||
TARGET_END_DATE | DATE | Target Subscriprion End Date |
Indexes
Index | Uniqueness | Columns |
---|---|---|
OSS_R_PARTIES_GT_U1 | Unique | TARGET_SUBSCRIPTION_PARTY_ID |