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_BCL_PR

Object Details

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

This stores the billing transactions for the contract lines. This table is populated from 'Service Contracts Main Billing' concurrent program, when executed in preview mode. Each record includes start date, end date, amount charged and billing type as 'RI' -invoice. The information in this record is used to generate custom report.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OKS_BCL_PR_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	ID
OKS_BCL_PR_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CLE_ID DATE_BILLED_FROM BILL_ACTION

Columns

Name	Datatype	Length	Mandatory	Comments
ID	NUMBER		Yes	Surrogate key used for primary unique identifiers.
CLE_ID	NUMBER		Yes	Contract line ID. References OKC_K_LINES_B.ID.
BTN_ID	NUMBER			Bill Transaction line ID. References OKS_BTN_PR.ID.
DATE_BILLED_FROM	DATE		Yes	Stores the start date of billing period. For regular invoice, main billing program populates the column from OKS_LEVEL_ELEMENTS.DATE_START.
DATE_BILLED_TO	DATE		Yes	Stores the end date of billing period. For regular invoice, main billing program populates the column from OKS_LEVEL_ELEMENTS.DATE_END.
SENT_YN	VARCHAR2	(3)	Yes	Not used.
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.
AMOUNT	NUMBER	(17)		Stores the billing amount for a period associated with the contract line. This is the total of all sub lines from OKS_BSL_PR table
BILL_ACTION	VARCHAR2	(9)		Stores billing transaction type. Valid value is Regular Invoice -RI
DATE_NEXT_INVOICE	DATE			Not used.
CURRENCY_CODE	VARCHAR2	(15)		Contract Currency Code. References OKC_K_HEADERS_B.CURRENCY_CODE
LAST_UPDATE_LOGIN	NUMBER	(15)		OS ID of the user who last updated the record.
ATTRIBUTE_CATEGORY	VARCHAR2	(90)		Typically, a reference field from which a descriptive flexfield can get a context field value (optional, but recommended).
ATTRIBUTE1	VARCHAR2	(450)		Descriptive flexfield
ATTRIBUTE2	VARCHAR2	(450)		Descriptive flexfield
ATTRIBUTE3	VARCHAR2	(450)		Descriptive flexfield
ATTRIBUTE4	VARCHAR2	(450)		Descriptive flexfield
ATTRIBUTE5	VARCHAR2	(450)		Descriptive flexfield
ATTRIBUTE6	VARCHAR2	(450)		Descriptive flexfield
ATTRIBUTE7	VARCHAR2	(450)		Descriptive flexfield
ATTRIBUTE8	VARCHAR2	(450)		Descriptive flexfield
ATTRIBUTE9	VARCHAR2	(450)		Descriptive flexfield
ATTRIBUTE10	VARCHAR2	(450)		Descriptive flexfield
ATTRIBUTE11	VARCHAR2	(450)		Descriptive flexfield
ATTRIBUTE12	VARCHAR2	(450)		Descriptive flexfield
ATTRIBUTE13	VARCHAR2	(450)		Descriptive flexfield
ATTRIBUTE14	VARCHAR2	(450)		Descriptive flexfield
ATTRIBUTE15	VARCHAR2	(450)		Descriptive flexfield
SECURITY_GROUP_ID	NUMBER			Used to create a Virtual Private Database which was originally designed to be used by Hosting services. Now obsolete.
AVERAGED_YN	VARCHAR2	(1)		Not Used
SETTLED_YN	VARCHAR2	(1)		Not Used

Query Text

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


SELECT ID
,      CLE_ID
,      BTN_ID
,      DATE_BILLED_FROM
,      DATE_BILLED_TO
,      SENT_YN
,      OBJECT_VERSION_NUMBER
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      AMOUNT
,      BILL_ACTION
,      DATE_NEXT_INVOICE
,      CURRENCY_CODE
,      LAST_UPDATE_LOGIN
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      SECURITY_GROUP_ID
,      AVERAGED_YN
,      SETTLED_YN
FROM OKS.OKS_BCL_PR;

Dependencies

[top of page]

OKS.OKS_BCL_PR does not reference any database object

OKS.OKS_BCL_PR is referenced by following:

APPS: OKS_BCL_PR