Results for “okl_stream_type_purpose”

50+ results




AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

APPS.OKL_LINE_STREMS_SUM_UV is an Oracle E-Business Suite view belonging to the Oracle Lease and Finance Management (OKL) application module, also referred to as ETRM (Enterprise Transaction and Revenue Management). The view presents a summarized, de-normalized picture of contract line level revenue streams organized by stream type and stream purpose. It consolidates monetary amounts from OKL_STRM_ELEMENTS grouped to the contract, contract line, and stream type level, and exposes descriptive (translated) attributes for activity codes, stream type purposes, and stream purposes drawn from the OKL lookup framework.

Because it joins contract header, contract line, style, item, stream, and stream element data and returns translated descriptions via OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING, the view functions as a reporting and integration layer. Reporting tools, BI Publisher extracts, and interface programs can query OKL_LINE_STREMS_SUM_UV rather than reconstructing the joins across OKC and OKL base tables. The presence of K_LINE_NAME as an exposed column makes the view particularly useful when users search by contract line name (k_line_name), since it surfaces the descriptive contract line name alongside the aggregated stream amounts.

Underlying Base Objects

The view is defined over a set of OKC (Contracts Core) and OKL (Leasing) synonyms and one package, as documented in the ETRM metadata:

The view is a UNION ALL of at least two branches, each aggregating SELB.AMOUNT (OKL_STRM_ELEMENTS) with GROUP BY on contract, contract number, activity code, K_LINE_NAME, stream type name, stream type purpose, purpose code, and lookup meanings. Usages of language-sensitive columns are filtered to USERENV('LANG').

Key Columns

  • CONTRACT_ID / CONTRACT_NUMBER — identifier and number of the OKC contract header.
  • ACTIVITY_CODE (SAY_CODE) and ACTIVITY — coded and translated stream activity.
  • K_LINE_NAME — the contract line (or stream type) descriptive name; the column users commonly search on.
  • NAME — translated stream type name.
  • STREAM_TYPE_PURPOSE_CODE / STREAM_TYPE_PURPOSE — coded and translated stream type purpose.
  • PURPOSE_CODE / PURPOSE — coded and translated stream general purpose.
  • AMOUNT — SUM of stream element amounts for the grouping key.
  • STYB.ID — stream type identifier from the base stream type table.

Common Use Cases and Queries

Typical uses include revenue stream summaries by contract line, fee-line reporting, and reconciliation of stream elements to contract headers. To find rows by k_line_name:

SELECT contract_number, k_line_name, activity, stream_type_purpose, purpose, amount
FROM apps.okl_line_strms_sum_uv
WHERE k_line_name LIKE :line_name_bind
ORDER BY contract_number, k_line_name;

To summarize amounts per contract:

SELECT contract_number, k_line_name, SUM(amount) total_amount
FROM apps.okl_line_strms_sum_uv
GROUP BY contract_number, k_line_name;

Because lookups are resolved at query time through OKL_ACCOUNTING_UTIL, results reflect the session language (USERENV('LANG')), so callers should set NLS appropriately when translated descriptions are required.