FA_LEASE_EXPENSE_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 LEASE_RUN_ID EVENT_ID REVERSAL_EVENT_ID LEDGER_ID

Query

SQL_Statement

SELECT ad.asset_id, ad.asset_number, adtl.description, le.book_type_code, le.period_counter, dp.period_name, le.lease_run_id, le.event_id, le.reversal_event_id, le.ledger_id from fa_lease_expense_events le, fa_additions_b ad, fa_additions_tl adtl, fa_deprn_periods dp WHERE ad.asset_id = le.asset_id and adtl.asset_id = ad.asset_id and adtl.language = USERENV('LANG') and le.book_type_code = dp.book_type_code and le.period_counter = dp.period_counter