[Home] [Help]
View: 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
Name |
ASSET_ID |
ASSET_NUMBER |
DESCRIPTION |
BOOK_TYPE_CODE |
PERIOD_COUNTER |
PERIOD_NAME |
DEPRN_RUN_ID |
EVENT_ID |
REVERSAL_EVENT_ID |