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: OKL.OKL_TXL_CNTRCT_LNS_ALL

Object Details

Object Name:	OKL_TXL_CNTRCT_LNS_ALL
Object Type:	TABLE
Owner:	OKL
FND Design Data:	OKL.OKL_TXL_CNTRCT_LNS_ALL
Subobject Name:
Status:	VALID

This is transaction line table for OKL_TRX_CONTRACTS. It contains one or more than one records for each record in the header table. Different categories of transaction lines are stored in this table. The category of the line is identified by the field TCL_TYPE. Usually one line record is created for each stream type in a transaction. This is the source table for calling the accounting engine for most of the transactions.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OKL_TXL_CNTRCT_LNS_ALL_U1	NORMAL	UNIQUE	APPS_TS_NOLOGGING	ID
OKL_TXL_CNTRCT_LNS_ALL_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	AVL_ID
OKL_TXL_CNTRCT_LNS_ALL_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BTC_ID
OKL_TXL_CNTRCT_LNS_ALL_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	KHR_ID
OKL_TXL_CNTRCT_LNS_ALL_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	RCT_ID
OKL_TXL_CNTRCT_LNS_ALL_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	STY_ID
OKL_TXL_CNTRCT_LNS_ALL_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TCN_ID

Columns

Name	Datatype	Length	Mandatory	Comments
ID	NUMBER		Yes	Primary key column
LINE_NUMBER	NUMBER		Yes	Line number
OBJECT_VERSION_NUMBER	NUMBER	(9)	Yes	Column used for locking records during updates
KHR_ID	NUMBER		Yes	Foreign key to table OKL_K_HEADERS
TCN_ID	NUMBER		Yes	Foreign key to table OKL_TRX_CONTRACTS
RCT_ID	NUMBER			Foreign key to table OKL_TRX_CSH_RECEIPT_B
BTC_ID	NUMBER			Foreign key to table OKL_TRX_CSH_BATCH_B
STY_ID	NUMBER			Foreign key to table OKL_STRM_TYPE_B
AVL_ID	NUMBER			Foreign key to table OKL_AE_TEMPLATES
BKT_ID	NUMBER			Foreign key to table OKL_BUCKETS
TCL_TYPE	VARCHAR2	(10)	Yes	Transaction line type. This field differentiates the various transaction line types. The values are derived from OKL_TCL_TYPE lookup.
DESCRIPTION	VARCHAR2	(1995)		User entered description
GL_REVERSAL_YN	VARCHAR2	(3)		Indicates if the journal entries pertaining to the accrual transaction are reversed in the beginning of the next period or not. Used for variable interest rate accrual transactions. Values are Y or N.
AMOUNT	NUMBER	(14)		Amount
CURRENCY_CODE	VARCHAR2	(150)		Currency code
KLE_ID	NUMBER			Foreign key to table OKL_K_LINES
BEFORE_TRANSFER_YN	VARCHAR2	(3)		Before or after image flag. In case of transfer and assumptions, pre-transfer and post-transfer images are stored. This flag indicates if the record is a pre-transfer image or the post-transfer image.
KLE_ID_NEW	NUMBER			Not used in current release
PERCENTAGE	NUMBER	(5)		Not used in current release
ATTRIBUTE_CATEGORY	VARCHAR2	(90)		Descriptive flexfield category column
ATTRIBUTE1	VARCHAR2	(450)		Descriptive flexfield column
ATTRIBUTE2	VARCHAR2	(450)		Descriptive flexfield column
ATTRIBUTE3	VARCHAR2	(450)		Descriptive flexfield column
ATTRIBUTE4	VARCHAR2	(450)		Descriptive flexfield column
ATTRIBUTE5	VARCHAR2	(450)		Descriptive flexfield column
ATTRIBUTE6	VARCHAR2	(450)		Descriptive flexfield column
ATTRIBUTE7	VARCHAR2	(450)		Descriptive flexfield column
ATTRIBUTE8	VARCHAR2	(450)		Descriptive flexfield column
ATTRIBUTE9	VARCHAR2	(450)		Descriptive flexfield column
ATTRIBUTE10	VARCHAR2	(450)		Descriptive flexfield column
ATTRIBUTE11	VARCHAR2	(450)		Descriptive flexfield column
ATTRIBUTE12	VARCHAR2	(450)		Descriptive flexfield column
ATTRIBUTE13	VARCHAR2	(450)		Descriptive flexfield column
ATTRIBUTE14	VARCHAR2	(450)		Descriptive flexfield column
ATTRIBUTE15	VARCHAR2	(450)		Descriptive flexfield column
ORG_ID	NUMBER	(15)		Operating unit identifier
PROGRAM_ID	NUMBER	(15)		Concurrent Manager column
PROGRAM_APPLICATION_ID	NUMBER	(15)		Concurrent Manager column
REQUEST_ID	NUMBER	(15)		Concurrent Manager column
PROGRAM_UPDATE_DATE	DATE			Concurrent Manager column
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
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column
ACCRUAL_RULE_YN	VARCHAR2	(1)		This column indicates whether stream type accrued was subject to accrual rules or not.
CANCELED_DATE	DATE			Date on which the transaction ic canceled
SOURCE_COLUMN_1	VARCHAR2	(150)		Source column which identifies the type of source value.
SOURCE_VALUE_1	NUMBER			This column stores the value of the source.
SOURCE_COLUMN_2	VARCHAR2	(150)		Source column which identifies the type of source value.
SOURCE_VALUE_2	NUMBER			This column stores the value of the source.
SOURCE_COLUMN_3	VARCHAR2	(150)		Source column which identifies the type of source value.
SOURCE_VALUE_3	NUMBER			This column stores the value of the source.
TAX_LINE_ID	NUMBER			Transaction Tax Line Identifier
ASSET_BOOK_TYPE_NAME	VARCHAR2	(30)		Not populated for SLA - Asset Book Type Code
STREAM_TYPE_CODE	VARCHAR2	(150)		Stream Type Code
STREAM_TYPE_PURPOSE	VARCHAR2	(240)		Stream Type Purpose.Points to FND lookup OKL_STREAM_TYPE_PURPOSE
UPGRADE_STATUS_FLAG	VARCHAR2	(1)		This column is added as part of SLA uptake for making Ids sequence generatedThe various values are :NULL - Upgrade required by ID upgrade scriptY - Upgraded by scriptN - Created new and hence uses correct sequence

