[Home] [Help] [Dependency Information]
Object Name: | OKS_SUBSCR_HEADER_B |
---|---|
Object Type: | TABLE |
Owner: | OKS |
FND Design Data: | OKS.OKS_SUBSCR_HEADER_B |
Subobject Name: | |
Status: | VALID |
A subscription template contains a set of attributes associated to subscription items. A separate row is created in OKS_SUBSCR_HEADER_B for each subscription template.
When a subscription contract line is created, the templated is instantiated for that line. This instantiated subscription associated to a specific contract line is also stored in this table. A template row is identified by the value of -1 in the column DNZ_CHR_ID. In instantiated rows, the corresponding contract header ID and subscription line ID will be stored in the columns DNZ_CHR_ID and CLE_ID respectively.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
OKS_SUBSCR_HEADER_B_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | ID |
OKS_SUBSCR_HEADER_B_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | CLE_ID |
OKS_SUBSCR_HEADER_B_N3 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | INSTANCE_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ID | NUMBER | Yes | Primary identifier. | |
CLE_ID | NUMBER | ID of the contract line with which this subscription is associated. Value will be NULL for subscription templates | ||
DNZ_CHR_ID | NUMBER | Yes | Contract ID. Denormalized for performance. Value will be -1 for subscription templates | |
INSTANCE_ID | NUMBER | ID of the Item Instance with which this subscription is associated. Value will be NULL for subscription templates | ||
SUBSCRIPTION_TYPE | VARCHAR2 | (30) | Yes | Subscription Type. Defined in FND_LOOKUPS with Lookup Type 'OKS_SUB_TYPE'. User definable |
ITEM_TYPE | VARCHAR2 | (10) | Item Type for subscription. | |
MEDIA_TYPE | VARCHAR2 | (10) | Media Type for subscription. Defined in FND_LOOKUPS with Lookup Type 'OKS_MED_PRTY_TYPE'. User definable | |
STATUS | VARCHAR2 | (3) | Status of the Subscription ('A'ctive, 'I'nactive) | |
FREQUENCY | VARCHAR2 | (60) | Yes | Subscription Frequency. ('Y'early, 'M'onthly, 'W'eekly, 'D'aily) |
FULFILLMENT_CHANNEL | VARCHAR2 | (30) | Yes | Subscription Fulfillment Channel ('OM' for Order Management or 'None' for intangible items). Defined in FND_LOOKUPS with Lookup Type 'OKS_FULFILMT_CHNL'. |
OFFSET | NUMBER | OM Interface date offset from the period start date. Used for creating subscription fulfillment schedule elements | ||
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. | ||
UPG_ORIG_SYSTEM_REF | VARCHAR2 | (60) | Source system reference number. Used for upgrades | |
UPG_ORIG_SYSTEM_REF_ID | NUMBER | Source system reference ID. Used for upgrades | ||
ORIG_SYSTEM_ID1 | NUMBER | Unique identifier in the source system | ||
ORIG_SYSTEM_REFERENCE1 | VARCHAR2 | (30) | Unique identifier in the source system | |
ORIG_SYSTEM_SOURCE_CODE | VARCHAR2 | (30) | Identifier of Source system |
Cut, paste (and edit) the following text to query this object:
SELECT ID
, CLE_ID
, DNZ_CHR_ID
, INSTANCE_ID
, SUBSCRIPTION_TYPE
, ITEM_TYPE
, MEDIA_TYPE
, STATUS
, FREQUENCY
, FULFILLMENT_CHANNEL
, OFFSET
, OBJECT_VERSION_NUMBER
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, SECURITY_GROUP_ID
, UPG_ORIG_SYSTEM_REF
, UPG_ORIG_SYSTEM_REF_ID
, ORIG_SYSTEM_ID1
, ORIG_SYSTEM_REFERENCE1
, ORIG_SYSTEM_SOURCE_CODE
FROM OKS.OKS_SUBSCR_HEADER_B;
OKS.OKS_SUBSCR_HEADER_B does not reference any database object
OKS.OKS_SUBSCR_HEADER_B is referenced by following:
|
|
|