Results for “gem_lookups”

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

Overview

PMITS_ITEM_MASTER_V is an APPS-owned view in Oracle E-Business Suite, catalogued under the Process Manufacturing Intelligence (PMI) product. In ETRM 12.2.2 metadata the PMI module is flagged as obsolete, and the view should be treated as a legacy reporting artifact rather than a supported integration interface. It presents a denormalised, read-only projection of the OPM Item Master, exposing every attribute required to describe a process manufacturing item: unit-of-measure definitions, lot, sublot and location control flags, quality and grade indicators, planning and pricing categories, and the full set of item class and type designations.

The view's principal reporting value lies in its decoding of internal single-character flag columns into lookup meanings. Rather than returning raw '0'/'1' values for lot control or inactivity, the view joins to the GEM_LOOKUPS lookup view and substitutes the translated YES/NO meaning, which makes it directly consumable by BI Publisher reports, Discoverer workbooks and ad hoc SQL without additional lookup joins in the calling query.

Underlying Base Objects

ETRM documents two referenced base objects for this view: GEM_LOOKUPS (a view) and IC_ITEM_MST_VL (a view). IC_ITEM_MST_VL is the OPM Item Master base, the source of the item rows, identifiers, UOM data, control flags and class columns. GEM_LOOKUPS supplies the decode meanings applied through several aliased joins in the view text — NO_LKUP, YES_LKUP, DUAL_IND_LKUP, LOCT_CTL_LKUP, MATCHING_LKUP, STATUS_CTL_LKUP and EXP_IND_LKUP. The view text also carries the SEQ_DPND_CLASS column (the underlying OPM field SEQ_DPND_CLASS), which is the object most commonly sought when this view is researched.

Key Columns

• ITEM_ID, ITEM_NO — surrogate and user-facing item identifiers; the primary join keys to inventory, batch and cost tables.
• ITEM_UM, ITEM_UM2, DUALUM_IND, DUAL_IND_LKUP.MEANING — primary and secondary unit of measure and the dual-UOM indicator with its decoded meaning.
• LOT_CTL, SUBLOT_CTL, LOT_INDIVISIBLE, LOCT_CTL — lot, sublot and location control flags, each paired with a decoded lookup meaning.
• SEQ_DPND_CLASS — sequence-dependent class designation, used to group items whose characteristics vary by production sequence or grade.
• GL_CLASS, INV_CLASS, SALES_CLASS, SHIP_CLASS, FRT_CLASS, PRICE_CLASS, STORAGE_CLASS, PURCH_CLASS, TAX_CLASS, CUSTOMS_CLASS, ALLOC_CLASS, PLANNING_CLASS, ITEMCOST_CLASS — the full set of OPM class and type designations referenced in the view description.
• GRADE_CTL, QC_GRADE, LOT_STATUS, QCITEM_ID, QCHOLD_RES_CODE — quality control attributes covering grade control, grade assignment and hold resolution.
• SHELF_LIFE, RETEST_INTERVAL, EXPACTION_CODE, EXPACTION_INTERVAL — shelf-life and expiration action parameters.
• NONINV_IND, INACTIVE_IND, EXPERIMENTAL_IND, DELETE_MARK — status and lifecycle indicators, decoded where a lookup exists.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE — standard audit columns.

Common Use Cases and Queries

Typical uses include item master extracts for quality reporting, lot-control audits and cross-reference of OPM class assignments to downstream planning or costing tables. The decoded meaning columns remove the need to re-implement lookup joins.

List lot-controlled, sequence-dependent items:

• SELECT item_no, item_um, lot_ctl, seq_dpnd_class, qc_grade FROM apps.pmits_item_master_v WHERE lot_ctl = '1' AND inactive_ind = '0';

Extract class designations for a given item:

• SELECT item_no, inv_class, sales_class, planning_class, itemcost_class FROM apps.pmits_item_master_v WHERE item_no = :item_no;

Review items nearing retest, joining to OPM batch or inventory tables on ITEM_ID:

• SELECT item_no, shelf_life, retest_interval FROM apps.pmits_item_master_v WHERE retest_interval IS NOT NULL ORDER BY retest_interval;

Because the PMI module is obsolete in ETRM 12.2.2, new development should target the underlying IC_ITEM_MST_VL view or the current Process Manufacturing item master interfaces, reserving PMITS_ITEM_MASTER_V for existing reports that already depend on its decoded output.