View: FA_EXTENDED_DEPRN_V

Product:	OFA - Assets
Description:	FA_EXTENDED_DEPRN_V view is used for extended depreciation.
Implementation/DBA Data:	APPS.FA_EXTENDED_DEPRN_V

View Text

SELECT AD.ASSET_NUMBER
, ADT.DESCRIPTION
, AD.ASSET_TYPE
, AD.ATTRIBUTE_CATEGORY_CODE
, FAB.BOOK_TYPE_CODE
, FAB.DATE_PLACED_IN_SERVICE
, FAB.DEPRN_METHOD_CODE
, FAB.LIFE_IN_MONTHS
, FAB.COST
, FAB.ORIGINAL_COST
, FAB.SALVAGE_VALUE
, FAB.PRORATE_CONVENTION_CODE
, FAB.DEPRECIATE_FLAG
, FAB.ITC_AMOUNT_ID
, FAB.BASIC_RATE
, FAB.ADJUSTED_RATE
, FAB.BONUS_RULE
, FAB.CEILING_NAME
, FAB.FULLY_RSVD_REVALS_COUNTER
, FAB.PERIOD_COUNTER_FULLY_RESERVED
, FAB.PRODUCTION_CAPACITY
, FAB.REVAL_AMORTIZATION_BASIS
, FAB.REVAL_CEILING
, FAB.UNREVALUED_COST
, FAB.ALLOWED_DEPRN_LIMIT
, FAB.ALLOWED_DEPRN_LIMIT_AMOUNT
, FAB.SHORT_FISCAL_YEAR_FLAG
, FAB.CONVERSION_DATE
, FAB.ORIGINAL_DEPRN_START_DATE
, FAB.GROUP_ASSET_ID
, FAB.DEPRN_LIMIT_TYPE
, FAB.EXTENDED_DEPRN_FLAG
, FAB.EXTENDED_DEPRECIATION_PERIOD
, FATH.TRANSACTION_NAME
, FATH.AMORTIZATION_START_DATE
, FADS.DEPRN_RESERVE
, FADS.YTD_DEPRN
, FADS.REVAL_RESERVE
, FADS.YTD_REVAL_DEPRN_EXPENSE
, FADP.PERIOD_NAME
, FADS.IMPAIRMENT_RESERVE
FROM FA_ADDITIONS_B AD
, FA_ADDITIONS_TL ADT
, FA_BOOKS FAB
, FA_TRANSACTION_HEADERS FATH
, FA_DEPRN_SUMMARY FADS
, FA_DEPRN_PERIODS FADP
WHERE AD.ASSET_ID = ADT.ASSET_ID
AND AD.ASSET_ID = FAB.ASSET_ID
AND AD.ASSET_ID = FATH.ASSET_ID
AND AD.ASSET_ID = FADS.ASSET_ID
AND FAB.BOOK_TYPE_CODE = FATH.BOOK_TYPE_CODE
AND FAB.BOOK_TYPE_CODE = FADP.BOOK_TYPE_CODE
AND FAB.BOOK_TYPE_CODE = FADS.BOOK_TYPE_CODE
AND FAB.TRANSACTION_HEADER_ID_IN = FATH.TRANSACTION_HEADER_ID
AND FAB.PERIOD_COUNTER_FULLY_RESERVED IS NOT NULL
AND FAB.PERIOD_COUNTER_FULLY_RETIRED IS NULL
AND FAB.PERIOD_COUNTER_FULLY_EXTENDED IS NULL
AND FAB.TRANSACTION_HEADER_ID_OUT IS NULL
AND FAB.DEPRECIATE_FLAG = 'YES'
AND FADP.PERIOD_CLOSE_DATE IS NULL
AND FADS.PERIOD_COUNTER = (SELECT MAX(FADS2.PERIOD_COUNTER)
FROM FA_DEPRN_SUMMARY FADS2
, FA_DEPRN_PERIODS FADP2
WHERE FADS2.BOOK_TYPE_CODE = FADS.BOOK_TYPE_CODE
AND FADS2.ASSET_ID = FADS.ASSET_ID
AND FADP2.BOOK_TYPE_CODE = FADS2.BOOK_TYPE_CODE
AND FADS2.PERIOD_COUNTER = FADP2.PERIOD_COUNTER
AND FADP2.PERIOD_CLOSE_DATE IS NOT NULL)
AND FAB.COST > (FADS.IMPAIRMENT_RESERVE + FADS.DEPRN_RESERVE + (SELECT NVL(SUM(DECODE(FAADJ.ADJUSTMENT_TYPE
, 'EXPENSE'
, DECODE (FAADJ.DEBIT_CREDIT_FLAG
, 'DR'
, FAADJ.ADJUSTMENT_AMOUNT
, -1 * FAADJ.ADJUSTMENT_AMOUNT)
, 'RESERVE'
, DECODE (FAADJ.DEBIT_CREDIT_FLAG
, 'CR'
, FAADJ.ADJUSTMENT_AMOUNT
, -1 * FAADJ.ADJUSTMENT_AMOUNT)))
, 0)
FROM FA_ADJUSTMENTS FAADJ
WHERE FAADJ.PERIOD_COUNTER_CREATED = FADP.PERIOD_COUNTER
AND FAADJ.ASSET_ID = FADS.ASSET_ID
AND FAADJ.BOOK_TYPE_CODE = FADS.BOOK_TYPE_CODE))
AND EXISTS ( SELECT '1'
FROM FA_BOOKS FABK
WHERE FABK.ASSET_ID = FAB.ASSET_ID
AND FABK.BOOK_TYPE_CODE = FAB.BOOK_TYPE_CODE
AND FABK.DEPRN_METHOD_CODE <> 'JP-STL-EXTND')
AND ADT.LANGUAGE = USERENV('LANG')

Columns