FND Design Data [Home] [Help]

Table: FA_CATEGORIES_B

Product: OFA - Assets
Description: Default financial information for asset categories (base MLS table)
Implementation/DBA Data: TableFA.FA_CATEGORIES_B
Primary Key: FA_CATEGORIES_B_PK
  1. ColumnCATEGORY_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
TableFA_ADDITIONS_B FK Joins to FA_CATEGORIES_B FA_ADDITIONS_B.ASSET_CATEGORY_ID
TableFA_ASSET_HISTORY FK Joins to FA_CATEGORIES_B FA_ASSET_HISTORY.CATEGORY_ID
TableFA_BUDGET_DISTRIBUTION FK Joins to FA_CATEGORIES_B FA_BUDGET_DISTRIBUTION.CATEGORY_ID
TableFA_CATEGORY_BOOKS FK Joins to FA_CATEGORIES_B FA_CATEGORY_BOOKS.CATEGORY_ID
Table% FK Joins to FA_CATEGORIES_B
TableFA_CATEGORY_BOOK_DEFAULTS FK Joins to FA_CATEGORIES_B FA_CATEGORY_BOOK_DEFAULTS.CATEGORY_ID
TableFA_MAINT_SCHEDULE_HDR FK Joins to FA_CATEGORIES_B FA_MAINT_SCHEDULE_HDR.CATEGORY_ID
TableFA_MASS_ADDITIONS FK Joins to FA_CATEGORIES_B FA_MASS_ADDITIONS.ASSET_CATEGORY_ID
Table% FK Joins to FA_CATEGORIES_B
TableFA_MASS_CHANGES FK Joins to FA_CATEGORIES_B FA_MASS_CHANGES.CATEGORY_ID
TableFA_MASS_RECLASS FK Joins to FA_CATEGORIES_B FA_MASS_RECLASS.FROM_CATEGORY_ID
TableFA_MASS_RECLASS FK Joins to FA_CATEGORIES_B FA_MASS_RECLASS.TO_CATEGORY_ID
TableFA_MASS_RETIREMENTS FK Joins to FA_CATEGORIES_B FA_MASS_RETIREMENTS.CATEGORY_ID
TableFA_MASS_REVALUATION_RULES FK Joins to FA_CATEGORIES_B FA_MASS_REVALUATION_RULES.CATEGORY_ID
TableFA_MASS_REVAL_REP_ITF FK Joins to FA_CATEGORIES_B FA_MASS_REVAL_REP_ITF.ASSET_CATEGORY_ID
TableFA_MASS_TRANSFERS FK Joins to FA_CATEGORIES_B FA_MASS_TRANSFERS.CATEGORY_ID
TableFA_PARALLEL_WORKERS FK Joins to FA_CATEGORIES_B FA_PARALLEL_WORKERS.ASSET_CATEGORY_ID
TableJAI_FA_AST_BLOCK_DTLS FK Joins to FA_CATEGORIES_B JAI_FA_AST_BLOCK_DTLS.ASSET_CATEGORY_ID
TableMTL_SYSTEM_ITEMS_B FK Joins to FA_CATEGORIES_B MTL_SYSTEM_ITEMS_B.ASSET_CATEGORY_ID
TablePA_PROJECT_ASSETS_ALL FK Joins to FA_CATEGORIES_B PA_PROJECT_ASSETS_ALL.ASSET_CATEGORY_ID
TablePA_PROJECT_ASSET_LINES_ALL FK Joins to FA_CATEGORIES_B PA_PROJECT_ASSET_LINES_ALL.ASSET_CATEGORY_ID
TablePA_STANDARD_UNIT_COSTS FK Joins to FA_CATEGORIES_B PA_STANDARD_UNIT_COSTS.ASSET_CATEGORY_ID