Results for “std_rate_tmpl_ver_id”

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

Overview

The APPS.OKL_FE_STD_RT_TMP_VERS_V view belongs to the Oracle Lease and Finance Management (OKL) module and is documented in ETRM as the "Standard Rate Template version view." Its purpose is to present standard rate template version data joined with the corresponding header-level attributes of the parent standard rate template in a single, denormalized result set. This combination allows reporting and integration components to retrieve version-specific pricing parameters together with the governing template metadata, without having to join the two base objects manually.

The view is defined in the APPS schema, has VALID status, and contains twenty-six columns. Because it surfaces both version-level and header-level attributes, it is well suited for rate card configuration inquiries, effective-dating analysis, and pricing engine integration lookups. The presence of the header status column aliased as HDR_STS_CODE is directly relevant to searches such as "hdr_sts_code," which target the header-level status of the standard rate template rather than the version-level status.

Underlying Base Objects

The view is defined over two documented base objects:

• OKL_FE_STD_RT_TMP_VERS (documented as a SYNONYM) — supplies the version-level columns, including the primary key STD_RATE_TMPL_VER_ID and the foreign key STD_RATE_TMPL_ID.
• OKL_FE_STD_RT_TMP_V (VIEW) — supplies the header-level columns, including template name, description, pricing engine code, currency, and the header status code.

The two objects are joined on STD_RATE_TMPL_ID, so each row represents one version of a standard rate template enriched with the attributes of its parent template. The join is an inner join, meaning a version row is returned only when a matching header template exists in OKL_FE_STD_RT_TMP_V.

Key Columns

Version-level columns originate from the VER alias and include:

• STD_RATE_TMPL_VER_ID — unique identifier for the rate template version.
• VERSION_NUMBER and OBJECT_VERSION_NUMBER — the logical version sequence and the optimistic locking version, respectively.
• STS_CODE — status of the version record itself.
• EFFECTIVE_FROM_DATE / EFFECTIVE_TO_DATE — the effective date range for the version.
• SRT_RATE, SPREAD, MIN_ADJ_RATE, MAX_ADJ_RATE — the rate, spread, and adjustment rate boundaries.
• DAY_CONVENTION_CODE and ADJ_MAT_VERSION_ID — day-count convention and adjustment matrix version reference.

Header-level columns originate from the HDR alias and include:

• HDR_STS_CODE — the status code of the parent standard rate template; this is the column referenced by the "hdr_sts_code" search term.
• TEMPLATE_NAME / TEMPLATE_DESC — descriptive identifiers for the template.
• CURRENCY_CODE, RATE_CARD_YN, PRICING_ENGINE_CODE, RATE_TYPE_CODE, FREQUENCY_CODE, INDEX_ID — pricing and currency configuration attributes.
• HDR_EFFECTIVE_FROM_DATE / HDR_EFFECTIVE_TO_DATE / HDR_SRT_RATE — header-level effective dates and standard rate.
• ORIG_STD_RATE_TMPL_ID — reference to an originating template, if applicable.

Common Use Cases and Queries

Typical scenarios include validating which versions are active under actively maintained templates, reconciling version-level rates against header defaults, and restricting lookups to templates whose header status meets a business condition. The following query retrieves all versions of templates that are currently active:

• SELECT std_rate_tmpl_ver_id, version_number, template_name, hdr_sts_code, sts_code, effective_from_date, effective_to_date, srt_rate
• FROM apps.okl_fe_std_rt_tmp_vers_v
• WHERE hdr_sts_code = 'ACTIVE'
• ORDER BY template_name, version_number;

A second common pattern filters versions by effective date while displaying the joined header status, assisting rate card maintenance and pricing engine troubleshooting. Because the view already resolves the header join, queries referencing HDR_STS_CODE avoid the overhead and risk of an ad hoc join between the version and header objects.