[Home] [Help]
View: FA_BOOKS_GROUPS_V1
Product: | OFA - Assets |
Description: | Updates NBV and reserve of group assets with depreciation adjustments |
Implementation/DBA Data: |
APPS.FA_BOOKS_GROUPS_V1
|
View Text
SELECT BG.CONCATENATED_SEGMENTS
, BG.GROUP_ASSET_ID
, BG.COST
, BG.ADJUSTED_COST
, BG.NBV - NVL(CA.CURR_ADJUSTMENT_TOTAL
, 0)
, BG.DEPRN_RESERVE + NVL(CA.CURR_ADJUSTMENT_TOTAL
, 0)
, BG.BOOK_TYPE_CODE
, BG.DATE_INEFFECTIVE
FROM FA_BOOKS_GROUPS_V BG
, FA_CURR_DEPRN_ADJ_V CA
WHERE CA.ASSET_ID(+) = BG.GROUP_ASSET_ID
AND CA.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 |