Search Results qc_smpl_mst




Overview
Explore in AI Chat

Overview

The QC_SMPL_MST table is the central repository for quality control sample master data within Oracle E-Business Suite Process Manufacturing (GMD). It functions as the primary transactional table for managing and tracking physical samples collected for quality inspection and testing. Its role is integral to the Quality Management module, linking quality sampling activities to core manufacturing and inventory processes such as batches, formulas, routings, items, and lots. The table's extensive foreign key relationships underscore its position as a critical hub connecting quality data to the broader supply chain and production execution system.

Key Information Stored

The table's primary key is the SAMPLE_ID, a unique system-generated identifier for each sample record. Based on its documented foreign key relationships, the table stores numerous foreign key columns that contextualize the sample's origin. Key reference columns include BATCH_ID (linking to the production batch in PM_BTCH_HDR), ITEM_ID and LOT_ID (linking to the specific inventory item and lot in IC_ITEM_MST and IC_LOTS_MST), and FORMULALINE_ID, OPRN_ID, ROUTING_ID, and ROUTINGSTEP_NO (linking the sample to specific formula details and process routing steps). Additional columns like WHSE_CODE, ORGN_CODE, CUST_ID, and VENDOR_ID define the sample's associated warehouse, organization, customer, or vendor. The TEXT_CODE column links to descriptive text in QC_TEXT_HDR.

Common Use Cases and Queries

This table is central to queries for sample tracking, quality history, and compliance reporting. Common scenarios include retrieving all samples for a specific production batch to review its quality history, or listing samples taken for a particular inventory lot to assess its quality status. A typical query might join QC_SMPL_MST to QC_RSLT_MST to fetch all test results for samples collected within a given date range. Another common pattern is to trace samples back to their production context by joining with PM_BTCH_HDR and IC_LOTS_MST. For example, a report to find all samples related to a recalled lot would utilize the LOT_ID link. Data from this table is also essential for generating Certificate of Analysis (CoA) documents and audit trails.

Related Objects

QC_SMPL_MST has a dense network of dependencies, primarily as a parent table referenced by QC_RSLT_MST (which stores the actual test results for each sample). It is a child table to numerous master and transactional tables across EBS modules, as evidenced by its foreign keys. Key parent tables include:

This structure positions QC_SMPL_MST as a pivotal integration point between Quality (GMD), Inventory (INV), and Order Management (ONT) modules.