Search Results pm_matl_dtl




Overview
Explore in AI Chat

Overview

The PM_MATL_DTL table is a core data object within the Oracle E-Business Suite Process Manufacturing Process Execution (GME) module. It serves as the detailed repository for all material components associated with a manufacturing batch or a Fixed Process Order (FPO). This table captures the specific items, quantities, and units of measure required or produced during the execution of a batch, linking the theoretical bill of material to the actual material transactions. Its role is critical for tracking material consumption, yield, and cost analysis within process manufacturing operations.

Key Information Stored

The table's structure is defined by its primary and foreign keys, which anchor it within the manufacturing schema. The primary key is a composite of BATCH_ID and LINE_ID, ensuring each material line is uniquely identified within a batch. Key columns include LINE_ID for the transaction line sequence, ITEM_ID linking to the master item definition in IC_ITEM_MST, and BATCH_ID linking to the parent batch header in PM_BTCH_HDR. The ITEM_UM and ITEM_UM2 columns store the primary and secondary units of measure, referencing SY_UOMS_MST. The TEXT_CODE column links to descriptive text in PM_TEXT_HDR. Notably, the metadata indicates the table is not implemented in the queried database, suggesting it may be a legacy or reference object in certain versions, though its logical purpose remains.

Common Use Cases and Queries

This table is central to material-related reporting and reconciliation in Process Manufacturing. Common use cases include generating batch material pick lists, analyzing actual versus planned material usage (variance reporting), and supporting cost roll-ups. A typical query would join PM_MATL_DTL to the batch header and item master to list all materials for a specific batch. For example:

  • SELECT pmd.line_id, iim.item_no, pmd.plan_qty, pmd.actual_qty, uom.um_code FROM pm_matl_dtl pmd JOIN ic_item_mst iim ON pmd.item_id = iim.item_id JOIN sy_uoms_mst uom ON pmd.item_um = uom.um_id WHERE pmd.batch_id = :batch_id ORDER BY pmd.line_id;

Another critical pattern involves tracing material lineage by joining through PM_BTCH_PKG or PM_ROUT_MTL to understand bulk material allocations or routing step associations.

Related Objects

PM_MATL_DTL is intricately connected to several key tables in the GME schema, as defined by its foreign key relationships. The primary parent table is PM_BTCH_HDR, which defines the batch. It references IC_ITEM_MST for item attributes and SY_UOMS_MST for unit of measure definitions. It is also referenced by PM_BTCH_PKG (for bulk material packaging details) and PM_ROUT_MTL (for routing-specific material requirements), forming a network for detailed material tracking. The relationship with PM_BTCH_HDR via the PARENTLINE_ID column suggests a hierarchical structure for co-product or by-product lines within a batch.