Supplier Name Wise Invoice withholding Tax Group Name in Oracle Apps EBS R12

----***************************************************************************----
----  Supplier Name Wise Invoice withholding Tax Group Name in Oracle Apps EBS R12            ----
----***************************************************************************----


SELECT APS.VENDOR_ID,APS.VENDOR_NAME,APSS.VENDOR_SITE_CODE, AWTG.DESCRIPTION
FROM AP_SUPPLIERS APS,
     AP_SUPPLIER_SITES_ALL APSS,
     AP_AWT_GROUPS AWTG
WHERE APS.VENDOR_ID       = APSS.VENDOR_ID
AND   APSS.ALLOW_AWT_FLAG = 'Y'
AND   APSS.AWT_GROUP_ID   = AWTG.GROUP_ID
AND   APS.VENDOR_NAME like  '%Maan Engineering%';