Search Results account_segment_value

Overview

ZX_ACCOUNT_RATES_V is a reporting view owned by the APPS schema in Oracle E-Business Suite, registered under the FND — Application Object Library product group. It is part of the Oracle E-Business Tax (EBTax/ETRM) data model and exposes configuration data stored in the ZX_ACCOUNT_RATES entity, which defines tax rates and tax rules at the account level rather than at the party or jurisdiction level. The view joins the account rate definition to its owning ledger and to the first-party organization that owns the corresponding tax content, producing a denormalized, human-readable result set suitable for reporting, reconciliation, and integration extracts.

The defining characteristic of this view — and the reason it is frequently located through searches on "account_segment_value" — is its hard-coded filter AND ACCOUNT_SEGMENT_VALUE IS NULL. This restricts the view to account rate records that are not tied to a specific accounting segment value. Records carrying a populated ACCOUNT_SEGMENT_VALUE are excluded, so the view should be understood as representing the "no specific account segment" subset of the ZX_ACCOUNT_RATES table, typically the party-level or regime-level rates that apply generally rather than to a single natural account.

Underlying Base Objects

The view is defined over three documented base objects, joined in a single SELECT statement:

• ZX_ACCOUNT_RATES (synonym to the ZX_ACCOUNT_RATES table) — aliased ZXAR, this is the driving entity holding the tax rate, tax regime, tax status, rounding rules, and descriptive flexfield attribute columns.
• GL_LEDGERS (synonym) — aliased LGR, joined on LGR.LEDGER_ID = ZXAR.LEDGER_ID, supplying the ledger name for the owning ledger of each rate record.
• ZX_FIRST_PARTY_ORGS_ALL_V (view) — aliased PTP, joined on ZXAR.CONTENT_OWNER_ID = PTP.PARTY_TAX_PROFILE_ID, supplying the party name of the content owner that published the tax content.
• FND_GLOBAL (package) — documented as a referenced object, indicating the view's dependency on global context (such as responsibility, ledger, or user context) used elsewhere in the ETRM stack for multi-org and security filtering.

Only the columns present in all three joined sources survive into the projection; the ACCOUNT_SEGMENT_VALUE column itself is returned but is always NULL in any row produced by this view.

Key Columns

• LEDGER_ID / LEDGER_NAME — the ledger to which the account rate belongs and its display name from GL_LEDGERS.
• TAX_REGIME_CODE, TAX, TAX_STATUS_CODE, TAX_RATE_CODE, TAX_CLASS — the tax determination keys identifying which regime, tax, tax status, and rate code the record configures.
• TAX_CURRENCY_CODE, TAX_PRECISION, TAX_MAU, ALLOW_ROUNDING_OVERRIDE_FLAG, ROUNDING_RULE_CODE, AMT_INCL_TAX_FLAG — currency and rounding configuration controlling how tax amounts are calculated and rounded.
• CALCULATION_LEVEL_CODE, RECORD_TYPE_CODE — indicators of the level at which the rate applies and the nature of the record.
• CONTENT_OWNER_ID / CONTENT_OWNER_NAME — the first-party organization (via ZX_FIRST_PARTY_ORGS_ALL_V) that owns the tax content.
• ACCOUNT_SEGMENT_VALUE — exposed but always NULL due to the view's filter; used as the discriminator that separates this view from the segment-specific rate records.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE15 — the descriptive flexfield columns for customer extensions.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — standard WHO audit columns.

Common Use Cases and Queries

Typical usage includes auditing tax rate configuration across ledgers, validating which first-party organization owns a given rate, and extracting tax setup for migration or reconciliation. Because ACCOUNT_SEGMENT_VALUE is always NULL here, users seeking segment-specific rates must query ZX_ACCOUNT_RATES directly.

A representative query joining the view to ledger context is:

• SELECT ledger_name, tax_regime_code, tax, tax_rate_code, tax_status_code, content_owner_name, tax_currency_code, rounding_rule_code FROM zx_account_rates_v WHERE tax_regime_code = :p_regime ORDER BY ledger_name, tax_rate_code;
• SELECT v.tax_rate_code, v.tax, v.amt_incl_tax_flag, v.last_update_date FROM zx_account_rates_v v WHERE v.ledger_id = :p_ledger_id AND v.tax_status_code = 'TAXABLE';
• SELECT account_segment_value, COUNT(*) FROM zx_account_rates_v GROUP BY account_segment_value; — returns a single NULL bucket, confirming the view's scope.

Because the view is owned by APPS and depends on FND_GLOBAL, it should be queried with an initialized EBS session context to ensure ledger and organization security behave as expected.