Search Results ic_item_mst_b

Overview

The IC_ITEM_MST_B table is the central item master definition table 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 foundational repository for all items that require the specialized lot, grade, and sublot control inherent to process industries such as chemicals, food and beverage, and pharmaceuticals. Its role is to define the core attributes and control policies for every item, enabling inventory transactions, cost management, production, and quality processes throughout the GMI and related manufacturing applications.

Key Information Stored

The table stores a comprehensive set of attributes that define an item's behavior within the Process Manufacturing system. Key columns include the surrogate primary key ITEM_ID and the unique business identifier ITEM_NO. Critical control flags govern lot and sublot management, inventory type (e.g., finished good, raw material), and unit of measure definitions. The table also holds numerous foreign key references to classify items, including COMMODITY_CODE, INV_TYPE, LOT_STATUS, and QC_GRADE. Additional columns manage packaging (PKG_ID), descriptive text (TEXT_CODE), and quality hold actions (EXPACTION_CODE, QCHOLD_RES_CODE). The self-referencing columns WHSE_ITEM_ID, BULK_ID, and QCITEM_ID establish relationships between different item records for warehouse, bulk, and quality control purposes.

Common Use Cases and Queries

This table is essential for any reporting or integration involving process items. Common use cases include generating item master data lists for ERP data governance, supporting inventory valuation reports by linking to cost tables, and providing item attributes for manufacturing recipe (formula) definition. A fundamental query retrieves the core item definition:

• Basic Item Inquiry: SELECT item_no, item_desc, lot_status, inv_type, commodity_code FROM gmi.ic_item_mst_b WHERE organization_id = :org_id ORDER BY item_no;
• Lot-Controlled Items Report: SELECT item_no, item_desc FROM gmi.ic_item_mst_b WHERE lot_control = 1;
• Item Cost Analysis Join: Queries frequently join IC_ITEM_MST_B to cost tables like GL_ITEM_CST or CM_ACST_LED on ITEM_ID to analyze inventory value by item class or type.

Related Objects

IC_ITEM_MST_B has extensive relationships, acting as a hub for transactional and master data. Key documented foreign key relationships include:

• Master Data References: The table references classification and control tables such as IC_COMD_CDS (commodity), IC_INVN_TYP (inventory type), IC_LOTS_STS (lot status), and QC_GRAD_MST (quality grade).
• Core Transaction Dependencies: Numerous critical transactional tables reference IC_ITEM_MST_B.ITEM_ID, including cost ledgers (CM_ACST_LED, CM_SCST_LED), adjustment details (CM_ADJS_DTL), burden details (CM_BRDN_DTL), and component details (CM_CMPT_DTL, CM_CMPT_MTL).
• Manufacturing Integration: It is linked to formula details (FM_MATL_DTL), item allocations for advanced planning (GMP_ITEM_APS), and workplan items (GMP_ITEM_WPS).
• Self-Referential Links: The table references itself for specialized item relationships via WHSE_ITEM_ID, BULK_ID, and QCITEM_ID.