E-Business Tax (MOSC)

MOSC Banner

Tax Groups

edited May 8, 2012 10:51PM in E-Business Tax (MOSC) 1 commentAnswered

Hi,

we have an interface in 11i extracting data for the fields tax_group_code_id,tax_group_id,tax_group_name;Now we are implementing the same in R12 ,so which table in R12 will contain the tax group related information

which will be equivalent to the data fetched from the 11i table ar_tax_group_codes_all.

Following is the 11i query to fetch the data :

Select (select tc2.ORG_ID
          from apps.AR_VAT_TAX_ALL_B tc2
          where tc2.VAT_TAX_ID = tgp.TAX_GROUP_ID) ORG_ID,
        tgp.TAX_GROUP_CODE_ID,
        tgp.TAX_GROUP_ID,

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.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center