E-Business Tax (MOSC)

MOSC Banner

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

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center