Search Results okl_strm_tmpt_types_all_uv




Overview
Explore in AI Chat

Overview

OKL_STRM_TMPT_TYPES_ALL_UV is a read-only 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 Leasing and Finance Management (also marketed as Oracle Financial Services Leasing). As its description states, the view is designed to "display all the stream template all types," meaning it consolidates the distinct stream type identifiers referenced by stream generation template lines, whether those types are attached as primary types or as dependent types.

The view is primarily a reporting and integration artifact. It does not store data; it projects a denormalized, presentation-friendly list of stream types that a given template line set touches. Because Oracle Leasing stream generation depends on templates that drive cash flow generation, users frequently need a flattened list that answers the question, "Which stream types does this template involve, and what is each type's purpose and billable flag?" This view answers that question without requiring a caller to write the UNION logic themselves.

Underlying Base Objects

The view is defined over three documented referenced objects: the synonym OKL_ST_GEN_TMPT_LNS_ALL, the view OKL_STRM_TYPE_V, and the package OKL_ACCOUNTING_UTIL. Functionally, its SELECT statement performs a UNION ALL of two nearly identical query blocks:

  • The first block joins OKL_ST_GEN_TMPT_LNS_ALL (alias GLTV) to OKL_STRM_TYPE_V (alias STY) on GLTV.PRIMARY_STY_ID = STY.ID, restricted to rows where PRIMARY_YN = 'Y'.
  • The second block joins the same two objects on GLTV.DEPENDENT_STY_ID = STY.ID, restricted to rows where NVL(PRIMARY_YN,'N') = 'N'.

The result set is therefore the union of primary and dependent stream type references, deduplicated within each branch by SELECT DISTINCT but not across branches. OKL_ST_GEN_TMPT_LNS_ALL is the template-line synonym corresponding to the underlying stream generation template line table; OKL_STRM_TYPE_V supplies the stream type master attributes. The package OKL_ACCOUNTING_UTIL is referenced only through its GET_LOOKUP_MEANING function, which translates a lookup code into its displayed meaning.

Key Columns

  • STY_ID — The stream type identifier (PRIMARY_STY_ID or DEPENDENT_STY_ID resolved to the stream type master ID).
  • STY_NAME — The stream type name from OKL_STRM_TYPE_V.
  • STY_PURPOSE — The raw stream type purpose code from OKL_STRM_TYPE_V.STREAM_TYPE_PURPOSE.
  • STY_PURPOSE_MEANING — The decoded meaning of the purpose, obtained via OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING against the OKL_STREAM_TYPE_PURPOSE lookup.
  • BILLABLE_YN — Indicates whether the stream type is billable.
  • DESCRIPTION — The descriptive text for the stream type.

Common Use Cases and Queries

This view is used in template configuration reporting, integration extracts into downstream pricing or billing systems, and investigative diagnostics when a stream template produces unexpected stream types. A representative query is:

  • SELECT sty_id, sty_name, sty_purpose, sty_purpose_meaning, billable_yn FROM okl_strm_tmpt_types_all_uv ORDER BY sty_purpose_meaning, sty_name;

Because the view has no template-line ID column, it returns the distinct set of types associated with all template lines in the environment, not per-template detail. To obtain template-level granularity, join back to OKL_ST_GEN_TMPT_LNS_ALL on PRIMARY_STY_ID or DEPENDENT_STY_ID. A common pattern is filtering on a purpose, for example restricting to billable types, and joining to the stream type master for additional attributes not exposed here, such as accounting or term rules. The view remains valid in both 12.1.1 and 12.2.2, though any environment-specific synonyms or custom lookups should be validated before relying on the decoded purpose column.