Search Results oke_k_headers_orgnzr_v




Overview
Explore in AI Chat

Overview

OKE_K_HEADERS_ORGNZR_V is a denormalized reporting view owned by the APPS schema in Oracle E-Business Suite, delivered as part of the OKE - Project Contracts module. Its documented purpose is to serve as the contract listing view for the Contract Organizer tree, a hierarchical navigation and selection component used within the Project Contracts (formerly Oracle Contracts Core) user interface. The view flattens contract header data drawn from several contract and HR tables into a single row per contract, presenting descriptive identifiers such as contract number, authoring and owning organizations, program details, product line, and short description.

The object is a VIEW, not a table, and carries a VALID status in the ETRM 12.2.2 metadata. Because it consolidates security-filtered contract listings, it plays a dual role: it supports interactive Contract Organizer functionality, and it can be used as a read-only data source for custom reports and integrations that require a listing of contracts visible to the current user. The view is self-filtering; it does not return every contract in the database but only those the querying session is entitled to see.

Underlying Base Objects

The documented base objects referenced by this view are FND_LOOKUP_VALUES_VL (VIEW), HR_ALL_ORGANIZATION_UNITS_TL (SYNONYM), OKC_K_HEADERS_B (SYNONYM), OKC_K_HEADERS_TL (SYNONYM), OKE_K_HEADERS (SYNONYM), OKE_K_SECURITY_PKG (PACKAGE), and OKE_PROGRAMS (SYNONYM). The view joins these to assemble descriptive and organizational attributes on top of the core contract header records stored in OKC_K_HEADERS_B and OKC_K_HEADERS_TL.

The most significant dependency is the security access view OKE_K_ALL_ACCESS_BASIC_V, which is joined on K_HEADER_ID and constrained by ACC.PERSON_ID = FND_GLOBAL.EMPLOYEE_ID. This join is what restricts output to contracts accessible to the logged-in employee. Cross-organization visibility is governed by the OKE_UTILS.CROSS_ORG_ACCESS flag: when it equals 'Y', organization filtering is bypassed; otherwise the authoring organization must match OKE_UTILS.ORG_ID, with a NVL default of -99 for null authoring organizations. Organizational names are resolved through HR_ALL_ORGANIZATION_UNITS_TL twice — once for the authoring organization and once for the owning organization — using outer joins keyed on USERENV('LANG'). Product line descriptions are resolved from FND_LOOKUP_VALUES_VL with VIEW_APPLICATION_ID 777 and LOOKUP_TYPE 'PRODUCT_LINE'. Program information is joined from OKE_PROGRAMS, and the translated short description from OKC_K_HEADERS_TL.

Key Columns

  • K_HEADER_ID — Primary identifier of the contract header; the join key to OKC_K_HEADERS_B and related contract tables.
  • K_NUMBER_DISP / K_NUMBER — The displayed contract number used to identify the contract in listings and trees.
  • AUTHORING_ORG_ID / AUTHORING_ORG — Identifier and name of the organization that authored the contract; central to the organization-based access filter.
  • OWNING_ORGANIZATION_ID / OWNING_ORGANIZATION — Identifier and name of the organization that owns the contract.
  • PROGRAM_ID / PROGRAM_NAME / PROGRAM_NUMBER — Reference to the OKE_PROGRAMS program associated with the contract.
  • PRODUCT_LINE_CODE / PRODUCT_LINE — The product line lookup code and its translated meaning from FND_LOOKUP_VALUES_VL.
  • SHORT_DESCRIPTION — The translated short description from OKC_K_HEADERS_TL, in the session language.

Common Use Cases and Queries

Typical uses include Contract Organizer navigation support, custom contract listing reports, and data extracts for downstream systems that need contract header attributes with organization and program context. Because the view enforces person-level and organization-level security, it is well suited to self-service reporting where row-level entitlement matters.

A basic listing query:

  • SELECT k_header_id, k_number_disp, authoring_org, owning_organization, program_name, product_line, short_description FROM apps.oke_k_headers_orgnzr_v;

Filtering to a specific product line:

  • SELECT k_number_disp, authoring_org, short_description FROM apps.oke_k_headers_orgnzr_v WHERE product_line_code = :product_line;

Joining back to the base contract header for additional attributes:

  • SELECT v.k_number_disp, v.authoring_org, b.start_date, b.end_date FROM apps.oke_k_headers_orgnzr_v v, apps.okc_k_headers_b b WHERE v.k_header_id = b.id;

Note that the view's output depends on FND_GLOBAL.EMPLOYEE_ID and the OKE_UTILS.CROSS_ORG_ACCESS setting, so results vary by session context; initialize the application context before querying outside of the standard application flow.