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_BILL_TXN_LINES

Object Details

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

This stores the billing transaction details like bill instance number, invoice number, invoice date, invoice amount and tax amount. The table is populated from 'Service Contracts Main Billing', 'Service Contracts Usage Averaging' and 'Service Contracts Usage Settlement' concurrent programs.
The transaction number, transaction line tax amount, transaction amount and transaction class columns are updated from 'Service Contracts Fetch Receivables Info For Billing' concurrent program after completion of Auto Invoice import program.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OKS_BILL_TXN_LINES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	ID
OKS_BILL_TXN_LINES_U3	NORMAL	UNIQUE	APPS_TS_TX_IDX	BSL_ID BCL_ID
OKS_BILL_TXN_LINES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BTN_ID
OKS_BILL_TXN_LINES_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BCL_ID
OKS_BILL_TXN_LINES_U2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BILL_INSTANCE_NUMBER

Columns

Name	Datatype	Length	Mandatory	Comments
ID	NUMBER		Yes	Primary key column.
BTN_ID	NUMBER		Yes	ID of the transaction parent record. References OKS_BILL_TRANSACTIONS.ID
BSL_ID	NUMBER			ID of the contract sub line billing transaction record. References OKS_BILL_SUB_LINES.ID. It will be populated only for detail transactions.
BCL_ID	NUMBER			ID of the contract line billing transaction record. References OKS_BILL_CONT_LINES.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	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
BILL_INSTANCE_NUMBER	NUMBER	(30)	Yes	Unique Identifier generated by sequence. The value is sent in Oracle Receivables interface table. It is used to map billing history records with its corresponding invoice records in Oracle Receivables
TRX_LINE_AMOUNT	VARCHAR2	(240)		Obsolete
TRX_LINE_TAX_AMOUNT	NUMBER			Stores the Invoice line tax amount received from Oracle Receivables. It is updated by fetch program from RA_CUSTOMER_TRX_LINES_ALL.EXTENDED_AMOUNT.
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
TRX_DATE	DATE			Stores the Invoice date received from Oracle Receivables. It is updated by fetch program from RA_CUSTOMER_TRX_ALL.TRX_DATE.
TRX_NUMBER	VARCHAR2	(60)		Stores the Invoice Number received from Oracle Receivables. It is updated by fetch program from RA_CUSTOMER_TRX_ALL.TRX_NUMBER.
TRX_CLASS	VARCHAR2	(60)		Stores the Invoice class. Valid values for this column are INV - Invoice, CM - Credit Memo. It is updated by fetch program from RA_CUST_TRX_TYPES_ALL.TYPE.
MANUAL_CREDIT	NUMBER			Obsolete
TRX_AMOUNT	NUMBER			Stores the Invoice amount received from Oracle Receivables. It is updated by fetch program from RA_CUSTOMER_TRX_LINES_ALL.EXTENDED_AMOUNT.
SPLIT_FLAG	VARCHAR2	(1)
CYCLE_REFRENCE	VARCHAR2	(120)

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
,      TRX_DATE
,      TRX_NUMBER
,      TRX_CLASS
,      MANUAL_CREDIT
,      TRX_AMOUNT
,      SPLIT_FLAG
,      CYCLE_REFRENCE
FROM OKS.OKS_BILL_TXN_LINES;

Dependencies

[top of page]

OKS.OKS_BILL_TXN_LINES does not reference any database object

OKS.OKS_BILL_TXN_LINES is referenced by following:

APPS: OKS_BILL_TXN_LINES