VIEW: OKL.OKL_CONTRACT_ASSET_H#

Source

View Text - Preformatted

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

View Text - HTML Formatted

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