Search Results so_tax_codes_v




Overview
Explore in AI Chat

Overview

The APPS.SO_TAX_CODES_V view is a reporting and validation object owned by the APPS schema and associated with the OE (Order Entry) product family in Oracle E-Business Suite 12.1.1 and 12.2.2. It exposes a filtered, joined list of tax codes, their rates, validity dates, and tax types for use by order entry and related tax determination logic. Rather than reading raw setup tables directly, the view applies the business rules required to return only tax codes that are currently usable in the operating context of the current set of books.

Because it is a view and not a table, it carries no persisted data. Its value lies in encapsulating the join between the VAT tax definition table and the system parameters table, and in applying enablement, tax class, and display filtering so that downstream forms, concurrent programs, and integrations see only meaningful tax code values. The view is central to how tax codes are surfaced for order lines in Order Management, and it is frequently referenced in reporting where a stable, filtered list of valid tax codes is required.

Underlying Base Objects

The view is defined over two documented base objects, both referenced through synonyms in the APPS schema:

The join is performed on SET_OF_BOOKS_ID, ensuring the tax codes returned correspond to the same set of books as the active Receivables system parameters. The filter logic includes two tax-method branches: where TAX_METHOD is not SALES_TAX, rows with TAX_TYPE of LOCATION are excluded; where TAX_METHOD is SALES_TAX, that exclusion does not apply. Additional NVL-based filters require ENABLED_FLAG to default to 'Y', TAX_CLASS to default to 'O', and DISPLAYED_FLAG to default to 'Y', which is directly relevant to the user search term "displayed_flag."

Key Columns

  • TAX_CODE — the tax code identifier presented to order entry users and stored on order lines.
  • TAX_RATE — the rate applied to the taxable amount for the code.
  • START_DATE and END_DATE — the effective date range during which the tax code applies.
  • TAX_TYPE — the classification of the tax code (for example, location-based or otherwise), used together with TAX_METHOD to determine eligibility.

The DISPLAYED_FLAG attribute is not projected in the SELECT list, but it is a critical filter predicate: NVL(DISPLAYED_FLAG, 'Y') = 'Y' ensures that only tax codes flagged for display, or lacking an explicit flag value, are returned. The same pattern applies to ENABLED_FLAG and TAX_CLASS.

Common Use Cases and Queries

The view supports tax code list-of-values lookups, order entry validation, and reporting on applicable tax rates. A typical query listing all currently displayable tax codes is:

  • SELECT tax_code, tax_rate, tax_type, start_date, end_date FROM so_tax_codes_v ORDER BY tax_code;
  • SELECT tax_code, tax_rate FROM so_tax_codes_v WHERE TRUNC(SYSDATE) BETWEEN start_date AND NVL(end_date, SYSDATE);
  • SELECT tax_code FROM so_tax_codes_v WHERE tax_type = 'LOCATION';

These queries return only tax codes that satisfy the enablement, tax class, display, and set-of-books constraints enforced by the view, making it preferable to querying AR_VAT_TAX directly for order entry purposes.