Search Results qc_assy_typ




Overview
Explore in AI Chat

Overview

The QC_ASSY_TYP table serves as the master repository for Quality Control (QC) assay definitions within the Oracle E-Business Suite Process Manufacturing (GMD) Product Development module. An assay, in this context, represents a standardized test or analytical procedure used to measure a specific characteristic, property, or component of a material, such as purity, concentration, or physical attribute. This table is central to configuring and maintaining the library of quality tests that can be referenced throughout the manufacturing process, from raw material inspection to finished product release. Its role is to establish a consistent, organization-specific catalog of assay methods, ensuring standardized quality measurements across the enterprise.

Key Information Stored

Based on the provided ETRM metadata, the table's structure is defined by its primary and foreign keys. The primary identifier for a record is the QCASSY_TYP_ID. However, the business key, which ensures uniqueness for an assay within an operating unit, is the combination of ORGN_CODE (organization) and ASSAY_CODE. This design allows the same assay code to be used in different organizations with potentially different configurations. Critical foreign key columns link the assay master to supporting data: TEXT_CODE references descriptive text in QC_TEXT_HDR, QCUNIT_CODE links to the unit of measure in QC_UNIT_MST, and the ORGN_CODE itself is validated against the organization master tables (SY_ORGN_MST and SY_ORGN_MST_B).

Common Use Cases and Queries

A primary use case is the setup and maintenance of the assay library via the application's user interface, which ensures referential integrity. Technically, common queries involve retrieving assay details for integration with specification limits (QC_SPEC_MST) or for reporting on quality results. A typical SQL pattern to list all assays for a specific organization would be:

  • SELECT assay_code, text_code, qcunit_code FROM qc_assy_typ WHERE orgn_code = :org_code ORDER BY assay_code;

Another critical use case is validating assay existence and retrieving its master data when processing laboratory results (QC_RSLT_MST) or when defining technical parameters (GMD_TECH_PARAMETERS_B) for a recipe or formula. Reporting often joins this table to its related child tables to analyze assay usage and associated quality metrics.

Related Objects

The QC_ASSY_TYP table has extensive relationships within the GMD and Quality Management modules. It is a parent table referenced by several key transactional and master tables. These include QC_SPEC_MST (specification master), QC_RSLT_MST (result master), and QC_ASSY_VAL (assay validation details). Furthermore, it is integrated with Process Manufacturing's core tables: GMD_TECH_PARAMETERS_B and LM_TECH_HDR for defining technology parameters, and LM_SPRD_PRM for spread parameters. The foreign keys to QC_TEXT_HDR and QC_UNIT_MST provide essential descriptive and unit of measure data, completing the assay definition.