[Home] [Help] [Dependency Information]
Object Name: | OKL_FE_STD_RT_TMP_VERS |
---|---|
Object Type: | TABLE |
Owner: | OKL |
FND Design Data: | OKL.OKL_FE_STD_RT_TMP_VERS |
Subobject Name: | |
Status: | VALID |
OKL_FE_STD_RT_TMP_VERS is a table holding the standard rate template lines information for all versions. A pricing adjustment matrix can be associated to a particular standard rate template. The rate can be adjusted according to the factors specified in the pricing adjusment matrix. Eligibility criteria attached to this standard rate template determine whether this particular template is applicable for a quote.
STD_RATE_TMPL_VER_ID is the primary key. STD_RATE_TMP_ID is the standard rate template header id.
The effectivity dates and the status of the template for each version is being stored.
The different statuses are new, active, submitted, abandoned. If the adjusted rate calculated from the adjustment matrix is not in the range of the minimum and maximum adjusted rate, then they are taken into consideration.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
OKL_FE_STD_RT_TMP_VERS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | STD_RATE_TMPL_VER_ID |
OKL_FE_STD_RT_TMP_VERS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | STD_RATE_TMPL_ID |
OKL_FE_STD_RT_TMP_VERS_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | STS_CODE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
STD_RATE_TMPL_VER_ID | NUMBER | Yes | Standard Rate Template Lines Identifier | |
OBJECT_VERSION_NUMBER | NUMBER | (9) | Yes | Object version number tracks row updates |
VERSION_NUMBER | VARCHAR2 | (30) | Yes | Version of the Standard Rate Template |
STD_RATE_TMPL_ID | NUMBER | Yes | Standard Rate Template Identifier | |
EFFECTIVE_FROM_DATE | DATE | Yes | Effective from date of the version | |
EFFECTIVE_TO_DATE | DATE | Effective to date of the version | ||
STS_CODE | VARCHAR2 | (30) | Yes | Status code of the versionLookup Type "OKL_PRC_STATUS" |
ADJ_MAT_VERSION_ID | NUMBER | Pricing Adjustment Matrix Identifier | ||
SRT_RATE | NUMBER | Yes | Interest Rate | |
SPREAD | NUMBER | Spread added to the base/index rate to get the final interest rate | ||
DAY_CONVENTION_CODE | VARCHAR2 | (30) | Yes | Day Convention to be used. Lookup Type "OKL_YEAR_TYPE" |
MIN_ADJ_RATE | NUMBER | Minimum rate that can be adjusted by the adjustment matrix | ||
MAX_ADJ_RATE | NUMBER | Maximum rate that can be adjusted by the adjsutment matrix | ||
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 STD_RATE_TMPL_VER_ID
, OBJECT_VERSION_NUMBER
, VERSION_NUMBER
, STD_RATE_TMPL_ID
, EFFECTIVE_FROM_DATE
, EFFECTIVE_TO_DATE
, STS_CODE
, ADJ_MAT_VERSION_ID
, SRT_RATE
, SPREAD
, DAY_CONVENTION_CODE
, MIN_ADJ_RATE
, MAX_ADJ_RATE
, 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_STD_RT_TMP_VERS;
OKL.OKL_FE_STD_RT_TMP_VERS does not reference any database object
OKL.OKL_FE_STD_RT_TMP_VERS is referenced by following:
|
|
|