Search Results original_item_flag




Overview
Explore in AI Chat

Overview

APPS.GMF_MATERIAL_EFFECTIVITIES_VW1 is a reporting and integration view in the Oracle E-Business Suite Process Manufacturing (OPM) module. It exposes material effectivity records associated with formulas, providing a consolidated, query-ready projection of the material effectivity data used throughout process manufacturing. In ETRM 12.1.1 and 12.2.2, this view serves as the APPS-owned interface through which forms, concurrent programs, and external integrations retrieve formula material line information without directly accessing the underlying base object.

A distinguishing feature of this view is that it is not a simple pass-through projection. It applies an analytic ranking function and a row-filtering construct, meaning consumers receive a pre-ranked, deterministic result set rather than raw effectivity rows. This design is significant because formula material effectivities can contain multiple candidate rows for the same formula line, and the view resolves which row should be treated as authoritative.

Underlying Base Objects

The documented base object referenced by GMF_MATERIAL_EFFECTIVITIES_VW1 is a single view: GMD_MATERIAL_EFFECTIVITIES_VW. The APPS view therefore layers directly on top of GMD_MATERIAL_EFFECTIVITIES_VW, and all columns exposed at the GMF level correspond to columns already present in the GMD view. The GMD view in turn draws from the underlying process manufacturing material effectivity tables, which store formula line material assignments, substitutions, and their effective date ranges.

The relationship is one of progressive refinement: the GMD view establishes the base column set, while GMF_MATERIAL_EFFECTIVITIES_VW1 adds ranking logic and standardizes the result set for application consumption. No additional joins or base tables are introduced at the GMF layer per the documented metadata; the only referenced base object is GMD_MATERIAL_EFFECTIVITIES_VW.

Key Columns

Common Use Cases and Queries

Because the view pre-computes the RK column, the most common pattern is to filter for the top-ranked row per formula line, obtaining the preferred material effectivity. The ORIGINAL_ITEM_FLAG term in the ORDER BY ensures original items rank ahead of substitutes, subject to the preference value.

SELECT formula_id, formulaline_id, line_no, item_id, qty,
       item_um, original_item_flag, rk
FROM   apps.gmf_material_effectivities_vw1
WHERE  formula_id = :p_formula_id
AND    rk = 1;

Other practical scenarios include extracting all substitutes for a line by omitting the RK filter, reporting effectivity ranges using START_DATE and END_DATE, and supplying scaling or cost-allocation attributes to integration interfaces. When querying, standard APPS views are resolved through the APPS schema synonym convention in EBS 12.1.1 and 12.2.2, so no additional schema qualification is required for authorized responsibilities.