Search Results ic_item_loct_vw




Overview
Explore in AI Chat

Overview

IC_ITEM_LOCT_VW is a database view owned by the APPS schema in Oracle E-Business Suite, residing in the GMF (Process Manufacturing Financials) product family. The ETRM metadata explicitly marks this object as OBSOLETE, with the documented description reading "OBSOLETE:Used in Financials for Lots." This designation is the single most important fact about the object: while the view remains VALID in the data dictionary and is still present in both 12.1.1 and 12.2.2 environments, it is a legacy construct that Oracle no longer intends for active use. Its historical role was to flatten the combination of item, warehouse, location, lot, and sublot attributes into a single denormalized code (LOC_CODE) for consumption by Process Manufacturing financial routines dealing with lot-level inventory valuation and costing. In current reporting and integration work, the view should be treated as a compatibility artifact rather than a recommended data source.

Underlying Base Objects

The view is defined over a four-way join. Three Process Manufacturing master tables are accessed through APPS synonyms — IC_ITEM_MST (items), IC_LOCT_MST (locations), and IC_LOTS_MST (lots) — and these are joined to MTL_SYSTEM_ITEMS, the Oracle Inventory item master synonym. The join predicates link IC_ITEM_MST.ITEM_ID to IC_LOTS_MST.ITEM_ID, relate IC_ITEM_MST.ITEM_NO to MTL_SYSTEM_ITEMS.SEGMENT1 to expose the Oracle item identifier, and constrain IC_LOCT_MST.LOCATION against a DECODE that falls back to the FND_PROFILE value 'IC$DEFAULT_LOCT' when the item's LOCT_CTL flag is zero. A fourth reference, FND_PROFILE (PACKAGE), supplies that default location profile value at query time. Rows are filtered with IM.DELETE_MARK = 0, excluding soft-deleted items.

Key Columns

  • LOC_CODE — A concatenated key composed of warehouse code, an optional dotted location, an optional colon-prefixed lot number, and an optional dotted sublot number. The DECODE logic suppresses each segment when the corresponding control flag (LOCT_CTL, LOT_CTL, SUBLOT_CTL) on the item master is disabled.
  • ORA_ITEM_ID / DLX_ITEM_ID / WHSE_ITEM_ID — The Oracle inventory item identifier, the Process Manufacturing item identifier, and the warehouse item identifier respectively, bridging the two item numbering schemes.
  • ITEM_NO — The Process Manufacturing item number, matched to MTL_SYSTEM_ITEMS.SEGMENT1.
  • DUALUM_IND — The dual unit of measure indicator on the item, which flags items transacted in both a primary and secondary UOM. This is the column most directly associated with the user's search term.
  • PRIMARY_UOM / SECONDARY_UOM — The item's primary and secondary units of measure (ITEM_UM and ITEM_UM2).
  • LOT_ID, LOT_NO, SUBLOT_NO, QC_GRADE, LOT_STATUS — Lot identity and quality attributes, each defaulted to zero or blank when the relevant control flag is off.
  • LOCATION, WHSE_CODE — The resolved location (or profile default) and its parent warehouse code.

Common Use Cases and Queries

Because the view is obsolete, queries against it are typically encountered during upgrades, historical reconciliation, or when maintaining legacy customizations inherited from earlier Process Manufacturing implementations. The DUALUM_IND column is commonly searched during dual-UOM remediation exercises, since it quickly identifies items flagged for dual-unit processing. A representative query is:

  • SELECT ITEM_NO, DUALUM_IND, PRIMARY_UOM, SECONDARY_UOM FROM APPS.IC_ITEM_LOCT_VW WHERE DUALUM_IND IS NOT NULL;
  • SELECT LOC_CODE, ITEM_NO, LOT_NO, SUBLOT_NO, QC_GRADE FROM APPS.IC_ITEM_LOCT_VW WHERE WHSE_CODE = :warehouse;
  • SELECT COUNT(*) FROM APPS.IC_ITEM_LOCT_VW WHERE LOT_ID = 0 AND DUALUM_IND = 1;

For new development, Oracle recommends querying the underlying master tables or the supported Inventory views directly, as the obsolete status of IC_ITEM_LOCT_VW means it may be desupported without further notice.