Search Results gme_yes_no




Overview
Explore in AI Chat

Overview

PMITS_FORMULA_MASTER_V is an APPS-owned reporting view in the Process Manufacturing Intelligence (PMI) module of Oracle E-Business Suite. It is described in the ETRM metadata as the "GMD Formula Master View." Its purpose is to expose a denormalized, human-readable projection of process manufacturing formulas by joining the master formula table to lookup, status, class, organization, and user reference data. Rather than requiring report authors to resolve coded values against multiple lookup and master tables, the view resolves those codes into descriptive meanings at query time.

The view is validated and available in both 12.1.1 and 12.2.2. It carries an embedded security predicate through PMI_SECURITY_PKG.SHOW_RECORD, which filters rows so that only organizations the current user is authorized to see are returned. This makes the view suitable for secured reporting, analytics, and integration extracts where formula master data must be presented with resolved descriptive attributes.

Underlying Base Objects

The view text joins the following documented base objects:

The ETRM metadata lists DUAL (a synonym) among the referenced base objects, reflecting the dictionary-level dependency capture. The join conditions tie formulas to their owner, status, class, and organization, and resolve each coded attribute through the GEM_LOOKUPS reference set.

Key Columns

The recurring GME_YES_NO lookup type is the connecting thread for the type, scale, and inactive-indicator columns, which is directly relevant to the searched term "gme_yes_no."

Common Use Cases and Queries

Typical uses include formula master listings, organization-scoped formula reports, and extracts that feed downstream analytics. The security predicate means results automatically reflect the querying user's organization access.

SELECT formula_no, formula_vers, formula_desc1,
       formula_type, scale_type, status, orgn_desc, owner
FROM   apps.pmits_formula_master_v
WHERE  inactive_ind = 'No'
ORDER  BY formula_no, formula_vers;

To analyze formula classification and ownership:

SELECT formula_class_desc, COUNT(*) formula_count
FROM   apps.pmits_formula_master_v
WHERE  delete_mark = 0
GROUP  BY formula_class_desc;

Because the view already resolves GME_YES_NO meanings, report authors should filter on the descriptive MEANING values rather than underlying lookup codes, simplifying query construction for process manufacturing formula reporting.