Search Results okl_strmtyp_source_v




Overview
Explore in AI Chat

Overview

OKL_STRMTYP_SOURCE_V is a database view owned by the APPS schema in Oracle E-Business Suite Release 12.1.1 and 12.2.2. It belongs to the OKL product family — Oracle Lease and Finance Management — and is documented in the ETRM as the source view for the JTF object OKL_STRMTYP, whose business subject is stream types. In practical terms, the view supplies a JTF-ready projection of the stream type definition so that Oracle's object-layer and integration infrastructure (for example, JTF object registration used by CRM-style lookups, list-of-values providers, and external integrations) can consume stream type metadata in a consistent, denormalized shape.

The view joins the stream type base table to its translation table so that the descriptive attributes — name and description — are returned in the session language. Status is computed at query time from the effective start and end dates, so consumers do not have to perform date logic themselves.

Underlying Base Objects

The documented base objects referenced by the view are two synonyms: OKL_STRM_TYPE_B and OKL_STRM_TYPE_TL. OKL_STRM_TYPE_B is the base (non-translated) stream type table and holds the operational attributes: version, code, scope, start and end dates, billable/taxable/fundable flags, periodic and class indicators, capitalization and accrual flags, and stream type purpose. OKL_STRM_TYPE_TL is the translated table, providing NAME and DESCRIPTION per language.

The join is on ID between the two tables, with the translation row restricted by STYT.LANGUAGE = USERENV('LANG'). This is the standard EBS multilingual pattern; a stream type row appears once per language in the _TL table, and the view returns a single row in the caller's language.

Key Columns

Common Use Cases and Queries

Typical uses include LOV and list-box population, integration extracts for downstream systems, and ad hoc reporting on which stream types are currently active. A basic listing of active stream types:

SELECT id1, code, name, stream_type_class, status
FROM okl_strmtyp_source_v
WHERE status = 'A'
ORDER BY name;

For a JTF-aware lookup by code:

SELECT id1, code, name, description
FROM okl_strmtyp_source_v
WHERE code = 'LEASE' AND status = 'A';

To profile stream types by class and purpose, aggregate on the corresponding columns. Note that STATUS is computed from SYSDATE at runtime, so results shift automatically as effective dates pass.