Results for “from_category_id”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

CR_SQDS_TBL is a Process Manufacturing Process Planning table owned by the GMP schema in Oracle E-Business Suite 12.1.1 and 12.2.2. Its documented purpose is to store sequence-dependent setup information — the changeover cost, time, or transition characteristics incurred when a production line moves from one item to another within a specific operation. In process manufacturing environments, such as food, beverage, chemical, and pharmaceutical production, the order in which items are run on shared equipment materially affects yield, run time, and waste; CR_SQDS_TBL is the repository that captures these from-item/to-item transition rules for each operation.

The table contains 15 documented columns in the 12.2.2 physical schema and is keyed by CR_SQDS_TBL_PK, a composite unique index spanning OPRN_ID, FROM_ITEM_ID, and TO_ITEM_ID. Under the heuristic Data Vault classification mined from its foreign-key structure, CR_SQDS_TBL is best modeled as a link table: it represents an association or relationship between an operation and a pair of items (the item being completed and the item being started), rather than describing an independent business entity or acting as a pure descriptive satellite.

Key Information Stored

The most significant columns fall into three groups — keys, setup attributes, and audit columns.

• OPRN_ID — identifies the operation (routing step) whose sequence-dependent setup is being defined; a primary-key component and FK to FM_OPRN_MST.
• FROM_ITEM_ID — the item transitioning out of production; a primary-key component and FK to IC_ITEM_MST and IC_ITEM_MST_B.
• TO_ITEM_ID — the item transitioning into production; a primary-key component and FK to IC_ITEM_MST and IC_ITEM_MST_B.
• FROM_ITEM_CLASS and TO_ITEM_CLASS — item class designations used when setup is defined at a class level rather than by individual item; FKs to CR_SQDT_CLS.
• SETUP_TIME — the setup or changeover duration applied when moving from the FROM item to the TO item on the operation.
• TRANS_CNT — the transition count or sequence transition metric associated with the from/to pairing.
• TEXT_CODE — a reference to descriptive text held in CR_TEXT_HDR, allowing free-form documentation of the setup rule.
• FROM_CATEGORY_ID and TO_CATEGORY_ID — category identifiers that generalize the setup rule beyond discrete items.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — standard Oracle audit columns recording who created and last modified each row.

Common Use Cases and Queries

The primary use case is retrieval of the setup time for a given operation and item-to-item transition, typically during production scheduling or sequencing optimization.

• Look up setup time for a specific operation and item pair:

SELECT oprn_id, from_item_id, to_item_id, setup_time
FROM   gmp.cr_sqds_tbl
WHERE  oprn_id     = :p_oprn_id
AND    from_item_id = :p_from_item
AND    to_item_id   = :p_to_item;

• Report all sequence-dependent setups defined for an operation, resolved to item numbers via IC_ITEM_MST.
• Identify transitions with the largest setup times to prioritize changeover reduction.
• Audit recently modified setup definitions using LAST_UPDATE_DATE.

Related Objects

• FM_OPRN_MST — joined on CR_SQDS_TBL.OPRN_ID; supplies the operation master definition.
• IC_ITEM_MST — joined on FROM_ITEM_ID and TO_ITEM_ID; provides item master detail.
• IC_ITEM_MST_B — the base/translation item master, also joined on FROM_ITEM_ID and TO_ITEM_ID.
• CR_SQDT_CLS — joined on FROM_ITEM_CLASS and TO_ITEM_CLASS; provides setup classification values.
• CR_TEXT_HDR — joined on TEXT_CODE; supplies descriptive text for setup rules.

Together these references establish CR_SQDS_TBL as the operational link connecting an operation, an originating item, and a destination item, with supporting class and text metadata.