Search Results authoring_org




Overview
Explore in AI Chat

Overview

APPS.OKE_K_HEADERS_ORGNZR_V is a supplementary Oracle E-Business Suite view in the Oracle Contracts (OKE/OKC) module, defined in the APPS schema with FND Design Data reference OKE.OKE_K_HEADERS_ORGNZR_V. In Oracle EBS 12.1.1 and 12.2.2 the object is registered as VALID and is classified as a "supplementary view used to simplify forms coding." Oracle explicitly warns that this view is not intended for direct customer query or data manipulation, since its definition may change substantially across minor or major releases. Its practical role is to present contract header information enriched with organization and program attributes — most notably the Authoring (Owning) Organization — so that Oracle Forms-based contract authoring screens and dependent reporting logic can resolve organization names without embedding complex join logic. For users who search on the term "authoring_org," this view is the primary documented source that exposes the AUTHORING_ORG and AUTHORING_ORG_ID columns alongside contract header identifiers.

Underlying Base Objects

The view draws on both transactional contract tables and reference/lookup objects. The documented base objects are:

The view is not referenced by any other database object, confirming its role as a terminal presentation layer rather than a building block for further dependent views.

Key Columns

  • K_HEADER_ID (NUMBER) — unique identifier of the contract document header; the primary join key.
  • K_NUMBER (VARCHAR2, 240) — the contract document number.
  • AUTHORING_ORG_ID (NUMBER) — unique identifier of the Contract Authoring (Owning) Organization.
  • AUTHORING_ORG (VARCHAR2, 240) — the resolved display name of the authoring organization.
  • OWNING_ORGANIZATION_ID / OWNING_ORGANIZATION — the owning organization identifier and name.
  • PROGRAM_ID, PROGRAM_NAME, PROGRAM_NUMBER — identifiers and descriptive attributes of the associated contract program.
  • PRODUCT_LINE_CODE / PRODUCT_LINE — the product line code and its decoded description.
  • SHORT_DESCRIPTION (VARCHAR2, 600) — the contract document short description.

Common Use Cases and Queries

Typical uses include identifying which authoring organization owns a contract, reporting contract volumes by organization or program, and validating organization assignments during integration or conversion. Because Oracle cautions against production dependencies on this view, it is best used for ad hoc diagnostics and read-only reporting.

List contracts for a given authoring organization:

  • SELECT k_number, authoring_org, owning_organization, program_name FROM apps.oke_k_headers_orgnzr_v WHERE authoring_org_id = :org_id;

Aggregate contract counts by authoring organization and product line:

  • SELECT authoring_org, product_line, COUNT(*) FROM apps.oke_k_headers_orgnzr_v GROUP BY authoring_org, product_line ORDER BY authoring_org;

Retrieve contract details by number:

  • SELECT k_header_id, k_number, authoring_org, owning_organization, short_description FROM apps.oke_k_headers_orgnzr_v WHERE k_number = :contract_number;