[Home] [Help] [Dependency Information]
Object Name: | OKS_SUBSCR_ELEMENTS |
---|---|
Object Type: | TABLE |
Owner: | OKS |
FND Design Data: | OKS.OKS_SUBSCR_ELEMENTS |
Subobject Name: | |
Status: | VALID |
OKS_SUBSCR_ELEMENTS stores information relating to the fulfillment schedule of a subscription line.
This table is populated for tangible subscriptions only. A row will be created for each subscription fulfillment. For example, if a one-year contract line is created with a subscription item that is fulfilled monthly, there will be twelve rows in this table corresponding to the contract line, one for each monthly fulfillment.
The fulfillment schedule is populated at the time of contract creation. Subscription fulfillment concurrent program populates order details after it successfully creates an order to fulfill the specific record. The presence of an order header ID and order line ID indicates that an order has been created for the schedule element and Oracle Service Contracts considers it fulfilled.
An IB instance is created for the subscription item when a subscription contract line is created. When an order is created, another IB instance is created for the specific fulfillment. Service Contracts Instance Relationship program establishes a parent-child relation between these instances and updates the LINKED_FLAG column with the value 'Y'.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
OKS_SUBSCR_ELEMENTS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | ID |
OKS_SUBSCR_ELEMENTS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | DNZ_CLE_ID |
OKS_SUBSCR_ELEMENTS_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | OSH_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ID | NUMBER | Yes | Primary identifier. | |
OSH_ID | NUMBER | Yes | ID of the subscription header with which this subscription element is associated. Foreign key to OKS_SUBSCR_HEADER_B.ID | |
DNZ_CHR_ID | NUMBER | Yes | Contract ID. Denormalized for performance. | |
DNZ_CLE_ID | NUMBER | Contract Line ID. Denormalized for performance. | ||
LINKED_FLAG | VARCHAR2 | (10) | Indicates that the relationship between Subscription and Fulfillment instances is made. | |
SEQ_NO | NUMBER | Yes | Sequence Number. For future use. | |
OM_INTERFACE_DATE | DATE | Date on which order will be created for the Subscription Element | ||
AMOUNT | NUMBER | (15) | Amount for Subscription Element. | |
START_DATE | DATE | Start Date of the Subscription period | ||
END_DATE | DATE | End Date of Subscription period | ||
QUANTITY | NUMBER | Quantity of Subscription for the period | ||
UOM_CODE | VARCHAR2 | (3) | Yes | Unit Of Measure for the quantity. |
ORDER_HEADER_ID | NUMBER | ID of the Order Header with which this subscription element is fulfilled. | ||
ORDER_LINE_ID | NUMBER | ID of the Order Line with which this subscription element is fulfilled. | ||
OBJECT_VERSION_NUMBER | NUMBER | (9) | Yes | Sequential number set at 1 on insert and incremented on update. Used by APIs to ensure current record is passed. |
CREATED_BY | NUMBER | (15) | Yes | ID of the user whom created the record. |
CREATION_DATE | DATE | Yes | Date the record was created. | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | ID of the last user who updated the record. |
LAST_UPDATE_DATE | DATE | Yes | Date the record was last updated. | |
LAST_UPDATE_LOGIN | NUMBER | (15) | OS ID of the user who last updated the record. | |
SECURITY_GROUP_ID | NUMBER | Used to create a Virtual Private Database which was originally designed to be used by Hosting services. Now obsolete. |
Cut, paste (and edit) the following text to query this object:
SELECT ID
, OSH_ID
, DNZ_CHR_ID
, DNZ_CLE_ID
, LINKED_FLAG
, SEQ_NO
, OM_INTERFACE_DATE
, AMOUNT
, START_DATE
, END_DATE
, QUANTITY
, UOM_CODE
, ORDER_HEADER_ID
, ORDER_LINE_ID
, OBJECT_VERSION_NUMBER
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, SECURITY_GROUP_ID
FROM OKS.OKS_SUBSCR_ELEMENTS;
OKS.OKS_SUBSCR_ELEMENTS does not reference any database object
OKS.OKS_SUBSCR_ELEMENTS is referenced by following:
|
|
|