Search Results gmd_formula_item_type




Overview
Explore in AI Chat

Overview

APPS.GME_STEP_MATERIAL_DETAILS_V is a reporting and integration view in Oracle EBS Process Manufacturing (OPM). It presents a denormalized, human-readable projection of batch step material detail records held in GME_MATERIAL_DETAILS, augmented with descriptive fields from inventory item master, item location, batch step, and lookup data. In EBS 12.1.1 and 12.2.2 the view serves as the primary read interface for material requirements and consumption at the batch step level, exposing both the raw quantities and the coded flexfield values needed for forms, concurrent program reports, and downstream integrations.

Underlying Base Objects

The view is defined over the following documented base objects:

Key Columns

Common Use Cases and Queries

Typical uses include batch step material requirement reports, material consumption reconciliation, yield and dispense analysis, and integration extracts feeding MES or warehouse systems. The decoded LINE_TYPE (GMD_FORMULA_ITEM_TYPE) is commonly filtered to isolate ingredient, by-product, or product lines.

Sample query listing material details for a batch:

  • SELECT batch_id, batchstep_id, line_no, meaning line_type_meaning, item_no, item_desc, plan_qty, actual_qty, locator FROM apps.gme_step_material_details_v WHERE batch_id = :p_batch_id ORDER BY line_no;

Sample query filtered by formula item type:

  • SELECT batch_id, material_detail_id, item_no, plan_qty, item_um FROM apps.gme_step_material_details_v WHERE organization_id = :p_org AND meaning = 'Ingredient';

Because the view resolves lookups and joins item and location views, it should be queried with the ORGANIZATION_ID and BATCH_ID predicates for optimal performance; it is intended for read-only reporting and integration use.