Search Results gmd_supplier_spec_vrs




Overview
Explore in AI Chat

Overview

GMD_SUPPLIER_SPEC_VRS is a Product Development table in the Oracle Process Manufacturing (OPM) module, owned by the GMD schema. It stores supplier specification validity rules that govern how purchased materials are inspected, sampled, and accepted against quality specifications tied to approved suppliers, supplier sites, and purchasing documents. The table description labels it "OPM Work-in-Process Specification validity rules," reflecting its role in controlling the effective dates, status, and sampling behavior of supplier specifications within the quality and receiving lifecycle.

From a data modeling perspective, the ETRM metadata classifies this object heuristically as a standalone structure with no outbound foreign keys other than a reference to QA_SAMPLING_PLANS via SAMPLING_PLAN_ID. This suggests it functions as a satellite-type entity that captures attribute-level detail (validity, dates, COA requirements, sampling rules) around supplier specifications rather than acting as a hub or link. The single-column primary key GMD_SUPPLIER_SPEC_VRS_PK on SPEC_VR_ID provides the surrogate identifier for each validity rule record.

Key Information Stored

The table contains 68 documented columns in the 12.2.2 physical schema. The most operationally significant include:

The only documented unique business-key candidate is the primary key column SPEC_VR_ID; no alternate unique index is reported. The 30 ATTRIBUTE columns provide DFF extensibility.

Common Use Cases and Queries

Typical scenarios include determining which specification rules apply to a supplier at receipt time, identifying sampling requirements during PO receipt, and reporting on expired or inactive validity rules. A representative query retrieves active rules for a supplier:

  • Filter by SUPPLIER_ID, SUPPLIER_SITE_ID, and effective dates: SELECT spec_vr_id, spec_id, orgn_code, start_date, end_date FROM gmd.gmd_supplier_spec_vrs WHERE supplier_id = :p_supplier AND delete_mark = 0 AND TRUNC(SYSDATE) BETWEEN start_date AND NVL(end_date, SYSDATE + 1);
  • Join to QA_SAMPLING_PLANS on SAMPLING_PLAN_ID to resolve sampling instructions.
  • Join to purchasing tables on PO_HEADER_ID and PO_LINE_ID for receipt-level quality reporting.
  • Aggregate by COA_TYPE or COA_REQ_FROM_SUPL_IND to assess certificate compliance across the supplier base.

Related Objects

  • QA_SAMPLING_PLANS — referenced via SAMPLING_PLAN_ID; supplies the sampling plan definition.
  • GMD_SPECIFICATIONS / GMD_SPEC_TABLES — parent specification metadata referenced by SPEC_ID.
  • PO_HEADERS_ALL / PO_LINES_ALL — purchasing documents linked through PO_HEADER_ID and PO_LINE_ID.
  • QA_LOTS / QA_RESULTS — quality outcome tables consuming in-spec/out-of-spec status assignments.
  • GMD_SUPPLIER_SPECS — supplier specification master that this validity table qualifies.