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


TABLE: OKL.OKL_UPG_TRNS_ACC_DSTRS_T

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


This table is used for the upgrade of the identifier column of the okl_trns_acc_dstrs 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_TRNS_ACC_DSTRS_T_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnDIST_ID
Columns
Name Datatype Length Mandatory Comments
DIST_ID NUMBER
Yes Stores the Distribution Identifier (okl_trns_acc_dstrs_all.id) prior to the upgrade of the identifier column
DISTRIBUTION_ID NUMBER
Yes New Identifer that is generated by the new sequence. Foreign key regerence to okl_trns_acc_dstrs table.
Query Text

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


SELECT DIST_ID
,      DISTRIBUTION_ID
FROM OKL.OKL_UPG_TRNS_ACC_DSTRS_T;

Dependencies

[top of page]

OKL.OKL_UPG_TRNS_ACC_DSTRS_T does not reference any database object

OKL.OKL_UPG_TRNS_ACC_DSTRS_T is referenced by following:

SchemaOKL
ViewOKL_UPG_TRNS_ACC_DSTRS_T#