Search Results gmd_units_b




Overview
Explore in AI Chat

Overview

The GMD_UNITS_B table is a core master data table within the Oracle E-Business Suite Process Manufacturing (GMD) module, specifically for the Product Development sub-module. It serves as the central repository for defining and storing units of measure (UOM) used specifically for Quality Control (QC) assays. In the context of manufacturing processes, particularly in industries like pharmaceuticals, chemicals, and food and beverage, precise measurement of test results is critical. This table provides the standardized UOM codes—such as 'MG', 'ML', 'PPM', or 'PERCENT'—that are referenced throughout the QC lifecycle to ensure consistency in the recording, specification, and reporting of assay results.

Key Information Stored

While the provided ETRM excerpt does not list all columns, the primary and foreign key relationships define its essential structure. The table's primary key is the QCUNIT_CODE column, which stores the unique identifier for each unit of measure. A critical foreign key relationship exists via the TEXT_CODE column, which links to the QC_TEXT_HDR table. This linkage allows for the association of extensive descriptive text, names, and translations for each UOM code, enabling multilingual support and detailed documentation. The table's design centralizes UOM definitions to enforce data integrity and standardization across all QC operations.

Common Use Cases and Queries

The primary use case is the maintenance of the UOM master list within the application's front-end, typically via a dedicated form. This table is queried whenever a user defines a QC specification or enters a test result, presenting a validated list of units. Common reporting and integration queries involve joining this table to result and specification data. A fundamental SQL pattern is retrieving a UOM's code with its associated description:

  • SELECT u.qcunit_code, t.text
    FROM gmd_units_b u, qc_text_hdr t
    WHERE u.text_code = t.text_code
    AND u.qcunit_code = :1;

Another critical query supports data validation and audit reports by listing all QC specifications or results that use a specific unit of measure, leveraging its foreign key relationships.

Related Objects

As documented, GMD_UNITS_B has integral relationships with several key QC tables. It is referenced as a foreign key by:

  • QC_RSLT_MST (QC Result Master): Stores actual test results, using QCUNIT_CODE to denote the unit of the measured value.
  • QC_SPEC_MST (QC Specification Master): Stores the acceptable range or target for a test, using QCUNIT_CODE to define the specification's unit.

Furthermore, it references:

  • QC_TEXT_HDR: Provides the descriptive text (name, translation) for the unit code via the TEXT_CODE foreign key, which is essential for user interfaces and reports.

This network of relationships positions GMD_UNITS_B as a foundational reference table for quality management within Process Manufacturing.