Search Results gmd_sample_spec_disp_pk

Overview

The GMD_SAMPLE_SPEC_DISP table is a core data object within the Oracle E-Business Suite (EBS) Process Manufacturing (OPM) Product Development module (GMD). It functions as a transactional table that stores the display or presentation details for quality sample specifications. In the context of OPM Quality Management, a sample specification defines the quality tests and acceptable results for a material. This table specifically manages the link between a quality sample event and the associated specification display records, ensuring that the correct specification version and its presentation rules are applied during the quality inspection and data capture process for a collected sample.

Key Information Stored

The table's primary purpose is to associate a specific sample with its corresponding specification display record. The documented structure reveals two critical foreign key columns that form its composite primary key. The SAMPLE_ID column links to the unique identifier for a physical or logical sample collected for testing. The EVENT_SPEC_DISP_ID column links to the specification display setup, which controls how the specification's tests and limits are presented to the user during data entry. This relationship ensures that for every sample requiring analysis, the system can retrieve the precise specification format and version that was valid and applicable at the time of sampling.

Common Use Cases and Queries

This table is central to operations where quality results are recorded or reported against a sample. A primary use case is the dynamic generation of data entry forms in the Quality module, where the tests and tolerances displayed are driven by the specification linked via this table. For reporting, it is essential for joining sample results back to their governing specifications. A typical query pattern involves joining this table to the sample master (GMD_SAMPLES) and the specification display details (GMD_EVENT_SPEC_DISP).

• Sample Specification Lookup: To retrieve the specification details for a given sample ID for audit or data validation purposes.
• Results Analysis: Joining GMD_SAMPLE_SPEC_DISP to results tables (like GMD_RESULTS) to analyze outcomes against the specified limits and tolerances.

Related Objects

The table's relationships are explicitly defined by its primary key constraint, GMD_SAMPLE_SPEC_DISP_PK, which is composed of EVENT_SPEC_DISP_ID and SAMPLE_ID. These columns are foreign keys referencing other core OPM Quality tables.

• GMD_SAMPLES: The SAMPLE_ID column references the primary key of this table, which stores master information about all collected samples (e.g., item, lot, date).
• GMD_EVENT_SPEC_DISP: The EVENT_SPEC_DISP_ID column references this table, which holds the configuration for how a specification is displayed, including the specific tests and their sequence for a given quality event or context.

This structure positions GMD_SAMPLE_SPEC_DISP as a critical junction table that enforces the business rule linking a physical sample to the exact version and presentation format of its quality specification.