Results for “ae_tmpt_set_name”

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

Overview

OKL_STRM_TMPT_CONTRACTS_UV is an Oracle E-Business Suite view owned by the APPS schema within the OKL (Lease and Finance Management) product family. Its documented purpose is to display all the stream types associated with a miscellaneous transaction, joining stream generation template definitions to the contracts that qualify under those templates. The view resolves a many-to-many relationship across stream generation lines, stream generation templates, template sets, accounting entry template sets, products, stream types, and contract headers.

In practice, this view answers the question: for a given contract, which stream types were generated by which stream generation template set, under which accounting entry template set and product? It is a reporting and diagnostic object rather than a transactional one, and it is typically queried during period-end reconciliation, template-impact analysis, and troubleshooting of stream generation setup. Because it already joins the contract header to its product and template lineage, it relieves report authors from reconstructing those chains manually.

Underlying Base Objects

The view is defined over the following documented base objects, all resolved through APPS synonyms except where noted:

• OKL_ST_GEN_TMPT_LNS_ALL — stream generation template lines; supplies the primary and dependent stream type identifiers.
• OKL_ST_GEN_TEMPLATES_ALL — stream generation templates; filters on TMPT_STATUS = 'ACTIVE'.
• OKL_ST_GEN_TMPT_SETS_ALL — stream generation template sets; the source of the ST_GEN_TMPT_SET_NAME column.
• OKL_AE_TMPT_SETS_ALL — accounting entry template sets linked to the generation set.
• OKL_PRODUCTS_V — a view supplying product identifiers and names.
• OKL_STRM_TYPE_V — a view supplying stream type name and purpose.
• OKL_K_HEADERS and OKC_K_HEADERS_ALL_B — contract header tables providing contract number and start date.
• OKL_ACCOUNTING_UTIL — a package whose GET_LOOKUP_MEANING function translates the stream type purpose code into a display meaning.

The view text unions two branches. The first selects lines where GTL.PRIMARY_YN = 'Y' and joins PRIMARY_STY_ID to the stream type. The second selects lines where NVL(GTL.PRIMARY_YN, 'N') = 'N' and joins DEPENDENT_STY_ID. Both branches apply the same downstream joins and a date-range predicate comparing the contract start date against the template start and end dates.

Key Columns

• STY_ID / STY_NAME — stream type identifier and name.
• STY_PURPOSE / STY_PURPOSE_MEANING — the raw code and its decoded meaning from OKL_STREAM_TYPE_PURPOSE.
• ST_GEN_TMPT_SET_NAME — the stream generation template set name (GTS.NAME). This is the column most commonly searched for, since it identifies the template set that produced the stream type.
• GTS_ID — the template set identifier.
• AES_ID / AE_TMPT_SET_NAME — the accounting entry template set linking to the generation set.
• PDT_ID / PRODUCT_NAME — the product tied to the template set.
• KHR_ID / CONTRACT_NUMBER — the lease contract header identifier and contract number.

Common Use Cases and Queries

A frequent requirement is to list every contract using a specific stream generation template set, for example when a template set is being retired or modified. Because the searched term is the template set name, the following query is typical:

• 1. SELECT st_gen_tmpt_set_name, contract_number, sty_name, product_name FROM okl_strm_tmpt_contracts_uv WHERE st_gen_tmpt_set_name = 'MY_GTS_NAME';
• 2. SELECT contract_number, sty_name, sty_purpose_meaning FROM okl_strm_tmpt_contracts_uv WHERE contract_number = '123456';
• 3. SELECT st_gen_tmpt_set_name, ae_tmpt_set_name, product_name, COUNT(*) FROM okl_strm_tmpt_contracts_uv GROUP BY st_gen_tmpt_set_name, ae_tmpt_set_name, product_name;

Reports typically join this view back to OKL_K_HEADERS or OKC_K_HEADERS_ALL_B when additional contract attributes are required, and filter on STY_PURPOSE to isolate primary versus dependent streams in analysis.