Results for “outside_spec_min”

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

Overview

QC_SPEC_MST is the Quality Control specification master table in the Oracle E-Business Suite Process Manufacturing (OPM) Product Development module (GMD schema). It stores the definition of quality control specifications that govern testing, sampling, and acceptance criteria for items, lots, formulas, batches, and operations. Each row represents a discrete QC specification applicable to a particular item/context combination, defining numeric targets, tolerance bands, units of measure, effective date ranges, and out-of-specification action handling. The table is central to GMD quality workflows, feeding QC result capture (QC_RSLT_MST) and Certificates of Analysis (GMD_COA_DETAILS).

From a Data Vault modeling perspective, the FK profile suggests a satellite-leaning classification. The table carries descriptive and contextual attributes (spec limits, dates, flags) and accumulates many foreign keys pointing outward to business hubs such as items, lots, customers, vendors, batches, and organizations. Rather than acting as a true hub itself, it behaves largely as a descriptive satellite attached to those master entities, though QC_SPEC_ID serves as a legitimate surrogate key for the specification entity.

Key Information Stored

The primary key is QC_SPEC_ID, enforced by the unique index QC_SPEC_MST_PK. No alternate unique index is documented, so surrogate key access is the reliable join path. Among the most significant columns:

• QC_SPEC_ID — surrogate primary key identifying each specification row.
• QCASSY_TYP_ID — links to the assay/specification type (QC_ASSY_TYP), classifying the test category.
• ITEM_ID, LOT_ID, BATCH_ID, ORGN_CODE — scope the specification to an item, lot, batch, and organization.
• FORMULA_ID, FORMULALINE_ID, ROUTING_ID, ROUTINGSTEP_ID, OPRN_ID — tie the spec to formula and routing/operation context.
• TARGET_SPEC, MIN_SPEC, MAX_SPEC, MIN_CHAR, MAX_CHAR — numeric and character target/tolerance definitions.
• INSIDE_SPEC_MIN, INSIDE_SPEC_MAX, OUTSIDE_SPEC_MIN, OUTSIDE_SPEC_MAX — refined tolerance bands aligning to action codes.
• QCUNIT_CODE — unit of measure for the specification.
• FROM_DATE, TO_DATE — effective dating of the specification.
• OUTACTION_CODE, OUTACTION_INTERVAL — action to trigger when limits are breached.
• CUST_ID, VENDOR_ID — customer- or vendor-specific specifications and certification flags.
• TEXT_CODE, TEXT_SPEC — descriptive/long text specification reference.
• DELETE_MARK — soft-delete indicator.

Common Use Cases and Queries

Typical usage includes retrieving active specifications for an item/organization, validating results against limits, and driving CoA output.

• Active spec lookup by item and org:

  SELECT qc_spec_id, target_spec, min_spec, max_spec, qcunit_code
  FROM   gmd.qc_spec_mst
  WHERE  item_id = :item_id
  AND    orgn_code = :orgn
  AND    delete_mark = 0
  AND    SYSDATE BETWEEN from_date AND NVL(to_date, SYSDATE);

• Customer- or vendor-specific specifications joined to OP_CUST_MST / PO_VEND_MST by CUST_ID or VENDOR_ID.
• Batch-level specs joined to PM_BTCH_HDR via BATCH_ID for production quality reporting.
• CoA generation joining GMD_COA_DETAILS.QC_SPEC_ID back to this table.
• Result evaluation via QC_RSLT_MST.QC_SPEC_ID, comparing captured results to INSIDE/OUTSIDE limits.

Related Objects

The most significant related objects, based on documented FK relationships:

• QC_RSLT_MST — child table storing results, joined on QC_RSLT_MST.QC_SPEC_ID = QC_SPEC_MST.QC_SPEC_ID.
• GMD_COA_DETAILS and GMD_SPEC_MAPPING — reference QC_SPEC_ID for CoA and spec mapping.
• IC_ITEM_MST / IC_ITEM_MST_B — item master join on ITEM_ID.
• IC_LOTS_MST — lot context via ITEM_ID and LOT_ID.
• PM_BTCH_HDR — batch linkage via BATCH_ID.
• QC_ASSY_TYP, QC_UNIT_MST, QC_ACTN_MST — supporting quality masters.
• FM_MATL_DTL, FM_OPRN_MST, FM_ROUT_DTL — formula/routing context.
• OP_CUST_MST, PO_VEND_MST, SY_ORGN_MST — customer, vendor, and organization masters.