Results for “cur_exp_val”

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

Overview

The APPS.PMI_REP_EXP_INVENTORY_V view is a reporting object that belongs to the Process Manufacturing Intelligence (PMI) module, a legacy component classified as obsolete in Oracle E-Business Suite 12.1.1 and 12.2.2. Its purpose is to supply the dataset behind the PMI Expired Inventory Report, which users run to identify on-hand lot inventory that has passed its expiration date and to quantify the associated financial exposure. The view is defined entirely within the APPS schema and is marked VALID, but it depends on PMI-specific packages and on the discrete inventory tables it reads through synonyms.

The view does not present a physical entity; it is a denormalized projection that joins inventory, lot, item, warehouse, and organization master data. It additionally performs UOM conversion using the profile option PMI$CONV_UOM and applies a row-level security filter through PMI_SECURITY_PKG. Because PMI is obsolete, this view is maintained for backward compatibility and should not be used as the basis for new development on current releases.

Underlying Base Objects

The view is defined over a mix of synonyms, packages, and DUAL, as documented in the ETRM metadata:

• IC_LOCT_INV — the primary inventory source, supplying lot-level on-hand quantities (LOCT_ONHAND, LOCT_ONHAND2), ITEM_ID, LOT_ID, and WHSE_CODE.
• IC_ITEM_MST — item master, supplying ITEM_UM and ITEM_UM2, the primary and secondary units of measure.
• IC_LOTS_MST — lot master, supplying EXPIRE_DATE used to determine expired status.
• IC_WHSE_MST — warehouse master, supplying WHSE_CODE and its organization linkage.
• SY_ORGN_MST — organization master, supplying ORGN_CODE and CO_CODE.
• FND_PROFILE — package used to read the PMI$CONV_UOM profile value, aliased in the view as DEFAULT_UOM.
• GMICUOM — package providing I2UOM_CV, the item-to-UOM conversion function.
• PMI_COMMON_PKG — package providing PMICO_GET_COST, which returns item cost for valuation.
• PMI_SECURITY_PKG — package providing SHOW_RECORD, applying organization-level security.
• DUAL — used to materialize the default UOM profile value as an inline row source.

Joins are enforced on ORGN_CODE between organization and warehouse, WHSE_CODE between warehouse and lot inventory, and both ITEM_ID and LOT_ID between lot inventory and the item/lot masters. Rows with zero on-hand or zero lot ID are excluded.

Key Columns

• COMPANY_ID — the company code (CO_CODE) from the organization master.
• ORGANIZATION_ID — the organization code (ORGN_CODE) from the organization master.
• WAREHOUSE_ID — the warehouse code (WHSE_CODE).
• CONV_ONHAND — the on-hand quantity expressed in the default UOM. A DECODE selects LOCT_ONHAND when the profile UOM equals ITEM_UM, LOCT_ONHAND2 when it equals ITEM_UM2, otherwise it calls GMICUOM.I2UOM_CV to convert.
• CUR_OHD_VAL — current on-hand value, computed as LOCT_ONHAND multiplied by PMI_COMMON_PKG.PMICO_GET_COST.
• CONV_EXP_QTY — the expired quantity in the default UOM, returned only when SYSDATE exceeds EXPIRE_DATE (DECODE on SIGN), otherwise 0.
• CUR_EXP_VAL — the expired inventory value, being the cost-extended on-hand returned when the lot is expired, otherwise 0.

Because the user searched for default_uom, it is relevant to note that DEFAULT_UOM is not an exposed column; it is an inline subquery alias derived from FND_PROFILE.VALUE('PMI$CONV_UOM') and used internally to drive the CONV_ONHAND and CONV_EXP_QTY calculations.

Common Use Cases and Queries

Typical use is legacy reporting of expired lots with UOM-normalized quantities and current cost-based valuation, filtered automatically by organization security. A representative query is:

• SELECT ORGANIZATION_ID, WAREHOUSE_ID, CONV_ONHAND, CUR_OHD_VAL, CONV_EXP_QTY, CUR_EXP_VAL FROM APPS.PMI_REP_EXP_INVENTORY_V WHERE CONV_EXP_QTY > 0;
• Aggregate valuation by organization or warehouse for expired stock write-down analysis.
• Filter by WAREHOUSE_ID to review a single site's expired lots.

Given the obsolete status of PMI, replacements on discrete or process inventory reporting should be evaluated before relying on this view in production.