Search Results ic_loct_inv

Overview

The IC_LOCT_INV table is a core data object within the Oracle E-Business Suite Process Manufacturing (GMI) Inventory module. It functions as the detailed location inventory table, storing granular on-hand quantity and status information for items at the specific warehouse, lot, and location level. Its primary role is to track the physical inventory of items within discrete storage locations (e.g., bins, racks) within a warehouse, providing the foundational data for inventory accuracy, lot traceability, and warehouse operations. The table's existence is critical for supporting the complex inventory management requirements of process manufacturing, where precise control over lot and location is essential for quality, costing, and fulfillment.

Key Information Stored

The table's structure is defined by its composite primary key, which uniquely identifies a specific inventory record: ITEM_ID, WHSE_CODE, LOT_ID, and LOCATION. Key columns include the primary key fields, which link to master data tables for items, warehouses, and lots. Additional significant columns store the on-hand quantity (QTY), the lot status (LOT_STATUS), and a text code (TEXT_CODE) for descriptive notes. The table also holds quality control information, such as a hold resolution code (QCHOLD_RES_CODE), linking it to quality management processes. This design enables the system to answer precise questions about what quantity of which specific lot is stored in a particular location.

Common Use Cases and Queries

This table is central to inventory inquiries, cycle counting, picking, and putaway transactions. A common reporting use case is generating a detailed location-level inventory report. A typical query would join IC_LOCT_INV with master tables to translate IDs into meaningful descriptions. For example:

• Location Detail Report: SELECT wh.whse_code, i.item_no, l.lot_no, li.location, li.qty FROM gmi.ic_loct_inv li JOIN gmi.ic_whse_mst wh ON li.whse_code = wh.whse_code JOIN gmi.ic_item_mst i ON li.item_id = i.item_id JOIN gmi.ic_lots_mst l ON li.item_id = l.item_id AND li.lot_id = l.lot_id WHERE li.qty > 0;
• Lot Traceability: Queries against IC_LOCT_INV are essential for tracing the current storage location(s) of a specific manufacturing or purchase lot.
• Transaction Support: Any material movement transaction (issue, transfer, receipt) that specifies a location will query and update this table to adjust the on-hand quantity.

Related Objects

As indicated by its foreign key constraints, IC_LOCT_INV has strong dependencies on several master and status tables. The primary foreign keys link to IC_LOTS_MST (lot definition), IC_WHSE_MST (warehouse definition), and IC_LOTS_STS (lot status codes). It also references IC_TEXT_HDR for descriptive text and QC_HRES_MST for quality hold resolutions. This table is a primary child of the lot master (IC_LOTS_MST) and is often accessed in conjunction with the item master (IC_ITEM_MST) to provide a complete inventory picture. It serves as a key source for inventory valuation and availability checks within the Process Manufacturing suite.