Search Results gmd_grades_b




Overview
Explore in AI Chat

Overview

The GMD_GRADES_B table serves as the master repository for Quality Control (QC) grade codes within Oracle E-Business Suite Process Manufacturing (GMD). It is a foundational data object that defines the discrete quality classifications that can be assigned to items, lots, and transactions. Its primary role is to enforce data integrity and provide a centralized reference for quality grading across manufacturing, inventory, and procurement modules. The table's integrity is maintained by the primary key GMD_GRADES_B_PK on the QC_GRADE column, ensuring each grade code is unique.

Key Information Stored

While the provided ETRM excerpt does not list specific columns beyond the key, the table's description as a "QC grade code master" indicates it stores the core attributes defining a grade. Based on standard EBS patterns, the table typically contains the QC_GRADE (primary key), a descriptive name, an effective date range (enabled/disabled status), and a TEXT_CODE linking to descriptive flexfield text in QC_TEXT_HDR. The grade code itself is a critical piece of master data referenced throughout the supply chain to signify the quality level or conformance of a material.

Common Use Cases and Queries

This table is central to quality and inventory management processes. Common use cases include validating grade codes during lot creation, filtering inventory searches by grade, and reporting on the distribution of materials by quality level. A typical query would join GMD_GRADES_B to inventory or transaction tables to retrieve meaningful grade descriptions. For example, to find all lots with a specific grade, one might use:

  • SELECT lot_number, item_id, gb.qc_grade FROM ic_lots_mst lm, gmd_grades_b gb WHERE lm.qc_grade = gb.qc_grade AND gb.qc_grade = 'A';

The user's search for "op_cntr_dtl" directly relates to a documented foreign key, indicating a use case where grade codes are tracked against operation completion details in manufacturing execution.

Related Objects

As documented in the foreign key relationships, GMD_GRADES_B is referenced by numerous transactional and master tables across Process Manufacturing (GMD), Inventory (IC), and Purchasing (PO). Key relationships include:

  • IC_ITEM_MST_B: Links via IC_ITEM_MST_B.QC_GRADE to define a default grade for an item.
  • IC_LOTS_MST: Links via IC_LOTS_MST.QC_GRADE to store the actual grade assigned to a specific inventory lot.
  • OP_CNTR_DTL: Links via OP_CNTR_DTL.QC_GRADE, as per the user's search, to record the grade produced or consumed in a manufacturing operation.
  • OP_ORDR_DTL / PO_ORDR_DTL: Links via QC_GRADE_WANTED to specify the desired grade on manufacturing and purchase orders.
  • IC_TRAN_PND / IC_TRAN_CMP / IC_TRAN_ARC: Links via QC_GRADE to track the grade on pending, completed, and archived inventory transactions.
  • QC_TEXT_HDR: Links via GMD_GRADES_B.TEXT_CODE for descriptive flexfield text storage.