You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
Skip to content
  • Register

    • help to get SQL query to get the data from tax conditions to Value set values

    in Tax & Global 4 comments

    Summary:

    One of our tax determination factors is line account (one of the segments in CoA). We are looking for a report to get CoA values with tax rule name and tax rate. I have tried and could not find a link between following tables in FND_VS_VALUES_Vl, GL_CODE_COMBINATIONS, ZX_RATES_B, ZX_RULES_B, ZX_CONDITIONS. The datatype of the columns that stores CoA values is 'XML Type', in ZX_CONDITIONS.

    There is no subject areas in OTBI for tax modules as well

    Can someone please help to joint the tables or provide the query?

    Tagged:

    Howdy, Stranger!

    Log In

    To view full details, sign in.

    Register

    Don't have an account? Click here to get started!