Search Results aso_i_tax_codes_v




Overview
Explore in AI Chat

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

Overview

ASO_I_TAX_CODES_V is a PL/SQL view owned by the APPS schema in Oracle E-Business Suite, classified under the ASO (Order Capture) product family. Its documented purpose is to present information about all tax codes recognized by Oracle Receivables (AR). The view is registered with a VALID status and is exposed as a reporting and integration interface, allowing downstream ASO components — such as iStore, Order Management, and quote or order capture flows — to enumerate the tax codes that are valid for the current AR operating context.

Users searching for the term ar_vat_tax typically arrive at this object because ASO_I_TAX_CODES_V is defined directly over the AR_VAT_TAX table. The view therefore acts as a filtered, join-enriched projection of AR's VAT tax repository rather than as a base table in its own right. It presents tax codes in a consistent shape that calling applications can consume without needing to replicate AR's tax-method filtering logic.

Underlying Base Objects

The documented base objects referenced by ASO_I_TAX_CODES_V are AR_VAT_TAX (SYNONYM) and AR_SYSTEM_PARAMETERS (SYNONYM). The view definition is a join between these two entities:

The join predicate is V.SET_OF_BOOKS_ID = P.SET_OF_BOOKS_ID, meaning the view returns only tax codes belonging to the set of books defined in AR system parameters. An additional filter expression restricts the result set based on the configured tax method: when the AR tax method is not SALES_TAX, tax codes of type LOCATION are excluded; when the tax method is SALES_TAX, the tax-type restriction is not applied. This conditional logic ensures the view aligns with the AR tax regime configured for the installation.

Key Columns

The view exposes five columns, drawn from AR_VAT_TAX:

  • TAX_CODE — the tax code identifier defined in AR, used as the lookup key by ASO pricing and tax calculation logic.
  • TAX_RATE — the rate associated with the tax code, expressed as a numeric percentage used in tax computation.
  • START_DATE — the effective start date from which the tax code is valid.
  • END_DATE — the effective end date through which the tax code remains valid. Dates bound the period in which the tax code may be applied.
  • TAX_TYPE — the classification of the tax code (for example, LOCATION or other AR-defined types), used to determine applicability under the configured tax method.

Common Use Cases and Queries

The view is commonly used when an ASO or Order Management component must populate a list of valid tax codes, validate a tax code supplied on an order line, or display tax code information during quote entry. Because it references SYNONYMs for both base objects, it resolves against the APPS schema in both 12.1.1 and 12.2.2 environments.

A representative query listing all valid tax codes for the current set of books is:

  • SELECT tax_code, tax_rate, start_date, end_date, tax_type FROM apps.aso_i_tax_codes_v ORDER BY tax_code;

To retrieve only currently effective tax codes:

  • SELECT tax_code, tax_rate, tax_type FROM apps.aso_i_tax_codes_v WHERE SYSDATE BETWEEN start_date AND NVL(end_date, SYSDATE);

To restrict results to a particular tax type:

  • SELECT tax_code, tax_rate FROM apps.aso_i_tax_codes_v WHERE tax_type = 'LOCATION';

Analysts should note that the row set returned depends on the AR TAX_METHOD and SET_OF_BOOKS_ID configured in AR_SYSTEM_PARAMETERS, so results can vary between environments even when the underlying AR_VAT_TAX records are identical.