[Home] [Help] [Dependency Information]
Object Name: | OKL_INS_CLASS_CATS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | OKL.OKL_INS_CLASS_CATS_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
It stores relationship between insurance class and asset categories of fixed assets.
This information is used for insurance premiun calculation and it is required that all fixed asset types be associated with a limited number of asset classes.
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 |
IAY_ID | NUMBER | Yes | Asset category Identifier | |
IAC_CODE | VARCHAR2 | (30) | Yes | Foreign key column to FND_LOOKUPS (OKL_INSURANCE_ASSET_CLASS). |
DATE_FROM | DATE | Start date | ||
DATE_TO | DATE | End date | ||
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
, IAY_ID
, IAC_CODE
, DATE_FROM
, DATE_TO
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM APPS.OKL_INS_CLASS_CATS_V;
|
|
|