View: OKL_TXL_ASSETS_V

Product:	OKL - Lease and Finance Management
Description:	A contract line level transaction table to record various asset attributes needed by Fixed Asset Module before activating the contract.
Implementation/DBA Data:	APPS.OKL_TXL_ASSETS_V

View Text

SELECT TALB.ROWID ROW_ID
, TALB.ID ID
, TALB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, TALT.SFWT_FLAG SFWT_FLAG
, TALB.TAS_ID TAS_ID
, TALB.ILO_ID ILO_ID
, TALB.ILO_ID_OLD ILO_ID_OLD
, TALB.IAY_ID IAY_ID
, TALB.IAY_ID_NEW IAY_ID_NEW
, TALB.KLE_ID KLE_ID
, TALB.DNZ_KHR_ID DNZ_KHR_ID
, TALB.LINE_NUMBER LINE_NUMBER
, TALB.ORG_ID ORG_ID
, TALB.TAL_TYPE TAL_TYPE
, TALB.ASSET_NUMBER ASSET_NUMBER
, TALT.DESCRIPTION DESCRIPTION
, TALB.FA_LOCATION_ID FA_LOCATION_ID
, TALB.ORIGINAL_COST ORIGINAL_COST
, TALB.CURRENT_UNITS CURRENT_UNITS
, TALB.MANUFACTURER_NAME MANUFACTURER_NAME
, TALB.YEAR_MANUFACTURED YEAR_MANUFACTURED
, TALB.SUPPLIER_ID SUPPLIER_ID
, TALB.USED_ASSET_YN USED_ASSET_YN
, TALB.TAG_NUMBER TAG_NUMBER
, TALB.MODEL_NUMBER MODEL_NUMBER
, TALB.CORPORATE_BOOK CORPORATE_BOOK
, TALB.DATE_PURCHASED DATE_PURCHASED
, TALB.DATE_DELIVERY DATE_DELIVERY
, TALB.IN_SERVICE_DATE IN_SERVICE_DATE
, TALB.LIFE_IN_MONTHS LIFE_IN_MONTHS
, TALB.DEPRECIATION_ID DEPRECIATION_ID
, TALB.DEPRECIATION_COST DEPRECIATION_COST
, TALB.DEPRN_METHOD DEPRN_METHOD
, TALB.DEPRN_RATE DEPRN_RATE
, TALB.SALVAGE_VALUE SALVAGE_VALUE
, TALB.PERCENT_SALVAGE_VALUE PERCENT_SALVAGE_VALUE
, TALB.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, TALB.ATTRIBUTE1 ATTRIBUTE1
, TALB.ATTRIBUTE2 ATTRIBUTE2
, TALB.ATTRIBUTE3 ATTRIBUTE3
, TALB.ATTRIBUTE4 ATTRIBUTE4
, TALB.ATTRIBUTE5 ATTRIBUTE5
, TALB.ATTRIBUTE6 ATTRIBUTE6
, TALB.ATTRIBUTE7 ATTRIBUTE7
, TALB.ATTRIBUTE8 ATTRIBUTE8
, TALB.ATTRIBUTE9 ATTRIBUTE9
, TALB.ATTRIBUTE10 ATTRIBUTE10
, TALB.ATTRIBUTE11 ATTRIBUTE11
, TALB.ATTRIBUTE12 ATTRIBUTE12
, TALB.ATTRIBUTE13 ATTRIBUTE13
, TALB.ATTRIBUTE14 ATTRIBUTE14
, TALB.ATTRIBUTE15 ATTRIBUTE15
, TALB.CREATED_BY CREATED_BY
, TALB.CREATION_DATE CREATION_DATE
, TALB.LAST_UPDATED_BY LAST_UPDATED_BY
, TALB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, TALB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, TALB.DEPRECIATE_YN DEPRECIATE_YN
, TALB.HOLD_PERIOD_DAYS HOLD_PERIOD_DAYS
, TALB.OLD_SALVAGE_VALUE OLD_SALVAGE_VALUE
, TALB.NEW_RESIDUAL_VALUE NEW_RESIDUAL_VALUE
, TALB.OLD_RESIDUAL_VALUE OLD_RESIDUAL_VALUE
, TALB.UNITS_RETIRED UNITS_RETIRED
, TALB.COST_RETIRED COST_RETIRED
, TALB.SALE_PROCEEDS SALE_PROCEEDS
, TALB.REMOVAL_COST REMOVAL_COST
, TALB.DNZ_ASSET_ID DNZ_ASSET_ID
, TALB.DATE_DUE DATE_DUE
, TALB.REP_ASSET_ID REP_ASSET_ID
, TALB.LKE_ASSET_ID LKE_ASSET_ID
, TALB.MATCH_AMOUNT MATCH_AMOUNT
, TALB.SPLIT_INTO_SINGLES_FLAG SPLIT_INTO_SINGLES_FLAG
, TALB.SPLIT_INTO_UNITS SPLIT_INTO_UNITS
, TALB.CURRENCY_CODE CURRENCY_CODE
, TALB.CURRENCY_CONVERSION_TYPE CURRENCY_CONVERSION_TYPE
, TALB.CURRENCY_CONVERSION_RATE CURRENCY_CONVERSION_RATE
, TALB.CURRENCY_CONVERSION_DATE CURRENCY_CONVERSION_DATE
, TALB.ASSET_KEY_ID ASSET_KEY_ID
, TALB.FA_TRX_DATE FA_TRX_DATE
, TALB.RESIDUAL_SHR_PARTY_ID RESIDUAL_SHR_PARTY_ID
, TALB.RESIDUAL_SHR_AMOUNT RESIDUAL_SHR_AMOUNT
, TALB.RETIREMENT_ID RETIREMENT_ID
, TALB.FA_COST FA_COST
FROM OKL_TXL_ASSETS_B TALB
, OKL_TXL_ASSETS_TL TALT
WHERE TALB.ID = TALT.ID
AND TALT.LANGUAGE = USERENV('LANG')

Columns