Search Results ic_crul_cls_pk

Overview

The IC_CRUL_CLS table is a core master data table within the Oracle E-Business Suite Process Manufacturing Inventory (GMI) module. It serves as the central repository for defining and storing count classes. A count class is a categorization mechanism used to group inventory items for the purpose of cycle counting, a critical inventory control process. The table's primary role is to provide a validated list of count classes that can be assigned to items, enabling systematic scheduling, execution, and analysis of physical inventory counts. Its existence is fundamental to maintaining accurate inventory records and supporting compliance in process manufacturing environments.

Key Information Stored

While the provided metadata does not list specific columns, the structure of the table can be inferred from its relationships and purpose. The primary key is the COUNT_CLASS column, which uniquely identifies each count class code. Based on standard EBS design patterns, the table likely contains descriptive columns such as a description field (e.g., CLASS_DESC) and status indicators. A critical column is TEXT_CODE, which acts as a foreign key to the IC_TEXT_HDR table. This relationship allows for the association of extensive descriptive text or instructions with a specific count class, providing detailed procedural guidance for counters.

Common Use Cases and Queries

The primary use case is the configuration and maintenance of cycle counting programs. Administrators use this table to define the classes (e.g., "A-Items," "Critical Raw Materials," "Slow-Moving") against which items are categorized. A common reporting need is to list all active count classes with their descriptions. A typical query would join IC_CRUL_CLS to IC_TEXT_HDR to retrieve long descriptions.

SELECT c.count_class,
       c.class_desc, -- Assumed column
       t.long_text
FROM   gmi.ic_crul_cls c,
       gmi.ic_text_hdr t
WHERE  c.text_code = t.text_code(+)
ORDER BY c.count_class;

Another critical use is analyzing count performance by class, which would involve joining IC_CRUL_CLS to transactional tables like IC_WHSE_INV via the COUNT_CLASS column.

Related Objects

The IC_CRUL_CLS table maintains defined relationships with several key inventory tables, as documented in the provided foreign key metadata.

• Primary Key: IC_CRUL_CLS_PK on COUNT_CLASS. This ensures the uniqueness of each count class code.
• Foreign Key (Outbound): The column TEXT_CODE references the IC_TEXT_HDR table. This allows a count class to have associated descriptive text.
• Foreign Key (Inbound): The IC_WHSE_INV table references IC_CRUL_CLS via its COUNT_CLASS column. This is the most significant relationship, as it physically links the count class master data to the inventory items (lots) stored within a warehouse, determining their cycle counting schedule and grouping.

These relationships position IC_CRUL_CLS as a configuration hub between descriptive text and the vast quantity of inventory records, governing the cycle counting process flow.