eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

Table: FA_TRANSACTION_HEADERS

Product:	OFA - Assets
Description:	Information about all transactions performed within Oracle Assets
Implementation/DBA Data:	FA.FA_TRANSACTION_HEADERS

Primary Key: FA_TRANSACTION_HEADERS_PK

TRANSACTION_HEADER_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
FA_TRANSACTION_HEADERS	FA_BOOK_CONTROLS	FA_TRANSACTION_HEADERS.BOOK_TYPE_CODE
FA_TRANSACTION_HEADERS	FA_ADDITIONS_B	FA_TRANSACTION_HEADERS.ASSET_ID
FA_TRANSACTION_HEADERS	FA_INVOICE_TRANSACTIONS	FA_TRANSACTION_HEADERS.INVOICE_TRANSACTION_ID
FA_TRANSACTION_HEADERS	FA_TRANSACTION_HEADERS	FA_TRANSACTION_HEADERS.SOURCE_TRANSACTION_HEADER_ID
FA_TRANSACTION_HEADERS	FA_TRANSACTION_HEADERS	FA_TRANSACTION_HEADERS.MEMBER_TRANSACTION_HEADER_ID
FA_TRANSACTION_HEADERS	FA_TRX_REFERENCES	FA_TRANSACTION_HEADERS.TRX_REFERENCE_ID
FA_ADJUSTMENTS	FA_TRANSACTION_HEADERS	FA_ADJUSTMENTS.TRANSACTION_HEADER_ID
FA_ASSET_HISTORY	FA_TRANSACTION_HEADERS	FA_ASSET_HISTORY.TRANSACTION_HEADER_ID_IN
FA_ASSET_HISTORY	FA_TRANSACTION_HEADERS	FA_ASSET_HISTORY.TRANSACTION_HEADER_ID_OUT
FA_BOOKS	FA_TRANSACTION_HEADERS	FA_BOOKS.TRANSACTION_HEADER_ID_IN
FA_BOOKS	FA_TRANSACTION_HEADERS	FA_BOOKS.TRANSACTION_HEADER_ID_OUT
FA_CAPITAL_BUDGET	FA_TRANSACTION_HEADERS	FA_CAPITAL_BUDGET.TRANSFER_HEADER_ID
FA_DISTRIBUTION_HISTORY	FA_TRANSACTION_HEADERS	FA_DISTRIBUTION_HISTORY.TRANSACTION_HEADER_ID_IN
FA_DISTRIBUTION_HISTORY	FA_TRANSACTION_HEADERS	FA_DISTRIBUTION_HISTORY.TRANSACTION_HEADER_ID_OUT
FA_MC_ADJUSTMENTS	FA_TRANSACTION_HEADERS	FA_MC_ADJUSTMENTS.TRANSACTION_HEADER_ID
FA_MC_BOOKS	FA_TRANSACTION_HEADERS	FA_MC_BOOKS.TRANSACTION_HEADER_ID_IN
FA_MC_BOOKS	FA_TRANSACTION_HEADERS	FA_MC_BOOKS.TRANSACTION_HEADER_ID_OUT
FA_MC_BOOKS_RATES	FA_TRANSACTION_HEADERS	FA_MC_BOOKS_RATES.TRANSACTION_HEADER_ID
FA_MC_RETIREMENTS	FA_TRANSACTION_HEADERS	FA_MC_RETIREMENTS.TRANSACTION_HEADER_ID_IN
FA_MC_RETIREMENTS	FA_TRANSACTION_HEADERS	FA_MC_RETIREMENTS.TRANSACTION_HEADER_ID_OUT
FA_PARALLEL_WORKERS	FA_TRANSACTION_HEADERS	FA_PARALLEL_WORKERS.CORP_TRANSACTION_HEADER_ID
FA_PARALLEL_WORKERS	FA_TRANSACTION_HEADERS	FA_PARALLEL_WORKERS.TAX_TRANSACTION_HEADER_ID
FA_PARALLEL_WORKERS	FA_TRANSACTION_HEADERS	FA_PARALLEL_WORKERS.TRANSACTION_TYPE_CODE
FA_RETIREMENTS	FA_TRANSACTION_HEADERS	FA_RETIREMENTS.TRANSACTION_HEADER_ID_IN
FA_RETIREMENTS	FA_TRANSACTION_HEADERS	FA_RETIREMENTS.TRANSACTION_HEADER_ID_OUT
FA_TRANSACTION_HEADERS	FA_TRANSACTION_HEADERS	FA_TRANSACTION_HEADERS.SOURCE_TRANSACTION_HEADER_ID
FA_TRANSACTION_HEADERS	FA_TRANSACTION_HEADERS	FA_TRANSACTION_HEADERS.MEMBER_TRANSACTION_HEADER_ID
FA_TRANSFER_DETAILS	FA_TRANSACTION_HEADERS	FA_TRANSFER_DETAILS.TRANSFER_HEADER_ID
FA_TRX_REFERENCES	FA_TRANSACTION_HEADERS	FA_TRX_REFERENCES.SRC_TRANSACTION_HEADER_ID
FA_TRX_REFERENCES	FA_TRANSACTION_HEADERS	FA_TRX_REFERENCES.DEST_TRANSACTION_HEADER_ID
FA_TRX_REFERENCES	FA_TRANSACTION_HEADERS	FA_TRX_REFERENCES.MEMBER_TRANSACTION_HEADER_ID
OKL_EXT_FA_LINE_SOURCES_B	FA_TRANSACTION_HEADERS	OKL_EXT_FA_LINE_SOURCES_B.FA_TRANSACTION_ID
PA_PROJECT_ASSET_LINES_ALL	FA_TRANSACTION_HEADERS	PA_PROJECT_ASSET_LINES_ALL.RET_ADJUSTMENT_TXN_ID