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_BSD_PR

Object Details

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

This is used to store billing details for usage counter lines. Each row includes amount charged and detailed information for the quantity billed for usage counter lines. The table is populated from 'Service Contracts Main Billing' concurrent programs. This table 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_BSD_PR_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	ID
OKS_BSD_PR_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BSL_ID

Columns

Name	Datatype	Length	Mandatory	Comments
ID	NUMBER		Yes	Primary key column.
BSL_ID	NUMBER		Yes	ID of contract sub line billing record. References OKS_BILL_SUB_LINES.ID.
BSL_ID_AVERAGED	NUMBER			Not Used.
BSD_ID	NUMBER			Not Used.
BSD_ID_APPLIED	NUMBER			Not Used.
UNIT_OF_MEASURE	VARCHAR2	(30)	Yes	Unit of measure referenced from MTL_SYSTEM_ITEMS_B. PRIMARY_UOM_CODE.
AMCV_YN	VARCHAR2	(3)	Yes	Average monthly counter values. Valid values for the field are 'Y' and 'N'. 'Y' indicates, AMCV estimation method is applied for calculating the counter quantity to be billed for current billing period. 'N' indicates, AMCV estimation method is not applied.
RESULT	NUMBER	(15)	Yes	Quantity Billed for Usage. The quantity can be Fixed, Actual, Default, Minimum or Actual + Estimated Quantity
AMOUNT	NUMBER	(17)	Yes	Stores the invoice amount for the period associated with contract sub line. This column is populated from OKS_LEVEL_ELEMENTS.AMOUNT for all sub lines except for usage lines of type 'Fixed per period', 'Actual by quantity' and 'Actual per period', is derived from pricing engine.
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	Standard who column
CREATION_DATE	DATE		Yes	Standard who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column
LAST_UPDATE_DATE	DATE		Yes	Standard who column
FIXED	NUMBER	(15)		Fixed quantity to be billed for usage lines of type 'Fixed Per Period'. Referenced from OKS_K_LINES_B. FIXED_QUANTITY.
ACTUAL	NUMBER	(15)		Captured counter quantity to be billed for usage lines. Referenced from CS_CTR_COUNTER_VALUES_V.NET_READING.
DEFAULT_DEFAULT	NUMBER	(15)		Default quantity to be billed for usage lines if there is no reading captured. Referenced from OKS_K_LINES_B. DEFAULT_QUANTITY.
ADJUSTMENT_LEVEL	NUMBER	(15)		Quantity after averaging of two or more counter lines net counter reading, which are referenced from CS_CTR_COUNTER_VALUES_V.NET_READING.
ADJUSTMENT_MINIMUM	NUMBER	(15)		Minimum Quantity to be billed if actual quantity < minimum quantity. Referenced from OKS_K_LINES_B.MINIMUM_QUANTITY.
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column
ATTRIBUTE_CATEGORY	VARCHAR2	(90)		Flex field attribute category column
ATTRIBUTE1	VARCHAR2	(450)		Flex field attribute value column.
ATTRIBUTE2	VARCHAR2	(450)		Flex field attribute value column.
ATTRIBUTE3	VARCHAR2	(450)		Flex field attribute value column.
ATTRIBUTE4	VARCHAR2	(450)		Flex field attribute value column.
ATTRIBUTE5	VARCHAR2	(450)		Flex field attribute value column.
ATTRIBUTE6	VARCHAR2	(450)		Flex field attribute value column.
ATTRIBUTE7	VARCHAR2	(450)		Flex field attribute value column.
ATTRIBUTE8	VARCHAR2	(450)		Flex field attribute value column.
ATTRIBUTE9	VARCHAR2	(450)		Flex field attribute value column.
ATTRIBUTE10	VARCHAR2	(450)		Flex field attribute value column.
ATTRIBUTE11	VARCHAR2	(450)		Flex field attribute value column.
ATTRIBUTE12	VARCHAR2	(450)		Flex field attribute value column.
ATTRIBUTE13	VARCHAR2	(450)		Flex field attribute value column.
ATTRIBUTE14	VARCHAR2	(450)		Flex field attribute value column.
ATTRIBUTE15	VARCHAR2	(450)		Flex field attribute value column.
SECURITY_GROUP_ID	NUMBER			Used in hosted environments
START_READING	NUMBER			Start Reading for the billing period. It is populated from OKS_SUB_LINE_DTLS.END_READING of previous billing period record.
END_READING	NUMBER			End Reading for the billing period. It is populated from CS_CTR_COUNTER_VALUES_V. NET_READING.
CCR_ID	NUMBER			Counter Identifier from Install Base. References CS_CTR_COUNTER_VALUES_V. COUNTER_VALUE_ID
CGR_ID	NUMBER			Counter Group Identifier from Install Base. References CS_CTR_COUNTER_VALUES_V. COUNTER_GROUP_ID.
BASE_READING	NUMBER			Start reading for the counter. References CS_CTR_COUNTER_VALUES_V. NET_READING.
ESTIMATED_QUANTITY	NUMBER			Estimated counter quantity from AMCV method or Install Base.

Query Text

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


SELECT ID
,      BSL_ID
,      BSL_ID_AVERAGED
,      BSD_ID
,      BSD_ID_APPLIED
,      UNIT_OF_MEASURE
,      AMCV_YN
,      RESULT
,      AMOUNT
,      OBJECT_VERSION_NUMBER
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      FIXED
,      ACTUAL
,      DEFAULT_DEFAULT
,      ADJUSTMENT_LEVEL
,      ADJUSTMENT_MINIMUM
,      LAST_UPDATE_LOGIN
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      SECURITY_GROUP_ID
,      START_READING
,      END_READING
,      CCR_ID
,      CGR_ID
,      BASE_READING
,      ESTIMATED_QUANTITY
FROM OKS.OKS_BSD_PR;

Dependencies

[top of page]

OKS.OKS_BSD_PR does not reference any database object

OKS.OKS_BSD_PR is referenced by following:

APPS: OKS_BSD_PR