If you need to troubleshoot ebTax setup , you should use the Following query . These are retrived from the
main E-Business tax tables that will contain the setup information
that will help support in troubleshooting E-Business tax information.
In order to get access you need to provide the
tax regime code when prompted.
a. Tax Regimes:
ZX_REGIMES_B
SELECT *
FROM zx_regimes_b
WHERE
tax_regime_code = '&tax_regime_code';
b. Taxes:
ZX_TAXES_B
SELECT *
FROM zx_taxes_b
WHERE
DECODE('&tax_name',null,'xxx',tax) = nvl('&tax_name','xxx')
AND tax_regime_code
= '&tax_regime_code';
c. Tax Status:
ZX_STATUS_B
SELECT *
FROM zx_status_b
WHERE tax =
'&tax_name'
AND tax_regime_code
= '&tax_regime_code';
d. Tax Rates:
ZX_RATES_B
SELECT *
FROM zx_rates_b
WHERE tax =
'&tax_name'
AND tax_regime_code
= '&tax_regime_code';
e. Tax
Jurisdictions: ZX_JURISDICTIONS_B
SELECT *
FROM
zx_jurisdictions_b
WHERE DECODE('&tax_name',null,'xxx',tax)
= nvl('&tax_name','xxx')
AND tax_regime_code
= '&tax_regime_code';
f. Tax Rules:
ZX_RULES_B
SELECT *
FROM zx_rules_b
WHERE tax =
'&tax_name'
AND tax_regime_code
= '&tax_regime_code';