[Home] [Help] [Dependency Information]
Object Name: | OKL_INS_RATES |
---|---|
Object Type: | TABLE |
Owner: | OKL |
FND Design Data: | OKL.OKL_INS_RATES |
Subobject Name: | |
Status: | VALID |
It stores information about rates for insurance premium.It is used for calculation of insurance premium based on deductible,factor range,coverage,insurance product,country,insurance asset class. It also stores rate forsupplier and rate for customer.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
OKL_INS_RATES_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | ID |
INR_IAC_FK_I | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | IAC_CODE |
INR_IC_FK_I | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | IC_ID |
INR_IPT_FK_I | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | IPT_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ID | NUMBER | Yes | Primary key column | |
IAC_CODE | VARCHAR2 | (30) | Yes | Foriegn key column to FND_LOOKUPS (OKL_INSURANCE_ASSET_CLASS) |
IPT_ID | NUMBER | Yes | Foreign key to table OKL_INS_PRODUCTS_B | |
IC_ID | VARCHAR2 | (2) | Yes | Foriegn key to OKX_COUNTRIES_V |
COVERAGE_MAX | NUMBER | (14) | Coverage amount | |
DEDUCTIBLE | NUMBER | (14) | Insurance deductible | |
OBJECT_VERSION_NUMBER | NUMBER | (9) | Yes | Column used for locking records during updates |
FACTOR_RANGE_START | NUMBER | (14) | Lower limit for the insurance factor range | |
INSURED_RATE | NUMBER | (8) | Supplier rate | |
FACTOR_RANGE_END | NUMBER | (14) | Upper limit for the insurance factor range | |
DATE_FROM | DATE | Start date | ||
DATE_TO | DATE | End date | ||
INSURER_RATE | NUMBER | (8) | Customer rate | |
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 | |
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 ID
, IAC_CODE
, IPT_ID
, IC_ID
, COVERAGE_MAX
, DEDUCTIBLE
, OBJECT_VERSION_NUMBER
, FACTOR_RANGE_START
, INSURED_RATE
, FACTOR_RANGE_END
, DATE_FROM
, DATE_TO
, INSURER_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_INS_RATES;
OKL.OKL_INS_RATES does not reference any database object
OKL.OKL_INS_RATES is referenced by following:
|
|
|