Results for “sil_type”

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

Overview

OKL_ST_MAP_STREAMS_V is a reporting view owned by the APPS schema in Oracle Lease and Finance Management (OKL), delivered as part of Oracle E-Business Suite 12.1.1 and 12.2.2. It consolidates stream interface data—transaction-level stream headers, stream types, and their associated line and fee records—into a single denormalized result set suitable for inquiry, reconciliation, and downstream integration. The view joins five operational and reference objects from the OKL module: OKL_STRM_TYPE_B, OKL_STRM_TYPE_TL, OKL_SIF_LINES, OKL_SIF_FEES, and OKL_STREAM_INTERFACES, together with the OKL_SIF_STREAM_TYPES association table.

The view is largely used to map interface rows to their originating stream type and pricing context. By exposing the SIF_ID, SFE_ID, and index columns alongside descriptive attributes such as STREAM_TYPE_NAME and PRICING_NAME, it allows implementers to trace how lease stream interface records are distributed across asset lines and fee records without writing ad hoc joins across the six underlying tables.

Underlying Base Objects

The view is defined over synonyms that resolve to the following base tables:

• OKL_STREAM_INTERFACES — the stream interface header table aliased as SIFB, supplying TRANSACTION_NUMBER.
• OKL_SIF_STREAM_TYPES — the association table aliased as SITB, linking SIF_ID to stream type and line/fee records; it supplies SIF_ID, SFE_ID, and PRICING_NAME.
• OKL_STRM_TYPE_TL — the stream type translation table aliased as STYL, providing STREAM_TYPE_NAME filtered to LANGUAGE = 'US'.
• OKL_STRM_TYPE_B — the stream type base table, joined through SITB.STY_ID.
• OKL_SIF_LINES — the SIF line table aliased as SILB, supplying ASSET_INDEX_NUMBER and SIL_TYPE.
• OKL_SIF_FEES — the SIF fee table aliased as SFEB, supplying FEE_INDEX_NUMBER and SFE_TYPE.

The joins use inner joins for the mandatory header, stream type, and SIF_STREAM_TYPES relationships, and outer joins (SIL_ID(+) and SFE_ID(+)) for the line and fee tables. This permits stream interface rows to be returned even when no line or fee record exists, with NULL values in the corresponding columns.

Key Columns

• TRANSACTION_NUMBER — interface transaction identifier from OKL_STREAM_INTERFACES.
• STREAM_TYPE_NAME — the language-specific stream type description.
• SIF_ID — the stream interface identifier, the primary linkage back to the interface header.
• SFE_ID — the stream fee identifier, joining to OKL_SIF_FEES.
• FEE_INDEX_NUMBER — fee index from the SIF fee record; NULL when no fee row exists.
• ASSET_INDEX_NUMBER — asset index from the SIF line record; NULL when no line row exists.
• SFE_TYPE — the fee type code, the column most commonly referenced when users search on "sfe_type".
• SIL_TYPE — the line type code from OKL_SIF_LINES.
• PRICING_NAME — the pricing name associated with the stream type.

Common Use Cases and Queries

Typical uses include verifying that stream interface records have been correctly mapped to a stream type, identifying fee and line configurations for a given transaction, and auditing interface rows where expected fee or asset records are missing. Because the view always filters the translation table to the US language, it is intended for English-language reporting.

To list transaction, stream type, and fee detail:

• SELECT transaction_number, stream_type_name, sfe_type, fee_index_number FROM okl_st_map_streams_v;

To isolate interface rows lacking an asset line:

• SELECT transaction_number, stream_type_name, sil_type FROM okl_st_map_streams_v WHERE asset_index_number IS NULL;

To filter by a specific fee type:

• SELECT transaction_number, sfe_type, fee_index_number FROM okl_st_map_streams_v WHERE sfe_type = :p_sfe_type;

Because the view performs joins across six tables, queries against it are read-only and should be executed with the standard APPS responsibility or a reporting credential that has SELECT privilege on the underlying synonyms.