Search Results open_yn




Overview
Explore in AI Chat

Overview

The OKE_K_HEADERS_FWDN_V view is a reporting and integration object within the Oracle E-Business Suite OKE – Project Contracts module. As its name and description indicate ("Contract header view for flowdown"), it exposes contract header information in a flattened, denormalized form suitable for flowdown processing, reporting, and external consumption. The view is owned by the APPS schema and is documented as VALID in both ETRM 12.1.1 and 12.2.2.

The view consolidates a broad set of contract attributes—identification, versioning, status, classification, financial terms, and project associations—into a single queryable structure. It incorporates display-ready formatting, notably currency values converted through FND_CURRENCY_CACHE.GET_FORMAT_MASK, and provides paired flag columns (a code and a display value) such as BOOKED_FLAG/BOOKED_YN. Because it sits on top of the secured contract header view, it respects Oracle's contract security model while offering a convenient projection for downstream use cases such as project contract flowdown to sub-contracts, interfaces, and ad hoc reporting.

Underlying Base Objects

The documented base objects referenced by this view are:

  • OKE_K_HEADERS_SECURE_V (VIEW) – the primary source supplying the contract header rows, filtered by the contract security model.
  • OKE_K_SECURITY_PKG (PACKAGE) – the security package governing access to contract records.
  • OKE_UTILS (PACKAGE) – utility functions used in column derivation (for example, converting flag codes into Y/N display values).
  • FND_CURRENCY_CACHE (PACKAGE) – supplies the currency format mask applied to monetary columns such as K_VALUE and NTE_AMOUNT.

This layered architecture means the view does not query base tables directly; instead it inherits row-level security, versioning logic, and lookup translation from the underlying secured view and packages, ensuring consistent behavior with other Project Contracts components.

Key Columns

Common Use Cases and Queries

A frequent requirement is to retrieve booked contract headers for flowdown or downstream contracts:

SELECT K_NUMBER, K_ALIAS, STATUS, BOOKED_YN,
       AUTHORING_ORG, K_VALUE, START_DATE, END_DATE
FROM   APPS.OKE_K_HEADERS_FWDN_V
WHERE  BOOKED_FLAG = 'Y'
  AND  STATUS_CODE = 'APPROVED';

Because the view applies contract security, results are automatically limited to records the querying user is authorized to see, making it safe for shared reporting and integration layers. It is also useful for project-level rollups:

  • Listing all booked contracts associated with a given PROJECT_ID or PROJECT_NUMBER.
  • Feeding flowdown interfaces that copy header attributes to sub-contracts.
  • Building currency-consistent financial extracts using the pre-formatted K_VALUE and NTE_AMOUNT columns.
  • Tracking award and approval milestones via AWARD_DATE, DATE_APPROVED, and AUTHORIZE_DATE.

In each case, filtering on BOOKED_FLAG (with BOOKED_YN for display) provides the simplest way to isolate active, booked contracts from draft or unbooked headers.