Search Results k_number




Overview
Explore in AI Chat

Overview

APPS.OKE_K_HEADERS_FWDN_V is a forward-facing (FWDN) reporting view in Oracle E-Business Suite that exposes contract header information managed by Oracle Contract Management / Procurement Contracts (OKE schema). It presents a consolidated, presentation-ready projection of award and contract headers, including identifiers, versioning data, classification attributes, financial values, and workflow/status flags. The view is particularly relevant to users searching on "k_number," the human-readable contract or award number used to uniquely identify a contract header.

Because it resolves foreign key relationships into descriptive columns (organization names, product lines, priorities, project details, currency-formatted amounts), the view is commonly used as a reporting and integration source rather than as a transactional entity. It abstracts the underlying multitenant security model and joins so that downstream consumers — BI Publisher reports, interfaces, extracts, or custom OAF pages — can query contract headers without reconstructing those relationships manually.

Underlying Base Objects

The documented metadata identifies four referenced base objects:

The view therefore inherits the row-level security applied to contract headers via OKE_K_SECURITY_PKG, ensuring that only contracts the querying user is authorized to see are returned.

Key Columns

Columns most relevant to "k_number" and general contract reporting include:

Common Use Cases and Queries

Typical scenarios include contract register reports, award extracts, integration feeds into external systems, and lookups by contract number.

SELECT k_header_id,
       k_number,
       contract_number_modifier,
       k_alias,
       version_disp,
       k_type,
       status,
       currency_code,
       start_date,
       end_date
  FROM apps.oke_k_headers_fwdn_v
 WHERE k_number LIKE :p_k_number
   AND status_code = 'ACTIVE';

For BOA contracts, users often filter on the composite expression shown in the view definition (BOA_NUMBER || '/' || K_NUMBER). Because the view is security-aware, no additional WHERE clause is needed to enforce OKE contract access privileges; those are applied automatically by OKE_K_SECURITY_PKG through OKE_K_HEADERS_SECURE_V.