Search Results ic_pkgs_mst




Overview
Explore in AI Chat

Overview

The IC_PKGS_MST table is a core data structure within the Process Manufacturing Inventory (GMI) module of Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2. It serves as the master repository for packaging definitions used in process manufacturing environments. While the official ETRM description is marked as "NOT USED," its extensive foreign key relationships and primary key constraints confirm its active role in the data model. The table's primary function is to define standard packaging units, such as boxes, drums, or pallets, which are then associated with items to manage inventory, costing, and transactions at the package level.

Key Information Stored

The table's central column is the primary key, PKG_ID, which uniquely identifies each packaging definition. Other critical columns define the physical and logistical characteristics of the package. The FILL_UM and TARE_UM columns store the unit of measure for the package's fill capacity and its tare (empty) weight, respectively, both referencing the SY_UOMS_MST table. The TEXT_CODE column provides a link to descriptive text stored in the IC_TEXT_HDR table, allowing for detailed package descriptions. Collectively, these columns enable the system to model complex packaging hierarchies and calculate net weights for inventory items.

Common Use Cases and Queries

A primary use case is retrieving the packaging definition for a specific item to support warehouse operations or shipping processes. For example, a query might join IC_PKGS_MST to the item master to list all items using a specific package type. Another common scenario is reporting on package specifications for compliance or labeling requirements, which involves joining to the units of measure and text tables. While direct data manipulation via custom code is discouraged in favor of standard APIs, analytical queries are frequent. A sample query pattern is:

  • SELECT im.item_no, pm.pkg_id, pm.fill_um, uom.unit_desc FROM ic_item_mst im, ic_pkgs_mst pm, sy_uoms_mst uom WHERE im.pkg_id = pm.pkg_id AND pm.fill_um = uom.unit_code;

Related Objects

IC_PKGS_MST maintains integral relationships with several key inventory tables, as documented by its foreign keys. It is referenced as a parent table by the item master tables, IC_ITEM_MST and IC_ITEM_MST_B, via their PKG_ID columns, establishing the fundamental link between items and their packaging. Conversely, IC_PKGS_MST itself references the SY_UOMS_MST table twice: once for the fill unit of measure (FILL_UM) and once for the tare unit of measure (TARE_UM). It also holds a foreign key relationship to IC_TEXT_HDR via the TEXT_CODE column for descriptive text. These relationships underscore its role as a central hub for packaging data within the GMI schema.