FA_RESERVE_TRANSFERS

Details

Schema: FUSION
Object owner: FA
Object type: VIEW

Columns

Name
TRX_REFERENCE_ID BOOK_TYPE_CODE SRC_ASSET_ID SRC_ASSET_NUMBER SRC_DESCRIPTION SRC_TRANSACTION_HEADER_ID DEST_ASSET_ID DEST_ASSET_NUMBER DEST_DESCRIPTION DEST_TRANSACTION_HEADER_ID RESERVE_TRANSFER_AMOUNT PERIOD_COUNTER PERIOD_NAME

Name

TRX_REFERENCE_ID

BOOK_TYPE_CODE

SRC_ASSET_ID

SRC_ASSET_NUMBER

SRC_DESCRIPTION

SRC_TRANSACTION_HEADER_ID

DEST_ASSET_ID

DEST_ASSET_NUMBER

DEST_DESCRIPTION

DEST_TRANSACTION_HEADER_ID

RESERVE_TRANSFER_AMOUNT

PERIOD_COUNTER

PERIOD_NAME

Query

SQL_Statement
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)

SQL_Statement

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)