issue with the link between gl_code_combinations and ZX_ACCOUNTS
Summary:
I am creating a report to gather the taxes and all invoices related to this tax.
Content (please ensure you mask any confidential information):
I used the below query in my data model to get the tax accounts used in the general ledger along with the tax details(tax rate code, percentage rate, etc.).
SELECT
RB.TAX_RATE_CODE,
RB.CREATION_DATE,
COMB.Segment4,
RB.PERCENTAGE_RATE,
COMB.chart_of_accounts_id
FROM zx_rates_b RB
JOIN ZX_ACCOUNTS TA ON TA.TAX_ACCOUNT_ENTITY_ID = RB.tax_rate_id
JOIN gl_code_combinations COMB ON COMB.code_combination_id IN