Search Results sales_tax




Overview
Explore in AI Chat

Overview

APPS.ASO_I_TAX_CODES_V is an Oracle E-Business Suite self-service reference view belonging to the ASO (Order Capture / Sales) application schema. It exposes the tax codes and associated rates available to the ordering and sales flows, drawing them from the Receivables tax setup while filtering them against the current Receivables system parameters. In the context of a "sales_tax" search, this view is particularly relevant because its WHERE clause is explicitly conditioned on the AR_SYSTEM_PARAMETERS.TAX_METHOD value, meaning the set of tax codes returned changes depending on whether the operating unit is configured to use Sales Tax or another tax method (such as VAT/EBTax). The view therefore acts as a method-aware lookup, ensuring that order-entry pages and validation logic surface only the tax codes appropriate to the configured tax regime. It is exposed under the APPS schema, and its referenced base objects are documented as AR_SYSTEM_PARAMETERS (SYNONYM) and AR_VAT_TAX (SYNONYM) in the ETRM 12.2.2 metadata.

Underlying Base Objects

The view is defined over two underlying objects, both referenced via APPS synonyms:

  • AR_VAT_TAX — the Receivables tax code definition table, aliased V. It supplies the tax code, rate, effective dates, and tax type.
  • AR_SYSTEM_PARAMETERS — the Receivables system options table, aliased P. It supplies the TAX_METHOD and SET_OF_BOOKS_ID used for filtering.

The join is performed on SET_OF_BOOKS_ID, restricting returned tax codes to the set of books (ledger) defined in the Receivables system parameters. A further predicate on TAX_METHOD and TAX_TYPE governs which tax types are valid for the configured method. No aggregation, outer join, or set operation is present; the view is a simple equi-join projection of five columns.

Key Columns

  • TAX_CODE — the tax code identifier (from AR_VAT_TAX), used to select and apply a tax in ordering and invoicing contexts.
  • TAX_RATE — the rate associated with the tax code, expressed as a percentage used in tax calculation.
  • START_DATE — the effective start date of the tax code, enabling date-valid selection.
  • END_DATE — the effective end date of the tax code.
  • TAX_TYPE — the tax type classification. Because the view's WHERE clause explicitly references TAX_TYPE (excluding 'LOCATION' when TAX_METHOD is not 'SALES_TAX'), this column is central to the method-dependent behavior of the view.

Common Use Cases and Queries

Typical uses include populating tax-code list-of-values in order capture, validating a chosen tax code against the current tax method, and reporting effective tax rates. A simple query listing available tax codes is:

  • SELECT TAX_CODE, TAX_RATE, TAX_TYPE, START_DATE, END_DATE FROM APPS.ASO_I_TAX_CODES_V ORDER BY TAX_CODE;
  • SELECT TAX_CODE, TAX_RATE FROM APPS.ASO_I_TAX_CODES_V WHERE SYSDATE BETWEEN START_DATE AND NVL(END_DATE, SYSDATE);
  • SELECT TAX_CODE FROM APPS.ASO_I_TAX_CODES_V WHERE TAX_TYPE = 'SALES_TAX';

The last query is directly relevant to a "sales_tax" search: when the Receivables TAX_METHOD equals SALES_TAX, the view returns all matching tax types, whereas under a non-sales-tax method the LOCATION tax type is excluded. This conditional filtering is the defining characteristic of the view and should be considered when interpreting its results.