Search Results sty_purpose




Overview
Explore in AI Chat

Overview

OKL_STRM_TMPT_ALL_TYPES_UV is an APPS-owned database view within the Oracle E-Business Suite Enterprise Contracts (OKL / Oracle Lease and Finance Management and Oracle Contracts) schema. Its name reflects its function: it consolidates stream template type information from temporary stream generation lines. The suffix conventions — "STRM" for stream, "TMPT" for template, "ALL_TYPES" indicating both primary and dependent stream types, and "UV" denoting a user view — signal that it is intended as a query and reporting layer rather than a base transactional table.

The view answers a common functional question in contract and lease stream processing: which stream types are referenced by the generated temporary stream lines, whether as the primary stream type or as a dependent stream type. Because a single temporary line set can reference many stream types, the view produces a distinct union of both categories in a single result set. The STY_NAME column, which the user searched for, exposes the human-readable stream type name and is the natural join key for reports and diagnostic queries.

In Oracle EBS 12.1.1 and 12.2.2, the view is read-only and serves reporting, diagnostic, and integration purposes. It is not a maintenance surface; stream type definitions are maintained through the underlying stream type setup forms.

Underlying Base Objects

The view is defined as a UNION ALL over two branches, each joining identical source objects with different filter predicates.

The first branch selects lines where PRIMARY_YN = 'Y' and joins on PRIMARY_STY_ID. The second branch selects lines where NVL(PRIMARY_YN,'N') = 'N' and joins on DEPENDENT_STY_ID. Both branches apply SELECT DISTINCT, so the same stream type appears once even when referenced by multiple lines.

Key Columns

  • STY_ID — the stream type identifier, taken from PRIMARY_STY_ID or DEPENDENT_STY_ID depending on the branch.
  • STY_NAME — the stream type name from OKL_STRM_TYPE_V.NAME; the primary search and display column.
  • STY_PURPOSE — the raw lookup code for the stream type purpose.
  • STY_PURPOSE_MEANING — the decoded meaning returned by OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING for the OKL_STREAM_TYPE_PURPOSE lookup type.
  • BILLABLE_YN — indicates whether the stream type is billable.
  • DESCRIPTION — the free-text description of the stream type.

Common Use Cases and Queries

  • Resolving a stream type name (sty_name) to its identifier and purpose during troubleshooting of stream generation.
  • Listing all stream types, primary and dependent, associated with the temporary generation lines of a contract.
  • Reporting on billable versus non-billable stream types referenced in a generation run.
  • Feeding integration or reconciliation extracts that require decoded purpose meanings.

SELECT sty_id, sty_name, sty_purpose_meaning, billable_yn FROM apps.okl_strm_tmpt_all_types_uv WHERE sty_name = :p_sty_name;

SELECT sty_name, sty_purpose_meaning FROM apps.okl_strm_tmpt_all_types_uv WHERE billable_yn = 'Y' ORDER BY sty_name;