Results for “arbv_ar_tax_codes”

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

Overview

ARBV_AR_TAX_CODES is a read-only Oracle EBS view owned by the APPS schema in the Oracle Receivables (AR) module. It is a compatibility (retrofitted) view designed to expose Oracle E-Business Tax (ZX) tax rate data in the shape historically expected by Receivables. In releases 12.1.1 and 12.2.2, taxation was externalized to the E-Business Tax engine, and legacy Receivables tax code constructs were remapped onto the ZX regime, tax, and rate model. This view provides that remapped, denormalized presentation.

The view presents tax codes (tax rates) together with their reporting name, effective dating, account association, and content owner (party tax profile) context. Its role is to satisfy reporting and integration consumers that reference "tax codes" in a Receivables sense while the physical data resides in the E-Business Tax tables. The view is flagged WITH READ ONLY, so it can be safely queried but never used for DML.

Underlying Base Objects

The view is defined over nine ZX synonyms, all resolving to E-Business Tax base tables under the APPS schema:

• ZX_RATES_B — tax rate definitions (the primary driver of the join).
• ZX_RATES_TL — translated tax rate names.
• ZX_TAXES_B — tax definitions, joined to rates on regime code, tax, and content owner.
• ZX_ACCOUNTS — accounting associations, restricted here to the 'RATES' entity code.
• ZX_PARTY_TAX_PROFILE — supplies party and profile identifiers used as ORG_ID and CONTENT_OWNER_ID.
• ZX_REPORTING_TYPES_B and ZX_REPORTING_CODES_B / ZX_REPORTING_CODES_TL — the PRINTED_TAX_RATE_NAME reporting type chain that yields the tax reporting name.
• ZX_REPORT_CODES_ASSOC — associates reporting codes to entities with entity code 'ZX_RATES'.

The joins are keyed on TAX_RATE_ID, TAX_REGIME_CODE, TAX, CONTENT_OWNER_ID, and language (USERENV('LANG')). The predicate RATES.SOURCE_ID IS NULL restricts the view to native E-Business Tax rates rather than migrated or externally sourced records.

Key Columns

• TAX_CODE_ID — aliased from ZX_RATES_B.TAX_RATE_ID; the unique identifier.
• TAX_CODE — the tax rate code from ZX_RATES_B.TAX_RATE_CODE.
• TAX_NAME — the reporting code name (PRINTED_TAX_RATE_NAME).
• START_EFFECTIVE_DATE / END_EFFECTIVE_DATE — effective_from and effective_to of the rate.
• TAX_RATE — the percentage rate value.
• TAX_CODE_DESCRIPTION — the translated tax rate name from ZX_RATES_TL.
• TAX_ACCOUNT_ID — the tax account CCID from ZX_ACCOUNTS.
• ORG_ID — the party identifier from the party tax profile.
• CONTENT_OWNER_ID — the party tax profile identifier.
• _LA:TAX_TYPE, _LA:ALLOW_EXEMPTION_FLAG, _LA:TAX_INCLUSIVE_FLAG — descriptive-flexfield style attributes resolved through AR_LOOKUPS and FND_LOOKUPS for meaning values.
• Standard WHO columns: CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY.

Common Use Cases and Queries

Typical uses include reconciling tax codes against the E-Business Tax setup and populating reporting extracts that expect Receivables tax code semantics.

• Listing active tax codes with their rates and effective dates for a given content owner.
• Joining tax codes to transaction lines or distributions for tax reporting.
• Verifying that a rate has an associated tax account.

SELECT tax_code_id,
       tax_code,
       tax_name,
       tax_rate,
       start_effective_date,
       end_effective_date
FROM   apps.arbv_ar_tax_codes
WHERE  TRUNC(SYSDATE) BETWEEN start_effective_date AND NVL(end_effective_date, SYSDATE)
ORDER BY tax_code;

Because tax ownership is party-based, filtering or grouping by ORG_ID and CONTENT_OWNER_ID is advisable when querying multi-organization environments.