Search Results gmd_all_spec_vrs




Overview
Explore in AI Chat

Overview

APPS.GMD_QC_E_ALL_SPEC_VRS_DISP_V is a display-oriented view within the Oracle E-Business Suite Process Manufacturing (OPM) Quality module. It exposes version-level specification data for quality specifications defined in OPM, combining the underlying specification version record with descriptive "meaning" values decoded from the FND_LOOKUP_VALUES_VL lookup view. The suffix "DISP" indicates that the view is intended primarily for user-facing presentation, such as in Oracle Forms-based OPM Quality windows, OAF pages, and reporting queries where code values must be rendered as human-readable descriptions.

Because the view resolves lookup codes into their display meanings, it serves a key role in reporting and integration: consumers do not need to re-implement DECODE logic against FND_LOOKUP_VALUES to obtain readable labels for fields such as spec_type_disp, coa_type_disp, sample_inv_trans_ind_disp, and control_batch_step_ind_disp. The view is owned by APPS and is therefore typically referenced by custom reports, Discoverer workbooks, and BI Publisher data templates that require specification version information in a business-friendly form.

The user search term "qc_source" maps directly to the qc_source lookup reference used in the view definition to derive spec_type_disp via qc_source.meaning. This indicates that specification types (such as Ingredient, Product, Packaging, or Stability specifications) are resolved through the QC_SOURCE lookup type maintained in FND_LOOKUP_VALUES_VL.

Underlying Base Objects

The documented base objects for this view are:

  • GMD_ALL_SPEC_VRS (referenced via a SYNONYM) — the core table storing all specification versions in OPM Quality. It supplies the primary key spec_vr_id, parent spec_id, organization, dates, status flags, sampling plan references, and the numerous indicator flags and foreign key relationships (recipe, formula, routing, step, operation, customer, order) exposed by the view.
  • FND_LOOKUP_VALUES_VL (VIEW) — the standard Oracle Application Object Library lookup view, joined multiple times (aliased as qc_source, fly, fln, coa_ind) to translate stored codes into their display meanings.

The view therefore acts as a semantic layer over GMD_ALL_SPEC_VRS, enriching raw specification version data with lookup-based descriptive columns while preserving all original identifier and attribute columns.

Key Columns

Common Use Cases and Queries

Typical uses include quality specification reporting, COA setup review, and integration extracts where readable labels are required.

List active specification versions with decoded type for an organization:

SELECT spec_name, spec_vers, spec_type_disp, spec_vr_status_desc
FROM   apps.gmd_qc_e_all_spec_vrs_disp_v
WHERE  organization_code = 'M1'
AND    spec_vr_status = 'ACTIVE'

Review COA configuration across specifications:

SELECT spec_name, spec_vers, coa_type_disp,
       coa_at_ship_ind_disp, coa_at_invoice_ind_disp
FROM   apps.gmd_qc_e_all_spec_vrs_disp_v
WHERE  coa_type IS NOT NULL

Filter by specification source/type:

SELECT spec_name, spec_type, spec_type_disp
FROM   apps.gmd_qc_e_all_spec_vrs_disp_v
WHERE  spec_type IN (SELECT lookup_code
                     FROM   fnd_lookup_values_vl
                     WHERE  lookup_type = 'QC_SOURCE')

The view is read-only and should be queried through the APPS schema; it is well suited to BI Publisher and custom concurrent program output where specification data must be presented with meaningful, localized lookup descriptions.