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_LEVEL_ELEMENTS

Object Details

Object Name:	OKS_LEVEL_ELEMENTS
Object Type:	TABLE
Owner:	OKS
FND Design Data:	OKS.OKS_LEVEL_ELEMENTS
Subobject Name:
Status:	VALID

This table stores the billing schedule for contract header, Line and sub lines. The data stored in this table is derived from the billing stream information captured in OKS_STREAM_LEVELS_B table. Corresponding to each record in OKS_STREAM_LEVELS_B table there exists one or more records in OKS_LEVEL_ELEMENTS table.
For a given billing stream, billing dates are determined. These billing dates, along with their billable amounts are what essentially comprise a "level element". Level elements are sequentially ordered through the SEQUENCE_NUMBER, which also corresponds to the level element's chronological order.
'Service Contracts Main Billing' concurrent program reads this table to identify the lines that need to be billed for a period. Billing program filters the records based on interface date (DATE_TO_INTERFACE) defined in the schedule. DATE_COMPLETED column is updated after the billing process.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OKS_LEVEL_ELEMENTS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	ID
OKS_LEVEL_ELEMENTS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	RUL_ID
OKS_LEVEL_ELEMENTS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PARENT_CLE_ID DATE_COMPLETED DATE_TO_INTERFACE
OKS_LEVEL_ELEMENTS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DATE_TO_INTERFACE
OKS_LEVEL_ELEMENTS_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CLE_ID
OKS_LEVEL_ELEMENTS_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DNZ_CHR_ID

Columns

Name	Datatype	Length	Mandatory	Comments
ID	NUMBER		Yes	Surrogate key used for primary unique identifiers.
SEQUENCE_NUMBER	VARCHAR2	(240)	Yes	Chronological sequence, which is generated programmatically to show the level element's order within a billing stream.
DATE_START	DATE			The starting date for the billing period derived based on start date of contract line or sub line
AMOUNT	NUMBER			Stores the amount to be billed for the billing period. It is derived based on billing stream uom code, duration of billing stream, effectivity and PRICE_NEGOTIATED.
DATE_RECEIVABLE_GL	DATE			Not used.
DATE_REVENUE_RULE_START	DATE			Not used.
DATE_TRANSACTION	DATE			The Invoice date of the transaction that is derived based on start date (Advance rule) or end date (Arrears rule) of billing period, and from INVOICE_OFSET_DAYS.
DATE_DUE	DATE			Not used.
DATE_PRINT	DATE			Not used.
DATE_TO_INTERFACE	DATE			Date to interface to Accounts Receivables. It is derived based on start date or end date of billing period, invoicing rule (Advance/Arrears) and INTERFACE_OFSET_DAYS. 'Service contracts main billing' concurrent program reads the records based on this date.
DATE_COMPLETED	DATE			The date the record was billed. Updated by Service contracts main billing concurrent program.
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.
RUL_ID	NUMBER		Yes	Identifies the stream level based on which this record was derived. References OKS_STREAM_LEVELS_B.ID.
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.
SECURITY_GROUP_ID	NUMBER			Used to create a Virtual Private Database which was originally designed to be used by Hosting services. Now obsolete.
CLE_ID	NUMBER			Contract line id. References OKC_K_LINES_B.ID.
DNZ_CHR_ID	NUMBER			Contract header id. References OKC_K_HEADERS_B.ID.
PARENT_CLE_ID	NUMBER			Parent id of contract sub lines. References OKC_K_LINES_B.ID.
DATE_END	DATE			The end date for the billing period derived based on start date of billing period (OKS_LEVEL_ELEMENTS.DATE_START), UOM code and UOM per period of billing stream.

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ID
,      SEQUENCE_NUMBER
,      DATE_START
,      AMOUNT
,      DATE_RECEIVABLE_GL
,      DATE_REVENUE_RULE_START
,      DATE_TRANSACTION
,      DATE_DUE
,      DATE_PRINT
,      DATE_TO_INTERFACE
,      DATE_COMPLETED
,      OBJECT_VERSION_NUMBER
,      RUL_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      SECURITY_GROUP_ID
,      CLE_ID
,      DNZ_CHR_ID
,      PARENT_CLE_ID
,      DATE_END
FROM OKS.OKS_LEVEL_ELEMENTS;

Dependencies

[top of page]

OKS.OKS_LEVEL_ELEMENTS does not reference any database object

OKS.OKS_LEVEL_ELEMENTS is referenced by following:

OKS: OKS_LEVEL_ELEMENTS#