Results for “ic_invn_typ”

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

Overview

IC_INVN_TYP is a process manufacturing inventory definition table owned by the GMI schema. It stores the master list of Inventory Types used throughout Oracle Process Manufacturing (OPM). Inventory Types are a fundamental classification mechanism in OPM, allowing items to be grouped by their inventory handling behavior—for example, distinguishing raw materials, finished goods, by-products, or other inventory categories that drive transaction processing rules. Because the table acts as an authoritative definition source, it is referenced repeatedly by item master records created and maintained in OPM.

From a dimensional modeling perspective, the documented foreign-key structure suggests a hub-leaning classification. IC_INVN_TYP has a single, stable business key (INV_TYPE) that is referenced by dependent item master tables, which is characteristic of a reference or hub entity. No bridge or link semantics are evident from the metadata; the table primarily serves as a definition lookup rather than a transactional fact or association table.

Key Information Stored

The table contains 42 documented columns, of which the following are the most significant:

• INV_TYPE — The primary key column and business identifier for the inventory type. It is enforced by the unique index IC_INVN_TYP_PK.
• INV_TYPE_DESC — The descriptive name of the inventory type, used in user interfaces and reports.
• TEXT_CODE — A reference to IC_TEXT_HDR, linking the inventory type to an extended text block for additional documentation.
• TRANS_CNT — A transaction counter, likely tracking the number of transactions associated with the type.
• DELETE_MARK — The soft-delete indicator; records are logically removed rather than physically deleted.
• MIGRATED_IND — Indicates whether the record originated from a data migration.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — Standard Oracle EBS audit columns capturing who created and last modified each record and when.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE30 — The standard Oracle EBS descriptive flexfield (DFF) columns, providing extensibility without schema changes.

The surrogate primary key is IC_INVN_TYP_PK, defined on INV_TYPE, which is also the sole documented business-key candidate via the unique index of the same name.

Common Use Cases and Queries

Typical use cases include validating item master records, building inventory type lookup lists for reports, and auditing which inventory types are actively used. A common query pattern filters out deleted rows:

• Listing active types: SELECT INV_TYPE, INV_TYPE_DESC FROM GMI.IC_INVN_TYP WHERE DELETE_MARK = 0 ORDER BY INV_TYPE;
• Joining to items: SELECT i.ITEM_ID, i.INV_TYPE, t.INV_TYPE_DESC FROM GMI.IC_ITEM_MST i JOIN GMI.IC_INVN_TYP t ON i.INV_TYPE = t.INV_TYPE;
• Retrieving extended text: SELECT t.INV_TYPE, h.TEXT_CODE, h.TEXT FROM GMI.IC_INVN_TYP t JOIN GMI.IC_TEXT_HDR h ON t.TEXT_CODE = h.TEXT_CODE;

These queries support item classification reporting, inventory hierarchy analysis, and data quality checks confirming every item references a valid inventory type.

Related Objects

• IC_ITEM_MST — References IC_INVN_TYP via IC_ITEM_MST.INV_TYPE, carrying the inventory type on each item record.
• IC_ITEM_MST_B — A related item master table also referencing INV_TYPE, typically holding a different logical partition of item data.
• IC_TEXT_HDR — Referenced by IC_INVN_TYP.TEXT_CODE, providing extended descriptive text for each inventory type.

These relationships establish IC_INVN_TYP as a foundational reference table for OPM item and inventory processing.