VIEW: APPS.FA_CURR_DEPRN_ADJ_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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