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_EVENTS_V

Source

View Text - Preformatted


SELECT ad.asset_id, ad.asset_number, adtl.description, de.book_type_code, de.period_counter, dp.period_name, de.deprn_run_id, de.event_id, de.reversal_event_id from fa_deprn_events de, fa_additions_b ad, fa_additions_tl adtl, fa_deprn_periods dp WHERE ad.asset_id = de.asset_id and adtl.asset_id = ad.asset_id and adtl.language = USERENV('LANG') and de.book_type_code = dp.book_type_code and de.period_counter = dp.period_counter

View Text - HTML Formatted

SELECT AD.ASSET_ID
, AD.ASSET_NUMBER
, ADTL.DESCRIPTION
, DE.BOOK_TYPE_CODE
, DE.PERIOD_COUNTER
, DP.PERIOD_NAME
, DE.DEPRN_RUN_ID
, DE.EVENT_ID
, DE.REVERSAL_EVENT_ID
FROM FA_DEPRN_EVENTS DE
, FA_ADDITIONS_B AD
, FA_ADDITIONS_TL ADTL
, FA_DEPRN_PERIODS DP
WHERE AD.ASSET_ID = DE.ASSET_ID
AND ADTL.ASSET_ID = AD.ASSET_ID
AND ADTL.LANGUAGE = USERENV('LANG')
AND DE.BOOK_TYPE_CODE = DP.BOOK_TYPE_CODE
AND DE.PERIOD_COUNTER = DP.PERIOD_COUNTER