Discussions
Join between zx_jurisdictions_b and zx_regimes_b or zx_taxes_b
Hi ,
I'm need to extract information regarding tax regimes screen. I'm able to find the information pertaining to tax regime and rate and tax type. However I'm stuck at finding the join with zx_jurisdictions_b table.
I did checked on the etrm.live for the zx_jurisdictions_b and zx_jurisdictions_tl but didn't find any relatable information pertaining to join.
Kindly share the details of the table or common key column between zx_regimes_b or zx_taxes_b and zx_jurisdictions_b
We are on R12.2 instance.
Regards,
Shareef
0