FA_TRANSACTIONS_V

Details

• Schema: FUSION

• Object owner: FA

• Object type: VIEW

Columns

Name
ASSET_ID ASSET_NUMBER DESCRIPTION TRANSACTION_HEADER_ID TRANSACTION_TYPE_CODE BOOK_TYPE_CODE INVOICE_TRANSACTION_ID TRX_REFERENCE_ID PERIOD_COUNTER PERIOD_NAME

Query

SQL_Statement

SELECT th.asset_id , ad.asset_number , adtl.description , th.transaction_header_id , th.transaction_type_code , th.book_type_code , th.invoice_transaction_id , th.trx_reference_id , dp.period_counter , dp.period_name from fa_transaction_headers th , fa_additions_b ad , fa_additions_tl adtl , fa_deprn_periods dp WHERE th.asset_id = ad.asset_id and adtl.asset_id = ad.asset_id and adtl.language = USERENV('LANG') and th.book_type_code = dp.book_type_code and th.date_effective between dp.period_open_date and nvl(dp.period_close_date, sysdate) UNION SELECT th.asset_id , ad.asset_number , adtl.description , th.transaction_header_id , th.transaction_type_code , dp.book_type_code , th.invoice_transaction_id , th.trx_reference_id , dp.period_counter , dp.period_name from fa_transaction_headers th , fa_additions_b ad , fa_additions_tl adtl , fa_deprn_periods dp , fa_book_controls fbc WHERE th.asset_id = ad.asset_id and adtl.asset_id = ad.asset_id and adtl.language = USERENV('LANG') and th.book_type_code = fbc.distribution_source_book and fbc.book_type_code = dp.book_type_code and th.transaction_type_code in ( 'TRANSFER','RECLASS', 'UNIT ADJUSTMENT','REINSTATEMENT','TRANSFER OUT') and th.date_effective between dp.period_open_date and nvl(dp.period_close_date, sysdate)