View: FA_DEPRN_EVENTS_V

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

View Text

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

Columns