FA_DEPRN_EVENTS_V

Details

• Schema: FUSION

• Object owner: FA

• Object type: VIEW

Columns

Name
ASSET_ID ASSET_NUMBER DESCRIPTION BOOK_TYPE_CODE PERIOD_COUNTER PERIOD_NAME DEPRN_RUN_ID EVENT_ID REVERSAL_EVENT_ID

Query

SQL_Statement

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