View: FA_CURR_DEPRN_ADJ_V

Product:	OFA - Assets
Description:	Provides total depreciation for the current period
Implementation/DBA Data:	APPS.FA_CURR_DEPRN_ADJ_V

View Text

SELECT SUM(AD.ADJUSTMENT_AMOUNT * DECODE(ADJUSTMENT_TYPE
, 'EXPENSE'
, DECODE(AD.DEBIT_CREDIT_FLAG
, 'CR'
, -1
, 1)
, 'RESERVE'
, DECODE(AD.DEBIT_CREDIT_FLAG
, 'DR'
, -1
, 1)
, 'GRP COR RESERVE'
, DECODE(AD.DEBIT_CREDIT_FLAG
, 'DR'
, -1
, 1)
, 'GRP PRC RESERVE'
, DECODE(AD.DEBIT_CREDIT_FLAG
, 'DR'
, -1
, 1)))
, AD.BOOK_TYPE_CODE
, AD.ASSET_ID
, AD.PERIOD_COUNTER_ADJUSTED
FROM FA_ADJUSTMENTS AD
WHERE PERIOD_COUNTER_ADJUSTED = (SELECT MAX(DP.PERIOD_COUNTER)
FROM FA_DEPRN_PERIODS DP
WHERE DP.BOOK_TYPE_CODE = AD.BOOK_TYPE_CODE)
AND ADJUSTMENT_TYPE IN ('EXPENSE'
, 'RESERVE'
, 'GRP COR RESERVE'
, 'GRP PRC RESERVE') GROUP BY AD.BOOK_TYPE_CODE
, AD.ASSET_ID
, AD.PERIOD_COUNTER_ADJUSTED

Columns