View: FA_DEFERRED_DEPRN_EVENTS_V

Product:	OFA - Assets
Description:
Implementation/DBA Data:	APPS.FA_DEFERRED_DEPRN_EVENTS_V

View Text

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

Columns