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

TABLE: OKS.OKS_BILL_SUB_LINE_DTLS

Object Details
Object Name: OKS_BILL_SUB_LINE_DTLS
Object Type: TABLE
Owner: OKS
FND Design Data: TableOKS.OKS_BILL_SUB_LINE_DTLS
Subobject Name:
Status: VALID


This is used to store billing details for usage counter lines. Each row includes amount charged or credit Issued and detailed information for the quantity billed for usage counter lines. The table is populated from 'Service Contracts Main Billing', 'Service Contracts Usage Averaging' and 'Service Contracts Usage Settlement' concurrent programs. This table is also populated from the Termination form. When main billing is run, records from this table are sent to billing interface tables to initiate the billing process with Oracle Receivables.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
OKS_BILL_SUB_LINE_DTLS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnID
OKS_BILL_SUB_LINE_DTLS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnBSL_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, credit, average or settlement 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)
Flexfield attribute value column.
ATTRIBUTE2 VARCHAR2 (450)
Flexfield attribute value column.
ATTRIBUTE3 VARCHAR2 (450)
Flexfield attribute value column.
ATTRIBUTE4 VARCHAR2 (450)
Flexfield attribute value column.
ATTRIBUTE5 VARCHAR2 (450)
Flexfield attribute value column.
ATTRIBUTE6 VARCHAR2 (450)
Flexfield attribute value column.
ATTRIBUTE7 VARCHAR2 (450)
Flexfield attribute value column.
ATTRIBUTE8 VARCHAR2 (450)
Flexfield attribute value column.
ATTRIBUTE9 VARCHAR2 (450)
Flexfield attribute value column.
ATTRIBUTE10 VARCHAR2 (450)
Flexfield attribute value column.
ATTRIBUTE11 VARCHAR2 (450)
Flexfield attribute value column.
ATTRIBUTE12 VARCHAR2 (450)
Flexfield attribute value column.
ATTRIBUTE13 VARCHAR2 (450)
Flexfield attribute value column.
ATTRIBUTE14 VARCHAR2 (450)
Flexfield attribute value column.
ATTRIBUTE15 VARCHAR2 (450)
Flexfield attribute value column.
SECURITY_GROUP_ID NUMBER

Used in hosted environments
START_READING NUMBER

Start Reading for the billing period.
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.
ESTIMATED_QUANTITY NUMBER

Estimated counter quantity from AMCV method or Install Base.
BASE_READING NUMBER

Currently same as START_READING.
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
,      ESTIMATED_QUANTITY
,      BASE_READING
FROM OKS.OKS_BILL_SUB_LINE_DTLS;

Dependencies

[top of page]

OKS.OKS_BILL_SUB_LINE_DTLS does not reference any database object

OKS.OKS_BILL_SUB_LINE_DTLS is referenced by following:

SchemaOKS
ViewOKS_BILL_SUB_LINE_DTLS#