Results for “precedence_level”

2 results




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

Overview

ZX_JURISDICTIONS_VL is a translated (MLS) view owned by the APPS schema and registered under the FND – Application Object Library product in Oracle E-Business Suite 12.1.1 and 12.2.2. It is part of the Oracle E-Business Tax (EBTax/ETRM) data model and presents tax jurisdiction definitions in the language of the current session. The view joins the base jurisdiction table to its translation table and exposes a single, language-filtered row per jurisdiction, combining descriptive attributes with the translated jurisdiction name. In practice it functions as the reporting and integration layer for jurisdiction data: concurrent programs, BI Publisher reports, OAF pages, and external interfaces query it instead of joining the underlying _B and _TL tables directly, thereby avoiding the need to replicate the MLS join condition in every consumer.

Underlying Base Objects

Per the documented view text, ZX_JURISDICTIONS_VL is defined over two synonyms that resolve to the ETRM base tables:

  • ZX_JURISDICTIONS_B — the base (non-translated) table holding the jurisdiction definition and all transactional/system columns. The view aliases it as B and returns nearly all of its columns.
  • ZX_JURISDICTIONS_TL — the translation table holding the language-dependent jurisdiction name. The view aliases it as T and returns TAX_JURISDICTION_NAME.

The two are joined on TAX_JURISDICTION_ID, with the translation side restricted by T.LANGUAGE = USERENV('LANG'). This is the standard MLS pattern: the row identifier (ROW_ID) is drawn from the base table (B.ROWID), and only the language-matching translation row is returned, so the view is effectively filtered by the session's language environment.

Key Columns

Common Use Cases and Queries

The view is typically used to drive jurisdiction list-of-values, tax setup validation, and reporting where the jurisdiction name must appear in the user's session language. A representative query retrieving active jurisdictions for a regime is:

  • SELECT tax_jurisdiction_id, tax_jurisdiction_code, tax_jurisdiction_name, tax_regime_code, effective_from, effective_to FROM zx_jurisdictions_vl WHERE tax_regime_code = :p_regime AND SYSDATE BETWEEN effective_from AND effective_to ORDER BY tax_jurisdiction_code;
  • SELECT tax_jurisdiction_id, tax_jurisdiction_name FROM zx_jurisdictions_vl WHERE default_jurisdiction_flag = 'Y' AND tax_regime_code = :p_regime;
  • SELECT j.tax_jurisdiction_name, j.tax_jurisdiction_code FROM zx_jurisdictions_vl j WHERE j.tax_jurisdiction_id = :p_jurisdiction_id;

Because the name is filtered by USERENV('LANG'), results vary with the session language; applications that must report in a fixed language should set the session language explicitly before querying the view.