Search Results cr_sqds_tbl




Overview
Explore in AI Chat

Overview

The CR_SQDS_TBL table is a core data object within Oracle E-Business Suite Process Manufacturing (GMP) Process Planning module. It stores sequence-dependent setup data, a critical concept in manufacturing scheduling and optimization. This table enables the system to define and manage the specific setup time, cost, or resource requirements needed on a production line when transitioning from manufacturing one item (the "from" item) to another (the "to" item) within a given operation. By capturing these dependencies, the table allows for more accurate production scheduling, capacity planning, and cost accounting, ensuring that non-productive setup intervals are properly accounted for in the manufacturing plan.

Key Information Stored

The table's primary structure defines the relationship between items within an operation. Its primary key uniquely identifies a setup rule through a combination of OPRN_ID, TO_ITEM_ID, and FROM_ITEM_ID. The OPRN_ID links to a specific manufacturing operation. The FROM_ITEM_ID and TO_ITEM_ID columns are foreign keys to the item master (IC_ITEM_MST_B), representing the item production is switching from and the item production is switching to, respectively. Additional columns, as indicated by the foreign key relationships, likely store associated setup class codes (FROM_ITEM_CLASS, TO_ITEM_CLASS) for grouping items with similar setup characteristics, and a TEXT_CODE for descriptive notes. The table's design allows for modeling asymmetric setup rules where the setup from Item A to Item B may differ from the setup from Item B to Item A.

Common Use Cases and Queries

A primary use case is generating a production schedule that accurately reflects total lead time by aggregating run times with the appropriate sequence-dependent setup times. Planners may query this table to analyze or report on setup constraints between specific products. A common reporting query would join CR_SQDS_TBL with the item master to retrieve item details. For example, to find all setup rules defined for a specific operation, one might use:

  • SELECT sqds.*, from_item.item_number as from_item, to_item.item_number as to_item
  • FROM GMP.CR_SQDS_TBL sqds,
  • INV.IC_ITEM_MST_B from_item,
  • INV.IC_ITEM_MST_B to_item
  • WHERE sqds.oprn_id = :operation_id
  • AND sqds.from_item_id = from_item.item_id
  • AND sqds.to_item_id = to_item.item_id;

Another critical use case is during detailed scheduling or finite capacity planning, where algorithms must sequence jobs to minimize total setup time, directly consuming data from this table.

Related Objects

CR_SQDS_TBL is centrally connected to several key manufacturing and inventory tables via foreign key constraints. Its primary relationships are:

  • FM_OPRN_MST: Linked via OPRN_ID. This is the master table for manufacturing operations.
  • IC_ITEM_MST_B and IC_ITEM_MST: Linked via FROM_ITEM_ID and TO_ITEM_ID. These tables store the item master definitions for the "from" and "to" items in the setup rule.
  • CR_SQDT_CLS: Linked via FROM_ITEM_CLASS and TO_ITEM_CLASS. This table likely defines setup classes used to group items with similar setup characteristics.
  • CR_TEXT_HDR: Linked via TEXT_CODE. This standard EBS table provides descriptive text for the setup rule.