Search Results ic_loct_mst

Overview

The IC_LOCT_MST table is a core master data table within the Process Manufacturing Inventory (GMI) module of Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2. It serves as the central repository for defining and storing physical storage locations within warehouses that are configured for location-level inventory control. This table is fundamental to enabling detailed tracking of inventory by specific bin, rack, or shelf, which is essential for process manufacturing operations requiring precise lot and location traceability. Its integrity is maintained through primary and unique keys and it acts as a parent table for numerous transactional and quality management entities.

Key Information Stored

The table's structure is designed to uniquely identify and describe a storage location within a specific warehouse. The primary key is a composite of WHSE_CODE and LOCATION, ensuring each location code is unique per warehouse. A separate unique key on INVENTORY_LOCATION_ID provides an alternative numeric identifier. Key descriptive and control columns include TEXT_CODE for attaching descriptive notes, CAPACITY_UM (with a foreign key to SY_UOMS_MST) to define the unit of measure for the location's storage capacity, and status fields to control a location's availability for transactions. The table also stores audit information such as creation and last update dates.

Common Use Cases and Queries

This table is primarily queried for inventory inquiries, putaway and picking logic, and warehouse capacity reporting. Common operational scenarios include validating a location's existence and status before a transaction, finding empty or available locations for putaway, and reporting on location utilization. A typical query to list all active locations within a warehouse, including their capacity, would be:

• SELECT whse_code, location, text_code, capacity_um, location_status FROM gmi.ic_loct_mst WHERE whse_code = :p_whse AND location_status = 'A' ORDER BY location;

For integration or data extraction, the INVENTORY_LOCATION_ID column is often used to join with other EBS inventory tables. Reporting on location usage might involve joining IC_LOCT_MST with IC_ONHAND_QTYS or transactional tables like IC_TRAN_ARC.

Related Objects

IC_LOCT_MST has defined relationships with several key tables, as indicated by its foreign key constraints. It is a child of IC_WHSE_MST (via WHSE_CODE), ensuring a location belongs to a valid warehouse, and SY_UOMS_MST (via CAPACITY_UM). It is a parent table to transactional history and quality management tables, including IC_TRAN_ARC, QC_RSLT_MST, and QC_SPEC_MST, which reference the WHSE_CODE and LOCATION pair. The relationship with IC_TEXT_HDR (via TEXT_CODE) allows for storing extended descriptive text for the location. These relationships underscore its role as a critical master data hub for inventory and quality transactions.