How to remove ADHOC tax cases from the query for a PO?.

Hi ,

What is the table name to get tax name ?

The ADHOC tax name show Zero/Null tax rate in the ‘tax rate’ column and a certain tax amount in the ‘Tax Amount’ column . Need to remove the ADHOC types.

Please provide update from the below query it is urgent.

-----------------------------------------------------------

SELECT * FROM (

SELECT  (SELECT NAME

          FROM hr_operating_units hou

         WHERE hou.organization_id = poh.org_id) circle,

         (SELECT nvl(SUM(tax_rate),0)

          FROM apps.jai_po_taxes

          WHERE poh.po_header_id = po_header_id

          AND poh.vendor_id = vendor_id

          AND pol.po_header_id = po_header_id