Search Results yes_lkup

Overview

APPS.PMITS_ITEM_MASTER_V is a reporting and integration view in Oracle EBS Process Manufacturing (OPM) that exposes item master definition data held in the IC_ITEM_MST_VL base view, enriched with decoded (meaning-level) values from the GEM_LOOKUPS lookup view. The view presents a single denormalized row per item, combining the raw coded indicator columns (for example, LOT_CTL, INACTIVE_IND, GRAD_CTL) with their human-readable lookup meanings, along with description, classification, planning, costing, and category-assignment attributes.

The view is typically consumed in OPM environments for item-level reporting, interfaces, and integration extracts where the item definition must be presented with both codes and decoded descriptions. Because it links to the lookup view, it allows report authors and interfaces to avoid joining to the lookup table themselves for the indicators that are decoded inside the view. The name prefix PMITS suggests a Process Manufacturing Information/Item-related object, and the view is commonly used in discrete-OPM coexistence scenarios where items defined in OPM must be surfaced to other modules.

Underlying Base Objects

The following base objects are documented for this view:

• IC_ITEM_MST_VL — the OPM item master view (base item definition), aliased as item in the view text. This supplies the primary columns such as ITEM_ID, ITEM_NO, ITEM_UM, and the many classification and indicator attributes that are returned unchanged (for example, INV_TYPE, SHELF_LIFE, GL_CLASS, UPC_CODE, EXPERIMENTAL_IND).
• GEM_LOOKUPS — the lookup view providing MEANING text for the coded indicators. Multiple aliases of this lookup are used in the SELECT list to resolve different code sets, for example NO_LKUP and YES_LKUP for values '0' and '1', DUAL_IND_LKUP for DUALUM_IND, LOCT_CTL_LKUP for LOCT_CTL, STATUS_CTL_LKUP for STATUS_CTL, MATCHING_LKUP for MATCH_TYPE, and EXP_IND_LKUP for EXPERIMENTAL_IND.

The relationship is therefore one item row in IC_ITEM_MST_VL to multiple decode lookups against GEM_LOOKUPS. The view does not in itself define a master-detail relationship; rather, it is a single-row-per-item projection.

Key Columns

• ITEM_ID / ITEM_NO — unique identifier and item number of the OPM item.
• ITEM_UM / ITEM_UM2 / DUALUM_IND — primary and secondary units of measure and the dual-UOM indicator (decoded via DUAL_IND_LKUP).
• LOT_CTL / LOT_INDIVISIBLE / SUBLOT_CTL — lot control, lot indivisibility, and sublot control flags, each decoded to Yes/No meanings.
• NONINV_IND / INACTIVE_IND / GRADE_CTL / STATUS_CTL — non-inventory, inactive, grade control, and status control indicators, with the first three decoded and STATUS_CTL decoded via STATUS_CTL_LKUP.
• EXPERIMENTAL_IND — the experimental item indicator, decoded through EXP_IND_LKUP.MEANING. This is the column most directly relevant to the "exp_ind_lkup" search term, i.e., the lookup resolving the experimental indicator.
• MATCH_TYPE — matching type decoded via MATCHING_LKUP.
• Classification columns — 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, plus corresponding category IDs (GL_CATEGORY_ID, INV_CATEGORY_ID, and so on).
• SHELF_LIFE / RETEST_INTERVAL / DEVIATION_LO / DEVIATION_HI — quality and stability attributes.
• ITEM_DESC1 / ITEM_DESC2 — descriptive text lines.
• Audit columns — CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY.

Common Use Cases and Queries

Typical uses include item master extracts, quality/status reporting, and integration into downstream systems that require decoded indicator meanings rather than internal codes.

• Listing all experimental items with a readable flag.
• Reporting lot-controlled or non-inventory items.
• Feeding item classification and category data into planning or costing interfaces.

Sample query to surface experimental items:

• SELECT ITEM_NO, ITEM_DESC1, EXPERIMENTAL_IND, EXP_IND_LKUP_MEANING FROM APPS.PMITS_ITEM_MASTER_V WHERE EXPERIMENTAL_IND = '1'; (the decoded column is the alias produced by the EXP_IND_LKUP decode in the view text).

Sample query for lot-controlled active items:

• SELECT ITEM_NO, ITEM_UM, LOT_CTL, INACTIVE_IND FROM APPS.PMITS_ITEM_MASTER_V WHERE LOT_CTL = '1' AND INACTIVE_IND = '0' ORDER BY ITEM_NO;

Because the view decodes indicators internally, consumers receive both the underlying code and its meaning in a single row, reducing the need for repeated joins to GEM_LOOKUPS in custom reports and interfaces.