Results for “ic_phys_cnt”

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

Overview

QC_GRAD_MST is the quality control (QC) grade code master table in Oracle E-Business Suite, owned by the Process Manufacturing Product Development module (GMD). It stores the set of QC grade codes that can be assigned to items, lots, inventory balances, transactions, and order lines across the Process Manufacturing and discrete inventory schemas. Because it acts as the single validated source of QC grade values, it is referenced by many operational tables spanning inventory (IC), order processing (OP), and purchasing (PO) modules.

The ETRM metadata classifies this object, heuristically, as hub-leaning under a Data Vault modeling approach. That is a modeling suggestion rather than a mandatory design: QC_GRAD_MST holds a relatively stable, low-volatility set of grade codes that behave as a business concept hub, with the surrounding transactional tables serving as satellites or link-bearing tables that carry the grade reference at each event. The table is documented as not implemented in the current database, indicating it is a referenced data dictionary object available in the Process Manufacturing schema context rather than an actively populated table in every environment.

Key Information Stored

The table is keyed by the primary key constraint QC_GRAD_MST_PK, defined over the QC_GRADE column. QC_GRADE is therefore both the documented surrogate/business key for the master and the value propagated to every referencing table, making it the dominant business-key candidate for this object. A second documented column, TEXT_CODE, carries descriptive text and is the sole foreign key originating from QC_GRAD_MST to QC_TEXT_HDR. The remaining attribute content is not enumerated in the metadata excerpt; the table’s functional importance derives primarily from QC_GRADE as the controlled domain of valid grades.

• QC_GRADE — Primary key column (QC_GRAD_MST_PK); the grade code propagated to all referenced inventory, order, and purchasing tables.
• TEXT_CODE — Foreign key to QC_TEXT_HDR; links the grade to descriptive text maintained in the text header master.

Common Use Cases and Queries

Because the table feeds grade validation across so many modules, its primary use is lookup and validation. Typical reporting scenarios include listing all valid QC grades, resolving grades assigned to lots or items, and tracing grade assignments through inventory transactions. A representative validation query resolves an item’s assigned grade against the master:

• SELECT i.inventory_item_id, i.qc_grade FROM ic_item_mst i WHERE i.qc_grade IN (SELECT qc_grade FROM qc_grad_mst);
• SELECT l.lot_number, l.qc_grade FROM ic_lots_mst l, qc_grad_mst g WHERE l.qc_grade = g.qc_grade;
• SELECT a.qc_grade, COUNT(*) FROM ic_adjs_jnl a GROUP BY a.qc_grade; — grade distribution across adjustment journal entries.
• SELECT p.qc_grade_wanted, o.order_number FROM po_ordr_dtl o, qc_grad_mst p WHERE o.qc_grade_wanted = p.qc_grade;

These patterns support quality reporting, traceability investigations, and reconciliation of grades held on lots versus grades expected on purchase or process order lines.

Related Objects

QC_GRAD_MST participates in a hub-and-spoke reference pattern. It references QC_TEXT_HDR (via TEXT_CODE) and is referenced by numerous operational tables through QC_GRADE and related columns:

• IC_ITEM_MST / IC_ITEM_MST_B — reference QC_GRADE to hold the item-level grade.
• IC_LOTS_MST — holds QC_GRADE for lot master records.
• IC_ADJS_JNL, IC_TRAN_ARC, IC_TRAN_CMP, IC_TRAN_PND — inventory transaction and journal tables carrying QC_GRADE.
• IC_SUMM_INV and IC_PHYS_CNT (GRADE_CODE) — inventory summary and physical count references.
• OP_ORDR_DTL (QC_GRADE_WANTED), OP_CNTR_DTL (QC_GRADE), OP_PRCE_ITM (QC_GRADE), OP_PRSL_DTL (QC_GRADE_WANTED), and OP_ALOT_PRM (PREFQC_GRADE) — process order, pricing, proposal, and allocation references.
• PO_ORDR_DTL and PO_BPOS_DTL (QC_GRADE_WANTED) — purchasing references expressing the grade wanted on order and blanket detail lines.