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

TABLE: OKS.OKS_BTL_PR

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


This table stores the billing transactions. The table is populated from 'Service Contracts Main Billing' concurrent program when executed in preview mode for
Contract line or Contract sub line depending on profile option 'AR_SUMMARY_TRANSACTIONS'


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
OKS_BTL_PR_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnID
OKS_BTL_PR_U2 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnBSL_ID
ColumnBCL_ID
OKS_BTL_PR_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnBTN_ID
OKS_BTL_PR_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnBCL_ID
OKS_BTL_PR_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnBILL_INSTANCE_NUMBER
Columns
Name Datatype Length Mandatory Comments
ID NUMBER
Yes Primary key column.
BTN_ID NUMBER
Yes ID of bill transaction record. References OKS_BTN_PR.ID.
BSL_ID NUMBER

ID of sub line billing record. References OKS_BSL_PR.ID. It will be populated only for detail transactions
BCL_ID NUMBER

ID of contract line billing record. References OKS_BCL_PR.ID.
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.
BILL_INSTANCE_NUMBER NUMBER (30) Yes Unique Identifier generated by sequence.
TRX_LINE_AMOUNT VARCHAR2 (240)
Obsolete.
TRX_LINE_TAX_AMOUNT NUMBER

Not used
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.
MANUAL_CREDIT NUMBER

Query Text

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


SELECT ID
,      BTN_ID
,      BSL_ID
,      BCL_ID
,      OBJECT_VERSION_NUMBER
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      BILL_INSTANCE_NUMBER
,      TRX_LINE_AMOUNT
,      TRX_LINE_TAX_AMOUNT
,      LAST_UPDATE_LOGIN
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      SECURITY_GROUP_ID
,      MANUAL_CREDIT
FROM OKS.OKS_BTL_PR;

Dependencies

[top of page]

OKS.OKS_BTL_PR does not reference any database object

OKS.OKS_BTL_PR is referenced by following:

SchemaAPPS
SynonymOKS_BTL_PR