Search Results okl_strm_g_purpose




Overview
Explore in AI Chat

Overview

The view APPS.OKL_CNTRCT_STRMS_SUM_UV is a summary reporting object within the Oracle E-Business Suite Lease and Finance Management (formerly Oracle Lease Management, OKL) module, part of the E-Business Tax and Treasury/contract management family of products. It presents an aggregated, contract-level rollup of accounting stream activity derived from the OKL Streams architecture. In the OKL/ETRM data model, a "stream" represents a scheduled flow of accounting or financial activity associated with a contract — for example, a revenue recognition schedule, a depreciation stream, or a billing stream. The _UV suffix conventionally denotes a "user view," typically intended for reporting, inquiry, or integration consumption rather than for transactional update.

The view answers the practical question: for a given contract, stream type, and activity, what is the total monetary amount? This makes it well suited to dashboard-style reporting where users need summarized stream balances rather than individual stream element rows. Because the user search term was okl_stream_activity, this view is directly relevant: it resolves the cryptic activity code stored on the stream (SAY_CODE) into a human-readable meaning using the OKL_STREAM_ACTIVITY lookup type.

Underlying Base Objects

The view is defined over the following documented base objects, all referenced through APPS synonyms:

Joins are keyed on STMB.STY_ID = STYB.ID, STYB.ID = STYT.ID, and SELB.STM_ID = STMB.ID, with the contract header joined via CHRB.ID = STMB.KHR_ID.

Key Columns

  • KHR_ID — the contract header identifier; the principal linkage back to OKC contract data.
  • CONTRACT_NUMBER — the user-facing contract number from OKC_K_HEADERS_B.
  • ACTIVITY_CODE (SAY_CODE) and ACTIVITY — the raw stream activity code and its decoded lookup meaning (OKL_STREAM_ACTIVITY).
  • NAME — the stream type name in the session language.
  • STREAM_TYPE_PURPOSE_CODE and STREAM_TYPE_PURPOSE — the purpose code and decoded meaning (OKL_STREAM_TYPE_PURPOSE).
  • PURPOSE_CODE and PURPOSE — the general stream purpose and its decoded meaning (OKL_STRM_G_PURPOSE).
  • AMOUNT — the aggregated SUM(SELB.AMOUNT) across stream elements.
  • ID — the stream type identifier, carried through the GROUP BY.

Common Use Cases and Queries

Typical uses include contract-level stream balance reporting, reconciliation of activity totals against subledger balances, and feeding downstream integrations with summarized stream data. A representative query filtered to a single contract:

SELECT CONTRACT_NUMBER, NAME, STREAM_TYPE_PURPOSE, ACTIVITY, PURPOSE, AMOUNT
FROM APPS.OKL_CNTRCT_STRMS_SUM_UV
WHERE CONTRACT_NUMBER = :contract_number
ORDER BY NAME, ACTIVITY;

To summarize totals by stream activity across all contracts:

SELECT ACTIVITY_CODE, ACTIVITY, SUM(AMOUNT) TOTAL_AMOUNT
FROM APPS.OKL_CNTRCT_STRMS_SUM_UV
GROUP BY ACTIVITY_CODE, ACTIVITY;

Because the view performs the aggregation and lookup decoding internally, it eliminates the need to re-join the streams, elements, and type tables in ad hoc reports, and removes dependency on the raw SAY_CODE values. Note that the lookup decoding via OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING executes per row, so query performance may benefit from filtering on CONTRACT_NUMBER or KHR_ID before aggregation.