eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: OKS.OKS_SUBSCR_HEADER_B

Object Details

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.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

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

Columns

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

Query Text

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;

Dependencies

[top of page]

OKS.OKS_SUBSCR_HEADER_B does not reference any database object

OKS.OKS_SUBSCR_HEADER_B is referenced by following:

OKS: OKS_SUBSCR_HEADER_B#