Search Results op_prce_mst_pk




Overview
Explore in AI Chat

Overview

The OP_PRCE_MST table is a core data object within Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the Process Manufacturing Logistics (GML) product family. It functions as the header or master table for price lists. This table stores the foundational definition and control attributes for each price list, such as its unique identifier, code, description, and currency. As a header table, it establishes the primary entity to which detailed pricing rules, effective dates, and item-specific prices are linked, forming the structural backbone of the pricing module within Process Manufacturing.

Key Information Stored

The table's primary purpose is to define price list entities. The most critical columns, as indicated by the documented constraints, are PRICELIST_ID and PRICELIST_CODE. PRICELIST_ID serves as the primary key (OP_PRCE_MST_PK) for unique row identification and is the foreign key referenced by child tables. PRICELIST_CODE has a unique key constraint (OP_PRCE_MST_UK), enforcing business-level uniqueness for the price list identifier. Other significant columns include CURRENCY_CODE, which links to the GL_CURR_MST table to define the monetary unit for all prices on the list, and TEXT_CODE, which links to the OP_TEXT_HDR table to store descriptive notes or terms associated with the price list.

Common Use Cases and Queries

This table is central to pricing operations and reporting. Common use cases include retrieving a list of all active price lists for a specific currency, validating a price list code during order entry, or generating a master list of pricing structures for analysis. A typical query would join OP_PRCE_MST with its child tables to get a comprehensive price list report. For example, to list all price lists with their base currency, a basic query would be:

  • SELECT PRICELIST_CODE, NAME, CURRENCY_CODE FROM GML.OP_PRCE_MST ORDER BY PRICELIST_CODE;

For more detailed analysis, a join to the OP_PRCE_EFF (effectivity) and OP_PRCE_ITM (item price) tables is necessary to analyze pricing rules and values over time.

Related Objects

OP_PRCE_MST is a parent table with several key dependencies. The primary foreign key relationships documented are:

  • GL_CURR_MST: Via the CURRENCY_CODE column, ensuring valid currency definition.
  • OP_TEXT_HDR: Via the TEXT_CODE column, for attaching descriptive text.
  • Child Tables: The table is directly referenced as a foreign key by at least two critical detail tables:
    • OP_PRCE_EFF: Stores price list effectivity dates and rules, linked by PRICELIST_ID.
    • OP_PRCE_ITM: Stores the actual price for specific items within the price list, linked by PRICELIST_ID.

This structure means that OP_PRCE_MST is the central point from which all specific pricing data is organized and accessed.