View: OE_TAX_EXEMPTIONS_QP_V

Product:	ONT - Order Management
Description:	This view is used in deriving the Tax Exemption details defined for Customer/Customer Sites.
Implementation/DBA Data:	APPS.OE_TAX_EXEMPTIONS_QP_V

View Text

SELECT SHIP_TO_SITE_USE_ID
, SHIP_TO_CUSTOMER_ID
, BILL_TO_CUSTOMER_ID
, EXEMPTION_SHIP_TO_SITE_USE_ID
, NULL
, TAX_EXEMPT_NUMBER
, TAX_EXEMPT_REASON_CODE
, TAX_EXEMPT_REASON_MEANING
, PERCENT_EXEMPT
, STATUS_CODE
, STATUS_MEANING
, START_DATE
, END_DATE
, TAX_EXEMPTION_ID
, DISPLAY_ORDER
, TAX.TAX_CODE
, SHIP1.SITE_USE_ID
, SOLD1.ORGANIZATION_ID
, SOLD2.ORGANIZATION_ID
, SHIP2.SITE_USE_ID
, SHIP1.ORG_ID FROM TAX_EXEMPTIONS_V TAX
, HZ_CUST_SITE_USES_ALL SHIP1
, HZ_CUST_SITE_USES_ALL SHIP2
, OE_SOLD_TO_ORGS_V SOLD1
, OE_SOLD_TO_ORGS_V SOLD2
WHERE TAX.SHIP_TO_SITE_USE_ID = SHIP1.SITE_USE_ID
AND SHIP1.SITE_USE_CODE = 'SHIP_TO' AND TAX.EXEMPTION_SHIP_TO_SITE_USE_ID = SHIP2.SITE_USE_ID (+)
AND SHIP2.SITE_USE_CODE (+) = 'SHIP_TO' AND TAX.SHIP_TO_CUSTOMER_ID = SOLD1.CUSTOMER_ID AND TAX.BILL_TO_CUSTOMER_ID = SOLD2.CUSTOMER_ID (+)

Columns