----***************************************************************************----
---- 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%';
