View: OKL_ASSET_DEPRN_UV

Product:	OKL - Lease and Finance Management
Description:
Implementation/DBA Data:	APPS.OKL_ASSET_DEPRN_UV

View Text

SELECT FA.ASSET_ID ASSET_ID
, FA.ASSET_NUMBER ASSET_NUMBER
, FAT.DESCRIPTION ASSET_DESCRIPTION
, FB.BOOK_TYPE_CODE BOOK_TYPE_CODE
, FBC.BOOK_TYPE_NAME BOOK_NAME
, FB.COST DEPRECIABLE_COST
, NVL(TO_CHAR(FB.LIFE_IN_MONTHS)
, '') LIFE_IN_MONTHS
, FB.DATE_PLACED_IN_SERVICE IN_SERVICE_DATE
, FA.ASSET_CATEGORY_ID DEPRECIATION_CATEGORY_ID
, DECODE(CAT.SEGMENT1
, NULL
, NULL
, LTRIM(RTRIM(SEGMENT1
, ' ')
, ' '))|| DECODE(CAT.SEGMENT2
, NULL
, NULL
, '.'||LTRIM(RTRIM(SEGMENT2
, ' ')
, ' '))|| DECODE(CAT.SEGMENT3
, NULL
, NULL
, '.'||LTRIM(RTRIM(SEGMENT3
, ' ')
, ' '))|| DECODE(CAT.SEGMENT4
, NULL
, NULL
, '.'||LTRIM(RTRIM(SEGMENT4
, ' ')
, ' '))|| DECODE(CAT.SEGMENT5
, NULL
, NULL
, '.'||LTRIM(RTRIM(SEGMENT5
, ' ')
, ' '))|| DECODE(CAT.SEGMENT6
, NULL
, NULL
, '.'||LTRIM(RTRIM(SEGMENT6
, ' ')
, ' '))|| DECODE(CAT.SEGMENT7
, NULL
, NULL
, '.'||LTRIM(RTRIM(SEGMENT7
, ' ')
, ' ')) DEPRECIATION_CATEGORY_NAME
, DECODE(FB.PERCENT_SALVAGE_VALUE
, NULL
, FB.SALVAGE_VALUE
, NULL) SALVAGE_VALUE
, FB.PERCENT_SALVAGE_VALUE*100 PERCENT_SALVAGE_VALUE
, FB.DEPRN_METHOD_CODE DEPRECIATION_METHOD
, NVL(TO_CHAR(FB.ADJUSTED_RATE*100)
, '') DEPRECIATION_RATE
, FB.DEPRN_METHOD_CODE DESCRIPTION
, FBC.BOOK_CLASS BOOK_CLASS
FROM FA_CATEGORIES_B CAT
, FA_BOOK_CONTROLS FBC
, FA_BOOKS FB
, FA_ADDITIONS_TL FAT
, FA_ADDITIONS_B FA
WHERE CAT.CATEGORY_ID = FA.ASSET_CATEGORY_ID
AND FBC.BOOK_TYPE_CODE = FB.BOOK_TYPE_CODE
AND NVL(TRUNC(FBC.DATE_INEFFECTIVE)
, TRUNC(SYSDATE)+1) > TRUNC(SYSDATE)
AND FB.ASSET_ID = FA.ASSET_ID
AND FB.TRANSACTION_HEADER_ID_OUT IS NULL
AND FB.DATE_INEFFECTIVE IS NULL
AND FB.PERIOD_COUNTER_FULLY_RETIRED IS NULL
AND FAT.ASSET_ID = FA.ASSET_ID
AND FAT.LANGUAGE = USERENV('LANG')

Columns