Results for “content_owner_name”

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

Overview

ZX_MCO_EO_RATES_V is a multitenant, content-owner-aware reporting view owned by the APPS schema in Oracle E-Business Suite. It is published under the FND - Application Object Library product grouping and remains a VALID object in both release 12.1.1 and 12.2.2. The view presents tax rate definitions maintained in Oracle E-Business Tax (ETRM), exposing both a base rate row (ZX_RATES_B) and its language-specific translation row (ZX_RATES_TL), plus ownership and access-control metadata derived from first-party organization parties and the Multi-Organization Access Control (MOAC) security framework.

Because the ETRM configuration model separates a nonspatial tax rate from the jurisdictions, regimes, and recovery rules that consume it, this view functions as a flattened, denormalized read layer. Reporting solutions, reconciliation extracts, and integrations use it to retrieve rates without writing their own joins across the ZX_RATES_B / ZX_RATES_TL pair or re-implementing the MOAC access predicates. Its name prefix (ZX_MCO) signals that the view is filtered for the current user's organizational access — the UPDATE_ACCESS and DUPLICATE_ACCESS columns come directly from ZX_MCO_CHECK_ACCESS_V — and it is scoped to external or content-owner organizations (EO) rather than to a single legal entity.

Underlying Base Objects

The documented base objects are:

• ZX_RATES_B (synonym) — the base table holding one row per tax rate, aliased ZRB. It supplies the core rate attributes and the ROWID used as ROW_ID.
• ZX_RATES_TL (synonym) — the translation table for tax rate names and descriptions, aliased ZRT; joined on TAX_RATE_ID and constrained to LANGUAGE = USERENV('LANG').
• ZX_FIRST_PARTY_ORGS_MOAC_V (view) — aliased ZFPOMV, joined on PARTY_TAX_PROFILE_ID = CONTENT_OWNER_ID to resolve the owning party name.
• ZX_MCO_CHECK_ACCESS_V (view) — aliased ZMCAV, joined on TAX_REGIME_CODE and the parent regime, providing MOAC access flags.
• FND_GLOBAL and FND_PROFILE (packages) — referenced internally by the component views to resolve the current user, responsibility, organization, and language context.

The view therefore depends on the MOAC security stack: access is not governed by a simple WHERE clause on the rate table but by the join to ZX_MCO_CHECK_ACCESS_V, which evaluates the user's access to the tax regime that owns the rate.

Key Columns

• TAX_RATE_ID / TAX_RATE_CODE / TAX_RATE_NAME — the primary identifier, internal code, and translated display name of the rate.
• TAX_REGIME_CODE / TAX / TAX_STATUS_CODE / TAX_JURISDICTION_CODE — the tax regime, tax, status, and jurisdiction to which the rate belongs.
• EFFECTIVE_FROM / EFFECTIVE_TO — the date range during which the rate is valid.
• RATE_TYPE_CODE, PERCENTAGE_RATE, QUANTITY_RATE, UOM_CODE — the rate type and the percentage or quantity-based rate value (including unit of measure for quantity rates).
• RECOVERY_TYPE_CODE, RECOVERY_RULE_CODE, DEFAULT_REC_TYPE_CODE, DEFAULT_REC_RATE_CODE, DEF_REC_SETTLEMENT_OPTION_CODE — recovery configuration for the rate.
• ACTIVE_FLAG, DEFAULT_RATE_FLAG, DEFAULT_FLG_EFFECTIVE_FROM, DEFAULT_FLG_EFFECTIVE_TO, INCLUSIVE_TAX_FLAG, TAX_INCLUSIVE_OVERRIDE_FLAG — control flags governing activation, defaulting, and tax-inclusive treatment.
• TAXABLE_BASIS_FORMULA_CODE, ALLOW_EXEMPTIONS_FLAG, ALLOW_EXCEPTIONS_FLAG, ALLOW_ADHOC_TAX_RATE_FLAG — calculation and elasticity settings.
• CONTENT_OWNER_ID / CONTENT_OWNER_NAME — the owning first-party organization party and its resolved name.
• UPDATE_ACCESS / DUPLICATE_ACCESS — MOAC-derived flags indicating whether the current user may update or duplicate the rate record.
• ROW_ID — the ROWID of the underlying ZX_RATES_B row.
• DESCRIPTION — the translated description from ZX_RATES_TL.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_LOGIN_ID — standard WHO audit columns.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE15 — the DFF (descriptive flexfield) context and segments.

Common Use Cases and Queries

Typical uses include auditing active tax rates for a regime, building reconciliation extracts between ETRM and external tax engines, and populating reports that must respect MOAC access. A simple listing of currently effective rates is:

SELECT tax_rate_code,
       tax_rate_name,
       tax_regime_code,
       percentage_rate,
       effective_from,
       effective_to
  FROM apps.zx_mco_eo_rates_v
 WHERE active_flag = 'Y'
   AND SYSDATE BETWEEN effective_from AND NVL(effective_to, SYSDATE)
 ORDER BY tax_regime_code, tax_rate_code;

To identify rates writable by the current user, filter on the access flag supplied by ZX_MCO_CHECK_ACCESS_V:

SELECT tax_rate_id,
       tax_rate_code,
       content_owner_name,
       update_access,
       duplicate_access
  FROM apps.zx_mco_eo_rates_v
 WHERE update_access = 'Y';

Frequently the view is used to trace which rates belong to which content owner, or to extract recovery settings per jurisdiction. Because the view already applies the language and MOAC predicates, callers should avoid re-joining ZX_RATES_B or re-filtering by language; duplicate predicates can disable index access paths and return fewer rows than expected.