Search Results op_prce_itmi1




Overview
Explore in AI Chat

Overview

The OP_PRCE_ITM table is a core data object within the Oracle E-Business Suite (EBS) Process Manufacturing Logistics (GML) module. It serves as the central repository for storing detailed item pricing information associated with specific price lists. This table is fundamental to the pricing engine in manufacturing and distribution operations, enabling the system to determine the correct selling price for an item based on a combination of factors such as the price list, item, warehouse, quality grade, and unit of measure. Its role is critical for sales order processing, invoicing, and any business process requiring accurate and context-sensitive item pricing.

Key Information Stored

The table's structure is designed to support multi-dimensional pricing. Its primary key (OP_PRCE_ITMI1) is a composite key, highlighting that a unique price record is defined by the intersection of several attributes. Key columns include PRICELIST_ID, which links to the master price list (OP_PRCE_MST); ITEM_ID, referencing the item master (IC_ITEM_MST_B); and WHSE_CODE, linking to the warehouse master (IC_WHSE_MST). Additional critical dimensions are PRICE_CLASS, QC_GRADE, PRICE_UM (the pricing unit of measure), and FRTBILL_MTHD (the freight billing method). The table also contains a surrogate primary key, PRICE_ID (via OP_PRCE_ITM_PK), which is used as a unique identifier and foreign key by dependent tables like OP_PRCE_BRK for storing price break quantities.

Common Use Cases and Queries

A primary use case is retrieving the applicable price for an item during sales order entry. This involves querying OP_PRCE_ITM with known parameters from the order line. For example, a report to list all active prices on a specific price list would join to related master tables for descriptive information. Common SQL patterns include filtering by PRICELIST_ID and ITEM_ID, often with additional conditions for warehouse or grade. Price break analysis is another critical scenario, requiring a join from OP_PRCE_ITM to OP_PRCE_BRK on PRICE_ID to report volume-based pricing tiers. Technical consultants often query this table to troubleshoot pricing discrepancies by verifying the existence and values of price records for a given set of criteria.

Related Objects

OP_PRCE_ITM has extensive relationships within the GML and Inventory (INV) modules. It is a child table of the price list master (OP_PRCE_MST). Its foreign keys, as documented, reveal dependencies on fundamental master data: items (IC_ITEM_MST_B, IC_ITEM_MST), warehouses (IC_WHSE_MST), price classes (IC_PRCE_CLS), units of measure (SY_UOMS_MST), quality grades (GMD_GRADES_B, QC_GRAD_MST), freight methods (OP_FRGT_MTH), and text headers (OP_TEXT_HDR). Crucially, it is a parent table to OP_PRCE_BRK, which stores quantity break pricing. Any integration, data migration, or customization involving item pricing must account for these relationships to maintain data integrity.