View: FA_BOOKS_GROUPS_V

Product:	OFA - Assets
Description:	Updates NBV and reserve of group assets with depreciation adjustments
Implementation/DBA Data:	APPS.FA_BOOKS_GROUPS_V

View Text

SELECT GA.CONCATENATED_SEGMENTS
, BG.GROUP_ASSET_ID
, BG.COST
, BG.ADJUSTED_COST
, BG.COST - NVL(DS.DEPRN_RESERVE
, 0) NBV
, NVL(DS.DEPRN_RESERVE
, 0) DEPRN_RESERVE
, BG.BOOK_TYPE_CODE
, BG.DATE_INEFFECTIVE
FROM FA_GROUP_ASSETS GA
, FA_BOOKS_GROUPS BG
, FA_DEPRN_SUMMARY DS
WHERE GA.GROUP_ASSET_ID = BG.GROUP_ASSET_ID
AND BG.BOOK_TYPE_CODE = DS.BOOK_TYPE_CODE(+)
AND DS.ASSET_ID(+) = BG.GROUP_ASSET_ID
AND NVL(DS.PERIOD_COUNTER
, -1) = (SELECT NVL(MAX(PERIOD_COUNTER)
, -1)
FROM FA_DEPRN_SUMMARY DS2
WHERE DS2.ASSET_ID = BG.GROUP_ASSET_ID
AND DS2.BOOK_TYPE_CODE = BG.BOOK_TYPE_CODE)

Columns