Results for “tmpt_status”

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

Overview

OKL_STRM_TMPT_FULL_UV is a consolidated reporting view owned by the APPS schema in Oracle E-Business Suite, defined within the OKL – Leasing and Finance Management product family. The view fetches all stream types and purposes associated with a product, flattening the relationship between stream generation template lines, template versions, template sets, accounting engine template sets, products, and stream type definitions into a single denormalized result set. In the context of Oracle EBS 12.1.1 and 12.2.2, this view serves as a reference and integration surface for pricing-related configuration, exposing the PRICING_ENGINE and PRICING_NAME attributes alongside stream generation template metadata.

Because the view materializes the linkage between a product and the stream type purposes that drive pricing, billing, and capitalization behavior, it is frequently relevant to users searching for "pricing_engine." Rather than joining across the OKL stream generation and accounting engine tables manually, developers and analysts can query this single view to retrieve the pricing engine designation for each active stream generation template set tied to a product.

Underlying Base Objects

The view is defined over the following documented base objects:

• OKL_ST_GEN_TMPT_LNS_ALL – stream generation template lines (aliased GTLV), supplying the primary and dependent stream type identifiers, pricing name, and primary indicator.
• OKL_ST_GEN_TEMPLATES_ALL – template versions (GTTV), supplying version, start/end dates, and template status.
• OKL_ST_GEN_TMPT_SETS_ALL – template sets (GTSV), supplying the set name, product type, tax owner, deal type, and the PRICING_ENGINE attribute.
• OKL_AE_TMPT_SETS_ALL – accounting engine template sets (AES), linking template sets to products.
• OKL_PRODUCTS_V – product view (PDT), supplying the product name and AES association.
• OKL_STRM_TYPE_B – stream type base table (STY), supplying stream type purpose, billable and capitalize flags.
• OKL_STRM_TYPE_TL – stream type translation table (STYT), supplying language-specific names.
• OKL_ACCOUNTING_UTIL – PL/SQL package used to resolve lookup meanings via GET_LOOKUP_MEANING.

The view text is a UNION ALL of a primary-branch query (PRIMARY_YN = 'Y') and a dependent-branch query, retaining only templates with TMPT_STATUS = 'ACTIVE' and filtering translated names to the session language. A literal NULL column is projected as PRIMARY_STY_ID to align the two branches.

Key Columns

• ID / STY_ID – Identifier of the template line and the associated stream type.
• STY_NAME / STY_PURPOSE / STY_PURPOSE_MEANING – Stream type name, its coded purpose, and the decoded lookup meaning via OKL_ACCOUNTING_UTIL.
• PRICING_NAME – Pricing name carried on the template line.
• PRICING_ENGINE – The pricing engine designation from the template set, central to pricing configuration.
• BILLABLE_YN / CAPITALIZE_YN – Flags indicating billable and capitalization treatment.
• GTT_ID / VERSION / START_DATE / END_DATE / TMPT_STATUS – Template version identity, validity window, and status.
• GTS_ID / ST_GEN_TMPT_SET_NAME / PRODUCT_TYPE / TAX_OWNER / DEAL_TYPE – Template set context.
• AES_ID / AE_TMPT_SET_NAME / PDT_ID / PRODUCT_NAME – Accounting engine set and product linkage.

Common Use Cases and Queries

Typical scenarios include verifying which pricing engine applies to a product's active stream generation templates, auditing stream type purposes by product, and driving pricing configuration extracts or integrations. A representative query follows:

• SELECT PRODUCT_NAME, PRICING_ENGINE, PRICING_NAME, STY_NAME, STY_PURPOSE_MEANING FROM OKL_STRM_TMPT_FULL_UV WHERE PRODUCT_NAME = :p_product;
• SELECT DISTINCT PRODUCT_NAME, PRICING_ENGINE FROM OKL_STRM_TMPT_FULL_UV WHERE TMPT_STATUS = 'ACTIVE';
• SELECT ST_GEN_TMPT_SET_NAME, PRICING_ENGINE, COUNT(*) FROM OKL_STRM_TMPT_FULL_UV GROUP BY ST_GEN_TMPT_SET_NAME, PRICING_ENGINE;

These queries support pricing validation, configuration reporting, and reconciliation between product setup and stream generation template definitions in both 12.1.1 and 12.2.2 environments.