FND Design Data [Home] [Help]

Table: MTL_CATEGORIES_B

Product: INV - Inventory
Description: Code combinations table for Item Category
Implementation/DBA Data: TableINV.MTL_CATEGORIES_B
Primary Key: MTL_CATEGORIES_B_PK
  1. ColumnCATEGORY_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
TableAR_REVENUE_ADJUSTMENTS_ALL FK Joins to MTL_CATEGORIES_B AR_REVENUE_ADJUSTMENTS_ALL.FROM_CATEGORY_ID
TableAR_REVENUE_ADJUSTMENTS_ALL FK Joins to MTL_CATEGORIES_B AR_REVENUE_ADJUSTMENTS_ALL.TO_CATEGORY_ID
TableAS_AP_TRACKING_OBJECTIVES FK Joins to MTL_CATEGORIES_B AS_AP_TRACKING_OBJECTIVES.PRODUCT_CATEGORY_ID
TableAS_INTEREST_CODES_B FK Joins to MTL_CATEGORIES_B AS_INTEREST_CODES_B.CATEGORY_ID
TableCSI_I_EXTENDED_ATTRIBS FK Joins to MTL_CATEGORIES_B CSI_I_EXTENDED_ATTRIBS.ITEM_CATEGORY_ID
TableCSP_EXCESS_RULES_B FK Joins to MTL_CATEGORIES_B CSP_EXCESS_RULES_B.CATEGORY_ID
TableCSP_PLANNING_PARAMETERS FK Joins to MTL_CATEGORIES_B CSP_PLANNING_PARAMETERS.CATEGORY_ID
TableCSS_DEF_CAT_PROD_DENORM FK Joins to MTL_CATEGORIES_B CSS_DEF_CAT_PROD_DENORM.CATEGORY_ID
TableCSS_DEF_PROD_CAT_HRCHY FK Joins to MTL_CATEGORIES_B CSS_DEF_PROD_CAT_HRCHY.CATEGORY_ID
TableCSS_DEF_PROD_CAT_HRCHY FK Joins to MTL_CATEGORIES_B CSS_DEF_PROD_CAT_HRCHY.PARENT_CATEGORY_ID
TableCST_COST_TYPE_HISTORY FK Joins to MTL_CATEGORIES_B CST_COST_TYPE_HISTORY.CATEGORY_ID
TableCST_COST_UPDATES FK Joins to MTL_CATEGORIES_B CST_COST_UPDATES.CATEGORY_ID
TableCST_ITEM_OVERHEAD_DEFAULTS FK Joins to MTL_CATEGORIES_B CST_ITEM_OVERHEAD_DEFAULTS.CATEGORY_ID
TableCS_INCIDENTS_ALL_B FK Joins to MTL_CATEGORIES_B CS_INCIDENTS_ALL_B.CATEGORY_ID
TableCS_SR_PROB_CODE_MAPPING FK Joins to MTL_CATEGORIES_B CS_SR_PROB_CODE_MAPPING.CATEGORY_ID
TableCS_SR_PROB_CODE_MAPPING_DETAIL FK Joins to MTL_CATEGORIES_B CS_SR_PROB_CODE_MAPPING_DETAIL.CATEGORY_ID
TableCS_SR_RES_CODE_MAPPING FK Joins to MTL_CATEGORIES_B CS_SR_RES_CODE_MAPPING.CATEGORY_ID
TableCS_SR_RES_CODE_MAPPING_DETAIL FK Joins to MTL_CATEGORIES_B CS_SR_RES_CODE_MAPPING_DETAIL.CATEGORY_ID
TableHZ_CREDIT_PROFILES FK Joins to MTL_CATEGORIES_B HZ_CREDIT_PROFILES.ITEM_CATEGORY_ID
TableIBE_CT_IMEDIA_SEARCH FK Joins to MTL_CATEGORIES_B IBE_CT_IMEDIA_SEARCH.CATEGORY_ID
TableIBE_CT_RELATION_RULES FK Joins to MTL_CATEGORIES_B IBE_CT_RELATION_RULES.ORIGIN_OBJECT_ID
TableIBE_CT_RELATION_RULES FK Joins to MTL_CATEGORIES_B IBE_CT_RELATION_RULES.DEST_OBJECT_ID
TableIBE_DSP_OBJ_LGL_CTNT FK Joins to MTL_CATEGORIES_B IBE_DSP_OBJ_LGL_CTNT.OBJECT_ID
TableIBE_DSP_TPL_CTG FK Joins to MTL_CATEGORIES_B IBE_DSP_TPL_CTG.CATEGORY_ID
Table% FK Joins to MTL_CATEGORIES_B
TableICX_RELATED_CATEGORIES FK Joins to MTL_CATEGORIES_B ICX_RELATED_CATEGORIES.CATEGORY_ID
TableICX_RELATED_CATEGORIES FK Joins to MTL_CATEGORIES_B ICX_RELATED_CATEGORIES.RELATED_CATEGORY_ID
Table% FK Joins to MTL_CATEGORIES_B
TableIGR_EPU_CATEGORY_UPG FK Joins to MTL_CATEGORIES_B IGR_EPU_CATEGORY_UPG.PRODUCT_CATEGORY_ID
TableIGR_IS_I_LINES FK Joins to MTL_CATEGORIES_B IGR_IS_I_LINES.PRODUCT_CATEGORY_ID
TableIGR_I_LINES_INT FK Joins to MTL_CATEGORIES_B IGR_I_LINES_INT.PRODUCT_CATEGORY_ID
TableIGR_I_PKGITM_ASSIGN FK Joins to MTL_CATEGORIES_B IGR_I_PKGITM_ASSIGN.PRODUCT_CATEGORY_ID
TableJTF_DSP_OBJ_LGL_CTNT FK Joins to MTL_CATEGORIES_B JTF_DSP_OBJ_LGL_CTNT.OBJECT_ID
TableJTF_DSP_TPL_CTG FK Joins to MTL_CATEGORIES_B JTF_DSP_TPL_CTG.CATEGORY_ID
TableMRP_SR_ASSIGNMENTS FK Joins to MTL_CATEGORIES_B MRP_SR_ASSIGNMENTS.CATEGORY_ID
TableMRP_SYSTEM_ITEMS FK Joins to MTL_CATEGORIES_B MRP_SYSTEM_ITEMS.CATEGORY_ID
TableFTE_LANE_COMMODITIES FK Joins to MTL_CATEGORIES_B FTE_LANE_COMMODITIES.COMMODITY_CATG_ID
TableMTL_CATEGORIES_TL FK Joins to MTL_CATEGORIES_B MTL_CATEGORIES_TL.CATEGORY_ID
TableMTL_CATEGORY_ACCOUNTS FK Joins to MTL_CATEGORIES_B MTL_CATEGORY_ACCOUNTS.CATEGORY_ID
TableMTL_CATEGORY_SETS_B FK Joins to MTL_CATEGORIES_B MTL_CATEGORY_SETS_B.DEFAULT_CATEGORY_ID
TableMTL_CATEGORY_SET_VALID_CATS FK Joins to MTL_CATEGORIES_B MTL_CATEGORY_SET_VALID_CATS.CATEGORY_ID
TableMTL_FISCAL_CAT_ACCOUNTS FK Joins to MTL_CATEGORIES_B MTL_FISCAL_CAT_ACCOUNTS.CATEGORY_ID
TableMTL_ICG_CATEGORIES FK Joins to MTL_CATEGORIES_B MTL_ICG_CATEGORIES.CATEGORY_ID
TableMTL_SUPPLY FK Joins to MTL_CATEGORIES_B MTL_SUPPLY.CATEGORY_ID
TablePA_RESOURCE_ASSIGNMENTS FK Joins to MTL_CATEGORIES_B PA_RESOURCE_ASSIGNMENTS.ITEM_CATEGORY_ID
TablePA_RESOURCE_LIST_MEMBERS FK Joins to MTL_CATEGORIES_B PA_RESOURCE_LIST_MEMBERS.ITEM_CATEGORY_ID
TablePJM_DEFAULT_TASKS FK Joins to MTL_CATEGORIES_B PJM_DEFAULT_TASKS.CATEGORY_ID
TablePON_AUCTION_ITEM_PRICES_ALL FK Joins to MTL_CATEGORIES_B PON_AUCTION_ITEM_PRICES_ALL.CATEGORY_ID
TablePON_AUCTION_TEMPLATES FK Joins to MTL_CATEGORIES_B PON_AUCTION_TEMPLATES.CATEGORY_ID
TablePON_AUC_ITEMS_INTERFACE FK Joins to MTL_CATEGORIES_B PON_AUC_ITEMS_INTERFACE.CATEGORY_ID
TablePO_AGENTS FK Joins to MTL_CATEGORIES_B PO_AGENTS.CATEGORY_ID
TablePO_COMMODITY_CATEGORIES FK Joins to MTL_CATEGORIES_B PO_COMMODITY_CATEGORIES.CATEGORY_ID
TablePO_LINES_ARCHIVE_ALL FK Joins to MTL_CATEGORIES_B PO_LINES_ARCHIVE_ALL.CATEGORY_ID
TablePO_LINES_ALL FK Joins to MTL_CATEGORIES_B PO_LINES_ALL.CATEGORY_ID
TablePO_LINE_TYPES_B FK Joins to MTL_CATEGORIES_B PO_LINE_TYPES_B.CATEGORY_ID
TablePO_REQEXPRESS_LINES_ALL FK Joins to MTL_CATEGORIES_B PO_REQEXPRESS_LINES_ALL.CATEGORY_ID
TablePO_REQUISITIONS_INTERFACE_ALL FK Joins to MTL_CATEGORIES_B PO_REQUISITIONS_INTERFACE_ALL.CATEGORY_ID
TablePO_REQUISITION_LINES_ALL FK Joins to MTL_CATEGORIES_B PO_REQUISITION_LINES_ALL.CATEGORY_ID
TableRCV_SHIPMENT_LINES FK Joins to MTL_CATEGORIES_B RCV_SHIPMENT_LINES.CATEGORY_ID