[Home] [Help] [Dependency Information]
Object Name: | OKL_INS_PRODUCTS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | OKL.OKL_INS_PRODUCTS_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
It stores information about lease and optional insurance product. Each record stores supplier of the product and stores relationship with inventory product .
Each record has information about the products insurance factor range , coverage range and deal range for contract .It links a provider to products and this information is used in the creation of Lease and optional policies /quotes.
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 |
SFWT_FLAG | VARCHAR2 | (3) | Yes | Column used by the translation batch program |
ISU_ID | NUMBER | Yes | Insurance agency identifier | |
IPD_ID | NUMBER | Yes | Inventory product identifier | |
POLICY_SYMBOL | VARCHAR2 | (10) | Prefix for generating policy numbers using this insurance product | |
IPT_TYPE | VARCHAR2 | (30) | Yes | Foreign key column to FND_LOOKUPS (OKL_INSURANCE_PRODUCT_TYPE) |
NAME | VARCHAR2 | (256) | Name | |
FACTOR_MAX | NUMBER | (14) | Maximum limit for insurance factor | |
DATE_FROM | DATE | Start date | ||
FACTOR_MIN | NUMBER | (14) | Minimum limit for insurance factor | |
DATE_TO | DATE | End date | ||
FACTOR_NAME | VARCHAR2 | (20) | life, farm value | |
FACTOR_CODE | VARCHAR2 | (30) | Foreign key column to FND_LOOKUPS (OKL_INSURANCE_PRODUCT_TYPE) | |
COVERAGE_MIN | NUMBER | (14) | Minimum amount of coverage | |
COVERAGE_MAX | NUMBER | (14) | Maximum amount of coverage | |
DEAL_MONTHS_MIN | NUMBER | (10) | Minimum period of deal | |
DEAL_MONTHS_MAX | NUMBER | (8) | Maximum period of deal | |
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 | |
FACTOR_AMOUNT_YN | VARCHAR2 | (3) | Flag, whether Insurance Factor is of amount type |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, ID
, OBJECT_VERSION_NUMBER
, SFWT_FLAG
, ISU_ID
, IPD_ID
, POLICY_SYMBOL
, IPT_TYPE
, NAME
, FACTOR_MAX
, DATE_FROM
, FACTOR_MIN
, DATE_TO
, FACTOR_NAME
, FACTOR_CODE
, COVERAGE_MIN
, COVERAGE_MAX
, DEAL_MONTHS_MIN
, DEAL_MONTHS_MAX
, 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
, FACTOR_AMOUNT_YN
FROM APPS.OKL_INS_PRODUCTS_V;
|
|
|