View: FA_EXTENDED_DEPRN_V

Product:	OFA - Assets
Description:
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
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 FADS.PERIOD_COUNTER = DECODE(NVL(FAB.EXTENDED_DEPRN_FLAG
, 'N')
, 'Y'
, (SELECT MAX(FADS2.PERIOD_COUNTER)
FROM FA_DEPRN_SUMMARY FADS2
WHERE FADS2.BOOK_TYPE_CODE = FADS.BOOK_TYPE_CODE
AND FADS2.ASSET_ID = FADS.ASSET_ID )
, FAB.PERIOD_COUNTER_FULLY_RESERVED)
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 ADT.LANGUAGE = USERENV('LANG')

Columns