VIEW: APPS.FA_DEFERRED_DEPRN_EVENTS_V

Source

View Text - Preformatted

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_tax.book_type_code and dde.tax_period_counter = dp_tax.period_counter

View Text - HTML Formatted

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_TAX.BOOK_TYPE_CODE
AND DDE.TAX_PERIOD_COUNTER = DP_TAX.PERIOD_COUNTER