Results for “taxes_tl”

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

Overview

APPS.ZX_JRNL_LINE_DESC_V is a reporting view in the Oracle E-Business Suite ETRM (E-Business Tax / Tax Reporting) module that exposes a denormalized, human-readable description of individual tax lines. Its principal purpose is to resolve the internal identifiers stored on ZX_LINES into the meaningful, translatable names held in the ETRM setup tables: the tax regime name, the tax full name, the tax status name and the tax rate name. The view therefore allows journal-entry and tax-line reporting to display readable tax attributes without requiring the report or integration to re-join four separate setup tables.

The view is defined over ZX_LINES and four translated (TL) setup tables. It is owned by APPS and is exposed as a synonym for use by application reporting, concurrent programs and interfaces. Notably, it is a language-specific view: each row is returned for a single language only, since the join predicates force the LANGUAGE column of ZX_REGIMES_TL, ZX_TAXES_TL, ZX_STATUS_TL and ZX_RATES_TL to agree with one another.

Underlying Base Objects

Per the documented ETRM 12.2.2 metadata, the view is defined over the following referenced base objects, all accessed through APPS synonyms:

• ZX_LINES — the core ETRM tax line table, aliased TAX_LINE. It supplies TAX_LINE_ID, TAX_JURISDICTION_CODE and the foreign keys TAX_RATE_ID, TAX_ID, TAX_STATUS_ID and TAX_REGIME_ID.
• ZX_RATES_TL — the tax rate setup table (translated), aliased RATES_TL; source of TAX_RATE_NAME and the LANGUAGE discriminator.
• ZX_REGIMES_TL — the tax regime setup table (translated), aliased REGIMES_TL; source of TAX_REGIME_NAME.
• ZX_STATUS_TL — the tax status setup table (translated), aliased STATUS_TL; source of TAX_STATUS_NAME.
• ZX_TAXES_TL — the tax setup table (translated), aliased TAXES_TL; source of TAX_FULL_NAME.

Because every setup table is joined through its translated entity, the view depends on the language rows present in each _TL table. The join predicates also enforce that all four _TL tables carry the same LANGUAGE value as the regime, preventing mixed-language output within a single row.

Key Columns

The view projects the following columns:

• TAX_LINE_ID — the primary identifier of the tax line from ZX_LINES; the join key back to transactional tax details.
• TAX_REGIME_NAME — the printable name of the tax regime (from ZX_REGIMES_TL).
• TAX_FULL_NAME — the fully qualified tax name (from ZX_TAXES_TL).
• TAX_STATUS_NAME — the printable tax status (from ZX_STATUS_TL), such as Active or Inactive.
• TAX_RATE_NAME — the printable name of the rate definition including the rates_tl reference associated with the tax line (from ZX_RATES_TL).
• TAX_JURISDICTION_CODE — the jurisdiction code carried on the tax line.
• LANGUAGE — the language code returned by ZX_RATES_TL, indicating the language of the returned descriptions.

Common Use Cases and Queries

The view is typically used in tax-line reporting, journal-line enrichment and reconciliation extracts where readable tax attributes are required alongside the tax line identifier. A representative query joining the view to its transactional context is shown below.

• Listing all tax lines with their regime, tax, status and rate names.
• Driving tax reporting by joining TAX_LINE_ID to ZX_LINES or to journal-entry sources.

SELECT tax_line_id,
       tax_regime_name,
       tax_full_name,
       tax_status_name,
       tax_rate_name,
       tax_jurisdiction_code,
       language
FROM   apps.zx_jrnl_line_desc_v
WHERE  language = USERENV('LANG')
ORDER  BY tax_line_id;

Because the view is language-restricted, callers should filter on LANGUAGE where a specific reporting language is required, as illustrated above.