eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[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