Search Results billable_yn




Overview
Explore in AI Chat

Overview

APPS.OKL_STRM_TMPT_TYPES_ALL_UV is a union-based Oracle EBS view in the Enterprise Contract and Lease Management (formerly Oracle Lease Management / OKL) module, exposed under the APPS schema. It presents the set of stream types associated with stream generation template lines, resolving both primary and dependent stream type identifiers into descriptive stream type attributes. In practice, the view answers the question: "For a given stream generation template line, which stream types participate, and what are their descriptive characteristics?"

Its role is primarily reporting and downstream processing. Because stream generation templates define the recurring billing and accounting streams that ETRM produces for a contract, consumers frequently need a flattened, de-duplicated list of the stream types referenced by those templates. The view provides this by combining two symmetric branches — one for primary stream types and one for dependent stream types — into a single result set. This makes it suitable for BI Publisher reports, ad hoc SQL, and integration extracts that require stream type metadata without navigating the underlying template-line structure directly.

Underlying Base Objects

The view is defined over three documented base objects:

The UNION ALL structure is key. The first branch joins GLTV.PRIMARY_STY_ID to STY.ID and filters GLTV.PRIMARY_YN = 'Y'. The second branch joins GLTV.DEPENDENT_STY_ID to STY.ID and filters NVL(GLTV.PRIMARY_YN,'N') = 'N'. Each branch applies SELECT DISTINCT, and the two branches are combined via UNION ALL, so the same stream type may appear in multiple rows where it is referenced by more than one template line combination.

Key Columns

  • STY_ID — the stream type identifier (from PRIMARY_STY_ID or DEPENDENT_STY_ID).
  • STY_NAME — the stream type name from OKL_STRM_TYPE_V.NAME.
  • STY_PURPOSE — the raw stream type purpose code.
  • STY_PURPOSE_MEANING — the decoded purpose, resolved via OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING against the OKL_STREAM_TYPE_PURPOSE lookup.
  • BILLABLE_YN — from OKL_STRM_TYPE_V.BILLABLE_YN; indicates whether the stream type is billable. Given the user's search term, this is the column of primary interest.
  • DESCRIPTION — free-text description of the stream type.

Common Use Cases and Queries

Typical scenarios include identifying billable stream types referenced by templates, reviewing purpose composition across template lines, and feeding stream type reference data into accounting or billing extracts.

To list billable stream types referenced across templates:

  • SELECT DISTINCT sty_id, sty_name, sty_purpose_meaning, billable_yn FROM apps.okl_strm_tmpt_types_all_uv WHERE billable_yn = 'Y' ORDER BY sty_name;

To summarize purpose distribution:

  • SELECT sty_purpose_meaning, billable_yn, COUNT(*) FROM apps.okl_strm_tmpt_types_all_uv GROUP BY sty_purpose_meaning, billable_yn;

Because the view performs UPPER/LOWER-sensitive UNION ALL with DISTINCT and calls a PL/SQL lookup function per row, filtering predicates (especially on BILLABLE_YN) should be applied in the query to limit function invocation and improve performance.