Search Results ic_invn_typ




Overview
Explore in AI Chat

Overview

The IC_INVN_TYP table is a master data table within the Oracle Process Manufacturing (OPM) Inventory module of Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2. Owned by the GMI schema, it serves as the central repository for defining and maintaining Inventory Types. These types are classification codes used to categorize and control the behavior of items throughout the manufacturing and inventory management lifecycle in OPM. The table's primary role is to provide a validated list of inventory types that can be assigned to items, ensuring data integrity and enabling consistent business rule application across the system.

Key Information Stored

While the provided metadata does not list specific columns, the structure is defined by its primary and foreign keys. The core column is the INV_TYPE, which serves as the primary key and holds the unique identifier for each inventory type classification. Another critical column is TEXT_CODE, which is referenced by the IC_TEXT_HDR table, suggesting a relationship to descriptive, translatable text or notes associated with each inventory type. The table likely contains additional descriptive columns, such as a name or description field, and control columns for enabling/disabling types and tracking creation/modification dates, which are standard in EBS master tables.

Common Use Cases and Queries

The primary use case for IC_INVN_TYP is as a validation source and reference for item master data setup and reporting. When creating or updating an item in IC_ITEM_MST or IC_ITEM_MST_B, the assigned INV_TYPE must exist in this table. Common queries involve listing all active inventory types for LOVs in forms or identifying which items belong to a specific inventory classification for operational or analytical reporting.

  • Retrieving all valid inventory types: SELECT inv_type FROM gmi.ic_invn_typ ORDER BY inv_type;
  • Finding items of a specific inventory type: SELECT item_no, item_desc FROM gmi.ic_item_mst mst WHERE mst.inv_type = '<TYPE_CODE>';
  • Joining to get item details with type descriptions (if a description column exists): SELECT mst.item_no, typ.inv_type, typ.description FROM gmi.ic_item_mst mst, gmi.ic_invn_typ typ WHERE mst.inv_type = typ.inv_type;

Related Objects

The IC_INVN_TYP table has defined foreign key relationships with several core OPM inventory tables, as documented in the metadata.

  • IC_ITEM_MST & IC_ITEM_MST_B (Item Master): These tables store the base and frozen snapshot versions of item definitions, respectively. They reference IC_INVN_TYP via their INV_TYPE column, enforcing that every item is assigned a valid inventory type.
  • IC_TEXT_HDR (Text Header): This table holds multilingual descriptive text. IC_INVN_TYP references it via the TEXT_CODE column, allowing for translatable descriptions or notes to be associated with each inventory type definition.

The primary key constraint IC_INVN_TYP_PK on the INV_TYPE column ensures uniqueness and is the anchor for these relationships.