Results for “ic_summ_inv”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
IC_SUMM_INV is the inventory summary balance table within the GMI Process Manufacturing Inventory module (Process Manufacturing, not discrete Oracle Inventory). It stores aggregated on-hand balances for process-manufactured items, keyed by the combination of item, warehouse, and quality grade. Unlike transaction-detail tables such as inventory movement or lot tables, IC_SUMM_INV represents a summarized snapshot — a consolidated balance per item/warehouse/grade combination rather than a ledger of individual transactions.
The table's role is to provide fast read access to current inventory quantities without aggregating the underlying transaction history at query time. In the context of the Data Vault modeling heuristic applied to the metadata, IC_SUMM_INV is classified as a link. This classification reflects the fact that the table's identity is defined by the intersection of three independent business entities — item, warehouse, and quality grade — each represented by a foreign key to its own master table. The summary balances are attributes carried on that relationship, making the table a junction resolving a many-to-many-to-many business relationship rather than a standalone hub or a pure descriptive satellite. This is a modeling suggestion derived from the foreign-key structure, not a formal Oracle declaration.
Key Information Stored
The documented metadata identifies the following structural elements and columns:
- SUMM_INV_ID — the surrogate primary key, defined by the constraint IC_SUMM_INV_PK. It uniquely identifies each summary balance row and carries no business meaning.
- ITEM_ID — the process item identifier, forming part of the alternate unique key IC_SUMM_INV_U1 and acting as a foreign key to IC_ITEM_MST.
- WHSE_CODE — the warehouse code, the second component of IC_SUMM_INV_U1 and a foreign key to IC_WHSE_MST.
- QC_GRADE — the quality grade code, the third component of IC_SUMM_INV_U1 and a foreign key to QC_GRAD_MST.
The distinction between the two documented keys is important. IC_SUMM_INV_PK is a system-generated surrogate and is not exposed to users. IC_SUMM_INV_U1 is the business key: the natural uniqueness of a summary row is the ITEM_ID / WHSE_CODE / QC_GRADE triplet. Any query that retrieves a single balance should filter on those three columns; any join to this table from another summary or reporting table should also use them. Because grade is part of the business key, the same item and warehouse may legitimately hold multiple rows at different grades, and applications must never assume one row per item/warehouse pair.
Common Use Cases and Queries
IC_SUMM_INV supports on-hand reporting, grade-level inventory analysis, and reconciliation between summary balances and detail transactions. A typical lookup by business key:
SELECT * FROM IC_SUMM_INV WHERE ITEM_ID = :item AND WHSE_CODE = :whse AND QC_GRADE = :grade;- Warehouse-wide inventory rollup:
SELECT WHSE_CODE, SUM(QTY) FROM IC_SUMM_INV GROUP BY WHSE_CODE; - Grade-level analysis for a single item:
SELECT QC_GRADE, WHSE_CODE FROM IC_SUMM_INV WHERE ITEM_ID = :item ORDER BY QC_GRADE; - Reconciliation join to the item master to validate orphaned balances:
SELECT s.* FROM IC_SUMM_INV s LEFT JOIN IC_ITEM_MST i ON s.ITEM_ID = i.ITEM_ID WHERE i.ITEM_ID IS NULL;
Because the table stores summarized balances, reports built on it are significantly cheaper than reports that aggregate movement or lot tables. The trade-off is that the summary must be maintained by the application's processing; reconciliation against detail is a standard control.
Related Objects
The foreign-key metadata identifies the objects that IC_SUMM_INV depends upon:
- IC_ITEM_MST — joined on ITEM_ID. The item master supplies item descriptions, units of measure, and item type. This is the primary enrichment join for any inventory report.
- IC_WHSE_MST — joined on WHSE_CODE. Provides warehouse description, location attributes, and plant association.
- QC_GRAD_MST — joined on QC_GRADE. Supplies grade definitions and quality characteristics, essential when interpreting why multiple balance rows exist for one item/warehouse pair.
These three masters are referenced by the ITEM_ID, WHSE_CODE, and QC_GRADE foreign keys respectively, and together they form the full business identity of a summary balance row. Because IC_SUMM_INV is a link-class summary table, downstream reporting views, dashboards, and reconciliation extracts typically reference it rather than being referenced by it; consequently no child tables are documented as depending on IC_SUMM_INV through inbound foreign keys. Implementers should treat IC_SUMM_INV as a read-oriented reporting object and rely on the GMI application processes to keep it synchronized with the underlying transaction detail.
-
SYNONYM: APPS.IC_SUMM_INV 12.1.1
-
SYNONYM: APPS.IC_SUMM_INV 12.2.2
-
Table: IC_SUMM_INV 12.2.2
Inventory summary table. This table contains inventory summary balances by item/warehouse/grade.
Not implemented in this database·Explore GMI module →
-
Table: IC_SUMM_INV 12.1.1
Inventory summary table. This table contains inventory summary balances by item/warehouse/grade.
Not implemented in this database·Explore GMI module →
-
View: PMIBV_INV_SUMMARY_V 12.1.1
The purpose of this view is to find the Inventory balance by item/warehouse/grade. This view also birngs in the item information from the Item Master Table.
APPS.PMIBV_INV_SUMMARY_V·↳ IC_ITEM_MST·↳ IC_SUMM_INV·Explore PMI module →
-
View: PMIBV_INV_SUMMARY_V 12.2.2
The purpose of this view is to find the Inventory balance by item/warehouse/grade. This view also birngs in the item information from the Item Master Table.
APPS.PMIBV_INV_SUMMARY_V·↳ IC_ITEM_MST·↳ IC_SUMM_INV·Explore PMI module →
-
View: PMIFV_INV_SUMMARY_V 12.2.2
This View finds the Inv. balance by item/Whse/Grade.
APPS.PMIFV_INV_SUMMARY_V·↳ GMD_GRADES_VL·↳ IC_ITEM_MST·↳ IC_SUMM_INV·Explore PMI module →
-
View: PMIFV_INV_SUMMARY_V 12.1.1
This View finds the Inv. balance by item/Whse/Grade.
APPS.PMIFV_INV_SUMMARY_V·↳ GMD_GRADES_VL·↳ IC_ITEM_MST·↳ IC_SUMM_INV·Explore PMI module →
-
Formula detail with Onhanad inventory of the Ingredients
APPS.PMIFV_PRODUCTFORMULA_INV_V·↳ FM_FORM_EFF·↳ FM_FORM_MST·↳ FM_MATL_DTL·Explore PMI module →
-
Formula detail with Onhanad inventory of the Ingredients
APPS.PMIFV_PRODUCTFORMULA_INV_V·↳ FM_FORM_EFF·↳ FM_FORM_MST·↳ FM_MATL_DTL·Explore PMI module →