Withholding tax table in oracle Payables r12 : Withholding tax table Details in Oracle Payables r12

Withholding tax table in oracle Payables r12 : Withholding tax table Details in Oracle Payables r12

In this post , We will be discuss about Withholding tax table in Oracle Payables r12. Withholding tax information's stores in the Withholding tax table. To Develop the Withholding tax report , we should have the information about Withholding tax tables. Here below I will share the Withholding tax table which do stores the Withholding tax information's.  

 

 

 5 Important Withholding tax table in oracle Payables r12

1. AP_TAX_CODES_ALL

2. AP_AWT_TAX_RATES_ALL

3. AP_AWT_GROUPS

4.AP_AWT_GROUP_TAXES_ALL

5.AP_AWT_TEMP_DISTRIBUTIONS_ALL

Important Withholding tax SQL Queries in Oracle Payables r12

This below query helps to extract the Withholding tax rates which has applied for the Payables Invoices in Oracle apps r12.

 

SELECT DISTINCT
  awt.*
FROM
  ap_tax_codes_all atc,
  ap_awt_tax_rates_all awt
WHERE
  awt.tax_name  = atc.name
AND atc.tax_id IN
  (
    SELECT DISTINCT
      aid.tax_code_id
    FROM
      ap_invoice_distributions_all aid,
      ap_tax_codes_all atc
    WHERE
      aid.tax_code_id    = atc.tax_id
    AND aid.tax_code_id IS NOT NULL
    AND atc.tax_type     = 'AWT'
    AND aid.invoice_id   = :INVOICE_ID
  )

 

 This below Query helps to extract the With holding tax groups information's which has applied in the Payables Invoice distributions  and in the Invoice Headers itself.

SELECT DISTINCT
  awt.*
FROM
  ap_awt_groups awt
WHERE
  awt.group_id IN
  (
    SELECT DISTINCT
      aid.awt_group_id
    FROM
      ap_invoice_distributions_all aid
    WHERE
      aid.awt_group_id IS NOT NULL
    AND aid.invoice_id  = :INVOICE_ID
    UNION
    SELECT DISTINCT
      aid.pay_awt_group_id
    FROM
      ap_invoice_distributions_all aid
    WHERE
      aid.pay_awt_group_id IS NOT NULL
    AND aid.invoice_id      = :INVOICE_ID
    UNION
    SELECT DISTINCT
      ai.awt_group_id
    FROM
      ap_invoices_all ai
    WHERE
      ai.awt_group_id IS NOT NULL
    AND ai.invoice_id  = :INVOICE_ID
    UNION
    SELECT DISTINCT
      ai.pay_awt_group_id
    FROM
      ap_invoices_all ai
    WHERE
      ai.pay_awt_group_id IS NOT NULL
    AND ai.invoice_id      = :INVOICE_ID
  );

Withholding tax table in oracle Payables r12 : Withholding tax table Details in Oracle Payables r12