Search Results ic_ctms_cls




Overview
Explore in AI Chat

Overview

IC_CTMS_CLS is a reference (setup) table within the Oracle E-Business Suite GMI – Process Manufacturing Inventory module. Its documented description is "Item customs class," indicating that it stores the defined customs classification codes used to categorize items for customs, trade compliance, and import/export reporting purposes. In process manufacturing environments, customs classification is significant because raw materials, intermediates, and finished goods frequently cross national borders and must be assigned harmonized or internally defined customs codes for regulatory declaration.

The ETRM metadata states that the object is not implemented in the current database, meaning the table definition exists in the product schema but contains no active rows in the environment from which the metadata was extracted. This is typical of optional setup tables that are only populated when an organization performs international trade and elects to track customs classes at the item level. Note that the documentation labels the primary key as IC_CTMS_CLS_PK, while the listed key column is ICCUSTOMS_CLASS.

From a Data Vault modeling perspective, the supplied heuristic classifies this object as satellite-leaning. IC_CTMS_CLS behaves primarily as a descriptive lookup that enriches a parent entity — the item — with a customs attribute, rather than acting as an independent hub of business transactions. Modelers may therefore treat it as a satellite or reference table attached to the item hub, with the customs class acting as a descriptive business attribute rather than a standalone business key.

Key Information Stored

The documented metadata identifies a limited column set, so the following reflects only what is explicitly stated:

  • ICCUSTOMS_CLASS — the column associated with the IC_CTMS_CLS_PK primary key. It holds the customs classification identifier or code that distinguishes one customs class from another and is the principal business-key candidate.
  • TEXT_CODE — a foreign key column referencing IC_TEXT_HDR. It links the customs class to a text header record, allowing descriptive or multilingual text to be associated with the classification.

The surrogate primary key IC_CTMS_CLS_PK is documented as being defined on ICCUSTOMS_CLASS. Because the metadata does not enumerate additional descriptive columns, the practical content of the table beyond the key and the text reference should be confirmed by inspecting the deployed table definition or the GMI data dictionary before relying on any additional attribute names.

Common Use Cases and Queries

Typical uses center on item setup, customs reporting, and trade compliance validation. Analysts frequently need to confirm which customs class is assigned to a given item, or to list all items sharing a customs class.

  • Listing all defined customs classes: SELECT ICCUSTOMS_CLASS FROM IC_CTMS_CLS;
  • Joining items to their customs class: SELECT m.ITEM_ID, m.CUSTOMS_CLASS FROM IC_ITEM_MST m, IC_CTMS_CLS c WHERE m.CUSTOMS_CLASS = c.ICCUSTOMS_CLASS;
  • Retrieving associated descriptive text: SELECT c.ICCUSTOMS_CLASS, t.* FROM IC_CTMS_CLS c, IC_TEXT_HDR t WHERE c.TEXT_CODE = t.TEXT_CODE;
  • Identifying items with no valid customs class (data-quality check) by outer-joining IC_ITEM_MST to IC_CTMS_CLS and filtering for null matches.

Because the table is documented as not implemented, such queries will return no rows until customs classification setup is performed.

Related Objects

  • IC_ITEM_MST — the master item table. IC_ITEM_MST.CUSTOMS_CLASS references IC_CTMS_CLS, making this the primary consumer of customs class values.
  • IC_TEXT_HDR — the text header table referenced by IC_CTMS_CLS.TEXT_CODE, supplying descriptive text for each customs class.
  • IC_CTMS_CLS_PK — the documented primary key constraint on ICCUSTOMS_CLASS.

These relationships establish IC_CTMS_CLS as a small, item-facing reference table whose principal join paths are to IC_ITEM_MST (through CUSTOMS_CLASS) and to IC_TEXT_HDR (through TEXT_CODE).