Search Results exemption_ship_to_site_use_id




Overview
Explore in AI Chat

Overview

APPS.OE_TAX_EXEMPTIONS_QP_V is a reporting and integration view in Oracle E-Business Suite that exposes tax exemption records in the form required by Oracle Advanced Pricing (QP) and Order Management tax determination logic. It is documented in ETRM for releases 12.1.1 and 12.2.2 and is owned by the APPS schema. The view presents customer tax exemption data — exemption certificates, exemption reason codes, exemption percentages, validity dates, and status — enriched with ship-to and bill-to context, organization identifiers, and the associated tax code. This combination allows pricing and tax engines to evaluate whether a given ship-to site use qualifies for a tax exemption at the time an order or return is processed.

The view is particularly relevant to the seed data and setup verification performed by Oracle Receivables, Order Management, and Advanced Pricing, and it is frequently referenced when troubleshooting missing exemption behavior in order-to-cash flows. Its primary key-like grain is one row per tax exemption combined with the resolved ship-to site use and its associated customer and organization.

Underlying Base Objects

The view is defined over the following documented objects:

Joins are performed on SITE_USE_ID with the SHIP_TO site use code, on SHIP_TO_CUSTOMER_ID to SOLD1.CUSTOMER_ID, and on BILL_TO_CUSTOMER_ID to SOLD2.CUSTOMER_ID using an outer join. The SHIP2 and SOLD2 joins are also outer joins, so exemptions without a matching secondary ship-to site or bill-to customer are still returned.

Key Columns

  • SHIP_TO_SITE_USE_ID — Ship-to site use identifier for the exemption.
  • SHIP_TO_CUSTOMER_ID / BILL_TO_CUSTOMER_ID — Customer identifiers for the ship-to and bill-to parties.
  • EXEMPTION_SHIP_TO_SITE_USE_ID — The exemption-specific ship-to site use, exposed from the underlying exemption record and central to the user's search.
  • TAX_EXEMPT_NUMBER / TAX_EXEMPT_REASON_CODE / TAX_EXEMPT_REASON_MEANING — Certificate number and coded/decoded exemption reason.
  • PERCENT_EXEMPT — Percentage of tax exempted on qualifying transactions.
  • STATUS_CODE / STATUS_MEANING — Current status of the exemption record.
  • START_DATE / END_DATE — Effective date range of the exemption.
  • TAX_EXEMPTION_ID / DISPLAY_ORDER / TAX_CODE — Internal exemption identifier, display sequence, and associated tax code from the pricing tax repository.
  • SITE_USE_ID / ORGANIZATION_ID / ORG_ID — Resolved site use and organization identifiers used for multi-org and operating unit filtering.

Common Use Cases and Queries

Typical scenarios include identifying active exemptions for a customer or ship-to site, validating whether an exemption is within its effective date range, and reviewing exemption percentages and reasons for audit or reconciliation. A representative query follows:

  • SELECT ship_to_site_use_id, exemption_ship_to_site_use_id, tax_exempt_number, percent_exempt, status_code, start_date, end_date FROM apps.oe_tax_exemptions_qp_v WHERE ship_to_customer_id = :p_customer_id AND SYSDATE BETWEEN start_date AND NVL(end_date, SYSDATE + 1);
  • SELECT tax_exempt_number, tax_code, percent_exempt, org_id FROM apps.oe_tax_exemptions_qp_v WHERE exemption_ship_to_site_use_id = :p_site_use_id;
  • SELECT COUNT(*) FROM apps.oe_tax_exemptions_qp_v WHERE status_code = 'A' AND org_id = :p_org_id;

These queries support setup verification, tax determination debugging, and reporting against exemption certificates in Oracle EBS 12.1.1 and 12.2.2.