[Home] [Help] [Dependency Information]
Object Name: | OKL_INS_RATES_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | OKL.OKL_INS_RATES_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
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.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | Row Identifier in the database | |
ID | NUMBER | Yes | Primary key column | |
OBJECT_VERSION_NUMBER | NUMBER | (9) | Yes | Column used for locking records during updates |
IC_ID | VARCHAR2 | (2) | Yes | Foriegn key to OKX_COUNTRIES_V |
IPT_ID | NUMBER | Yes | Foreign key to table OKL_INS_PRODUCTS_B | |
IAC_CODE | VARCHAR2 | (30) | Yes | Foriegn key column to FND_LOOKUPS (OKL_INSURANCE_ASSET_CLASS) |
COVERAGE_MAX | NUMBER | (14) | Coverage amount | |
DEDUCTIBLE | NUMBER | (14) | Insurance deductible | |
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 ROW_ID
, ID
, OBJECT_VERSION_NUMBER
, IC_ID
, IPT_ID
, IAC_CODE
, COVERAGE_MAX
, DEDUCTIBLE
, 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 APPS.OKL_INS_RATES_V;
|
|
|