Search Results bom_structure_types_b

Overview

The BOM_STRUCTURE_TYPES_B table is a core master data table within the Oracle E-Business Suite Bills of Material (BOM) module. It serves as the foundational repository for defining and managing different categories or classifications of bill of material structures. These structure types are critical for organizing and controlling the various forms a product's manufacturing or engineering definition can take, such as standard, model, option class, or planning bills. The table's role is to provide a centralized, unique list of valid structure types that can be assigned to items and their associated bills, enabling complex product configuration, manufacturing planning, and engineering change management processes.

Key Information Stored

The table stores the essential identifiers and attributes for each defined structure type. The primary column is STRUCTURE_TYPE_ID, which is the system-generated, unique numeric primary key for each record. The STRUCTURE_TYPE_NAME column serves as a unique textual identifier (e.g., 'Standard', 'Model') and is enforced by a unique key constraint. A significant relational column is ITEM_CATALOG_GROUP_ID, which establishes a foreign key relationship to the MTL_ITEM_CATALOG_GROUPS_B table. This link allows structure types to be associated with specific item catalog categories, providing a mechanism for controlling which structure types are valid for different classes of items, thereby enforcing business rules during item and BOM definition.

Common Use Cases and Queries

A primary use case is validating and populating list of values (LOV) in forms where a structure type must be selected, such as when defining an item in the Item Master or creating a new bill. System administrators may query this table to audit or maintain the list of available structure types. Common reporting needs include listing all structure types along with their associated item catalog groups for business process documentation. A typical query to retrieve this information would be:

SELECT bst.STRUCTURE_TYPE_ID, bst.STRUCTURE_TYPE_NAME, bst.ITEM_CATALOG_GROUP_ID, mig.CATALOG_GROUP_NAME
FROM BOM.BOM_STRUCTURE_TYPES_B bst
LEFT JOIN INV.MTL_ITEM_CATALOG_GROUPS_B mig ON bst.ITEM_CATALOG_GROUP_ID = mig.CATALOG_GROUP_ID
ORDER BY bst.STRUCTURE_TYPE_NAME;

Another critical use case involves integration or data migration scripts, where validating incoming STRUCTURE_TYPE_NAME values against this master table is necessary to ensure data integrity before inserting records into dependent tables like BOM_BILL_OF_MATERIALS.

Related Objects

The BOM_STRUCTURE_TYPES_B table is central to a small but crucial network of related objects within the BOM module. It references one parent table and is referenced by two key child tables, as documented in the provided metadata.

• Referenced Parent Table: The table holds a foreign key to MTL_ITEM_CATALOG_GROUPS_B via the ITEM_CATALOG_GROUP_ID column, linking structure types to inventory catalog categories.
• Referencing Child Tables:
  • BOM_COMPONENT_TYPES: References this table via its STRUCTURE_TYPE_ID column. This relationship defines which component types (like Phantom, Standard) are valid for use within a given structure type.
  • BOM_STRUCTURE_TYPES_TL: The corresponding Translation table. It references the base table's STRUCTURE_TYPE_ID to store multilingual descriptions (STRUCTURE_TYPE_DESCRIPTION) for the structure types defined in BOM_STRUCTURE_TYPES_B.