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


TABLE: OKL.OKL_UPG_TXL_CNTRCT_LNS_T

Object Details
Object Name: OKL_UPG_TXL_CNTRCT_LNS_T
Object Type: TABLE
Owner: OKL
FND Design Data: TableOKL.OKL_UPG_TXL_CNTRCT_LNS_T
Subobject Name:
Status: VALID


This table is used for the upgrade of the identifier column of the okl_trx_contracts table. It stores the old and new identifiers.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
OKL_UPG_TXL_CNTRCT_LNS_T_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnTXL_ID
Columns
Name Datatype Length Mandatory Comments
TXL_ID NUMBER
Yes Stores the Transaction Line Identifier (okl_txl_cntrct_lns.id) prior to the upgrade of the identifier column
TXL_LINE_ID NUMBER
Yes New Identifer that is generated by the new sequence. Foreign key regerence to okl_txl_cntrct_lns_all table.
Query Text

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


SELECT TXL_ID
,      TXL_LINE_ID
FROM OKL.OKL_UPG_TXL_CNTRCT_LNS_T;

Dependencies

[top of page]

OKL.OKL_UPG_TXL_CNTRCT_LNS_T does not reference any database object

OKL.OKL_UPG_TXL_CNTRCT_LNS_T is referenced by following:

SchemaOKL
ViewOKL_UPG_TXL_CNTRCT_LNS_T#