Search Results overlay_ind




Overview
Explore in AI Chat

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

Overview

GMD_SPEC_SUMMARY is an APPS-owned database view in the Oracle E-Business Suite Process Manufacturing Product Development (GMD) module. It provides a consolidated, denormalized presentation of specification records, joining the base specification entity to its quality status, inventory organization, and item master data in a single queryable object. The view is documented as VALID in ETRM for EBS 12.1.1 and 12.2.2 and carries the description "View for Summary of Specifications."

Its principal reporting value lies in the fact that it resolves the SPEC_STATUS code into a human-readable status description and resolves numeric organization and item identifiers into recognizable codes and concatenated segment values. This makes the view suitable for direct use in custom reports, concurrent program extracts, and integration queries without requiring the caller to reimplement the joins to the status and item master tables. Because the view is defined over the _VL (view/translation) variants of the specification and QC status entities, it returns the appropriate language-specific descriptions for the session.

Underlying Base Objects

The view is defined over four documented base objects:

The status and item joins are inner and outer respectively, meaning a specification is only returned when a matching specification-entity status exists, but the item number may be null. The view's owner is APPS.

Key Columns

Common Use Cases and Queries

Typical uses include specification status listings, item-to-specification cross-reference reports, and extracts feeding quality or compliance systems that require the readable status description rather than the internal code.

Listing active specification statuses by organization:

SELECT spec_name, spec_vers, item_number,
       owner_organization_code, spec_status, spec_status_desc
FROM   apps.gmd_spec_summary
WHERE  delete_mark = 0
ORDER  BY owner_organization_code, spec_name;

Filtering by a specific status description sought via the spec_status_desc term:

SELECT spec_id, spec_name, spec_status_desc
FROM   apps.gmd_spec_summary
WHERE  spec_status_desc = :p_status
AND    owner_organization_id = :p_org_id;

Joining specifications to flexfield attribute values for a given item:

SELECT item_number, spec_name, attribute1, attribute2
FROM   apps.gmd_spec_summary
WHERE  inventory_item_id = :p_item_id
AND    delete_mark = 0;