VIEW: APPS.OE_TAX_EXEMPTIONS_QP_V

Source

View Text - Preformatted

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 (+)

View Text - HTML Formatted

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 (+)