FND Design Data [Home] [Help]

Table: MTL_SYSTEM_ITEMS_B

Product: INV - Inventory
Description: Inventory item definitions
Implementation/DBA Data: TableINV.MTL_SYSTEM_ITEMS_B
Primary Key: MTL_SYSTEM_ITEMS_B_PK
  1. ColumnINVENTORY_ITEM_ID
  2. ColumnORGANIZATION_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
MTL_SYSTEM_ITEMS_B FK Joins to TableGL_CODE_COMBINATIONS MTL_SYSTEM_ITEMS_B.COST_OF_SALES_ACCOUNT
MTL_SYSTEM_ITEMS_B FK Joins to TableMTL_PARAMETERS MTL_SYSTEM_ITEMS_B.DEFAULT_SHIPPING_ORG
MTL_SYSTEM_ITEMS_B FK Joins to TableMTL_ITEM_STATUS MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_STATUS_CODE
MTL_SYSTEM_ITEMS_B FK Joins to TableMTL_PARAMETERS MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID
MTL_SYSTEM_ITEMS_B FK Joins to TableMTL_SYSTEM_ITEMS_B MTL_SYSTEM_ITEMS_B.ENGINEERING_ITEM_ID
MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID
MTL_SYSTEM_ITEMS_B FK Joins to TableRA_RULES MTL_SYSTEM_ITEMS_B.ACCOUNTING_RULE_ID
MTL_SYSTEM_ITEMS_B FK Joins to TableMTL_PARAMETERS MTL_SYSTEM_ITEMS_B.SOURCE_ORGANIZATION_ID
MTL_SYSTEM_ITEMS_B FK Joins to TableMTL_SECONDARY_INVENTORIES MTL_SYSTEM_ITEMS_B.SOURCE_SUBINVENTORY
MTL_SYSTEM_ITEMS_B.SOURCE_ORGANIZATION_ID
MTL_SYSTEM_ITEMS_B FK Joins to TablePO_HAZARD_CLASSES_B MTL_SYSTEM_ITEMS_B.HAZARD_CLASS_ID
MTL_SYSTEM_ITEMS_B FK Joins to TableRA_RULES MTL_SYSTEM_ITEMS_B.INVOICING_RULE_ID
MTL_SYSTEM_ITEMS_B FK Joins to TablePO_UN_NUMBERS_B MTL_SYSTEM_ITEMS_B.UN_NUMBER_ID
MTL_SYSTEM_ITEMS_B FK Joins to TableFA_CATEGORIES_B MTL_SYSTEM_ITEMS_B.ASSET_CATEGORY_ID
MTL_SYSTEM_ITEMS_B FK Joins to TableMTL_SYSTEM_ITEMS_B MTL_SYSTEM_ITEMS_B.BASE_ITEM_ID
MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID
MTL_SYSTEM_ITEMS_B FK Joins to TableMTL_ITEM_LOCATIONS MTL_SYSTEM_ITEMS_B.WIP_SUPPLY_LOCATOR_ID
MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID
MTL_SYSTEM_ITEMS_B FK Joins to TableMTL_SECONDARY_INVENTORIES MTL_SYSTEM_ITEMS_B.WIP_SUPPLY_SUBINVENTORY
MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID
MTL_SYSTEM_ITEMS_B FK Joins to TableRCV_ROUTING_HEADERS MTL_SYSTEM_ITEMS_B.RECEIVING_ROUTING_ID
MTL_SYSTEM_ITEMS_B FK Joins to TableMTL_ATP_RULES MTL_SYSTEM_ITEMS_B.ATP_RULE_ID
MTL_SYSTEM_ITEMS_B FK Joins to TableMTL_SYSTEM_ITEMS_B MTL_SYSTEM_ITEMS_B.BASE_WARRANTY_SERVICE_ID
MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID
MTL_SYSTEM_ITEMS_B FK Joins to TableRA_TERMS_B MTL_SYSTEM_ITEMS_B.PAYMENT_TERMS_ID
MTL_SYSTEM_ITEMS_B FK Joins to TableMTL_ITEM_CATALOG_GROUPS_B MTL_SYSTEM_ITEMS_B.ITEM_CATALOG_GROUP_ID
MTL_SYSTEM_ITEMS_B FK Joins to TableGL_CODE_COMBINATIONS MTL_SYSTEM_ITEMS_B.EXPENSE_ACCOUNT
MTL_SYSTEM_ITEMS_B FK Joins to TableGL_CODE_COMBINATIONS MTL_SYSTEM_ITEMS_B.ENCUMBRANCE_ACCOUNT
MTL_SYSTEM_ITEMS_B FK Joins to TableENG_ENGINEERING_CHANGES MTL_SYSTEM_ITEMS_B.ENGINEERING_ECN_CODE
MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID
MTL_SYSTEM_ITEMS_B FK Joins to TableMTL_SYSTEM_ITEMS_B MTL_SYSTEM_ITEMS_B.PRODUCT_FAMILY_ITEM_ID
MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID
MTL_SYSTEM_ITEMS_B FK Joins to TableGL_CODE_COMBINATIONS MTL_SYSTEM_ITEMS_B.SALES_ACCOUNT
MTL_SYSTEM_ITEMS_B FK Joins to TableMTL_PICKING_RULES MTL_SYSTEM_ITEMS_B.PICKING_RULE_ID
MTL_SYSTEM_ITEMS_B FK Joins to TableMTL_PLANNERS MTL_SYSTEM_ITEMS_B.PLANNER_CODE
MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID
TableAHL_INV_SERVICE_ITEM_RELS FK Joins to MTL_SYSTEM_ITEMS_B AHL_INV_SERVICE_ITEM_RELS.INV_ITEM_ID
AHL_INV_SERVICE_ITEM_RELS.INV_ORG_ID
TableAHL_INV_SERVICE_ITEM_RELS FK Joins to MTL_SYSTEM_ITEMS_B AHL_INV_SERVICE_ITEM_RELS.SERVICE_ITEM_ID
AHL_INV_SERVICE_ITEM_RELS.INV_ORG_ID
TableAHL_MR_EFFECTIVITIES FK Joins to MTL_SYSTEM_ITEMS_B AHL_MR_EFFECTIVITIES.INVENTORY_ITEM_ID
AHL_MR_EFFECTIVITIES.INVENTORY_ORG_ID
TableAHL_PRD_DISPOSITIONS_B FK Joins to MTL_SYSTEM_ITEMS_B AHL_PRD_DISPOSITIONS_B.INVENTORY_ITEM_ID
AHL_PRD_DISPOSITIONS_B.ORGANIZATION_ID
TableAHL_PRD_DISPOSITIONS_B_H FK Joins to MTL_SYSTEM_ITEMS_B AHL_PRD_DISPOSITIONS_B_H.INVENTORY_ITEM_ID
AHL_PRD_DISPOSITIONS_B_H.ORGANIZATION_ID
TableAHL_RA_DEFINITION_HDR FK Joins to MTL_SYSTEM_ITEMS_B AHL_RA_DEFINITION_HDR.INVENTORY_ITEM_ID
AHL_RA_DEFINITION_HDR.INVENTORY_ORG_ID
TableAHL_ROUTES_B FK Joins to MTL_SYSTEM_ITEMS_B AHL_ROUTES_B.SERVICE_ITEM_ID
AHL_ROUTES_B.SERVICE_ITEM_ORG_ID
TableAHL_ROUTE_EFFECTIVITIES FK Joins to MTL_SYSTEM_ITEMS_B AHL_ROUTE_EFFECTIVITIES.INVENTORY_ITEM_ID
AHL_ROUTE_EFFECTIVITIES.INVENTORY_MASTER_ORG_ID
TableAHL_RT_OPER_MATERIALS FK Joins to MTL_SYSTEM_ITEMS_B AHL_RT_OPER_MATERIALS.INVENTORY_ITEM_ID
AHL_RT_OPER_MATERIALS.INVENTORY_ORG_ID
TableAHL_RT_OPER_MATERIALS_H FK Joins to MTL_SYSTEM_ITEMS_B AHL_RT_OPER_MATERIALS_H.INVENTORY_ITEM_ID
AHL_RT_OPER_MATERIALS_H.INVENTORY_ORG_ID
TableAHL_UF_HEADERS FK Joins to MTL_SYSTEM_ITEMS_B AHL_UF_HEADERS.INVENTORY_ITEM_ID
AHL_UF_HEADERS.INVENTORY_ORG_ID
TableAHL_VISITS_B FK Joins to MTL_SYSTEM_ITEMS_B AHL_VISITS_B.INVENTORY_ITEM_ID
AHL_VISITS_B.ITEM_ORGANIZATION_ID
TableAHL_VISIT_TASKS_B FK Joins to MTL_SYSTEM_ITEMS_B AHL_VISIT_TASKS_B.INVENTORY_ITEM_ID
AHL_VISIT_TASKS_B.ITEM_ORGANIZATION_ID
TableAHL_WORKORDER_MTL_TXNS FK Joins to MTL_SYSTEM_ITEMS_B AHL_WORKORDER_MTL_TXNS.INVENTORY_ITEM_ID
AHL_WORKORDER_MTL_TXNS.ORGANIZATION_ID
TableAMS_ACT_PRODUCTS FK Joins to MTL_SYSTEM_ITEMS_B AMS_ACT_PRODUCTS.INVENTORY_ITEM_ID
AMS_ACT_PRODUCTS.ORGANIZATION_ID
TableAMS_ITEM_ATTRIBUTES FK Joins to MTL_SYSTEM_ITEMS_B AMS_ITEM_ATTRIBUTES.INVENTORY_ITEM_ID
AMS_ITEM_ATTRIBUTES.ORGANIZATION_ID
TableAS_AP_TRACKING_OBJECTIVES FK Joins to MTL_SYSTEM_ITEMS_B AS_AP_TRACKING_OBJECTIVES.INVENTORY_ITEM_ID
AS_AP_TRACKING_OBJECTIVES.ORGANIZATION_ID
TableAS_COLLATERAL_REQ_ITEMS FK Joins to MTL_SYSTEM_ITEMS_B AS_COLLATERAL_REQ_ITEMS.INVENTORY_ITEM_ID
AS_COLLATERAL_REQ_ITEMS.ORGANIZATION_ID
TableAS_INTEREST_CODES_B FK Joins to MTL_SYSTEM_ITEMS_B AS_INTEREST_CODES_B.PF_ITEM_ID
AS_INTEREST_CODES_B.PF_ORGANIZATION_ID
TableAS_LEAD_LINES_ALL FK Joins to MTL_SYSTEM_ITEMS_B AS_LEAD_LINES_ALL.INVENTORY_ITEM_ID
AS_LEAD_LINES_ALL.ORGANIZATION_ID
TableAS_LEAD_LINES_ALL FK Joins to MTL_SYSTEM_ITEMS_B AS_LEAD_LINES_ALL.INVENTORY_ITEM_ID
AS_LEAD_LINES_ALL.ORGANIZATION_ID
TableAS_PROMOTIONS_ALL FK Joins to MTL_SYSTEM_ITEMS_B AS_PROMOTIONS_ALL.COLLATERAL_INVENTORY_ITEM_ID
AS_PROMOTIONS_ALL.COLLATERAL_ORGANIZATION_ID
TableAS_SALES_LEAD_LINES FK Joins to MTL_SYSTEM_ITEMS_B AS_SALES_LEAD_LINES.INVENTORY_ITEM_ID
AS_SALES_LEAD_LINES.ORGANIZATION_ID
TableAS_SCRIPT_ANSWER_ACTIONS_ALL FK Joins to MTL_SYSTEM_ITEMS_B AS_SCRIPT_ANSWER_ACTIONS_ALL.INVENTORY_ITEM_ID
AS_SCRIPT_ANSWER_ACTIONS_ALL.ORGANIZATION_ID
TableAS_TERRITORY_VALUES_ALL FK Joins to MTL_SYSTEM_ITEMS_B AS_TERRITORY_VALUES_ALL.INVENTORY_ITEM_ID
AS_TERRITORY_VALUES_ALL.ORGANIZATION_ID
TableAS_TERRITORY_VALUES_ALL FK Joins to MTL_SYSTEM_ITEMS_B AS_TERRITORY_VALUES_ALL.INVENTORY_ITEM_ID
AS_TERRITORY_VALUES_ALL.ORGANIZATION_ID
TableBOM_BILL_OF_MATERIALS FK Joins to MTL_SYSTEM_ITEMS_B BOM_BILL_OF_MATERIALS.ASSEMBLY_ITEM_ID
BOM_BILL_OF_MATERIALS.ORGANIZATION_ID
TableBOM_BILL_OF_MATERIALS FK Joins to MTL_SYSTEM_ITEMS_B BOM_BILL_OF_MATERIALS.COMMON_ASSEMBLY_ITEM_ID
BOM_BILL_OF_MATERIALS.COMMON_ORGANIZATION_ID
TableBOM_EXPLOSIONS FK Joins to MTL_SYSTEM_ITEMS_B BOM_EXPLOSIONS.TOP_ITEM_ID
BOM_EXPLOSIONS.ORGANIZATION_ID
TableBOM_EXPLOSIONS FK Joins to MTL_SYSTEM_ITEMS_B BOM_EXPLOSIONS.COMPONENT_ITEM_ID
BOM_EXPLOSIONS.ORGANIZATION_ID
TableBOM_MIXED_MODEL_MAP_HEADER FK Joins to MTL_SYSTEM_ITEMS_B BOM_MIXED_MODEL_MAP_HEADER.FAMILY_ITEM_ID
BOM_MIXED_MODEL_MAP_HEADER.ORGANIZATION_ID
TableBOM_OPERATIONAL_ROUTINGS FK Joins to MTL_SYSTEM_ITEMS_B BOM_OPERATIONAL_ROUTINGS.COMMON_ASSEMBLY_ITEM_ID
BOM_OPERATIONAL_ROUTINGS.ORGANIZATION_ID
TableBOM_OPERATIONAL_ROUTINGS FK Joins to MTL_SYSTEM_ITEMS_B BOM_OPERATIONAL_ROUTINGS.ASSEMBLY_ITEM_ID
BOM_OPERATIONAL_ROUTINGS.ORGANIZATION_ID
TableBOM_STRUCTURES_B FK Joins to MTL_SYSTEM_ITEMS_B BOM_STRUCTURES_B.ASSEMBLY_ITEM_ID
BOM_STRUCTURES_B.ORGANIZATION_ID
TableBOM_STRUCTURES_B FK Joins to MTL_SYSTEM_ITEMS_B BOM_STRUCTURES_B.COMMON_ASSEMBLY_ITEM_ID
BOM_STRUCTURES_B.COMMON_ORGANIZATION_ID
TableCRP_BILL_OF_RESOURCE_ITEMS FK Joins to MTL_SYSTEM_ITEMS_B CRP_BILL_OF_RESOURCE_ITEMS.INVENTORY_ITEM_ID
CRP_BILL_OF_RESOURCE_ITEMS.ORGANIZATION_ID
TableCRP_RESOURCE_HOURS FK Joins to MTL_SYSTEM_ITEMS_B CRP_RESOURCE_HOURS.SOURCE_ITEM_ID
CRP_RESOURCE_HOURS.ORGANIZATION_ID
TableCSD_GROUP_JOB_PARAM_TEMP FK Joins to MTL_SYSTEM_ITEMS_B CSD_GROUP_JOB_PARAM_TEMP.INVENTORY_ITEM_ID
CSD_GROUP_JOB_PARAM_TEMP.ORGANIZATION_ID
TableCSI_ITEM_INSTANCES FK Joins to MTL_SYSTEM_ITEMS_B CSI_ITEM_INSTANCES.INVENTORY_ITEM_ID
CSI_ITEM_INSTANCES.INV_MASTER_ORGANIZATION_ID
TableCSI_I_EXTENDED_ATTRIBS FK Joins to MTL_SYSTEM_ITEMS_B CSI_I_EXTENDED_ATTRIBS.INVENTORY_ITEM_ID
CSI_I_EXTENDED_ATTRIBS.MASTER_ORGANIZATION_ID
TableCSP_CURR_SUP_DEM_SUMS FK Joins to MTL_SYSTEM_ITEMS_B CSP_CURR_SUP_DEM_SUMS.INVENTORY_ITEM_ID
CSP_CURR_SUP_DEM_SUMS.ORGANIZATION_ID
TableCSP_EXCESS_LISTS FK Joins to MTL_SYSTEM_ITEMS_B CSP_EXCESS_LISTS.INVENTORY_ITEM_ID
CSP_EXCESS_LISTS.ORGANIZATION_ID
TableCSP_MSTRSTCK_LISTS_ITMS FK Joins to MTL_SYSTEM_ITEMS_B CSP_MSTRSTCK_LISTS_ITMS.INVENTORY_ITEM_ID
CSP_MSTRSTCK_LISTS_ITMS.ORGANIZATION_ID
TableCSP_NOTIFICATIONS FK Joins to MTL_SYSTEM_ITEMS_B CSP_NOTIFICATIONS.INVENTORY_ITEM_ID
CSP_NOTIFICATIONS.ORGANIZATION_ID
TableCSP_NOTIFICATION_DETAILS FK Joins to MTL_SYSTEM_ITEMS_B CSP_NOTIFICATION_DETAILS.INVENTORY_ITEM_ID
CSP_NOTIFICATION_DETAILS.SOURCE_ORGANIZATION_ID
TableCSP_PACKLIST_LINES FK Joins to MTL_SYSTEM_ITEMS_B CSP_PACKLIST_LINES.INVENTORY_ITEM_ID
CSP_PACKLIST_LINES.ORGANIZATION_ID
TableCSP_STOCK_LISTS FK Joins to MTL_SYSTEM_ITEMS_B CSP_STOCK_LISTS.INVENTORY_ITEM_ID
CSP_STOCK_LISTS.ORGANIZATION_ID
TableCSP_SUPPLY_CHAIN FK Joins to MTL_SYSTEM_ITEMS_B CSP_SUPPLY_CHAIN.INVENTORY_ITEM_ID
CSP_SUPPLY_CHAIN.ORGANIZATION_ID
TableCSP_USAGE_HEADERS FK Joins to MTL_SYSTEM_ITEMS_B CSP_USAGE_HEADERS.INVENTORY_ITEM_ID
CSP_USAGE_HEADERS.ORGANIZATION_ID
TableCSP_USAGE_HISTORIES FK Joins to MTL_SYSTEM_ITEMS_B CSP_USAGE_HISTORIES.INVENTORY_ITEM_ID
CSP_USAGE_HISTORIES.ORGANIZATION_ID
TableCST_COST_TYPE_HISTORY FK Joins to MTL_SYSTEM_ITEMS_B CST_COST_TYPE_HISTORY.INVENTORY_ITEM_ID
CST_COST_TYPE_HISTORY.ORGANIZATION_ID
TableCST_ITEM_COSTS FK Joins to MTL_SYSTEM_ITEMS_B CST_ITEM_COSTS.INVENTORY_ITEM_ID
CST_ITEM_COSTS.ORGANIZATION_ID
TableCST_ITEM_COSTS_INTERFACE FK Joins to MTL_SYSTEM_ITEMS_B CST_ITEM_COSTS_INTERFACE.INVENTORY_ITEM_ID
CST_ITEM_COSTS_INTERFACE.ORGANIZATION_ID
TableCST_ITEM_COST_DETAILS FK Joins to MTL_SYSTEM_ITEMS_B CST_ITEM_COST_DETAILS.INVENTORY_ITEM_ID
CST_ITEM_COST_DETAILS.ORGANIZATION_ID
TableCST_ITEM_CST_DTLS_INTERFACE FK Joins to MTL_SYSTEM_ITEMS_B CST_ITEM_CST_DTLS_INTERFACE.INVENTORY_ITEM_ID
CST_ITEM_CST_DTLS_INTERFACE.ORGANIZATION_ID
TableCST_QUANTITY_LAYERS FK Joins to MTL_SYSTEM_ITEMS_B CST_QUANTITY_LAYERS.INVENTORY_ITEM_ID
CST_QUANTITY_LAYERS.ORGANIZATION_ID
TableCST_WRITE_OFFS FK Joins to MTL_SYSTEM_ITEMS_B CST_WRITE_OFFS.INVENTORY_ITEM_ID
CST_WRITE_OFFS.OPERATING_UNIT_ID
TableCUN_NON_SERIALIZED_UNITS FK Joins to MTL_SYSTEM_ITEMS_B CUN_NON_SERIALIZED_UNITS.ITEM_ID
CUN_NON_SERIALIZED_UNITS.ORGANIZATION_ID
TableCUN_SERIALIZED_UNITS FK Joins to MTL_SYSTEM_ITEMS_B CUN_SERIALIZED_UNITS.ITEM_ID
CUN_SERIALIZED_UNITS.ORGANIZATION_ID
TableCZ_AUTOSELECTION_ITEMS FK Joins to MTL_SYSTEM_ITEMS_B CZ_AUTOSELECTION_ITEMS.INVENTORY_ITEM_ID
CZ_AUTOSELECTION_ITEMS.ORGANIZATION_ID
TableCZ_CONSTRAINT_ASSIGNMENTS FK Joins to MTL_SYSTEM_ITEMS_B CZ_CONSTRAINT_ASSIGNMENTS.INVENTORY_ITEM_ID
CZ_CONSTRAINT_ASSIGNMENTS.ORGANIZATION_ID
TableEAM_ASSET_METERS FK Joins to MTL_SYSTEM_ITEMS_B EAM_ASSET_METERS.ASSET_GROUP_ID
EAM_ASSET_METERS.ORGANIZATION_ID
TableEAM_JOB_COMPLETION_TXNS FK Joins to MTL_SYSTEM_ITEMS_B EAM_JOB_COMPLETION_TXNS.ASSET_ACTIVITY_ID
EAM_JOB_COMPLETION_TXNS.ORGANIZATION_ID
TableEAM_OP_COMPLETION_TXNS FK Joins to MTL_SYSTEM_ITEMS_B EAM_OP_COMPLETION_TXNS.ASSET_ACTIVITY_ID
EAM_OP_COMPLETION_TXNS.ORGANIZATION_ID
TableEAM_WORK_ORDER_BILLS FK Joins to MTL_SYSTEM_ITEMS_B EAM_WORK_ORDER_BILLS.BILLED_INVENTORY_ITEM_ID
EAM_WORK_ORDER_BILLS.ORGANIZATION_ID
TableENG_REVISED_ITEMS FK Joins to MTL_SYSTEM_ITEMS_B ENG_REVISED_ITEMS.REVISED_ITEM_ID
ENG_REVISED_ITEMS.ORGANIZATION_ID
TableENG_REVISED_ITEMS FK Joins to MTL_SYSTEM_ITEMS_B ENG_REVISED_ITEMS.USE_UP_ITEM_ID
ENG_REVISED_ITEMS.ORGANIZATION_ID
TableFLM_MMM_OP_ITEMS FK Joins to MTL_SYSTEM_ITEMS_B FLM_MMM_OP_ITEMS.ASSEMBLY_ITEM_ID
FLM_MMM_OP_ITEMS.ORGANIZATION_ID
TableFLM_SEQ_TASK_DEMANDS FK Joins to MTL_SYSTEM_ITEMS_B FLM_SEQ_TASK_DEMANDS.PRIMARY_ITEM_ID
FLM_SEQ_TASK_DEMANDS.ORGANIZATION_ID
TableIBE_CT_IMEDIA_SEARCH FK Joins to MTL_SYSTEM_ITEMS_B IBE_CT_IMEDIA_SEARCH.INVENTORY_ITEM_ID
IBE_CT_IMEDIA_SEARCH.ORGANIZATION_ID
TableIBE_CT_RELATED_ITEMS FK Joins to MTL_SYSTEM_ITEMS_B IBE_CT_RELATED_ITEMS.INVENTORY_ITEM_ID
IBE_CT_RELATED_ITEMS.ORGANIZATION_ID
TableIBE_CT_RELATED_ITEMS FK Joins to MTL_SYSTEM_ITEMS_B IBE_CT_RELATED_ITEMS.RELATED_ITEM_ID
IBE_CT_RELATED_ITEMS.ORGANIZATION_ID
TableIBE_CT_REL_EXCLUSIONS FK Joins to MTL_SYSTEM_ITEMS_B IBE_CT_REL_EXCLUSIONS.INVENTORY_ITEM_ID
IBE_CT_REL_EXCLUSIONS.ORGANIZATION_ID
TableIBE_CT_REL_EXCLUSIONS FK Joins to MTL_SYSTEM_ITEMS_B IBE_CT_REL_EXCLUSIONS.RELATED_ITEM_ID
IBE_CT_REL_EXCLUSIONS.ORGANIZATION_ID
TableIBE_DSP_SECTION_ITEMS FK Joins to MTL_SYSTEM_ITEMS_B IBE_DSP_SECTION_ITEMS.INVENTORY_ITEM_ID
IBE_DSP_SECTION_ITEMS.ORGANIZATION_ID
TableIBE_ECR_ORDERS_FACT FK Joins to MTL_SYSTEM_ITEMS_B IBE_ECR_ORDERS_FACT.INVENTORY_ITEM_ID
IBE_ECR_ORDERS_FACT.ORGANIZATION_ID
TableIBE_ECR_QUOTES_FACT FK Joins to MTL_SYSTEM_ITEMS_B IBE_ECR_QUOTES_FACT.INVENTORY_ITEM_ID
IBE_ECR_QUOTES_FACT.ORGANIZATION_ID
TableIBE_SHP_LIST_ITEMS_ALL FK Joins to MTL_SYSTEM_ITEMS_B IBE_SHP_LIST_ITEMS_ALL.INVENTORY_ITEM_ID
IBE_SHP_LIST_ITEMS_ALL.ORGANIZATION_ID
TableIBE_SECTION_SEARCH FK Joins to MTL_SYSTEM_ITEMS_B IBE_SECTION_SEARCH.INVENTORY_ITEM_ID
IBE_SECTION_SEARCH.ORGANIZATION_ID
TableICX_SHOPPING_CART_LINES FK Joins to MTL_SYSTEM_ITEMS_B ICX_SHOPPING_CART_LINES.ITEM_ID
ICX_SHOPPING_CART_LINES.DESTINATION_ORGANIZATION_ID
TableICX_WEB_STORE_OPTIONS FK Joins to MTL_SYSTEM_ITEMS_B ICX_WEB_STORE_OPTIONS.NON_SHIPITEM_ID
ICX_WEB_STORE_OPTIONS.ORG_ID
TableJAI_CMN_TRANSACTIONS_T FK Joins to MTL_SYSTEM_ITEMS_B JAI_CMN_TRANSACTIONS_T.INVENTORY_ITEM_ID
JAI_CMN_TRANSACTIONS_T.ORGANIZATION_ID
TableJAI_INV_ITM_SETUPS FK Joins to MTL_SYSTEM_ITEMS_B JAI_INV_ITM_SETUPS.INVENTORY_ITEM_ID
JAI_INV_ITM_SETUPS.ORGANIZATION_ID
TableJAI_MTL_MATCH_RECEIPTS FK Joins to MTL_SYSTEM_ITEMS_B JAI_MTL_MATCH_RECEIPTS.INVENTORY_ITEM_ID
JAI_MTL_MATCH_RECEIPTS.ORGANIZATION_ID
TableJAI_MTL_TRXS FK Joins to MTL_SYSTEM_ITEMS_B JAI_MTL_TRXS.INVENTORY_ITEM_ID
JAI_MTL_TRXS.FROM_ORGANIZATION
TableJAI_OPM_OSP_DTLS FK Joins to MTL_SYSTEM_ITEMS_B JAI_OPM_OSP_DTLS.ITEM_ID
JAI_OPM_OSP_DTLS.ORGANIZATION_ID
TableJAI_OPM_OSP_DTLS FK Joins to MTL_SYSTEM_ITEMS_B JAI_OPM_OSP_DTLS.INVENTORY_ITEM_ID
JAI_OPM_OSP_DTLS.ORGANIZATION_ID
TableJAI_PO_OSP_CENVAT_DTLS FK Joins to MTL_SYSTEM_ITEMS_B JAI_PO_OSP_CENVAT_DTLS.INVENTORY_ITEM_ID
JAI_PO_OSP_CENVAT_DTLS.ORGANIZATION_ID
TableJAI_PO_OSP_ITM_DTLS FK Joins to MTL_SYSTEM_ITEMS_B JAI_PO_OSP_ITM_DTLS.OSP_ITEM_ID
JAI_PO_OSP_ITM_DTLS.ORGANIZATION_ID
TableJAI_PO_OSP_ITM_DTLS FK Joins to MTL_SYSTEM_ITEMS_B JAI_PO_OSP_ITM_DTLS.ITEM_ID
JAI_PO_OSP_ITM_DTLS.ORGANIZATION_ID
TableJAI_PO_OSP_ITM_HDRS FK Joins to MTL_SYSTEM_ITEMS_B JAI_PO_OSP_ITM_HDRS.OSP_ITEM_ID
JAI_PO_OSP_ITM_HDRS.ORGANIZATION_ID
TableJAI_PO_RMA_RTN_LINES FK Joins to MTL_SYSTEM_ITEMS_B JAI_PO_RMA_RTN_LINES.INVENTORY_ITEM_ID
JAI_PO_RMA_RTN_LINES.ORGANIZATION_ID
TableJAI_RCV_LINES FK Joins to MTL_SYSTEM_ITEMS_B JAI_RCV_LINES.INVENTORY_ITEM_ID
JAI_RCV_LINES.ORGANIZATION_ID
TableJAI_RCV_RGM_LINES FK Joins to MTL_SYSTEM_ITEMS_B JAI_RCV_RGM_LINES.INVENTORY_ITEM_ID
JAI_RCV_RGM_LINES.ORGANIZATION_ID
TableJAI_RCV_TRANSACTIONS FK Joins to MTL_SYSTEM_ITEMS_B JAI_RCV_TRANSACTIONS.INVENTORY_ITEM_ID
JAI_RCV_TRANSACTIONS.ORGANIZATION_ID
TableJAI_RETRO_LINE_CHANGES FK Joins to MTL_SYSTEM_ITEMS_B JAI_RETRO_LINE_CHANGES.INVENTORY_ITEM_ID
JAI_RETRO_LINE_CHANGES.ORGANIZATION_ID
TableJAI_RGM_ITM_REGNS FK Joins to MTL_SYSTEM_ITEMS_B JAI_RGM_ITM_REGNS.INVENTORY_ITEM_ID
JAI_RGM_ITM_REGNS.ORGANIZATION_ID
TableJL_BR_AR_TX_EXC_ITM_ALL FK Joins to MTL_SYSTEM_ITEMS_B JL_BR_AR_TX_EXC_ITM_ALL.INVENTORY_ITEM_ID
JL_BR_AR_TX_EXC_ITM_ALL.ORGANIZATION_ID
TableJL_BR_PO_TAX_EXC_ITEMS_ALL FK Joins to MTL_SYSTEM_ITEMS_B JL_BR_PO_TAX_EXC_ITEMS_ALL.INVENTORY_ITEM_ID
JL_BR_PO_TAX_EXC_ITEMS_ALL.ORGANIZATION_ID
TableJL_ZZ_AR_TX_EXC_ITM_ALL FK Joins to MTL_SYSTEM_ITEMS_B JL_ZZ_AR_TX_EXC_ITM_ALL.INVENTORY_ITEM_ID
JL_ZZ_AR_TX_EXC_ITM_ALL.ORGANIZATION_ID
TableJMF_SHIKYU_COMPONENTS FK Joins to MTL_SYSTEM_ITEMS_B JMF_SHIKYU_COMPONENTS.SHIKYU_COMPONENT_ID
JMF_SHIKYU_COMPONENTS.OEM_ORGANIZATION_ID
TableJMF_SHIKYU_REPLENISHMENTS FK Joins to MTL_SYSTEM_ITEMS_B JMF_SHIKYU_REPLENISHMENTS.SHIKYU_COMPONENT_ID
JMF_SHIKYU_REPLENISHMENTS.OEM_ORGANIZATION_ID
TableJMF_SUBCONTRACT_ORDERS FK Joins to MTL_SYSTEM_ITEMS_B JMF_SUBCONTRACT_ORDERS.OSA_ITEM_ID
JMF_SUBCONTRACT_ORDERS.OEM_ORGANIZATION_ID
TableMRP_FORECAST_INTERFACE FK Joins to MTL_SYSTEM_ITEMS_B MRP_FORECAST_INTERFACE.INVENTORY_ITEM_ID
MRP_FORECAST_INTERFACE.ORGANIZATION_ID
TableMRP_FORECAST_ITEMS FK Joins to MTL_SYSTEM_ITEMS_B MRP_FORECAST_ITEMS.INVENTORY_ITEM_ID
MRP_FORECAST_ITEMS.ORGANIZATION_ID
TableMRP_ITEM_SUPPLIERS FK Joins to MTL_SYSTEM_ITEMS_B MRP_ITEM_SUPPLIERS.INVENTORY_ITEM_ID
MRP_ITEM_SUPPLIERS.ORGANIZATION_ID
TableMRP_RELIEF_INTERFACE FK Joins to MTL_SYSTEM_ITEMS_B MRP_RELIEF_INTERFACE.INVENTORY_ITEM_ID
MRP_RELIEF_INTERFACE.ORGANIZATION_ID
TableMRP_SALES_ORDER_UPDATES FK Joins to MTL_SYSTEM_ITEMS_B MRP_SALES_ORDER_UPDATES.BASE_MODEL_ID
MRP_SALES_ORDER_UPDATES.ORGANIZATION_ID
TableMRP_SALES_ORDER_UPDATES FK Joins to MTL_SYSTEM_ITEMS_B MRP_SALES_ORDER_UPDATES.INVENTORY_ITEM_ID
MRP_SALES_ORDER_UPDATES.ORGANIZATION_ID
TableMRP_SCHEDULE_INTERFACE FK Joins to MTL_SYSTEM_ITEMS_B MRP_SCHEDULE_INTERFACE.INVENTORY_ITEM_ID
MRP_SCHEDULE_INTERFACE.ORGANIZATION_ID
TableMRP_SCHEDULE_ITEMS FK Joins to MTL_SYSTEM_ITEMS_B MRP_SCHEDULE_ITEMS.INVENTORY_ITEM_ID
MRP_SCHEDULE_ITEMS.ORGANIZATION_ID
TableMRP_SUPPLIER_CAPACITIES FK Joins to MTL_SYSTEM_ITEMS_B MRP_SUPPLIER_CAPACITIES.INVENTORY_ITEM_ID
MRP_SUPPLIER_CAPACITIES.ORGANIZATION_ID
TableMRP_SUPPLIER_FLEX_FENCES FK Joins to MTL_SYSTEM_ITEMS_B MRP_SUPPLIER_FLEX_FENCES.INVENTORY_ITEM_ID
MRP_SUPPLIER_FLEX_FENCES.ORGANIZATION_ID
TableMRP_SYSTEM_ITEMS FK Joins to MTL_SYSTEM_ITEMS_B MRP_SYSTEM_ITEMS.INVENTORY_ITEM_ID
MRP_SYSTEM_ITEMS.ORGANIZATION_ID
TableMTL_ABC_COMPILES FK Joins to MTL_SYSTEM_ITEMS_B MTL_ABC_COMPILES.INVENTORY_ITEM_ID
MTL_ABC_COMPILES.ORGANIZATION_ID
TableMTL_CATALOG_SEARCH_ITEMS FK Joins to MTL_SYSTEM_ITEMS_B MTL_CATALOG_SEARCH_ITEMS.INVENTORY_ITEM_ID
MTL_CATALOG_SEARCH_ITEMS.ORGANIZATION_ID
TableMTL_CC_ENTRIES_INTERFACE FK Joins to MTL_SYSTEM_ITEMS_B MTL_CC_ENTRIES_INTERFACE.INVENTORY_ITEM_ID
MTL_CC_ENTRIES_INTERFACE.ORGANIZATION_ID
TableMTL_CROSS_REFERENCES FK Joins to MTL_SYSTEM_ITEMS_B MTL_CROSS_REFERENCES.INVENTORY_ITEM_ID
MTL_CROSS_REFERENCES.ORGANIZATION_ID
TableMTL_CST_ACTUAL_COST_DETAILS FK Joins to MTL_SYSTEM_ITEMS_B MTL_CST_ACTUAL_COST_DETAILS.INVENTORY_ITEM_ID
MTL_CST_ACTUAL_COST_DETAILS.ORGANIZATION_ID
TableMTL_CST_TXN_COST_DETAILS FK Joins to MTL_SYSTEM_ITEMS_B MTL_CST_TXN_COST_DETAILS.INVENTORY_ITEM_ID
MTL_CST_TXN_COST_DETAILS.ORGANIZATION_ID
TableMTL_CUSTOMER_ITEM_XREFS FK Joins to MTL_SYSTEM_ITEMS_B MTL_CUSTOMER_ITEM_XREFS.INVENTORY_ITEM_ID
MTL_CUSTOMER_ITEM_XREFS.MASTER_ORGANIZATION_ID
TableMTL_CYCLE_COUNT_ENTRIES FK Joins to MTL_SYSTEM_ITEMS_B MTL_CYCLE_COUNT_ENTRIES.INVENTORY_ITEM_ID
MTL_CYCLE_COUNT_ENTRIES.ORGANIZATION_ID
TableMTL_DEMAND FK Joins to MTL_SYSTEM_ITEMS_B MTL_DEMAND.INVENTORY_ITEM_ID
MTL_DEMAND.ORGANIZATION_ID
TableMTL_DEMAND FK Joins to MTL_SYSTEM_ITEMS_B MTL_DEMAND.DUPLICATED_CONFIG_ITEM_ID
MTL_DEMAND.ORGANIZATION_ID
TableMTL_DEMAND_HISTORIES FK Joins to MTL_SYSTEM_ITEMS_B MTL_DEMAND_HISTORIES.INVENTORY_ITEM_ID
MTL_DEMAND_HISTORIES.ORGANIZATION_ID
TableMTL_DEMAND_INTERFACE FK Joins to MTL_SYSTEM_ITEMS_B MTL_DEMAND_INTERFACE.INVENTORY_ITEM_ID
MTL_DEMAND_INTERFACE.ORGANIZATION_ID
TableMTL_EAM_ASSET_ACTIVITIES FK Joins to MTL_SYSTEM_ITEMS_B MTL_EAM_ASSET_ACTIVITIES.ASSET_ACTIVITY_ID
MTL_EAM_ASSET_ACTIVITIES.ORGANIZATION_ID
TableMTL_EAM_ASSET_ACTIVITIES FK Joins to MTL_SYSTEM_ITEMS_B MTL_EAM_ASSET_ACTIVITIES.INVENTORY_ITEM_ID
MTL_EAM_ASSET_ACTIVITIES.ORGANIZATION_ID
TableMTL_EAM_ASSET_ATTR_GROUPS FK Joins to MTL_SYSTEM_ITEMS_B MTL_EAM_ASSET_ATTR_GROUPS.INVENTORY_ITEM_ID
MTL_EAM_ASSET_ATTR_GROUPS.ORGANIZATION_ID
TableMTL_ITEM_CATEGORIES FK Joins to MTL_SYSTEM_ITEMS_B MTL_ITEM_CATEGORIES.INVENTORY_ITEM_ID
MTL_ITEM_CATEGORIES.ORGANIZATION_ID
TableMTL_ITEM_LOC_DEFAULTS FK Joins to MTL_SYSTEM_ITEMS_B MTL_ITEM_LOC_DEFAULTS.INVENTORY_ITEM_ID
MTL_ITEM_LOC_DEFAULTS.ORGANIZATION_ID
TableMTL_ITEM_REVISIONS_B FK Joins to MTL_SYSTEM_ITEMS_B MTL_ITEM_REVISIONS_B.INVENTORY_ITEM_ID
MTL_ITEM_REVISIONS_B.ORGANIZATION_ID
TableMTL_ITEM_SUB_DEFAULTS FK Joins to MTL_SYSTEM_ITEMS_B MTL_ITEM_SUB_DEFAULTS.INVENTORY_ITEM_ID
MTL_ITEM_SUB_DEFAULTS.ORGANIZATION_ID
TableMTL_ITEM_SUB_INVENTORIES FK Joins to MTL_SYSTEM_ITEMS_B MTL_ITEM_SUB_INVENTORIES.INVENTORY_ITEM_ID
MTL_ITEM_SUB_INVENTORIES.ORGANIZATION_ID
TableMTL_KANBAN_CARDS FK Joins to MTL_SYSTEM_ITEMS_B MTL_KANBAN_CARDS.INVENTORY_ITEM_ID
MTL_KANBAN_CARDS.ORGANIZATION_ID
TableMTL_KANBAN_CARD_ACTIVITY FK Joins to MTL_SYSTEM_ITEMS_B MTL_KANBAN_CARD_ACTIVITY.INVENTORY_ITEM_ID
MTL_KANBAN_CARD_ACTIVITY.ORGANIZATION_ID
TableMTL_KANBAN_PULL_SEQUENCES FK Joins to MTL_SYSTEM_ITEMS_B MTL_KANBAN_PULL_SEQUENCES.INVENTORY_ITEM_ID
MTL_KANBAN_PULL_SEQUENCES.ORGANIZATION_ID
TableMTL_LOT_NUMBERS FK Joins to MTL_SYSTEM_ITEMS_B MTL_LOT_NUMBERS.INVENTORY_ITEM_ID
MTL_LOT_NUMBERS.ORGANIZATION_ID
TableMTL_MATERIAL_TRANSACTIONS FK Joins to MTL_SYSTEM_ITEMS_B MTL_MATERIAL_TRANSACTIONS.INVENTORY_ITEM_ID
MTL_MATERIAL_TRANSACTIONS.ORGANIZATION_ID
TableMTL_MATERIAL_TRANSACTIONS_TEMP FK Joins to MTL_SYSTEM_ITEMS_B MTL_MATERIAL_TRANSACTIONS_TEMP.INVENTORY_ITEM_ID
MTL_MATERIAL_TRANSACTIONS_TEMP.ORGANIZATION_ID
TableMTL_MFG_PART_NUMBERS FK Joins to MTL_SYSTEM_ITEMS_B MTL_MFG_PART_NUMBERS.INVENTORY_ITEM_ID
MTL_MFG_PART_NUMBERS.ORGANIZATION_ID
TableMTL_ONHAND_QUANTITIES FK Joins to MTL_SYSTEM_ITEMS_B MTL_ONHAND_QUANTITIES.INVENTORY_ITEM_ID
MTL_ONHAND_QUANTITIES.ORGANIZATION_ID
TableMTL_ONHAND_QUANTITY_TEMP FK Joins to MTL_SYSTEM_ITEMS_B MTL_ONHAND_QUANTITY_TEMP.INVENTORY_ITEM_ID
MTL_ONHAND_QUANTITY_TEMP.ORGANIZATION_ID
TableMTL_PENDING_ITEM_STATUS FK Joins to MTL_SYSTEM_ITEMS_B MTL_PENDING_ITEM_STATUS.INVENTORY_ITEM_ID
MTL_PENDING_ITEM_STATUS.ORGANIZATION_ID
TableMTL_PHYSICAL_ADJUSTMENTS FK Joins to MTL_SYSTEM_ITEMS_B MTL_PHYSICAL_ADJUSTMENTS.INVENTORY_ITEM_ID
MTL_PHYSICAL_ADJUSTMENTS.ORGANIZATION_ID
TableMTL_PHYSICAL_INVENTORY_TAGS FK Joins to MTL_SYSTEM_ITEMS_B MTL_PHYSICAL_INVENTORY_TAGS.INVENTORY_ITEM_ID
MTL_PHYSICAL_INVENTORY_TAGS.ORGANIZATION_ID
TableMTL_RELATED_ITEMS FK Joins to MTL_SYSTEM_ITEMS_B MTL_RELATED_ITEMS.INVENTORY_ITEM_ID
MTL_RELATED_ITEMS.ORGANIZATION_ID
TableMTL_RELATED_ITEMS FK Joins to MTL_SYSTEM_ITEMS_B MTL_RELATED_ITEMS.RELATED_ITEM_ID
MTL_RELATED_ITEMS.ORGANIZATION_ID
TableMTL_REPLENISH_LINES FK Joins to MTL_SYSTEM_ITEMS_B MTL_REPLENISH_LINES.INVENTORY_ITEM_ID
MTL_REPLENISH_LINES.ORGANIZATION_ID
TableMTL_REPLENISH_LINES_INT FK Joins to MTL_SYSTEM_ITEMS_B MTL_REPLENISH_LINES_INT.INVENTORY_ITEM_ID
MTL_REPLENISH_LINES_INT.ORGANIZATION_ID
TableMTL_RESERVATIONS FK Joins to MTL_SYSTEM_ITEMS_B MTL_RESERVATIONS.INVENTORY_ITEM_ID
MTL_RESERVATIONS.ORGANIZATION_ID
TableMTL_RESERVATIONS_INTERFACE FK Joins to MTL_SYSTEM_ITEMS_B MTL_RESERVATIONS_INTERFACE.INVENTORY_ITEM_ID
MTL_RESERVATIONS_INTERFACE.ORGANIZATION_ID
TableMTL_SAFETY_STOCKS FK Joins to MTL_SYSTEM_ITEMS_B MTL_SAFETY_STOCKS.INVENTORY_ITEM_ID
MTL_SAFETY_STOCKS.ORGANIZATION_ID
TableMTL_SERIAL_NUMBERS FK Joins to MTL_SYSTEM_ITEMS_B MTL_SERIAL_NUMBERS.INVENTORY_ITEM_ID
MTL_SERIAL_NUMBERS.CURRENT_ORGANIZATION_ID
TableMTL_SHORT_CHK_TEMP FK Joins to MTL_SYSTEM_ITEMS_B MTL_SHORT_CHK_TEMP.INVENTORY_ITEM_ID
MTL_SHORT_CHK_TEMP.ORGANIZATION_ID
TableMTL_SO_RMA_INTERFACE FK Joins to MTL_SYSTEM_ITEMS_B MTL_SO_RMA_INTERFACE.INVENTORY_ITEM_ID
MTL_SO_RMA_INTERFACE.ORGANIZATION_ID
TableMTL_SO_RMA_RECEIPTS FK Joins to MTL_SYSTEM_ITEMS_B MTL_SO_RMA_RECEIPTS.INVENTORY_ITEM_ID
MTL_SO_RMA_RECEIPTS.ORGANIZATION_ID
TableMTL_SUPPLY_DEMAND_TEMP FK Joins to MTL_SYSTEM_ITEMS_B MTL_SUPPLY_DEMAND_TEMP.INVENTORY_ITEM_ID
MTL_SUPPLY_DEMAND_TEMP.ORGANIZATION_ID
TableMTL_SUPPLY FK Joins to MTL_SYSTEM_ITEMS_B MTL_SUPPLY.ITEM_ID
MTL_SUPPLY.TO_ORGANIZATION_ID
TableMTL_SYSTEM_ITEMS_B FK Joins to MTL_SYSTEM_ITEMS_B MTL_SYSTEM_ITEMS_B.ENGINEERING_ITEM_ID
MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID
TableMTL_SYSTEM_ITEMS_B FK Joins to MTL_SYSTEM_ITEMS_B MTL_SYSTEM_ITEMS_B.BASE_ITEM_ID
MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID
TableMTL_SYSTEM_ITEMS_B FK Joins to MTL_SYSTEM_ITEMS_B MTL_SYSTEM_ITEMS_B.BASE_WARRANTY_SERVICE_ID
MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID
TableMTL_SYSTEM_ITEMS_B FK Joins to MTL_SYSTEM_ITEMS_B MTL_SYSTEM_ITEMS_B.PRODUCT_FAMILY_ITEM_ID
MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID
TableMTL_SYSTEM_ITEMS_TL FK Joins to MTL_SYSTEM_ITEMS_B MTL_SYSTEM_ITEMS_TL.INVENTORY_ITEM_ID
MTL_SYSTEM_ITEMS_TL.ORGANIZATION_ID
TableMTL_TRANSACTIONS_INTERFACE FK Joins to MTL_SYSTEM_ITEMS_B MTL_TRANSACTIONS_INTERFACE.INVENTORY_ITEM_ID
MTL_TRANSACTIONS_INTERFACE.ORGANIZATION_ID
TableMTL_TRANSACTION_ACCOUNTS FK Joins to MTL_SYSTEM_ITEMS_B MTL_TRANSACTION_ACCOUNTS.INVENTORY_ITEM_ID
MTL_TRANSACTION_ACCOUNTS.ORGANIZATION_ID
TableMTL_TXN_REQUEST_LINES FK Joins to MTL_SYSTEM_ITEMS_B MTL_TXN_REQUEST_LINES.INVENTORY_ITEM_ID
MTL_TXN_REQUEST_LINES.ORGANIZATION_ID
TableMTL_USER_DEMAND FK Joins to MTL_SYSTEM_ITEMS_B MTL_USER_DEMAND.INVENTORY_ITEM_ID
MTL_USER_DEMAND.ORGANIZATION_ID
TableMTL_USER_SUPPLY FK Joins to MTL_SYSTEM_ITEMS_B MTL_USER_SUPPLY.INVENTORY_ITEM_ID
MTL_USER_SUPPLY.ORGANIZATION_ID
TableOKL_ASSET_RETURNS_ALL_B FK Joins to MTL_SYSTEM_ITEMS_B OKL_ASSET_RETURNS_ALL_B.IMR_ID
OKL_ASSET_RETURNS_ALL_B.ORG_ID
TableOKL_FE_EO_TERM_OBJECTS FK Joins to MTL_SYSTEM_ITEMS_B OKL_FE_EO_TERM_OBJECTS.INVENTORY_ITEM_ID
OKL_FE_EO_TERM_OBJECTS.ORGANIZATION_ID
TableOKL_FE_ITEM_RESIDUAL_ALL FK Joins to MTL_SYSTEM_ITEMS_B OKL_FE_ITEM_RESIDUAL_ALL.INVENTORY_ITEM_ID
OKL_FE_ITEM_RESIDUAL_ALL.ORG_ID
TableOKL_FE_RESI_CAT_OBJECTS FK Joins to MTL_SYSTEM_ITEMS_B OKL_FE_RESI_CAT_OBJECTS.INVENTORY_ITEM_ID
OKL_FE_RESI_CAT_OBJECTS.ORGANIZATION_ID
TableOKL_SUBSIDY_CRITERIA FK Joins to MTL_SYSTEM_ITEMS_B OKL_SUBSIDY_CRITERIA.INVENTORY_ITEM_ID
OKL_SUBSIDY_CRITERIA.ORGANIZATION_ID
TableOZF_RETAIL_PRICE_POINTS FK Joins to MTL_SYSTEM_ITEMS_B OZF_RETAIL_PRICE_POINTS.INVENTORY_ITEM_ID
OZF_RETAIL_PRICE_POINTS.ORGANIZATION_ID
TablePJM_BORROW_TRANSACTIONS FK Joins to MTL_SYSTEM_ITEMS_B PJM_BORROW_TRANSACTIONS.INVENTORY_ITEM_ID
PJM_BORROW_TRANSACTIONS.ORGANIZATION_ID
TablePJM_DEFAULT_TASKS FK Joins to MTL_SYSTEM_ITEMS_B PJM_DEFAULT_TASKS.INVENTORY_ITEM_ID
PJM_DEFAULT_TASKS.ORGANIZATION_ID
TablePJM_DEFAULT_TASKS FK Joins to MTL_SYSTEM_ITEMS_B PJM_DEFAULT_TASKS.ASSEMBLY_ITEM_ID
PJM_DEFAULT_TASKS.ORGANIZATION_ID
TablePJM_UNIT_NUMBERS FK Joins to MTL_SYSTEM_ITEMS_B PJM_UNIT_NUMBERS.END_ITEM_ID
PJM_UNIT_NUMBERS.MASTER_ORGANIZATION_ID
TableQA_RESULTS FK Joins to MTL_SYSTEM_ITEMS_B QA_RESULTS.ASSET_GROUP_ID
QA_RESULTS.ORGANIZATION_ID
TableQA_RESULTS FK Joins to MTL_SYSTEM_ITEMS_B QA_RESULTS.ASSET_ACTIVITY_ID
QA_RESULTS.ORGANIZATION_ID
TableQA_RESULTS FK Joins to MTL_SYSTEM_ITEMS_B QA_RESULTS.ITEM_ID
QA_RESULTS.ORGANIZATION_ID
TableWIP_COST_TXN_INTERFACE FK Joins to MTL_SYSTEM_ITEMS_B WIP_COST_TXN_INTERFACE.PRIMARY_ITEM_ID
WIP_COST_TXN_INTERFACE.ORGANIZATION_ID
TableWIP_DISCRETE_JOBS FK Joins to MTL_SYSTEM_ITEMS_B WIP_DISCRETE_JOBS.PRIMARY_ITEM_ID
WIP_DISCRETE_JOBS.ORGANIZATION_ID
TableWIP_DISCRETE_JOBS FK Joins to MTL_SYSTEM_ITEMS_B WIP_DISCRETE_JOBS.BOM_REFERENCE_ID
WIP_DISCRETE_JOBS.ORGANIZATION_ID
TableWIP_DISCRETE_JOBS FK Joins to MTL_SYSTEM_ITEMS_B WIP_DISCRETE_JOBS.ROUTING_REFERENCE_ID
WIP_DISCRETE_JOBS.ORGANIZATION_ID
TableWIP_ENTITIES FK Joins to MTL_SYSTEM_ITEMS_B WIP_ENTITIES.PRIMARY_ITEM_ID
WIP_ENTITIES.ORGANIZATION_ID
TableWIP_FLOW_SCHEDULES FK Joins to MTL_SYSTEM_ITEMS_B WIP_FLOW_SCHEDULES.PRIMARY_ITEM_ID
WIP_FLOW_SCHEDULES.ORGANIZATION_ID
TableWIP_MOVE_TXN_INTERFACE FK Joins to MTL_SYSTEM_ITEMS_B WIP_MOVE_TXN_INTERFACE.PRIMARY_ITEM_ID
WIP_MOVE_TXN_INTERFACE.ORGANIZATION_ID
TableWIP_REPETITIVE_ITEMS FK Joins to MTL_SYSTEM_ITEMS_B WIP_REPETITIVE_ITEMS.PRIMARY_ITEM_ID
WIP_REPETITIVE_ITEMS.ORGANIZATION_ID
TableWIP_REQUIREMENT_OPERATIONS FK Joins to MTL_SYSTEM_ITEMS_B WIP_REQUIREMENT_OPERATIONS.INVENTORY_ITEM_ID
WIP_REQUIREMENT_OPERATIONS.ORGANIZATION_ID
TableWIP_TEMP_REPORTS FK Joins to MTL_SYSTEM_ITEMS_B WIP_TEMP_REPORTS.INVENTORY_ITEM_ID
WIP_TEMP_REPORTS.ORGANIZATION_ID
TableWIP_TRANSACTIONS FK Joins to MTL_SYSTEM_ITEMS_B WIP_TRANSACTIONS.PRIMARY_ITEM_ID
WIP_TRANSACTIONS.ORGANIZATION_ID
TableWMS_EXCEPTIONS FK Joins to MTL_SYSTEM_ITEMS_B WMS_EXCEPTIONS.INVENTORY_ITEM_ID
WMS_EXCEPTIONS.ORGANIZATION_ID
TableWMS_LICENSE_PLATE_NUMBERS FK Joins to MTL_SYSTEM_ITEMS_B WMS_LICENSE_PLATE_NUMBERS.INVENTORY_ITEM_ID
WMS_LICENSE_PLATE_NUMBERS.ORGANIZATION_ID
TableWMS_LPN_CONTENTS FK Joins to MTL_SYSTEM_ITEMS_B WMS_LPN_CONTENTS.INVENTORY_ITEM_ID
WMS_LPN_CONTENTS.ORGANIZATION_ID
TableWMS_LPN_HISTORIES FK Joins to MTL_SYSTEM_ITEMS_B WMS_LPN_HISTORIES.INVENTORY_ITEM_ID
WMS_LPN_HISTORIES.ORGANIZATION_ID
TableWMS_LPN_INTERFACE FK Joins to MTL_SYSTEM_ITEMS_B WMS_LPN_INTERFACE.INVENTORY_ITEM_ID
WMS_LPN_INTERFACE.ORGANIZATION_ID
TableWMS_SHIPPING_TRANSACTION_TEMP FK Joins to MTL_SYSTEM_ITEMS_B WMS_SHIPPING_TRANSACTION_TEMP.INVENTORY_ITEM_ID
WMS_SHIPPING_TRANSACTION_TEMP.ORGANIZATION_ID
TableWMS_SKIP_TASK_EXCEPTIONS FK Joins to MTL_SYSTEM_ITEMS_B WMS_SKIP_TASK_EXCEPTIONS.INVENTORY_ITEM_ID
WMS_SKIP_TASK_EXCEPTIONS.ORGANIZATION_ID
TableWSH_PACKED_CONTAINERS FK Joins to MTL_SYSTEM_ITEMS_B WSH_PACKED_CONTAINERS.CONTAINER_INVENTORY_ITEM_ID
WSH_PACKED_CONTAINERS.ORGANIZATION_ID
TableXDP_ORDER_LINE_ITEMS FK Joins to MTL_SYSTEM_ITEMS_B XDP_ORDER_LINE_ITEMS.INVENTORY_ITEM_ID
XDP_ORDER_LINE_ITEMS.ORGANIZATION_ID
TableXDP_SERVICE_VAL_ACTS FK Joins to MTL_SYSTEM_ITEMS_B XDP_SERVICE_VAL_ACTS.INVENTORY_ITEM_ID
XDP_SERVICE_VAL_ACTS.ORGANIZATION_ID
TableXNC_FESW_REST_B FK Joins to MTL_SYSTEM_ITEMS_B XNC_FESW_REST_B.INVENTORY_ITEM_ID
XNC_FESW_REST_B.ORGANIZATION_ID
TableXNC_ITEM_ACTIONS_B FK Joins to MTL_SYSTEM_ITEMS_B XNC_ITEM_ACTIONS_B.INVENTORY_ITEM_ID
XNC_ITEM_ACTIONS_B.ORGANIZATION_ID
TableZX_EXCEPTIONS FK Joins to MTL_SYSTEM_ITEMS_B ZX_EXCEPTIONS.PRODUCT_ID
TableZX_EXEMPTIONS FK Joins to MTL_SYSTEM_ITEMS_B ZX_EXEMPTIONS.PRODUCT_ID