Results for “okl_asset_streams_uv”

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

Overview

The view OKL_ASSET_STREAMS_UV is a reporting and integration construct owned by the APPS schema within the Oracle Lease and Finance Management (OKL) module. It exposes asset-level stream data — the scheduled financial elements (payments, residuals, interest, and similar) generated against leased assets — joined to their originating contract header and contract line. The view serves as a denormalized, presentation-oriented layer that resolves raw code values into their user-facing lookup meanings, making it suitable for operational reporting, accounting reconciliation, and downstream integrations that require human-readable stream detail.

Its principal role is to flatten the relationship between a contract, its lease line, the free-form asset on that line, the stream type definitions, and the individual stream element schedule rows into a single queryable result set. This is particularly valuable because stream data in the base tables is distributed across several normalized structures and keyed by internal identifiers that are not meaningful without lookup translation.

Underlying Base Objects

The view is defined over the following documented objects: OKC_K_HEADERS_B, OKC_K_LINES_B, OKC_K_LINES_TL, OKC_LINE_STYLES_B, OKL_STREAMS, OKL_STRM_ELEMENTS, OKL_STRM_TYPE_B, OKL_STRM_TYPE_TL, and the package OKL_ACCOUNTING_UTIL.

• OKC_K_HEADERS_B / OKC_K_LINES_B / OKC_K_LINES_TL — contract header, line, and translated line name tables providing contract number, line identifier, and the asset number.
• OKC_LINE_STYLES_B — joined on LTY_CODE = 'FREE_FORM1', restricting output to free-form asset-type lines.
• OKL_STRM_TYPE_B / OKL_STRM_TYPE_TL — stream type definition and its translated short description.
• OKL_STREAMS — the parent stream record, supplying transaction number, activity code, and purpose code.
• OKL_STRM_ELEMENTS — the individual scheduled stream element rows supplying date and amount.
• OKL_ACCOUNTING_UTIL — its GET_LOOKUP_MEANING function resolves coded values (stream type purpose, stream activity, general purpose) into descriptive meanings.

Key Columns

• CONTRACT_ID / CONTRACT_NUMBER — identifier and display number of the parent contract header.
• LINE_ID / ASSET_NUMBER — the contract line identifier and the free-form asset name.
• STREAM_TYPE_PURPOSE_CODE / STREAM_TYPE_PURPOSE — the raw stream type purpose code and its decoded meaning.
• ACTIVITY_CODE / ACTIVITY — the stream activity say-code and its lookup meaning.
• PURPOSE_CODE / PURPOSE — the general stream purpose code (OKL_STRM_G_PURPOSE) and its decoded meaning. This is the column most directly associated with the search term purpose_code.
• STREAM_ELEMENT_DATE / AMOUNT — the scheduled date and monetary amount for each stream element.
• TRANSACTION_NUMBER / NAME / SHORT_DESCRIPTION / ID — supporting identifiers and descriptive attributes.

Common Use Cases and Queries

Typical applications include asset-level payment schedule reporting, purpose-based stream analysis, and feeding downstream accounting or integration processes with decoded stream data.

To list all streams for a given contract with decoded purposes:

SELECT contract_number, asset_number, stream_element_date,
       amount, purpose_code, purpose
FROM   okl_asset_streams_uv
WHERE  contract_number = :p_contract_number
ORDER BY stream_element_date;

To aggregate amounts by decoded purpose for reconciliation:

SELECT purpose_code, purpose, SUM(amount) total_amount
FROM   okl_asset_streams_uv
WHERE  stream_element_date BETWEEN :p_from AND :p_to
GROUP BY purpose_code, purpose;

Because the view applies USERENV('LANG') to the translated tables, results reflect the session language, which should be considered when scheduling concurrent reports.