[Home] [Help]
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
Name |
CONCATENATED_SEGMENTS |
GROUP_ASSET_ID |
COST |
ADJUSTED_COST |
NBV |
DEPRN_RESERVE |
BOOK_TYPE_CODE |
DATE_INEFFECTIVE |