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
- TAX_JURISDICTION_ID — primary key and unique identifier of the jurisdiction; the join key to the translation table.
- TAX_JURISDICTION_CODE — the user-visible short code for the jurisdiction.
- TAX_JURISDICTION_NAME — the translated descriptive name, sourced from the _TL table.
- TAX_REGIME_CODE — the tax regime to which the jurisdiction belongs.
- REP_TAX_AUTHORITY_ID / COLL_TAX_AUTHORITY_ID — reporting and collecting tax authority identifiers.
- ZONE_GEOGRAPHY_ID — the geography (zone) associated with the jurisdiction.
- EFFECTIVE_FROM / EFFECTIVE_TO — date range during which the jurisdiction definition is valid.
- DEFAULT_JURISDICTION_FLAG, with DEFAULT_FLG_EFFECTIVE_FROM / DEFAULT_FLG_EFFECTIVE_TO — indicates the default jurisdiction and the period for which that default applies.
- INNER_CITY_JURISDICTION_FLAG — flags inner-city (special district) jurisdictions.
- PRECEDENCE_LEVEL — ordering used when multiple jurisdictions apply.
- ALLOW_TAX_REGISTRATIONS_FLAG — controls whether tax registrations may be created for the jurisdiction.
- TAX_ACCT_SRC_JURISDICT_ID / TAX_EXMPT_SRC_JURISDICT_ID — source jurisdictions for tax accounting and exemption purposes.
- ATTRIBUTE1–15, ATTRIBUTE_CATEGORY — descriptive flexfield columns for customer-defined data.
- RECORD_TYPE_CODE, OBJECT_VERSION_NUMBER, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, plus the WHO columns REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, LAST_UPDATE_LOGIN — standard audit and concurrency-control metadata.
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.