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 |