View: FA_RESERVE_TRANSFERS_V

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

View Text

SELECT TRX.TRX_REFERENCE_ID
, TRX.BOOK_TYPE_CODE
, TRX.SRC_ASSET_ID
, AD_SRC.ASSET_NUMBER SRC_ASSET_NUMBER
, ADTL_SRC.DESCRIPTION SRC_DESCRIPTION
, TRX.SRC_TRANSACTION_HEADER_ID
, TRX.DEST_ASSET_ID
, AD_DEST.ASSET_NUMBER DEST_ASSET_NUMBER
, ADTL_DEST.DESCRIPTION DEST_DESCRIPTION
, TRX.DEST_TRANSACTION_HEADER_ID
, TRX.RESERVE_TRANSFER_AMOUNT
, DP.PERIOD_COUNTER
, DP.PERIOD_NAME
FROM FA_TRX_REFERENCES TRX
, FA_ADDITIONS_B AD_SRC
, FA_ADDITIONS_TL ADTL_SRC
, FA_ADDITIONS_B AD_DEST
, FA_ADDITIONS_TL ADTL_DEST
, FA_DEPRN_PERIODS DP
WHERE TRX.TRANSACTION_TYPE = 'RESERVE TRANSFER'
AND AD_SRC.ASSET_ID = TRX.SRC_ASSET_ID
AND ADTL_SRC.ASSET_ID = AD_SRC.ASSET_ID
AND ADTL_SRC.LANGUAGE = USERENV('LANG')
AND AD_DEST.ASSET_ID = TRX.DEST_ASSET_ID
AND ADTL_DEST.ASSET_ID = AD_DEST.ASSET_ID
AND ADTL_DEST.LANGUAGE = USERENV('LANG')
AND TRX.BOOK_TYPE_CODE = DP.BOOK_TYPE_CODE
AND TRX.CREATION_DATE BETWEEN DP.PERIOD_OPEN_DATE
AND NVL(DP.PERIOD_CLOSE_DATE
, SYSDATE)

Columns