Search Results cr_sqdt_cls




Overview
Explore in AI Chat

Overview

The CR_SQDT_CLS table is a core data object within the Process Manufacturing Process Planning (GMP) module of Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2. It is designed to store master data for sequence-dependent classes, which are critical for modeling production constraints in process industries. These classes categorize items or resources based on their sequence-dependent setup characteristics, enabling the planning system to calculate optimal production sequences that minimize changeover times and costs between different product families or grades. Its role is integral to advanced planning and scheduling (APS) operations within the manufacturing flow.

Key Information Stored

Based on the provided ETRM metadata, the primary data element stored is the sequence-dependent class identifier. The table's structure is centered around the SEQ_DPND_CLASS column, which serves as the primary key (CR_SQDT_CLS_PK). This key uniquely identifies each class definition. The table also contains a foreign key column, TEXT_CODE, which links to the CR_TEXT_HDR table. This relationship allows for the association of descriptive, multilingual text with each sequence-dependent class, ensuring that class descriptions can be maintained in multiple languages for global implementations.

Common Use Cases and Queries

A primary use case is the configuration and maintenance of sequence-dependent rules within Process Planning. Planners utilize these classes to define setup matrices that dictate the time or cost penalty for transitioning production from one item class to another. Common operational queries involve listing all defined classes for setup or reporting purposes, and validating item classifications. For example, a basic query to retrieve all classes with their descriptions would leverage the join to the text table:

  • SELECT cls.seq_dpnd_class, txt.description FROM cr_sqdt_cls cls, cr_text_hdr txt WHERE cls.text_code = txt.text_code;

Another critical query involves identifying all items assigned to a specific sequence-dependent class by joining to the IC_ITEM_MST table, which references this class via its SEQ_DPND_CLASS column.

Related Objects

The CR_SQDT_CLS table has defined relationships with several other key EBS tables, forming the backbone of sequence-dependent planning logic. As per the foreign key metadata, it is referenced by:

  • CR_SQDS_TBL: This table stores the sequence-dependent setup rules themselves. It references CR_SQDT_CLS twice, via FROM_ITEM_CLASS and TO_ITEM_CLASS, to define the transition cost or time from one class to another.
  • IC_ITEM_MST: The item master table holds a SEQ_DPND_CLASS column, linking each manufactured item to its respective sequence-dependent classification for planning calculations.
  • CR_TEXT_HDR: Provides descriptive text for the class codes through the TEXT_CODE foreign key relationship.

It is important to note the ETRM's "Implementation/DBA Data" flag stating "Not implemented in this database." This typically indicates the table is delivered as a seed data repository or its population is contingent on specific module configurations, and it may not contain transactional data in a fresh installation.