Results for “parent_rev_change_code”

8 results




Overview
Explore in AI Chat

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

BOM_COMPONENT_TYPES is a configuration table in the Oracle Bills of Material (BOM) module, owned by the BOM schema. It governs which component catalog groups are valid for a given structure type, effectively defining the permitted combinations of bill structure and component classification used when constructing bills of material. Because it constrains how components may be assigned across different structure types, it acts as a validation and control point for BOM definition and component selection.

Under the heuristic Data Vault classification mined from its foreign key structure, this table is characterized as satellite-leaning. In Data Vault modeling terms this suggests the table behaves primarily as a descriptive satellite attached to a parent hub (the structure type) rather than as an independent hub or a pure link, though its composite key does also encode a relationship between two business concepts.

Key Information Stored

The table carries a composite primary key, BOM_COMPONENT_TYPES_PK, defined over STRUCTURE_TYPE_ID and COMPONENT_CATALOG_GROUP_ID. STRUCTURE_TYPE_ID is a foreign key to BOM_STRUCTURE_TYPES_B, identifying the bill structure type being controlled. COMPONENT_CATALOG_GROUP_ID identifies the component catalog group permitted within that structure type. A unique index, BOM_COMPONENT_TYPES_U1, is documented over the reversed column pair (COMPONENT_CATALOG_GROUP_ID, STRUCTURE_TYPE_ID), confirming the business-key candidate is the combination of these two identifiers.

Effective-dating columns are present: EFFECTIVE_DATE and DISABLE_DATE record when a given structure-type/component-group association becomes active and when it is retired. Revision change control is supported through PARENT_REV_CHANGE_CODE and COMPONENT_REV_CHANGE_CODE, which govern how revision changes propagate for parent and component items respectively.

Standard EBS audit and descriptive-flexfield columns are also included: LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN, ATTRIBUTE_CATEGORY, and ATTRIBUTE1 through ATTRIBUTE15. The fifteen ATTRIBUTE columns provide a descriptive flexfield for customer-specific extension without schema modification.

Common Use Cases and Queries

Typical use cases include validating which component catalog groups may be used with a particular structure type, driving list-of-values behavior during bill entry, and reporting on the currently effective component-type configuration. Because the table is effective-dated, queries should filter on the effective window and exclude disabled records.

A representative query returning active component types for a structure type:

  • SELECT bct.component_catalog_group_id, bct.structure_type_id, bct.effective_date, bct.disable_date
  • FROM bom.bom_component_types bct
  • WHERE bct.structure_type_id = :p_structure_type_id
  • AND bct.effective_date <= SYSDATE
  • AND (bct.disable_date IS NULL OR bct.disable_date > SYSDATE);

Reports commonly join this table to the structure types parent to resolve descriptive names, and to component-related tables by COMPONENT_CATALOG_GROUP_ID to enumerate actual bill components governed by each configuration row. Audit reporting can leverage the CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, and LAST_UPDATE_DATE columns to track configuration changes over time.

Related Objects

The following objects are most significant in relation to BOM_COMPONENT_TYPES:

  • BOM_STRUCTURE_TYPES_B — the parent table referenced by the foreign key BOM_COMPONENT_TYPES.STRUCTURE_TYPE_ID. This is the primary dependency; joins use STRUCTURE_TYPE_ID.
  • BOM_COMPONENT_TYPES_PK — the composite primary key index (STRUCTURE_TYPE_ID, COMPONENT_CATALOG_GROUP_ID).
  • BOM_COMPONENT_TYPES_U1 — the unique index over (COMPONENT_CATALOG_GROUP_ID, STRUCTURE_TYPE_ID), representing the business-key candidate.
  • BOM_COMPONENTS_B / BOM_COMPONENTS_TL — the bill component tables that reference catalog groups, commonly joined by COMPONENT_CATALOG_GROUP_ID to constrain valid components.
  • BOM_BILL_OF_MATERIALS — bills whose structure and component composition are governed by the structure-type/component-group rules defined here.

These relationships make BOM_COMPONENT_TYPES a supporting configuration object that enforces consistency between structure types and component catalog groups across the BOM module.