Results for “gmd_grades_b”

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

Overview

GMD_GRADES_B is the quality control (QC) grade code master table within the Oracle E-Business Suite Process Manufacturing Product Development module (GMD). It stores the master list of QC grade codes used throughout the Process Manufacturing and Inventory modules to classify material quality, lot condition, and grade expectations at various stages of the supply chain. The table resides in the GMD schema and is owned by the Product Development product family, which governs formulation, quality specifications, and grade definitions in process manufacturing environments.

From a Data Vault modeling perspective, the metadata classifies GMD_GRADES_B as hub-leaning. This heuristic reflects the table's role as a stable reference source of business keys (QC grades) that are referenced by a wide array of transactional and master tables across Inventory, Order Processing, and Purchasing. The table is best understood as a reference or lookup master whose primary identifier is propagated as a foreign key into downstream transactional records.

Key Information Stored

The table contains 42 documented columns, of which the following are the most operationally significant:

• QC_GRADE — The primary key and sole unique business-key candidate (enforced by the GMD_GRADES_B_PK unique index). This is the code that uniquely identifies each grade and is the value propagated to all referencing tables.
• QC_GRADE_DESC — The descriptive name or long description associated with the grade code, used for user-facing display and reporting.
• TEXT_CODE — A foreign key to QC_TEXT_HDR, linking the grade to a text template or note header for supplemental descriptive information.
• DELETE_MARK — The standard Oracle EBS soft-delete flag; values other than 0 indicate logical deletion.
• TRANS_CNT — A transaction counter typically used for concurrency control or change tracking.
• MIGRATED_IND — Indicates whether the grade record originated from a data migration rather than direct entry.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — Standard EBS audit columns capturing who created and last modified each grade and when.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE30 — The standard Oracle EBS descriptive flexfield (DFF) columns, allowing customers to extend the grade master with site-specific attributes without schema changes.

The surrogate-style primary key here is effectively the business key QC_GRADE itself; no separate numeric surrogate is documented, meaning QC_GRADE serves dual purpose as both the unique identifier and the propagated foreign key value.

Common Use Cases and Queries

QC grades are consumed across inventory lot management, order promising, purchasing, and quality inspection. Typical reporting use cases include listing all active grades, resolving grade descriptions on transaction detail reports, and validating grade assignments on lots and orders.

Retrieve all active grades:

• SELECT QC_GRADE, QC_GRADE_DESC FROM GMD.GMD_GRADES_B WHERE DELETE_MARK = 0 ORDER BY QC_GRADE;

Join lots to their grade description:

• SELECT l.LOT_NO, l.QC_GRADE, g.QC_GRADE_DESC FROM IC_LOTS_MST l, GMD.GMD_GRADES_B g WHERE l.QC_GRADE = g.QC_GRADE AND g.DELETE_MARK = 0;

Sample the flexfield attributes and text linkage for a grade:

• SELECT g.QC_GRADE, g.QC_GRADE_DESC, g.ATTRIBUTE_CATEGORY, g.ATTRIBUTE1, t.TEXT_CODE FROM GMD.GMD_GRADES_B g LEFT JOIN QC_TEXT_HDR t ON g.TEXT_CODE = t.TEXT_CODE WHERE g.QC_GRADE = :grade;

Related Objects

GMD_GRADES_B is referenced extensively as a parent lookup. The most significant related objects and their join columns are:

• QC_TEXT_HDR — referenced by GMD_GRADES_B.TEXT_CODE; the sole outbound foreign key from the grades table.
• IC_LOTS_MST — joins on QC_GRADE; lots carry an assigned grade for quality classification.
• IC_ITEM_MST_B — joins on QC_GRADE; items define a default grade.
• IC_TRAN_CMP, IC_TRAN_PND, IC_TRAN_ARC — inventory transactions join on QC_GRADE to record grade at movement time.
• IC_ADJS_JNL — inventory adjustment journal joins on QC_GRADE.
• OP_ORDR_DTL and OP_PRSL_DTL — join on QC_GRADE_WANTED, capturing the grade desired on process orders and proposals.
• PO_ORDR_DTL and PO_BPOS_DTL — join on QC_GRADE_WANTED, capturing grade requirements on purchase orders and blanket purchase agreement lines.
• OP_CNTR_DTL, OP_PRCE_ITM, OP_ALOT_PRM — join on QC_GRADE or PREFQC_GRADE for contract, pricing, and preferred-grade parameters.

These relationships confirm the hub-leaning classification: a single grade definition is reused as a controlled vocabulary across the entire process manufacturing transaction landscape.