Search Results oe_blkt_headers_hist_v




Overview
Explore in AI Chat

Overview

OE_BLKT_HEADERS_HIST_V is a PL/SQL view owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It belongs to the Order Management (ONT) product family and is documented as valid in the ETRM repository. The view exposes historical header information for Blanket Sales Agreements (BSA) and is used specifically by the BSA Organizer, a form-based interface that allows order management users to query, review, and maintain blanket sales agreements over time. Because the view surfaces versioned header data, it supports historical analysis of negotiated agreements rather than only current or active agreement states.

The view is read-only in nature. It is not a base table and holds no data of its own; it is a projection over the blanket agreement header history tables and associated reference objects. Its role in reporting and integration is to provide a denormalized, queryable surface that combines agreement header attributes with currency, customer, shipment, pricing, and control information, so that custom reports, extracts, and interfaces can retrieve BSA history without joining dozens of base tables manually.

Underlying Base Objects

The view is defined over OE_BLANKET_HEADERS_HIST, which stores the versioned history rows for blanket agreement headers. Because agreements can be renegotiated, multiple version rows may exist for a single agreement. The view also references the current header object OE_BLANKET_HEADERS and its extension OE_BLANKET_HEADERS_EXT, along with the OE_BLANKET_FORM_CONTROL package used by the BSA Organizer form.

Reference and lookup objects joined or referenced include OE_TRANSACTION_TYPES_TL (order type translated names), OE_LOOKUPS and AR_LOOKUPS (lookup meanings), FND_CURRENCIES (currency codes and descriptions), QP_LIST_HEADERS_TL (price lists), RA_RULES and RA_TERMS_TL (invoicing and accounting rules, payment terms), MTL_PARAMETERS (shipping organization parameters), and the HZ customer model objects HZ_CUST_ACCOUNTS, HZ_CUST_ACCOUNT_ROLES, HZ_PARTIES, and HZ_RELATIONSHIPS. These joins resolve internal IDs into business-meaningful values.

Key Columns

The view exposes the complete BSA header attribute set. Principal columns include:

Common Use Cases and Queries

Typical uses include BSA Organizer backing queries, agreement version comparisons, ship-from sourcing analysis, and extracts feeding custom reporting or integrations. A representative query filtering by ship-from organization is:

SELECT order_number, version_number, expiration_date, ship_from_org_id, ship_to_org_id, transactional_curr_code FROM oe_blkt_headers_hist_v WHERE ship_from_org_id = :org_id AND org_id = :operating_unit ORDER BY order_number, version_number;

To trace all historical versions of a single agreement:

SELECT order_number, version_number, expiration_date, agreement_id FROM oe_blkt_headers_hist_v WHERE order_number = :order_number ORDER BY version_number DESC;

Because the view is built on history tables, queries should always constrain on ORG_ID and an identifying key to avoid returning every version in the operating unit. Joins back to OE_BLANKET_LINES_HIST_V or OE_BLANKET_HEADERS provide line-level detail when a full agreement picture is required.