Search Results gmd_customer_spec_vrs_pk

Overview

GMD_CUSTOMER_SPEC_VRS is an Oracle Process Manufacturing (OPM) Product Development table that stores customer specification validity rules. It belongs to the GMD schema and is classified under the Process Manufacturing Product Development module. The table governs the conditions under which customer specifications apply to specific orders, order lines, ship-to sites, and organizations — defining the start and end dates of validity, the status of the validity rule, and associated quality assurance behaviors such as sampling plans and Certificates of Analysis (COA).

In Oracle EBS 12.1.1 and 12.2.2, this table functions as the validity-rule layer connecting customer-defined specifications to transactional and organizational contexts. Each row establishes an effective-dated, status-controlled rule that determines when a customer specification is enforceable. The metadata classifies this object heuristically as standalone within a Data Vault modeling context, suggesting it behaves as an independent satellite with no strong hub/link dependency in the mined foreign-key structure, though it does reference QA_SAMPLING_PLANS via SAMPLING_PLAN_ID.

Key Information Stored

The table contains 60 documented columns. The most operationally significant are summarized below.

SPEC_VR_ID — Surrogate primary key (GMD_CUSTOMER_SPEC_VRS_PK). Uniquely identifies each validity rule.
SPEC_ID — Reference to the parent customer specification being made valid.
CUST_ID — The customer to whom the validity rule applies.
ORGN_CODE / ORGANIZATION_ID — Organizational context (code and internal identifier) for the rule.
ORDER_ID, ORDER_LINE, ORDER_LINE_ID — Optional order-level scoping, allowing a rule to be tied to a specific sales order line.
SHIP_TO_SITE_ID — Ship-to site scoping for the validity rule.
SPEC_VR_STATUS — Status of the validity rule (active/inactive lifecycle control).
START_DATE / END_DATE — Effective-dating window during which the rule is valid.
SAMPLING_PLAN_ID — Foreign key to QA_SAMPLING_PLANS, linking the rule to a quality sampling plan.
COA_TYPE, COA_AT_SHIP_IND, COA_AT_INVOICE_IND, COA_REQ_FROM_SUPL_IND — Certificate of Analysis configuration flags controlling when COAs are required.
SAMPLE_INV_TRANS_IND, LOT_OPTIONAL_ON_SAMPLE — Sampling behavior indicators for inventory transactions and lot handling.
DELETE_MARK — Soft-delete flag used throughout OPM tables.
ERECORD_SPEC_VR_ID, MIGRATED_IND — Electronic record and migration tracking columns.

The unique index GMD_CUSTOMER_SPEC_VRS_PK on SPEC_VR_ID is the business-key candidate. The remaining ATTRIBUTE1 through ATTRIBUTE30 columns provide extensibility via the descriptive flexfield mechanism (ATTRIBUTE_CATEGORY).

Common Use Cases and Queries

Typical reporting scenarios include identifying active specification validity rules by customer, order, or organization, and auditing COA requirements. A common query retrieves currently effective rules:

SELECT vr.SPEC_VR_ID, vr.SPEC_ID, vr.CUST_ID, vr.ORGN_CODE, vr.SPEC_VR_STATUS, vr.START_DATE, vr.END_DATE FROM GMD.GMD_CUSTOMER_SPEC_VRS vr WHERE vr.DELETE_MARK = 0 AND SYSDATE BETWEEN vr.START_DATE AND vr.END_DATE AND vr.SPEC_VR_STATUS = 'A';
Joining to QA_SAMPLING_PLANS on SAMPLING_PLAN_ID to report which validity rules carry sampling obligations.
Filtering by ORDER_ID and SHIP_TO_SITE_ID to determine which specification rule applies to a specific shipment.
Reporting on COA_AT_SHIP_IND or COA_AT_INVOICE_IND to support quality and billing compliance audits.

Related Objects

QA_SAMPLING_PLANS — Referenced via GMD_CUSTOMER_SPEC_VRS.SAMPLING_PLAN_ID; defines the sampling plan tied to a validity rule.
GMD_CUSTOMER_SPECS (parent specification table) — Related through SPEC_ID, holding the specification definition itself.
OE_ORDER_HEADERS_ALL / OE_ORDER_LINES_ALL — Correlation through ORDER_ID and ORDER_LINE_ID for order-scoped rules.
HZ_CUST_ACCOUNTS — Correlates to CUST_ID for customer identification.
HR_OPERATING_UNITS / ORG_ORGANIZATION_DEFINITIONS — Correlates to ORGANIZATION_ID for organizational context.

These relationships make GMD_CUSTOMER_SPEC_VRS a central control point for customer-specific quality and specification enforcement in OPM Product Development.

INDEX: GMD.GMD_CUSTOMER_SPEC_VRS_PK 12.1.1
owner:GMD, object_type:INDEX, object_name:GMD_CUSTOMER_SPEC_VRS_PK, status:VALID,
Table: GMD_CUSTOMER_SPEC_VRS 12.2.2
owner:GMD, object_type:TABLE, fnd_design_data:GMD.GMD_CUSTOMER_SPEC_VRS, object_name:GMD_CUSTOMER_SPEC_VRS, status:VALID, product: GMD - Process Manufacturing Product Development , description: OPM Work-in-Process Specification validity rules , implementation_dba_data: GMD.GMD_CUSTOMER_SPEC_VRS ,
Table: GMD_CUSTOMER_SPEC_VRS 12.1.1
owner:GMD, object_type:TABLE, fnd_design_data:GMD.GMD_CUSTOMER_SPEC_VRS, object_name:GMD_CUSTOMER_SPEC_VRS, status:VALID, product: GMD - Process Manufacturing Product Development , description: OPM Work-in-Process Specification validity rules , implementation_dba_data: GMD.GMD_CUSTOMER_SPEC_VRS ,
INDEX: GMD.GMD_CUSTOMER_SPEC_VRS_PK 12.2.2
owner:GMD, object_type:INDEX, object_name:GMD_CUSTOMER_SPEC_VRS_PK, status:VALID,
12.2.2 DBA Data 12.2.2
12.1.1 DBA Data 12.1.1
12.2.2 DBA Data 12.2.2
12.1.1 DBA Data 12.1.1
TABLE: GMD.GMD_CUSTOMER_SPEC_VRS 12.2.2
owner:GMD, object_type:TABLE, fnd_design_data:GMD.GMD_CUSTOMER_SPEC_VRS, object_name:GMD_CUSTOMER_SPEC_VRS, status:VALID,
TABLE: GMD.GMD_CUSTOMER_SPEC_VRS 12.1.1
owner:GMD, object_type:TABLE, fnd_design_data:GMD.GMD_CUSTOMER_SPEC_VRS, object_name:GMD_CUSTOMER_SPEC_VRS, status:VALID,
eTRM - GMD Tables and Views 12.2.2
description: QC Module Text Lines. Descriptive text for all tables in this module. ,
eTRM - GMD Tables and Views 12.1.1
description: QC Module Text Lines. Descriptive text for all tables in this module. ,
eTRM - GMD Tables and Views 12.1.1
description: QC Module Text Lines. Descriptive text for all tables in this module. ,
eTRM - GMD Tables and Views 12.2.2
description: QC Module Text Lines. Descriptive text for all tables in this module. ,