VIEW: APPS.OKL_TXL_ASSETS_V

Source

View Text - Preformatted

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')

View Text - HTML Formatted

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')