Results for “tax_code_description”

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

Overview

APPS.ARFV_AR_TAX_CODES is a retrofitted Oracle E-Business Suite view owned by the APPS schema and classified under the Receivables (AR) product family. It presents a flattened, reporting-friendly projection of tax setup data that is otherwise distributed across the E-Business Tax (ZX) schema and the Oracle General Ledger chart of accounts. The view exposes tax rates as "tax codes," pairing each rate with its reporting name, effective dates, tax type, inclusive-tax indicator, exemption flag, operating unit, and — critically for the user's search term — the accounting flexfield combination identified as TAX_ACCOUNT_ID.

The presence of the _LA:, _KF:, and UNIQUE ATTRIBUTES comments in the view text indicates the object was generated for Oracle's Applications Technology "Business Intelligence" / OBIA-style extraction layer, where descriptive flexfield attributes and key flexfield resolutions are annotated inline. Functionally, ARFV_AR_TAX_CODES serves as a denormalized read-only interface for reporting, integration, and analytics workloads that need tax code information without joining the underlying ZX tables directly.

Underlying Base Objects

The view is defined over eleven documented base objects (referenced via APPS synonyms):

• ZX_RATES_B and ZX_RATES_TL — the tax rate definition and its translated name; these supply TAX_CODE_ID, TAX_CODE, effective dates, and TAX_RATE.
• ZX_TAXES_B — the parent tax definition, joined on regime code, tax code, and content owner.
• ZX_ACCOUNTS — supplies the accounting flexfield CCID where TAX_ACCOUNT_ENTITY_CODE = 'RATES', resolved to TAX_ACCOUNT_ID.
• ZX_PARTY_TAX_PROFILE — the content owner, providing ORG_ID and CONTENT_OWNER_ID.
• ZX_REPORTING_TYPES_B, ZX_REPORTING_CODES_B, ZX_REPORTING_CODES_TL, and ZX_REPORT_CODES_ASSOC — the reporting-code chain that yields the printed tax name (TAX_NAME), restricted to reporting type PRINTED_TAX_RATE_NAME.
• GL_CODE_COMBINATIONS — referenced for key flexfield resolution of the tax account.
• HR_ALL_ORGANIZATION_UNITS — provides the operating unit name.

Key Columns

• TAX_CODE_ID — aliased from ZX_RATES_B.TAX_RATE_ID; the unique identifier for the rate.
• TAX_CODE / TAX_CODE_DESCRIPTION — the rate code and its translated rate name.
• TAX_NAME — the printed reporting code name.
• TAX_RATE — the percentage rate from ZX_RATES_B.
• START_EFFECTIVE_DATE / END_EFFECTIVE_DATE — the rate's validity window.
• TAX_ACCOUNT_ID — the accounting flexfield CCID (ZX_ACCOUNTS.TAX_ACCOUNT_CCID) associated with the tax rate; this is the column the user's search term references.
• ORG_ID and CONTENT_OWNER_ID — multi-tenant and party tax profile identifiers.
• Descriptive-field annotations _LA:TAX_TYPE, _LA:ALLOW_EXEMPTION_FLAG, and _LA:TAX_INCLUSIVE_FLAG — lookup-resolved descriptive attributes.
• WHO columns — CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY.

Common Use Cases and Queries

Typical uses include validating tax account assignments, migrating or reconciling tax code configurations, and feeding downstream reporting. A simple lookup by the searched identifier:

• Find the tax account for a given tax code:

  SELECT tax_code, tax_name, tax_rate, tax_account_id, operating_unit
  FROM   apps.arfv_ar_tax_codes
  WHERE  tax_code = :p_tax_code;

• Return tax codes posting to a specific account:

  SELECT tax_code, tax_name, tax_account_id, start_effective_date
  FROM   apps.arfv_ar_tax_codes
  WHERE  tax_account_id = :p_tax_account_id
  AND    TRUNC(SYSDATE) BETWEEN start_effective_date AND NVL(end_effective_date, SYSDATE);

• Audit rates by operating unit and effective window for tax setup reviews.

Because the object is a view over translated (TL) tables filtered by USERENV('LANG'), results are language-dependent; consumers should set the session language appropriately. Access is read-only and should be granted via the APPS schema.