[Home] [Help] [Dependency Information]
Object Name: | OKL_FE_ADJ_MAT_VERSIONS |
---|---|
Object Type: | TABLE |
Owner: | OKL |
FND Design Data: | OKL.OKL_FE_ADJ_MAT_VERSIONS |
Subobject Name: | |
Status: | VALID |
OKL_FE_ADJ_MAT_VERSIONS is a table holding the Pricing adjustment matrix lines information for all versions. Adjustment criteria with the factors are attached to the pricing adjustment matrix to calculate the adjusted rate.
ADJ_MAT_VERSION_ID is the primary key. ADJ_MAT_ID is the pricing adjustment matrix header id.
The effectivity dates and the status of the matrix for each version is being stored.
The different statuses are new, active, submitted, abandoned.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
OKL_FE_ADJ_MAT_VERSIONS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | ADJ_MAT_VERSION_ID |
OKL_FE_ADJ_MAT_VERSIONS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | ADJ_MAT_ID |
OKL_FE_ADJ_MAT_VERSIONS_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | STS_CODE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ADJ_MAT_VERSION_ID | NUMBER | Yes | Pricing adjustment matrix lines identifier | |
OBJECT_VERSION_NUMBER | NUMBER | (9) | Yes | Object version number tracks row updates |
VERSION_NUMBER | VARCHAR2 | (30) | Yes | Version of the pricing adjustment matrix |
ADJ_MAT_ID | NUMBER | Yes | Pricing adjustment matrix id | |
STS_CODE | VARCHAR2 | (30) | Yes | Status code of the version.Lookup Type "OKL_PRC_STATUS" |
EFFECTIVE_FROM_DATE | DATE | Yes | Effective from date of the version | |
EFFECTIVE_TO_DATE | DATE | Effective to date of the version | ||
ATTRIBUTE_CATEGORY | VARCHAR2 | (90) | Descriptive flex field structure defining column | |
ATTRIBUTE1 | VARCHAR2 | (450) | Descriptive flex field segment | |
ATTRIBUTE2 | VARCHAR2 | (450) | Descriptive flex field segment | |
ATTRIBUTE3 | VARCHAR2 | (450) | Descriptive flex field segment | |
ATTRIBUTE4 | VARCHAR2 | (450) | Descriptive flex field segment | |
ATTRIBUTE5 | VARCHAR2 | (450) | Descriptive flex field segment | |
ATTRIBUTE6 | VARCHAR2 | (450) | Descriptive flex field segment | |
ATTRIBUTE7 | VARCHAR2 | (450) | Descriptive flex field segment | |
ATTRIBUTE8 | VARCHAR2 | (450) | Descriptive flex field segment | |
ATTRIBUTE9 | VARCHAR2 | (450) | Descriptive flex field segment | |
ATTRIBUTE10 | VARCHAR2 | (450) | Descriptive flex field segment | |
ATTRIBUTE11 | VARCHAR2 | (450) | Descriptive flex field segment | |
ATTRIBUTE12 | VARCHAR2 | (450) | Descriptive flex field segment | |
ATTRIBUTE13 | VARCHAR2 | (450) | Descriptive flex field segment | |
ATTRIBUTE14 | VARCHAR2 | (450) | Descriptive flex field segment | |
ATTRIBUTE15 | VARCHAR2 | (450) | Descriptive flex field segment | |
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 |
Cut, paste (and edit) the following text to query this object:
SELECT ADJ_MAT_VERSION_ID
, OBJECT_VERSION_NUMBER
, VERSION_NUMBER
, ADJ_MAT_ID
, STS_CODE
, EFFECTIVE_FROM_DATE
, EFFECTIVE_TO_DATE
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM OKL.OKL_FE_ADJ_MAT_VERSIONS;
OKL.OKL_FE_ADJ_MAT_VERSIONS does not reference any database object
OKL.OKL_FE_ADJ_MAT_VERSIONS is referenced by following:
|
|
|