Results for “default_flg_effective_from”

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

Overview

ZX_RATES_VL is a seeded, read-only view owned by the APPS schema in Oracle E-Business Suite, registered under the FND – Application Object Library product group. The "_VL" suffix denotes a "value-language" or translation view. It is a consumer-facing object that joins the base transaction table for tax rates with its translation table, thereby presenting tax rate definition data enriched with language-specific descriptive attributes. Within ETRM (E-Business Tax), the view provides a denormalized, presentation-ready representation of tax rate records and is intended to be used by reports, concurrent programs, and integration extracts rather than by direct data manipulation. Because it carries no DML capability, it is safe for reporting and querying in both Release 12.1.1 and 12.2.2, where the underlying column set and join semantics are consistent.

Underlying Base Objects

The view is defined over two base objects, each exposed through a synonym in the APPS schema: ZX_RATES_B and ZX_RATES_TL. ZX_RATES_B is the multitenant, language-independent base table holding the actual tax rate records, while ZX_RATES_TL is the translation table supplying descriptive attributes keyed by language. The view joins them on TAX_RATE_ID and restricts the translation row to the session's language. The catalog defines the columns from ZX_RATES_B as alias B (with B.ROWID surfaced as ROW_ID) and only two columns from the translation table: DESCRIPTION and TAX_RATE_NAME (aliases T). The dependency on USERENV('LANG') means language-specific names and descriptions reflect the environment of the querying session, which is a defining characteristic of value-language views.

Key Columns

The view exposes the full operational attribute set of a tax rate. Identification and validity columns include TAX_RATE_ID, TAX_RATE_CODE, TAX_RATE_NAME, EFFECTIVE_FROM, EFFECTIVE_TO, ACTIVE_FLAG, RECORD_TYPE_CODE, and OBJECT_VERSION_NUMBER. Tax classification is captured through TAX_REGIME_CODE, TAX, TAX_STATUS_CODE, TAX_JURISDICTION_CODE, TAX_CLASS, and SOURCE_ID. Rate behavior is described by RATE_TYPE_CODE, PERCENTAGE_RATE, QUANTITY_RATE, UOM_CODE, SCHEDULE_BASED_RATE_FLAG, INCLUSIVE_TAX_FLAG, TAX_INCLUSIVE_OVERRIDE_FLAG, and TAXABLE_BASIS_FORMULA_CODE. Recovery and offset semantics are represented by RECOVERY_TYPE_CODE, RECOVERY_RULE_CODE, DEF_REC_SETTLEMENT_OPTION_CODE, OFFSET_TAX, OFFSET_STATUS_CODE, and OFFSET_TAX_RATE_CODE. Default and exception handling appear via DEFAULT_RATE_FLAG, DEFAULT_REC_TYPE_CODE, ALLOW_EXEMPTIONS_FLAG, ALLOW_EXCEPTIONS_FLAG, and ALLOW_ADHOC_TAX_RATE_FLAG. Standard audit columns and fifteen descriptive flexfield attributes (ATTRIBUTE1–15, ATTRIBUTE_CATEGORY) are also included. DESCRIPTION and TAX_RATE_NAME supply the multilingual text.

Common Use Cases and Queries

Typical scenarios include validating configuration of tax rates, extracting rates for interface or reconciliation processes, and building multilingual reports. A basic query lists active percentage rates for a regime:

• SELECT tax_rate_code, tax_rate_name, percentage_rate, effective_from, effective_to FROM zx_rates_vl WHERE tax_regime_code = 'US_SALES' AND active_flag = 'Y' AND rate_type_code = 'PERCENTAGE';
• SELECT tax_rate_code, description FROM zx_rates_vl WHERE tax_regime_code = 'VAT' AND SYSDATE BETWEEN effective_from AND NVL(effective_to, SYSDATE + 1);

Because the view enforces the session language via USERENV('LANG'), names and descriptions are automatically localized. Joins to ZX_RATES_B or ZX_RATES_TL directly should be avoided where this view suffices, as it encapsulates the join and ensures consistent translation handling. All access is read-only; maintenance must occur through the E-Business Tax setup UI or the underlying base tables' supported APIs.