Tax Table in oracle apps r12

Tax Table in oracle apps r12

In this post , We will be discuss about the Tax Table in oracle apps r12. I will try to share all these Tax tables which most commonly used in the Oracle apps to extract any tax related information's in oracle apps. These tax tables stores all tax details like we can get the tax name , tax rate , tax rate codes , tax about calculated for each transactions , tax registrations information's and other tax regime related details.Here below i will try to explain all these tax table in more details and the important tax sql queries using these tax table in oracle apps.

6 Important Tax Table in oracle apps r12

1.ZX_STATUS_B

2.ZX_REGIMES_B
3.ZX_RATES_B

4.ZX_LINES
5.ZX_TAXEX_B

6.ZX_TAXES_TL

 

Detail explanation of tax tables in oracle 

ZX_STATUS_B :-

This table help to store the Tax status infromation's in oracle apps.

ZX_REGIMES_B :-

In this table , we do get the Tax regime Code and the Tax Reigme country.

ZX_RATES_B :-

In this table , we do get the Tax name , Percentage Rate, Tax Regime code , Tax Rate Code, Tax Class

ZX_LINES :-

In this table , we do get the TRX_number , TRX_date , Tax Line Amount , Tax Type Code, Tax Currency Conversion Rate and Date , Actual Tax amount calculated etc.

ZX_TAXEX_B :- In this table , We do get the Tax Name , Type Code and the Tax Regime code.

ZX_TAXES_TL :- In this table , we do get the Full Tax name.

Important SQL queries using Tax tables in oracle apps 

For AR Invoice Tax amount Calculation 

select sum(nvl(zl.UNROUNDED_TAX_AMT,0))  from apps.ZX_LINES a1, RA_CUSTOMER_TRX_ALL a2

where a1.trx_id=a2.CUSTOMER_TRX_ID

and a2.invoice_number=:P_TRX_NUMBER

For AP Invoice Tax amount Calculation 

select sum(nvl(zl.UNROUNDED_TAX_AMT,0))  from apps.ZX_LINES a1, ap_invoices_all a2

where a1.trx_id=a2.invoice_id

and a2.invoice_number=:P_invoice_number 

 

Tax Table in oracle apps r12