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.

VIEW: APPS.FA_DEPRN_GROUPS_V

Source

View Text - Preformatted


SELECT ds.book_type_code, ds.group_asset_id, dp.period_name, ds.period_counter, ds.deprn_amount, ds.deprn_reserve, dh.code_combination_id from fa_group_deprn_summary ds, fa_group_deprn_detail dd, fa_distribution_history dh, fa_deprn_periods dp WHERE dd.distribution_id = dh.distribution_id and dd.book_type_code = ds.book_type_code and dd.group_asset_id = ds.group_asset_id and dd.period_counter = ds.period_counter and dp.book_type_code = ds.book_type_code and dp.period_counter = ds.period_counter

View Text - HTML Formatted

SELECT DS.BOOK_TYPE_CODE
, DS.GROUP_ASSET_ID
, DP.PERIOD_NAME
, DS.PERIOD_COUNTER
, DS.DEPRN_AMOUNT
, DS.DEPRN_RESERVE
, DH.CODE_COMBINATION_ID
FROM FA_GROUP_DEPRN_SUMMARY DS
, FA_GROUP_DEPRN_DETAIL DD
, FA_DISTRIBUTION_HISTORY DH
, FA_DEPRN_PERIODS DP
WHERE DD.DISTRIBUTION_ID = DH.DISTRIBUTION_ID
AND DD.BOOK_TYPE_CODE = DS.BOOK_TYPE_CODE
AND DD.GROUP_ASSET_ID = DS.GROUP_ASSET_ID
AND DD.PERIOD_COUNTER = DS.PERIOD_COUNTER
AND DP.BOOK_TYPE_CODE = DS.BOOK_TYPE_CODE
AND DP.PERIOD_COUNTER = DS.PERIOD_COUNTER