VIEW: APPS.OKL_ASSET_DEPRN_UV

Source

View Text - Preformatted

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 fat.asset_id = fa.asset_id and fat.language = userenv('LANG')

View Text - HTML Formatted

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 FAT.ASSET_ID = FA.ASSET_ID
AND FAT.LANGUAGE = USERENV('LANG')