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
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
|
|
|