Results for “ic_item_mst”

50+ results




AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

IC_ITEM_MST is the core item definition (item master) table within the GMI Process Manufacturing Inventory module of Oracle E-Business Suite (relevant to both 12.1.1 and 12.2.2 deployments of Process Manufacturing). It stores all attributes that describe an item, including lot and sublot control flags, unit of measure information, quality control designations, and the full set of class and type classifications used throughout Process Manufacturing and adjacent modules (Order Processing, Purchasing, Costing, Forecasting, and Quality).

Because item data is referenced by virtually every transactional table in the process manufacturing inventory, purchasing, order management, and costing domains, IC_ITEM_MST functions as a foundational reference (master) object rather than a transactional one. The heuristic Data Vault classification provided in the metadata is hub-leaning, which suggests modeling this table as a hub entity keyed on the item business key, with surrounding descriptive attributes (unit of measure, quality grades, planning/class designations, lot control flags) potentially split into one or more satellites depending on the modeling goal.

Note that the metadata indicates this object is "Not implemented in this database" in the source environment — a common observation when documenting a definition repository (ETRM) rather than a live instance. The structural documentation (keys, foreign keys, dependencies) remains authoritative regardless.

Key Information Stored

The table's primary surrogate key is ITEM_ID (constraint IC_ITEM_MST_PK). A separate unique index, ITEM_NO (constraint IC_ITEM_MST_UNQ1), serves as the principal business-key candidate — the human-readable item number used throughout the application. Among the most significant attributes documented:

Additional class columns (ALLOC_CLASS, CUSTOMS_CLASS, FRT_CLASS, PRICE_CLASS, PURCH_CLASS, SALES_CLASS, SHIP_CLASS, STORAGE_CLASS, TAX_CLASS, SEQ_DPND_CLASS) each resolve through dedicated classification tables, illustrating the highly normalized classification architecture.

Common Use Cases and Queries

Typical reporting and integration scenarios include retrieving item attributes for a given item number, resolving class descriptions through join tables, and pulling lot-controlled items for inventory reconciliation.

  • Lookup by business key: SELECT ITEM_ID, ITEM_NO, ITEM_UM, LOT_STATUS FROM IC_ITEM_MST WHERE ITEM_NO = :item_no;
  • Join to unit of measure: ... FROM IC_ITEM_MST i JOIN SY_UOMS_MST u ON i.ITEM_UM = u.UM_CODE;
  • Resolve inventory class description: join IC_INVN_CLS on INV_CLASS.
  • Reporting on lot-controlled or QC-graded items for quality and compliance extracts.
  • Feeding item master data into order processing, purchasing, and costing extracts by joining on ITEM_ID from transactional tables.

Related Objects

IC_ITEM_MST sits at the center of the process manufacturing data model, referenced by many tables via ITEM_ID. The most significant relationships include:

  • IC_ITEM_WHS (IC_ITEM_WHS.ITEM_ID → IC_ITEM_MST.ITEM_ID) — item/warehouse assignment.
  • IC_LOTS_MST (IC_LOTS_MST.ITEM_ID → IC_ITEM_MST.ITEM_ID) — lot master.
  • IC_WHSE_INV and IC_SUMM_INV (ITEM_ID) — warehouse and summarized inventory balances.
  • IC_TRAN_PND, IC_TRAN_CMP, IC_TRAN_ARC (ITEM_ID) — pending, completed, and archived inventory transactions.
  • PO_ORDR_DTL, PO_RECV_DTL (ITEM_ID) — purchasing order and receipt lines.
  • OP_ORDR_DTL and OP_PRCE_ITM (ITEM_ID) — order processing and pricing.
  • GL_ITEM_CST (GL_ITEM_CST.ITEM_ID) — item cost ledger.
  • QC_SPEC_MST, QC_SMPL_MST, QC_RSLT_MST (ITEM_ID) — quality specification, sampling, and results.
  • SY_UOMS_MST — referenced by ITEM_UM, ITEM_UM2, and FILL_UM for unit-of-measure resolution.
  • IC_INVN_CLS, IC_COST_CLS, IC_GLED_CLS, PS_PLNG_CLS, QC_GRAD_MST — classification and quality lookups joined on the corresponding class/grade columns.

These relationships confirm IC_ITEM_MST as a central hub in the GMI inventory model, with transactional and classification satellites radiating outward through the ITEM_ID foreign key.