Results for “delayed_lot_entry”

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

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:

• SPEC_VR_ID — surrogate primary key; uniquely identifies each supplier specification validity rule.
• SPEC_ID — the parent specification to which the validity rule applies.
• SUPPLIER_ID / SUPPLIER_SITE_ID — the supplier and supplier site qualified by the rule.
• ORGN_CODE / ORG_ID / ORGANIZATION_ID — warehouse/organization context for the rule.
• PO_HEADER_ID / PO_LINE_ID — purchasing document linkage for receipt-driven inspection.
• SPEC_VR_STATUS — lifecycle status of the validity rule.
• START_DATE / END_DATE — effective date range controlling rule applicability.
• SAMPLING_PLAN_ID — foreign key to QA_SAMPLING_PLANS, defining the sampling strategy.
• COA_TYPE, COA_AT_SHIP_IND, COA_AT_INVOICE_IND, COA_REQ_FROM_SUPL_IND — Certificate of Analysis handling requirements.
• AUTO_SAMPLE_IND, SAMPLE_INV_TRANS_IND, RECEIPT_FREQUENCY — sampling and receiving behavior flags.
• IN_SPEC_LOT_STATUS_ID / OUT_OF_SPEC_LOT_STATUS_ID — lot status outcomes for in-spec and out-of-spec results.
• DELETE_MARK — logical deletion indicator.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY — standard audit columns.

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.