Query Text

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


SELECT ID
,      LINE_NUMBER
,      OBJECT_VERSION_NUMBER
,      KHR_ID
,      TCN_ID
,      RCT_ID
,      BTC_ID
,      STY_ID
,      AVL_ID
,      BKT_ID
,      TCL_TYPE
,      DESCRIPTION
,      GL_REVERSAL_YN
,      AMOUNT
,      CURRENCY_CODE
,      KLE_ID
,      BEFORE_TRANSFER_YN
,      KLE_ID_NEW
,      PERCENTAGE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ORG_ID
,      PROGRAM_ID
,      PROGRAM_APPLICATION_ID
,      REQUEST_ID
,      PROGRAM_UPDATE_DATE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      ACCRUAL_RULE_YN
,      CANCELED_DATE
,      SOURCE_COLUMN_1
,      SOURCE_VALUE_1
,      SOURCE_COLUMN_2
,      SOURCE_VALUE_2
,      SOURCE_COLUMN_3
,      SOURCE_VALUE_3
,      TAX_LINE_ID
,      ASSET_BOOK_TYPE_NAME
,      STREAM_TYPE_CODE
,      STREAM_TYPE_PURPOSE
,      UPGRADE_STATUS_FLAG
FROM OKL.OKL_TXL_CNTRCT_LNS_ALL;

Dependencies

[top of page]

OKL.OKL_TXL_CNTRCT_LNS_ALL does not reference any database object

OKL.OKL_TXL_CNTRCT_LNS_ALL is referenced by following:

APPS: OKL_TXL_CNTRCT_LNS; OKL_TXL_CNTRCT_LNS_ALL