FND Design Data [Home] [Help]

View: OKL_CONTRACT_ASSET_HV

Product: OKL - Leasing and Finance Management
Description: History view for lease management created fixed assets
Implementation/DBA Data: ViewAPPS.OKL_CONTRACT_ASSET_HV
View Text

SELECT VFA.ROWID ROW_ID
, VFA.ID
, VFA.MAJOR_VERSION
, VFA.OBJECT_VERSION_NUMBER
, VFA.DNZ_CHR_ID
, VFA.FA_CLE_ID
, VFA.NAME
, VFA.DESCRIPTION
, VFA.ASSET_ID
, VFA.ASSET_NUMBER
, VFA.CORPORATE_BOOK
, VFA.LIFE_IN_MONTHS
, VFA.ORIGINAL_COST
, VFA.COST
, VFA.ADJUSTED_COST
, VFA.CURRENT_UNITS
, VFA.NEW_USED
, VFA.IN_SERVICE_DATE
, VFA.MODEL_NUMBER
, VFA.ASSET_TYPE
, VFA.SALVAGE_VALUE
, VFA.PERCENT_SALVAGE_VALUE
, VFA.DEPRECIATION_CATEGORY
, VFA.DEPRN_START_DATE
, VFA.DEPRN_METHOD_CODE
, VFA.RATE_ADJUSTMENT_FACTOR
, VFA.BASIC_RATE
, VFA.ADJUSTED_RATE
, VFA.START_DATE_ACTIVE
, VFA.END_DATE_ACTIVE
, VFA.STATUS
, VFA.PRIMARY_UOM_CODE
, VFA.RECOVERABLE_COST
, VFA.ATTRIBUTE_CATEGORY
, VFA.ATTRIBUTE1
, VFA.ATTRIBUTE2
, VFA.ATTRIBUTE3
, VFA.ATTRIBUTE4
, VFA.ATTRIBUTE5
, VFA.ATTRIBUTE6
, VFA.ATTRIBUTE7
, VFA.ATTRIBUTE8
, VFA.ATTRIBUTE9
, VFA.ATTRIBUTE10
, VFA.ATTRIBUTE11
, VFA.ATTRIBUTE12
, VFA.ATTRIBUTE13
, VFA.ATTRIBUTE14
, VFA.ATTRIBUTE15
, VFA.CREATED_BY
, VFA.CREATION_DATE
, VFA.LAST_UPDATED_BY
, VFA.LAST_UPDATE_DATE
, VFA.LAST_UPDATE_LOGIN
, VFA.ASSET_KEY_ID
, VFA.LEGAL_ENTITY_ID
FROM OKL_CONTRACT_ASSET_H VFA

Columns

Name
ROW_ID
ID
MAJOR_VERSION
OBJECT_VERSION_NUMBER
DNZ_CHR_ID
FA_CLE_ID
NAME
DESCRIPTION
ASSET_ID
ASSET_NUMBER
CORPORATE_BOOK
LIFE_IN_MONTHS
ORIGINAL_COST
COST
ADJUSTED_COST
CURRENT_UNITS
NEW_USED
IN_SERVICE_DATE
MODEL_NUMBER
ASSET_TYPE
SALVAGE_VALUE
PERCENT_SALVAGE_VALUE
DEPRECIATION_CATEGORY
DEPRN_START_DATE
DEPRN_METHOD_CODE
RATE_ADJUSTMENT_FACTOR
BASIC_RATE
ADJUSTED_RATE
START_DATE_ACTIVE
END_DATE_ACTIVE
STATUS
PRIMARY_UOM_CODE
RECOVERABLE_COST
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
ASSET_KEY_ID
LEGAL_ENTITY_ID