Results for “oke_k_headers_hv”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

OKE_K_HEADERS_HV is a historical contract header view in the Oracle E-Business Suite Project Contracts module (OKE). It is owned by the APPS schema and carries a VALID status in ETRM 12.1.1 and 12.2.2. The view exposes historical (versioned) contract header information, allowing concurrent access to the current and prior versions of a contract header.

The "_HV" suffix denotes a History View. Unlike transactional base tables that hold only the latest state, this view joins the history table to the current header, returning the historical snapshot of a contract while merging descriptive attributes such as the cognomen, short description, and comments from the current (TL) table. Because header versioning is central to contract version control in OKE, OKE_K_HEADERS_HV is the standard reporting entry point for auditing contract evolution, version comparisons, and historical extracts.

It also plays a role in integration and extraction: external systems and reporting tools consume the view rather than the underlying base tables to retrieve both the historical key (K_HEADER_ID plus MAJOR_VERSION) and the descriptive data that is not versioned in the history table.

Underlying Base Objects

The documented referenced base objects are:

• OKC_K_HEADERS_ALL_BH (SYNONYM)
• OKC_K_HEADERS_TLH (SYNONYM)
• OKE_K_HEADERS_H (SYNONYM)
• PA_TASKS (SYNONYM)

The view is defined as a join in which CH represents the current header record, EH represents the historical header table OKE_K_HEADERS_H, and CHT represents OKC_K_HEADERS_TLH, providing the translated descriptive columns. The ROWID from the current header is retained, while K_HEADER_ID and MAJOR_VERSION are supplied from the history row (EH). This structure confirms that version-aware attributes such as K_NUMBER_DISP, BOOKED_FLAG, OPEN_FLAG, and AWARD_DATE come from the history table, whereas non-versioned descriptive text comes from the TL table. The user-searched object okc_k_headers_tlh is the translated header table that supplies COGNOMEN, SHORT_DESCRIPTION, DESCRIPTION, and COMMENTS in this join.

Key Columns

• K_HEADER_ID / MAJOR_VERSION — the versioned primary identifier of the contract header; used as the join key to history.
• CONTRACT_NUMBER / CONTRACT_NUMBER_MODIFIER / K_NUMBER_DISP — the contract's display number and modifiers.
• CHR_TYPE / K_TYPE_CODE / SCS_CODE — contract type and classification codes.
• STS_CODE / BOOKED_FLAG / OPEN_FLAG / AUTHORIZE_DATE — status and lifecycle flags that change per version.
• START_DATE / END_DATE / AWARD_DATE / DATE_ISSUED — contract milestone dates.
• ESTIMATED_AMOUNT / CURRENCY_CODE / NTE_AMOUNT — financial header values and currency.
• BUY_OR_SELL / ISSUE_OR_RECEIVE — contract direction indicators.
• COGNOMEN / SHORT_DESCRIPTION / DESCRIPTION / COMMENTS — descriptive text sourced from OKC_K_HEADERS_TLH.

Common Use Cases and Queries

Typical uses include retrieving the latest header version for a contract, comparing historical versions, and building audit/extract reports. Because the view mixes history and current descriptive data, filter on MAJOR_VERSION to control which version is returned.

Latest version of a contract:

• SELECT k_header_id, major_version, contract_number, k_type_code, sts_code, start_date, end_date
  FROM apps.oke_k_headers_hv
  WHERE k_header_id = :p_header_id
  ORDER BY major_version DESC;

Full version history for a contract:

• SELECT k_header_id, major_version, sts_code, booked_flag, authorize_date, estimated_amount, currency_code
  FROM apps.oke_k_headers_hv
  WHERE contract_number = :p_contract_number
  ORDER BY k_header_id, major_version;

Find all currently open, booked contracts:

• SELECT k_header_id, major_version, contract_number, cognomen, short_description
  FROM apps.oke_k_headers_hv
  WHERE open_flag = 'Y' AND booked_flag = 'Y';

These queries make OKE_K_HEADERS_HV the preferred source for historical contract header reporting without directly accessing the versioned base tables.