Results for “qc_smpl_mst”

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

Overview

QC_SMPL_MST is the quality control sample master table in Oracle E-Business Suite, owned by the GMD schema and delivered as part of the Process Manufacturing Product Development module. In Oracle EBS 12.1.1 and 12.2.2, it serves as the central repository for sample records created against batches, formulas, routing steps, operations, items, lots, customers, and vendors. Each row represents a discrete QC sample, capturing its origin, quantity, status, approval chain, and organizational context. The table participates directly in the quality workflow: samples defined here are subsequently tested, and the results are persisted in QC_RSLT_MST.

The table carries a documented primary key, QC_SMPL_MST_PK, defined on SAMPLE_ID. Based on the foreign key topology mined from the ETRM metadata, the table exhibits a satellite-leaning Data Vault classification. This is a modeling suggestion: QC_SMPL_MST primarily describes attributes of samples and carries numerous descriptive, mutable, and audit-oriented columns rather than acting as a pure transactional link or a central hub. Its dense set of reference foreign keys and attributes makes it a strong candidate for a satellite structure anchored to the sample business key.

Key Information Stored

The documented physical schema for release 12.2.2 contains 76 columns. The most significant are summarized below.

• SAMPLE_ID — surrogate primary key and the unique business-key candidate documented via the QC_SMPL_MST_PK unique index.
• ORGN_CODE — owning organization; foreign key to SY_ORGN_MST and SY_ORGN_MST_B.
• SAMPLE_NO and SAMPLE_DESC — the business identifier and description of the sample.
• BATCH_ID — the production batch the sample was drawn from; references PM_BTCH_HDR.
• FORMULA_ID and FORMULALINE_ID — formula context, with FORMULALINE_ID referencing FM_MATL_DTL.
• ROUTING_ID, ROUTINGSTEP_ID, ROUTINGSTEP_NO, OPRN_ID — routing and operation context; references FM_ROUT_DTL and FM_OPRN_MST.
• ITEM_ID, LOT_ID, WHSE_CODE, LOCATION — inventory identification and storage location; ITEM_ID references IC_ITEM_MST and IC_ITEM_MST_B, LOT_ID references IC_LOTS_MST.
• CUST_ID and VENDOR_ID — external party context; references OP_CUST_MST and PO_VEND_MST.
• SAMPLE_DATE, SAMPLED_BY, SAMPLE_QTY, SAMPLE_UM — when and by whom the sample was taken, and its quantity and unit of measure.
• SAMPLE_STATUS, SAMPLE_TEST_APPROVER, SAMPLE_FINAL_APPROVER — workflow state and approval attribution.
• SAMPLE_SOURCE and QC_REC_TYPE — origin and record type classification.
• ORDER_HEADER_ID, ORDER_LINE, ORDER_LINE_ID, ORDER_ORG_ID — order-related linkage where applicable.
• TEXT_CODE — references QC_TEXT_HDR for descriptive text.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE30 — the standard Oracle EBS extensibility (DDF) flexfield columns.
• DELETE_MARK — logical delete flag.

Common Use Cases and Queries

QC_SMPL_MST is queried extensively for sample tracking, batch quality reporting, and approval status monitoring. A typical pattern joins samples to their batches and items.

• List pending samples by organization: SELECT s.SAMPLE_NO, s.SAMPLE_DATE, s.SAMPLE_STATUS FROM GMD.QC_SMPL_MST s WHERE s.ORGN_CODE = :org AND s.DELETE_MARK = 0;
• Join samples to batch header: SELECT s.SAMPLE_ID, s.SAMPLE_NO, b.BATCH_NO FROM GMD.QC_SMPL_MST s, GMD.PM_BTCH_HDR b WHERE s.BATCH_ID = b.BATCH_ID;
• Trace samples to item and lot: SELECT s.SAMPLE_ID, s.ITEM_ID, s.LOT_ID, s.WHSE_CODE FROM GMD.QC_SMPL_MST s WHERE s.ITEM_ID = :item;
• Approval tracking by approver: SELECT s.SAMPLE_NO, s.SAMPLE_FINAL_APPROVER FROM GMD.QC_SMPL_MST s WHERE s.SAMPLE_STATUS = :status;

These patterns support laboratory dashboards, batch release reporting, and regulatory audit extracts.

Related Objects

The following objects are the most significant dependencies based on documented foreign key relationships.

• QC_RSLT_MST — references QC_SMPL_MST via SAMPLE_ID, holding sample test results.
• PM_BTCH_HDR — joined on BATCH_ID.
• FM_MATL_DTL — joined on FORMULALINE_ID.
• FM_OPRN_MST — joined on OPRN_ID.
• FM_ROUT_DTL — joined on ROUTING_ID and ROUTINGSTEP_ID.
• IC_ITEM_MST / IC_ITEM_MST_B — joined on ITEM_ID.
• IC_LOTS_MST — joined on ITEM_ID and LOT_ID.
• IC_WHSE_MST — joined on WHSE_CODE.
• OP_CUST_MST and PO_VEND_MST — joined on CUST_ID and VENDOR_ID respectively.
• SY_ORGN_MST / SY_ORGN_MST_B — joined on ORGN_CODE.