Search Results gmd_tests_b




Overview
Explore in AI Chat

Overview

The GMD_TESTS_B table is a core data object within the Oracle E-Business Suite Process Manufacturing (GMD) Product Development module. It serves as the master table for defining and storing the fundamental properties of quality control tests, also known as assays. These test definitions are essential for establishing the quality specifications and analytical procedures used to evaluate raw materials, in-process materials, and finished goods throughout the manufacturing lifecycle. The table's structure enforces uniqueness at the organizational level, ensuring that assay codes are unique within a specific operating unit (ORGN_CODE).

Key Information Stored

The table's primary purpose is to define the test's master attributes. Its key columns, as indicated by the primary and unique keys, include the system-generated primary key QCASSY_TYP_ID, the organizational code ORGN_CODE which links to SY_ORGN_MST_B, and the unique ASSAY_CODE identifier. Other critical columns referenced in the metadata are QCUNIT_CODE, which defines the default unit of measure for the test results and is linked to a unit of measure table, and TEXT_CODE, which links to QC_TEXT_HDR to store descriptive text, instructions, or notes associated with the test procedure.

Common Use Cases and Queries

This table is central to configuring the quality management framework. Common use cases include setting up a library of standard tests (e.g., pH, viscosity, potency) for product specifications, and defining the tests required for a specific material or process recipe. For reporting and data validation, typical SQL queries involve joining this master table with its child transactional tables. A fundamental pattern is retrieving all active test definitions for an organization:

  • SELECT assay_code, description, qcunit_code FROM gmd_tests_b WHERE orgn_code = :org_id AND delete_mark = 0;

Another critical query joins GMD_TESTS_B with GMD_TEST_VALUES_B to analyze the permissible or historical results for a given test, leveraging the foreign key relationship on QCASSY_TYP_ID.

Related Objects

GMD_TESTS_B is a pivotal master table with several key relationships. The primary foreign key dependency is the GMD_TEST_VALUES_B table, which stores the actual test results, specifications, or valid value ranges and references GMD_TESTS_B via the QCASSY_TYP_ID column. As per the metadata, it also has foreign key relationships to supporting reference tables: SY_ORGN_MST_B (for the operating unit validation via ORGN_CODE) and QC_TEXT_HDR (for descriptive text via TEXT_CODE). The QCUNIT_CODE column typically references a unit of measure table, such as QC_UNITS_MST. This table is also foundational for views and interfaces used in the Quality Management and Product Development forms within the EBS application.