Results for “okl_cntrct_strms_sum_uv”

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

Overview

The OKL_CNTRCT_STRMS_SUM_UV view is a reporting construct within the Oracle E-Business Suite (EBS) Lease and Finance Management (OKL) module. Its documented description, Contract Streams Sum, reflects its purpose: to aggregate the financial elements of contract streams into a denormalized, human-readable summary suitable for inquiry screens, concurrent reports, and integration extracts.

The view joins contract header information from the contracts core table with stream definitions and stream element amounts, then resolves several coded identifiers into their descriptive meanings through the OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING package function. This makes the view self-describing: consumers receive both the raw code and its display value without additional lookup joins. In the context of the user's search for activity_code, this view exposes that value directly via the ACTIVITY_CODE column, which is derived from the STMB.SAY_CODE column of the OKL_STREAMS table.

Underlying Base Objects

The view is owned by the APPS schema and is defined over the following documented base objects, all referenced as synonyms in the ETRM 12.2.2 metadata:

• OKC_K_HEADERS_B — the contracts header table, providing CONTRACT_NUMBER and the contract identifier (KHR_ID).
• OKL_STREAMS — stores the stream header records, supplying SAY_CODE (activity), PURPOSE_CODE, and the stream type and contract relationships.
• OKL_STRM_ELEMENTS — the stream element (line) table whose AMOUNT values are summed to produce the aggregated AMOUNT.
• OKL_STRM_TYPE_B and OKL_STRM_TYPE_TL — the base and translated stream type tables, providing the stream type purpose code and the translated stream type name.
• OKL_ACCOUNTING_UTIL — a PL/SQL package whose GET_LOOKUP_MEANING function translates codes from lookups such as OKL_STREAM_ACTIVITY, OKL_STREAM_TYPE_PURPOSE, and OKL_STRM_G_PURPOSE.

A defining filter of the view is STMB.KLE_ID IS NULL, which restricts results to stream records that are not associated with a lease-level element context, and the join STYT.LANGUAGE = USERENV('LANG'), which enforces the session's language for translated stream type names.

Key Columns

• KHR_ID — identifier of the contract header from OKC_K_HEADERS_B.
• CONTRACT_NUMBER — the user-facing contract number.
• ACTIVITY_CODE — the stream activity code sourced from OKL_STREAMS.SAY_CODE; this is the column matched by the search for "activity_code".
• ACTIVITY — the lookup meaning for the activity, resolved from the OKL_STREAM_ACTIVITY lookup type.
• NAME — the translated stream type name.
• STREAM_TYPE_PURPOSE_CODE / STREAM_TYPE_PURPOSE — the stream type purpose code and its resolved meaning from OKL_STREAM_TYPE_PURPOSE.
• PURPOSE_CODE / PURPOSE — the purpose code and its resolved meaning from OKL_STRM_G_PURPOSE.
• AMOUNT — the sum of stream element amounts (SUM(SELB.AMOUNT)) for the grouped combination.
• ID — the stream type identifier from OKL_STRM_TYPE_B.

Common Use Cases and Queries

Typical uses include ad-hoc reporting on contract stream activity, driving lease accounting inquiries, and feeding downstream extracts that require summarized stream amounts by activity and purpose. Because results are grouped by contract, activity, stream type, and purpose, the view is well suited to pivot-style reporting and totals reconciliation.

To retrieve all activity codes and their meanings for a given contract:

• SELECT contract_number, activity_code, activity, name, amount FROM okl_cntrct_strms_sum_uv WHERE contract_number = :p_contract_number;

To filter specifically on a known activity code while aggregating by purpose:

• SELECT contract_number, activity_code, purpose, SUM(amount) total_amount FROM okl_cntrct_strms_sum_uv WHERE activity_code = :p_activity_code GROUP BY contract_number, activity_code, purpose;

To list all streams for a contract irrespective of stream type purpose:

• SELECT activity_code, activity, stream_type_purpose, purpose, amount FROM okl_cntrct_strms_sum_uv WHERE khr_id = :p_khr_id ORDER BY activity_code, purpose;

Queries should account for the language binding of STYT.LANGUAGE = USERENV('LANG'), ensuring the session language is set appropriately when translated stream type names are required.