FA_DEFERRED_DEPRN_EVENTS

Details

Schema: FUSION
Object owner: FA
Object type: VIEW

Columns

Name
ASSET_ID ASSET_NUMBER DESCRIPTION CORP_BOOK_TYPE_CODE CORP_PERIOD_COUNTER CORP_PERIOD_NAME TAX_BOOK_TYPE_CODE TAX_PERIOD_COUNTER TAX_PERIOD_NAME EVENT_ID

Name

ASSET_ID

ASSET_NUMBER

DESCRIPTION

CORP_BOOK_TYPE_CODE

CORP_PERIOD_COUNTER

CORP_PERIOD_NAME

TAX_BOOK_TYPE_CODE

TAX_PERIOD_COUNTER

TAX_PERIOD_NAME

EVENT_ID

Query

SQL_Statement
SELECT ad.asset_id, ad.asset_number, adtl.description, dde.corp_book_type_code, dde.corp_period_counter, dp_corp.period_name as corp_period_name, dde.tax_book_type_code, dde.tax_period_counter, dp_tax.period_name as tax_period_name, dde.event_id from fa_deferred_deprn_events dde, fa_additions_b ad, fa_additions_tl adtl, fa_deprn_periods dp_corp, fa_deprn_periods dp_tax WHERE ad.asset_id = dde.asset_id and adtl.asset_id = ad.asset_id and adtl.language = USERENV('LANG') and dde.corp_book_type_code = dp_corp.book_type_code and dde.corp_period_counter = dp_corp.period_counter and dde.tax_book_type_code = dp_corp.book_type_code and dde.tax_period_counter = dp_corp.period_counter

SQL_Statement

SELECT ad.asset_id, ad.asset_number, adtl.description, dde.corp_book_type_code, dde.corp_period_counter, dp_corp.period_name as corp_period_name, dde.tax_book_type_code, dde.tax_period_counter, dp_tax.period_name as tax_period_name, dde.event_id from fa_deferred_deprn_events dde, fa_additions_b ad, fa_additions_tl adtl, fa_deprn_periods dp_corp, fa_deprn_periods dp_tax WHERE ad.asset_id = dde.asset_id and adtl.asset_id = ad.asset_id and adtl.language = USERENV('LANG') and dde.corp_book_type_code = dp_corp.book_type_code and dde.corp_period_counter = dp_corp.period_counter and dde.tax_book_type_code = dp_corp.book_type_code and dde.tax_period_counter = dp_corp.period_counter