Results for “stream_type_purpose”

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

Overview

OKL_STRM_TMPT_SET_TYPE_UV is an APPS-owned view in the Oracle E-Business Suite Lease and Finance Management (OKL) module. Its documented purpose is to hold the stream templates used by the OKL stream generation and accounting template framework. The view presents a denormalized, reporting-friendly projection that links a stream template set to the stream types and accounting template sets associated with it, together with a translated lookup meaning for the stream type purpose.

The object type is VIEW and its status is VALID in both the 12.1.1 and 12.2.2 reference environments. Because it is a view rather than a table, it contains no stored data of its own; every row is derived at query time from the documented base objects. This makes it suitable for read-only reporting, concurrent program data extraction, and integration queries that need a single consistent picture of stream templates without navigating the underlying normalized tables directly.

Underlying Base Objects

The view is defined over six documented referenced objects: the package OKL_ACCOUNTING_UTIL, the synonyms OKL_AE_TMPT_SETS_ALL, OKL_ST_GEN_TEMPLATES_ALL, OKL_ST_GEN_TMPT_LNS_ALL and OKL_ST_GEN_TMPT_SETS, and the view OKL_STRM_TYPE_V. The core template definition is carried by OKL_ST_GEN_TMPT_SETS (the template set header), OKL_ST_GEN_TEMPLATES_ALL (templates within a set), and OKL_ST_GEN_TMPT_LNS_ALL (template lines that reference stream types). The stream type itself is resolved through OKL_STRM_TYPE_V, while accounting template sets are supplied by OKL_AE_TMPT_SETS_ALL.

Joins follow the documented keys: GTT.GTS_ID = GTS.ID, GTL.GTT_ID = GTT.ID, and AES.GTS_ID = GTS.ID. The stream type is joined twice, once on GTL.PRIMARY_STY_ID and once on GTL.DEPENDENT_STY_ID, and the two result sets are combined with UNION. The lookup meaning column is produced by calling OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING against the OKL_STREAM_TYPE_PURPOSE lookup type. Because the same template set can therefore appear in more than one row, consumers should aggregate where a single row per template set is required.

Key Columns

• GTS_ID — Identifier of the stream generation template set; the principal grouping key of the view.
• STY_ID — Identifier of the stream type, whether reached as the primary or the dependent stream type on the template line.
• AES_ID — Identifier of the accounting template set linked to the template set. This is the column typically sought when users search for "aes_id," since it is the join point to accounting rule generation.
• STY_NAME — Descriptive name of the stream type.
• STREAM_TYPE_PURPOSE — Code indicating the purpose of the stream type.
• STREAM_TYPE_PURPOSE_MEAN — Translated lookup meaning for the purpose code, resolved via OKL_ACCOUNTING_UTIL.

Common Use Cases and Queries

A frequent requirement is to retrieve the accounting template set for a given stream template set, or to list all stream types associated with an accounting template.

SELECT gts_id, sty_id, aes_id, sty_name,
       stream_type_purpose, stream_type_purpose_mean
  FROM apps.okl_strm_tmpt_set_type_uv
 WHERE gts_id = :p_gts_id;

To find the accounting template set tied to a particular stream type, filter on STY_NAME. To produce one row per template set, aggregate:

SELECT gts_id, aes_id,
       MAX(sty_name) sty_name
  FROM apps.okl_strm_tmpt_set_type_uv
 GROUP BY gts_id, aes_id;

These queries support reconciliation between stream templates and accounting templates, troubleshooting of generation failures, and extraction of template metadata for reporting or migration analysis. All access is read-only and governed by the APPS schema grants.