View: FII_BIS_FANB1_V

View Text

SELECT DP.FISCAL_YEAR
, DP.FISCAL_YEAR - 1 LAST_YEAR
, BC.BOOK_TYPE_CODE
, AD.ATTRIBUTE_CATEGORY_CODE
, SUM(BK.COST)/1000 SUM_DS_ADJUSTED_COST
, SUM(DS.DEPRN_RESERVE)/1000 ACCUM_DEPRECIATION
, SUM(BK.COST - DS.DEPRN_RESERVE)/1000 NET_BOOK_VALUE
FROM FA_DEPRN_SUMMARY DS
, FA_DEPRN_PERIODS DP
, FA_CALENDAR_TYPES CT
, FA_ADDITIONS AD
, FA_CATEGORY_BOOKS CB
, FA_BOOK_CONTROLS BC
, FA_BOOKS BK
WHERE BC.BOOK_CLASS = 'CORPORATE'
AND BC.DATE_INEFFECTIVE IS NULL
AND BC.BOOK_TYPE_CODE = CB.BOOK_TYPE_CODE
AND CB.CATEGORY_ID = AD.ASSET_CATEGORY_ID
AND CT.CALENDAR_TYPE = BC.DEPRN_CALENDAR
AND DP.BOOK_TYPE_CODE = BC.BOOK_TYPE_CODE
AND (DP.PERIOD_NUM = CT.NUMBER_PER_FISCAL_YEAR OR DP.PERIOD_COUNTER = BC.LAST_PERIOD_COUNTER + 1)
AND DS.ASSET_ID = AD.ASSET_ID
AND DS.BOOK_TYPE_CODE = BC.BOOK_TYPE_CODE
AND DS.PERIOD_COUNTER = DECODE( DP.FISCAL_YEAR
, BC.CURRENT_FISCAL_YEAR
, BC.LAST_PERIOD_COUNTER
, DP.PERIOD_COUNTER)
AND BK.BOOK_TYPE_CODE = BC.BOOK_TYPE_CODE
AND BK.ASSET_ID = AD.ASSET_ID
AND NVL(DP.PERIOD_CLOSE_DATE
, SYSDATE) BETWEEN BK.DATE_EFFECTIVE
AND NVL(BK.DATE_INEFFECTIVE
, SYSDATE) GROUP BY BC.BOOK_TYPE_CODE
, BC.BOOK_TYPE_CODE
, DP.FISCAL_YEAR
, AD.ATTRIBUTE_CATEGORY_CODE

Columns