Search Results qc_hres_mst_pk

Overview

The QC_HRES_MST table is a master data table within the Oracle E-Business Suite (EBS) Process Manufacturing (GMD) product development module. It functions as the central repository for defining and managing Quality Control (QC) hold reason codes. These standardized codes are critical for documenting why a material, lot, or inventory item has been placed under a quality-related restriction or quarantine within the manufacturing and inventory management processes. The table's role is to ensure data integrity and consistency by providing a validated list of reasons that can be referenced by various transactional tables across the inventory and quality management systems.

Key Information Stored

The primary data element stored in this table is the QC hold reason code itself. Based on the provided metadata, the key column is QCHOLD_RES_CODE, which serves as the table's primary key (QC_HRES_MST_PK). This design ensures each reason code is unique. The table also contains a TEXT_CODE column, which is a foreign key to the QC_TEXT_HDR table. This relationship allows for the association of extensive descriptive text, instructions, or notes with each reason code, enabling detailed documentation beyond a simple code. The table's structure is focused on maintaining this master list of codes and their corresponding textual descriptions.

Common Use Cases and Queries

The primary use case for QC_HRES_MST is to provide a validated list of reasons during transactions that place inventory on hold. When a user places a lot or item on a quality hold in the system, they typically select a reason from a list populated by this table. Common reporting and query scenarios include generating lists of all active hold reasons or analyzing hold trends. A typical SQL query to retrieve all reason codes with their descriptions would join to the text table:

• SELECT qh.qchold_res_code, qt.text
  FROM gmd.qc_hres_mst qh,
  gmd.qc_text_hdr qt
  WHERE qh.text_code = qt.text_code(+)
  ORDER BY qh.qchold_res_code;

Another common operational query is to find all inventory items currently held for a specific reason by joining to the IC_ITEM_MST_B table.

Related Objects

As indicated by the foreign key relationships, QC_HRES_MST is a foundational table referenced by several key inventory and lot management tables. The primary foreign key links the TEXT_CODE to the QC_TEXT_HDR table for descriptive text. Importantly, the QCHOLD_RES_CODE column is referenced by numerous transactional tables, including:

• IC_ITEM_MST_B and IC_ITEM_MST (Item Master)
• IC_LOCT_INV (Location Inventory)
• IC_LOTS_STS (Lot Status)
• IC_PERD_BAL (Period Balances)

These relationships demonstrate that a hold reason code assigned from QC_HRES_MST can be applied at the item master, specific lot, inventory location, and periodic inventory balance levels, integrating quality control deeply into inventory management.