Search Results op_cntr_dtl




Overview
Explore in AI Chat

Overview

The OP_CNTR_DTL table is a core transactional data object within the Oracle E-Business Suite Process Manufacturing Logistics (GML) module. It functions as the detail line repository for pricing information defined on a sales or purchase contract. The table's primary role is to store and manage the specific item prices, including any associated conditions such as quality grade or warehouse, that are stipulated under a master contract header. This enables the enforcement of negotiated pricing and terms for transactions generated from the contract throughout the supply chain.

Key Information Stored

The table stores the definitive price list for items under a contract. Its structure includes a system-generated unique identifier (PRICE_ID) and links to the master contract (CONTRACT_ID). Critical business columns define the pricing rule: the ITEM_ID, PRICE_CLASS, and QC_GRADE specify what is being priced. The PRICE_UM (Price Unit of Measure) and associated price value columns (not explicitly listed but implied by the table's purpose) define the cost. Additional columns like WHSE_CODE and FRTBILL_MTHD (Freight Billing Method) provide further transactional context. The LINE_NO suggests the ability to maintain multiple price lines for the same item under different conditions.

Common Use Cases and Queries

This table is central to pricing determination during order entry and invoice generation. A common operational query retrieves the valid price for a given item and contract, often joining to the unit of measure and grade tables for descriptions. For reporting, analysts frequently aggregate pricing data by item or contract to analyze profitability or contract utilization. A typical lookup pattern would be:

  • SELECT price_value, price_um FROM gml.op_cntr_dtl WHERE contract_id = :p_contract_id AND item_id = :p_item_id AND qc_grade = :p_grade;

Data maintenance involves inserting or updating price lines when a contract is created or amended, ensuring the PRICE_CLASS and ITEM_ID combination is unique per the OP_CNTR_DTL_U1 key.

Related Objects

OP_CNTR_DTL maintains integral relationships with numerous master and transactional tables, as documented by its foreign keys: