Results for “residual_guarantee_type”

26 results




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

Overview

OKL_ST_MAP_ASSETS_V is an Oracle E-Business Suite (EBS) reporting view owned by the APPS schema within the OKL – Leasing and Finance Management product. It is a denormalized projection that joins two interface-layer objects, OKL_SIF_LINES and OKL_STREAM_INTERFACES, to present asset-level and stream-level lease attributes for a single transaction stream type. The view returns rows only where the underlying SIF line carries a stream interface type (SIL_TYPE) of 'SGA', meaning it is scoped to asset-related stream records rather than the full population of interface lines. Because it sits on the interface side of the OKL architecture, the view is primarily used during lease authoring, contract import, and asset mapping activities — that is, before or while lease streams are being staged and mapped into operational leasing tables. It exposes a wide and deliberately flattened column list covering residual values, depreciation parameters, purchase-option data, funding and delivery dates, and fifteen generic STREAM_INTERFACE_ATTRIBUTE columns, all of which support downstream data-mapping and validation reporting. The view is delivered as VALID and, in ETRM 12.2.2 metadata, resolves its base objects through APPS synonyms.

Underlying Base Objects

The view is defined over two documented base objects, both referenced as APPS synonyms:

  • OKL_SIF_LINES — the stream interface lines table. It supplies the transaction identifier, SIF identifier, KLE_ID, index number, descriptive text, the asset and residual columns, the depreciation columns, and the STREAM_INTERFACE_ATTRIBUTE01 through STREAM_INTERFACE_ATTRIBUTE15 flex-style columns.
  • OKL_STREAM_INTERFACES — the stream interface header table. It is joined on OKL_SIF_LINES.SIF_ID = OKL_STREAM_INTERFACES.ID, and the join predicate is qualified by the filter SIL_TYPE = 'SGA' to restrict the result set to the relevant stream interface type.

The join is an inner equi-join, so only SIF lines that resolve to a matching stream interface record and satisfy the SGA filter are surfaced. Results are ordered by OKL_SIF_LINES.INDEX_NUMBER, which preserves the natural line ordering expected during asset mapping. No aggregation or grouping is applied; the view is a straight projection.

Key Columns

Common Use Cases and Queries

Typical use is to inspect or reconcile staged asset and residual data for SGA-type streams before lease booking. Analysts commonly query by transaction or KLE to review residual amounts, depreciation setup, and purchase options in a single pass.

Sample SQL to isolate residual exposure for a given transaction:

  • SELECT TRANSACTION_NUMBER, INDEX_NUMBER, DESCRIPTION, ASSET_COST, RESIDUAL_AMOUNT, RESIDUAL_GUARANTEE_AMOUNT, RESIDUAL_DATE FROM APPS.OKL_ST_MAP_ASSETS_V WHERE TRANSACTION_NUMBER = :p_transaction_number ORDER BY INDEX_NUMBER;
  • SELECT SIF_ID, KLE_ID, SUM(RESIDUAL_AMOUNT) FROM APPS.OKL_ST_MAP_ASSETS_V GROUP BY SIF_ID, KLE_ID;
  • SELECT TRANSACTION_NUMBER, INDEX_NUMBER, BOOK_METHOD, BOOK_TERM, BOOK_SALVAGE, RESIDUAL_AMOUNT FROM APPS.OKL_ST_MAP_ASSETS_V WHERE RESIDUAL_AMOUNT > 0;

Because the view depends on interface and mapping stages, its row population is transient: records appear while SIF lines are staged and may be cleared after processing into operational leasing tables. Queries should therefore be run against the appropriate interface state and are best treated as mapping and verification instruments rather than as a source for steady-state financial reporting.