Search Results storage_org

Overview

APPS.GMD_QM_E_MATERIAL_SOURCES_V is a read-only database view owned by the APPS schema within the Oracle E-Business Suite Process Manufacturing (OPM) Quality Management module. The view is internally typed and carries the FND Design Data identifier GMD.GMD_QM_E_MATERIAL_SOURCES_V, meaning it is delivered and maintained as part of standard Oracle application design metadata. Its status is VALID in both 12.1.1 and 12.2.2.

The view consolidates material source information associated with sampling events, batch and recipe context, and storage definitions. It exposes columns that join material sources to plant, subinventory, locator, specification, variant, sampling event, resource, and formula data. In practice it serves as a flattened reporting and integration surface for quality material source records, allowing downstream programs, discoverer reports, and custom integrations to retrieve material source details without navigating the underlying normalized OPM tables directly.

Oracle explicitly designates this object as Oracle Internal Use Only and warns that access to application data through this object is unsupported except from standard Oracle Applications programs. Custom use should therefore be treated as read-only and subject to change between releases.

Underlying Base Objects

The documented ETRM dependency list identifies the following base objects referenced by the view: FM_FORM_MST_B, GMD_RECIPES_B, GMD_SPECIFICATIONS_B, GMD_SS_MATERIAL_SOURCES, GMD_SS_STORAGE_PACKAGE, GMD_SS_VARIANTS, GME_BATCH_HEADER, MTL_ITEM_LOCATIONS_KFV, and MTL_PARAMETERS. All are accessed through APPS synonyms except MTL_ITEM_LOCATIONS_KFV, which is itself a key-flexfield view. A parallel ETRM 12.2.2 dependency listing references FM_FORM_MST_B and GMD_RECIPES, confirming that the formula and recipe master tables anchor the formula/recipe columns exposed.

Conceptually, GMD_SS_MATERIAL_SOURCES supplies the core material source rows; GMD_SS_STORAGE_PACKAGE and GMD_SS_VARIANTS provide storage and variant context; GMD_SPECIFICATIONS_B and related specification joins yield the storage and default specification identifiers, names, and versions; GME_BATCH_HEADER supplies batch-level context such as batch number and plant; FM_FORM_MST_B and GMD_RECIPES_B provide formula, recipe, and version information; MTL_PARAMETERS and MTL_ITEM_LOCATIONS_KFV resolve storage organization, subinventory, and locator descriptions.

Key Columns

• PLANT_CODE, SS_ID, BATCH_NO — plant identifier, material source surrogate identifier, and batch number.
• RECIPE_NO, RECIPE_VERSION, FORMULA_NO, FORMULA_VERS, PACKAGE_NAME — recipe and formula identifiers and versions linking the source to its manufacturing definition.
• LOT_NUMBER, QUANTITY, UOM — lot and quantity attributes for the sourced material.
• STORAGE_ORG — the storage organization associated with the material source; this is the column most frequently targeted when users search for "storage_org," since it identifies the inventory organization where sampled or sourced material is stored.
• STORAGE_SUBINVENTORY, STORAGE_LOCATOR — the subinventory and locator (key-flexfield) of the storage position.
• STORAGE_SPEC_ID, STORGE_SPEC_NAME, STORAGE_SPEC_VERSION — storage specification identity (note the documented misspelling "STORGE" in the name column).
• DEFAULT_SPEC_ID, DEFAULT_SPEC_NAME, DEFAULT_SPEC_VERSION — default quality specification for the source.
• VARIANT_ID, VARIANT_NO, VARIANT_SCHED_START_DATE — variant definition and its scheduled start date.
• SAMPLING_EVENT_ID, SAMPLE_QTY, SAMPLE_QTY_UOM, SAMPLES_PER_TP, RETAINED_SAMPLES — sampling event and sampling quantity parameters.
• RESOURCES, RESOURCE_INSTANCE_ID, YIELD_DATE — resource assignment and yield timing.

Common Use Cases and Queries

Typical scenarios include listing material sources by storage organization, reporting sampling requirements per batch or recipe, and integrating quality sampling definitions into external systems.

Query material sources for a given storage organization:

SELECT material_source_id, plant_code, batch_no, lot_number, storage_org, storage_subinventory, storage_locator
FROM apps.gmd_qm_e_material_sources_v
WHERE storage_org = :p_storage_org;

Retrieve sampling and specification context for a single material source:

SELECT material_source_id, ss_id, batch_no, sample_qty, sample_qty_uom,
       storage_spec_id, storge_spec_name, default_spec_name
FROM apps.gmd_qm_e_material_sources_v
WHERE material_source_id = :p_source_id;

Join to a batch or recipe for traceability reporting:

SELECT batch_no, recipe_no, recipe_version, formula_no, formula_vers, variant_no, yield_date
FROM apps.gmd_qm_e_material_sources_v
WHERE plant_code = :p_plant
ORDER BY batch_no, material_source_id;

Because the view is unsupported for direct external access, these queries should target reporting or read-only integration purposes only, and any custom code should be regression-tested across 12.1.1 and 12.2.2 upgrades.