FND Design Data [Home] [Help]

Table: FA_DISTRIBUTION_HISTORY

Product: OFA - Assets
Description: Employee, location, and Accounting Flexfield values assigned to each asset
Implementation/DBA Data: TableFA.FA_DISTRIBUTION_HISTORY
Primary Key: FA_DISTRIBUTION_HISTORY_PK
  1. ColumnDISTRIBUTION_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
FA_DISTRIBUTION_HISTORY FK Joins to TableFA_ADDITIONS_B FA_DISTRIBUTION_HISTORY.ASSET_ID
FA_DISTRIBUTION_HISTORY FK Joins to TableFA_BOOK_CONTROLS FA_DISTRIBUTION_HISTORY.BOOK_TYPE_CODE
FA_DISTRIBUTION_HISTORY FK Joins to TableGL_CODE_COMBINATIONS FA_DISTRIBUTION_HISTORY.CODE_COMBINATION_ID
FA_DISTRIBUTION_HISTORY FK Joins to TableFA_LOCATIONS FA_DISTRIBUTION_HISTORY.LOCATION_ID
FA_DISTRIBUTION_HISTORY FK Joins to TableFA_TRANSACTION_HEADERS FA_DISTRIBUTION_HISTORY.TRANSACTION_HEADER_ID_IN
FA_DISTRIBUTION_HISTORY FK Joins to TableFA_TRANSACTION_HEADERS FA_DISTRIBUTION_HISTORY.TRANSACTION_HEADER_ID_OUT
FA_DISTRIBUTION_HISTORY FK Joins to TableFA_RETIREMENTS FA_DISTRIBUTION_HISTORY.RETIREMENT_ID
FA_DISTRIBUTION_HISTORY FK Joins to TableFA_BOOKS FA_DISTRIBUTION_HISTORY.TRANSACTION_HEADER_ID_IN
TableCUN_NON_SERIALIZED_UNITS FK Joins to FA_DISTRIBUTION_HISTORY CUN_NON_SERIALIZED_UNITS.FA_DISTRIBUTION_ID
TableCUN_SERIALIZED_UNITS FK Joins to FA_DISTRIBUTION_HISTORY CUN_SERIALIZED_UNITS.FA_DISTRIBUTION_ID
TableFA_ADJUSTMENTS FK Joins to FA_DISTRIBUTION_HISTORY FA_ADJUSTMENTS.DISTRIBUTION_ID
TableFA_CAPITAL_BUDGET FK Joins to FA_DISTRIBUTION_HISTORY FA_CAPITAL_BUDGET.DISTRIBUTION_ID
TableFA_DEFERRED_DEPRN FK Joins to FA_DISTRIBUTION_HISTORY FA_DEFERRED_DEPRN.DISTRIBUTION_ID
TableFA_DEPRN_DETAIL FK Joins to FA_DISTRIBUTION_HISTORY FA_DEPRN_DETAIL.DISTRIBUTION_ID
TableFA_DISTRIBUTION_ACCOUNTS FK Joins to FA_DISTRIBUTION_HISTORY FA_DISTRIBUTION_ACCOUNTS.DISTRIBUTION_ID
TableFA_MASS_EXT_RETIREMENTS FK Joins to FA_DISTRIBUTION_HISTORY FA_MASS_EXT_RETIREMENTS.DISTRIBUTION_ID
TableFA_MC_ADJUSTMENTS FK Joins to FA_DISTRIBUTION_HISTORY FA_MC_ADJUSTMENTS.DISTRIBUTION_ID
TableFA_MC_DEFERRED_DEPRN FK Joins to FA_DISTRIBUTION_HISTORY FA_MC_DEFERRED_DEPRN.DISTRIBUTION_ID
TableFA_MC_DEPRN_DETAIL FK Joins to FA_DISTRIBUTION_HISTORY FA_MC_DEPRN_DETAIL.DISTRIBUTION_ID
TableFA_TRANSFER_DETAILS FK Joins to FA_DISTRIBUTION_HISTORY FA_TRANSFER_DETAILS.DISTRIBUTION_ID
TableIA_REQUEST_DETAILS FK Joins to FA_DISTRIBUTION_HISTORY IA_REQUEST_DETAILS.FROM_DISTRIBUTION_ID
TableIA_REQUEST_DETAILS FK Joins to FA_DISTRIBUTION_HISTORY IA_REQUEST_DETAILS.TO_DISTRIBUTION_ID
TableJL_CO_FA_ADJUSTMENTS FK Joins to FA_DISTRIBUTION_HISTORY JL_CO_FA_ADJUSTMENTS.DISTRIBUTION_ID
TableJL_ZZ_FA_RETIREMNT_ADJS FK Joins to FA_DISTRIBUTION_HISTORY JL_ZZ_FA_RETIREMNT_ADJS.DISTRIBUTION_ID