Search Results tax_exempt_flag_display




Overview
Explore in AI Chat

Overview

SO_TAX_STATUSES_V is a lightweight, single-purpose view owned by the APPS schema and registered under the OE (Order Entry) product family in Oracle E-Business Suite. Its status is VALID in both the 12.1.1 and 12.2.2 releases. The view exists to expose a human-readable lookup of tax exemption control codes used throughout the order-to-cash flow. Rather than storing transactional tax status data of its own, it acts as a translation layer over the AR_LOOKUPS lookup repository, converting each internal lookup code into the user-facing meaning maintained by the system administrator.

Functionally, the object answers a narrow but recurring reporting question: for a given tax control code, what is the descriptive meaning shown to users? This makes it a convenience reference view rather than a fact or transaction view. It is commonly joined to order headers, order lines, and customer records where a tax exemption flag value is stored as a lookup code. Because the underlying lookup meanings are defined in AR_LOOKUPS, the view also centralizes lookup maintenance behavior — any change to the meaning of a TAX_CONTROL_FLAG code is immediately reflected wherever this view is queried.

Underlying Base Objects

The documented base object for this view is AR_LOOKUPS, itself an Oracle EBS view in the AR (Receivables) product. The view definition filters that source with a single predicate and projects only two columns:

Because AR_LOOKUPS is the shared, centralized lookup definition object for Oracle Receivables and adjacent modules, this view inherits its seeding and setup characteristics. Lookup codes for TAX_CONTROL_FLAG are typically seeded by Oracle and may be extended or deactivated by the implementation team, so the row set returned by SO_TAX_STATUSES_V is environment-dependent. Any row that is disabled, end-dated, or added through lookup setup will follow the standard behavior of the underlying AR_LOOKUPS view in the installed release.

Key Columns

  • TAX_EXEMPT_FLAG_DISPLAY — The descriptive meaning of the tax control lookup, suitable for presentation on reports, dashboards, and BI Publisher layouts. This is the column that resolves the user search term "tax_exempt_flag_display".
  • TAX_EXEMPT_FLAG — The underlying lookup code stored on transaction and customer records. This is the value that must be matched when joining the view back to order or customer data.

The view is intentionally narrow: no other attributes such as description, dates, or enabled flags are exposed. Where additional lookup metadata is required, the calling query must reference AR_LOOKUPS directly or join to it.

Common Use Cases and Queries

Typical applications include decoding tax exemption flags on order reports, building value sets or LOVs for custom concurrent programs, and validating that customer or order tax attributes carry a recognized lookup code.

  • Listing all available tax control codes with their display meanings.
  • Reporting order headers with a readable tax exempt status.
  • Auditing records whose tax exempt flag does not match a current lookup code.

Representative queries follow.

SELECT tax_exempt_flag, tax_exempt_flag_display FROM apps.so_tax_statuses_v ORDER BY tax_exempt_flag_display;

SELECT h.order_number, h.tax_exempt_flag, v.tax_exempt_flag_display FROM apps.oe_order_headers_all h, apps.so_tax_statuses_v v WHERE h.tax_exempt_flag = v.tax_exempt_flag;

Where a report must show a default label for orders that carry no valid tax control code, the view is best accessed through an outer join, using NVL on TAX_EXEMPT_FLAG_DISPLAY to substitute an appropriate placeholder such as "Undefined" or "Not Applicable".