Search Results tax_exemptions_qp_v




Overview
Explore in AI Chat

Overview

The TAX_EXEMPTIONS_QP_V view in the APPS schema is an Oracle E-Business Suite Receivables (AR) reporting and integration object that lists candidate exemption certificates applicable to a given Bill To customer and Ship To site. It plays a specialized role within the ETRM (E-Business Tax) and Oracle Receivables tax determination flow, where exemption certificates must be resolved for a specific customer account and ship-to location during tax calculation. The "_QP" suffix identifies this view as part of the QuickPick (QP) family of lookup views consumed by the tax engine to select the applicable exemption record. The view is documented as VALID and was introduced to support the tax exemption logic described in ETRM Releases 12.1.1 and 12.2.2.

Underlying Base Objects

The view is defined over a combination of Receivables and Oracle Trading Community Architecture (HZ) objects. Documented references include:

The joins link Ship To site uses to customer account sites via CUST_ACCT_SITE_ID, then to party sites and locations via PARTY_SITE_ID and LOCATION_ID, with an additional match on ORG_ID. The exemption record (RA_TAX_EXEMPTIONS) is then constrained so that its location segments (LOCATION_ID_SEGMENT_1/2/3) either match or are null relative to the location combination, ensuring that both customer-level and site-level exemptions are returned as candidates.

Key Columns

Common Use Cases and Queries

This view is typically consumed to diagnose which exemption certificate the tax engine will apply for a given Bill To / Ship To combination, and to troubleshoot reason codes seen in tax lines. A sample query to retrieve exemptions for a customer:

SELECT bill_to_customer_id, ship_to_site_use_id, tax_exempt_number, tax_exempt_reason_code, tax_exempt_reason_meaning, percent_exempt, status_code, start_date, end_date FROM apps.tax_exemptions_qp_v WHERE bill_to_customer_id = :p_customer_id ORDER BY display_order;

Analysts frequently filter specifically on the reason code to audit usage:

SELECT tax_exempt_number, tax_exempt_reason_code, tax_exempt_reason_meaning, status_code FROM apps.tax_exemptions_qp_v WHERE tax_exempt_reason_code = :p_reason_code;

Because DISPLAY_ORDER encodes the precedence rules, taking the first row returned per Ship To site (ordered by DISPLAY_ORDER) reproduces the engine's candidate selection and is the recommended approach when validating tax exemption behavior.