FA_INVOICE_TRANSFERS

Details

Schema: FUSION
Object owner: FA
Object type: VIEW

Columns

Name
SRC_ASSET_ID SRC_ASSET_NUMBER SRC_ASSET_DESCRIPTION SRC_TRANSACTION_HEADER_ID DEST_ASSET_ID DEST_ASSET_NUMBER DEST_ASSET_DESCRIPTION DEST_TRANSACTION_HEADER_ID BOOK_TYPE_CODE INVOICE_TRANSACTION_ID TRX_REFERENCE_ID PERIOD_COUNTER PERIOD_NAME

Name

SRC_ASSET_ID

SRC_ASSET_NUMBER

SRC_ASSET_DESCRIPTION

SRC_TRANSACTION_HEADER_ID

DEST_ASSET_ID

DEST_ASSET_NUMBER

DEST_ASSET_DESCRIPTION

DEST_TRANSACTION_HEADER_ID

BOOK_TYPE_CODE

INVOICE_TRANSACTION_ID

TRX_REFERENCE_ID

PERIOD_COUNTER

PERIOD_NAME

Query

SQL_Statement
SELECT trx.src_asset_id src_asset_id, ad_src.asset_number src_asset_number, adtl_src.description src_asset_description, trx.src_transaction_header_id src_transaction_header_id, trx.dest_asset_id dest_asset_id, ad_dest.asset_number dest_asset_number, adtl_dest.description dest_asset_description, trx.dest_transaction_header_id dest_transaction_header_id, trx.book_type_code, trx.invoice_transaction_id, trx.trx_reference_id, dp.period_counter, dp.period_name from fa_trx_references trx, fa_invoice_transactions it, 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 = 'INVOICE TRANSFER' and it.transaction_type = 'INVOICE TRANSFER' and it.invoice_transaction_id = trx.invoice_transaction_id and it.book_type_code = trx.book_type_code and trx.src_asset_id = ad_src.asset_id and adtl_src.asset_id = ad_src.asset_id and adtl_src.language = USERENV('LANG') and trx.dest_asset_id = ad_dest.asset_id and adtl_dest.asset_id = ad_dest.asset_id and adtl_dest.language = USERENV('LANG') and it.book_type_code = trx.book_type_code 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.src_asset_id src_asset_id, ad_src.asset_number src_asset_number, adtl_src.description src_asset_description, trx.src_transaction_header_id src_transaction_header_id, trx.dest_asset_id dest_asset_id, ad_dest.asset_number dest_asset_number, adtl_dest.description dest_asset_description, trx.dest_transaction_header_id dest_transaction_header_id, trx.book_type_code, trx.invoice_transaction_id, trx.trx_reference_id, dp.period_counter, dp.period_name

from fa_trx_references trx, fa_invoice_transactions it, 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 = 'INVOICE TRANSFER' and it.transaction_type = 'INVOICE TRANSFER' and it.invoice_transaction_id = trx.invoice_transaction_id and it.book_type_code = trx.book_type_code and trx.src_asset_id = ad_src.asset_id and adtl_src.asset_id = ad_src.asset_id and adtl_src.language = USERENV('LANG') and trx.dest_asset_id = ad_dest.asset_id and adtl_dest.asset_id = ad_dest.asset_id and adtl_dest.language = USERENV('LANG') and it.book_type_code = trx.book_type_code 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)