Search Results ic_comd_cds_pk

Overview

The IC_COMD_CDS table is a master data table within the Oracle E-Business Suite Process Manufacturing (GMI) inventory module. Its primary function is to serve as the central repository for commodity codes, which are standardized classifications for goods. These codes are critical for regulatory compliance reporting, specifically for the Intrastat module, which handles the declaration of trade statistics between member states of the European Union. The table's role is to provide a validated list of codes that can be assigned to items, enabling accurate categorization for statutory reporting on intra-community trade movements in both EBS 12.1.1 and 12.2.2.

Key Information Stored

The table's structure is centered on the commodity code itself. The primary key column, COMMODITY_CODE, stores the unique alphanumeric identifier for the commodity classification. While the provided metadata does not list all columns, standard practice suggests the table likely includes descriptive fields such as a description or name for the code. A significant relational column is TEXT_CODE, which is defined as a foreign key to the IC_TEXT_HDR table. This linkage allows for the association of extensive descriptive text or regulatory notes with the commodity code, providing necessary detail beyond a short description.

Common Use Cases and Queries

The primary use case is the maintenance and assignment of commodity codes to inventory items for Intrastat reporting. Administrators populate this table with valid codes, which are then selected during item definition. A common operational query involves listing all active commodity codes with their descriptions for setup or validation purposes. For reporting, a frequent pattern is joining IC_COMD_CDS to item master tables to generate lists of items by their commodity classification, which is essential for preparing Intrastat declarations. A sample query to find items linked to a specific commodity code, such as the user's search term '123', would be:

• SELECT item_no, description FROM ic_item_mst_b i, ic_comd_cds c WHERE i.commodity_code = c.commodity_code AND c.commodity_code = '123';

Related Objects

IC_COMD_CDS is a key reference table with several important dependencies. The primary key (COMMODITY_CODE) is referenced by the item master tables IC_ITEM_MST and IC_ITEM_MST_B, which store the commodity code assignment for each inventory item. This establishes the core data relationship for reporting. Furthermore, the table has a foreign key relationship to IC_TEXT_HDR via its TEXT_CODE column, enabling detailed textual annotations. The integrity of these relationships is enforced by the primary key constraint IC_COMD_CDS_PK and the documented foreign keys, ensuring data consistency across the Process Manufacturing inventory and Intrastat modules.