Search Results oke_contract_line_id




Overview
Explore in AI Chat

Overview

APPS.PO_SGD_MOD_DISTRIBUTIONS_V is a reporting view in Oracle E-Business Suite that exposes purchase order distribution data in a normalized, attribute-per-row format. Rather than returning one row per distribution with many columns, the view pivots each distribution into multiple rows, where each row carries a column name (COL_NAME) and its corresponding value (COL_VALUE), along with an optional human-readable description (COL_DESC). This "name-value pair" design is characteristic of Oracle's Self-Service Procurement and sourcing/negotiation modules, where distribution attributes can vary by document configuration and are stored generically.

The view is defined over PO_DISTRIBUTIONS_DRAFT_ALL, reflecting draft (in-progress) distribution records rather than finalized distributions. It carries a composite key consisting of PO_HEADER_ID, DRAFT_ID, PO_LINE_ID, LINE_LOCATION_ID, and PO_DISTRIBUTION_ID, allowing consumers to reconstruct the full document hierarchy. Its primary role is to support reporting, integration, and UI display where a flattened, decoded representation of distribution attributes is required.

Underlying Base Objects

The view selects from PO_DISTRIBUTIONS_DRAFT_ALL as its driving table, referencing the PO_GEN_DIFF_PKG package for supporting logic. For decode/description purposes it joins to several dimension objects:

Because these objects are referenced as synonyms or views, the view presents a denormalized, decoded projection suitable for read-only consumption.

Key Columns

  • PK1_VALUE..PK5_VALUE — the composite identifier capturing PO_HEADER_ID, DRAFT_ID, PO_LINE_ID, LINE_LOCATION_ID, and PO_DISTRIBUTION_ID.
  • COL_NAME — the distribution attribute name, e.g. DISTRIBUTION_NUM, QUANTITY_ORDERED, QUANTITY_DELIVERED, QUANTITY_BILLED, QUANTITY_CANCELLED, QUANTITY_FINANCED, QUANTITY_RECOUPED, plus decoded attributes such as CLM_DEFENCE_FUNDING, DESTINATION_TYPE_CODE, DELIVER_TO_LOCATION_ID, DELIVER_TO_PERSON_ID, CODE_COMBINATION_ID, ACCRUAL_ACCOUNT_ID, VARIANCE_ACCOUNT_ID, PROJECT_ID, TASK_ID, EXPENDITURE_ORGANIZATION_ID, and OKE_CONTRACT_LINE_ID.
  • COL_VALUE — the raw or coded value for the attribute in that row.
  • COL_DESC — a decoded, display-friendly description derived via the DECODE logic (e.g., lookup meaning, person full name, contract line number, project name).

The OKE_CONTRACT_LINE_ID attribute is of particular interest: the view resolves it to a contract line number via OKC_K_LINES_B, linking the distribution to its associated service contract line.

Common Use Cases and Queries

Typical scenarios include reconstructing draft distribution details for integration, displaying decoded attributes in custom OAF or Forms pages, and tracing contract references from a distribution. A basic query filtering on the contract line attribute:

  • SELECT * FROM APPS.PO_SGD_MOD_DISTRIBUTIONS_V WHERE col_name = 'OKE_CONTRACT_LINE_ID';
  • SELECT pk1_value, pk5_value, col_name, col_value, col_desc FROM APPS.PO_SGD_MOD_DISTRIBUTIONS_V WHERE pk5_value = :distribution_id;

Because the view returns name-value pairs, consumers frequently pivot on COL_NAME to produce a conventional wide row. It should be treated as a read-only reporting view and not used for DML.