Product: | OKL - Leasing and Finance Management |
---|---|
Description: | History view for lease management created fixed assets |
Implementation/DBA Data: |
![]() |
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