Search Results po_bpos_dtl

Overview

The QC_GRAD_MST table is the master repository for Quality Control (QC) grade codes within the Oracle E-Business Suite Process Manufacturing (GMD) Product Development module. It serves as a foundational reference table, defining the discrete quality classifications that can be assigned to items, lots, and transactions throughout the manufacturing and inventory lifecycle. Its primary role is to enforce data integrity and provide a centralized definition for grading, which is critical for quality management, inventory valuation, and production planning in process industries. The table's structure as a master with numerous foreign key relationships underscores its importance as a core control table within the GMD data model.

Key Information Stored

Based on the provided ETRM metadata, the central column in the QC_GRAD_MST table is QC_GRADE, which serves as the primary key (QC_GRAD_MST_PK). This column stores the unique identifier for each quality grade code. The table also contains a TEXT_CODE column, which is linked via a foreign key relationship to the QC_TEXT_HDR table. This relationship suggests that descriptive, translatable text for each grade code is managed separately in a multilingual text header table, a common pattern in Oracle EBS for supporting multiple languages. The table's purpose is to store the code and its associated text reference, forming the complete master record for a QC grade.

Common Use Cases and Queries

The QC_GRAD_MST table is referenced in operational scenarios involving quality specification and tracking. Common use cases include defining the acceptable or desired grade for an item master (IC_ITEM_MST), assigning an actual grade to a specific production or inventory lot (IC_LOTS_MST), and recording the grade involved in inventory transactions, adjustments, and physical counts. A typical reporting query would join this master table to various transaction tables to analyze inventory or production by quality grade. For example, to list all inventory lots with their grade descriptions, one might use a query pattern such as: SELECT lm.lot_number, gm.qc_grade, th.description FROM ic_lots_mst lm JOIN qc_grad_mst gm ON lm.qc_grade = gm.qc_grade JOIN qc_text_hdr th ON gm.text_code = th.text_code WHERE th.language = USERENV('LANG');. Another critical use is validating data entry in forms and APIs where a QC grade is specified.

Related Objects

The QC_GRAD_MST table has extensive relationships across Process Manufacturing and Inventory modules, as evidenced by its foreign keys. Key dependent tables include:

• Inventory Core Tables: IC_ITEM_MST_B, IC_ITEM_MST (item definition), IC_LOTS_MST (lot tracking), IC_TRAN_PND, IC_TRAN_CMP, IC_TRAN_ARC (inventory transactions).
• Inventory Operations: IC_ADJS_JNL (adjustments), IC_PHYS_CNT (physical counts), IC_SUMM_INV (summarized inventory).
• Process Execution: OP_CNTR_DTL (container details), OP_ORDR_DTL (operation details).
• Procurement: PO_ORDR_DTL, PO_BPOS_DTL (purchase order details).
• Text Management: QC_TEXT_HDR, which provides the translatable description for the grade code via the TEXT_CODE foreign key.

This network of relationships highlights that QC_GRAD_MST is a vital shared reference point for quality data integrity.