Introduction:
This SQL query is fetching the data of Tax reporting type code details by passing the tax regime.
Cause of the issue:
To find if any of the tax reporting type code is blank and that needs to find.
How do we solve:
By providing this report, the users can able to find out what are all the tax rates doesn’t have the tax reporting type code.
SQL Query:
select zrab.TAX_RATE_CODE, zrca.REPORTING_CODE_CHAR_VALUE REPORTING_CODE,
(select reporting_type_code from ZX_REPORTING_TYPES_B zrt
where zrt.REPORTING_TYPE_ID = zrca.reporting_type_id) reporting_type_code
from zx_rates_b zrab, ZX_REPORT_CODES_ASSOC zrca
where zrab.TAX_RATE_ID = zrca.entity_id(+)
and zrca.entity_code = ‘ZX_RATES’
and zrab.TAX_REGIME_CODE = <Regime Code>
and zrab.active_flag = ‘Y’
order by 1
