select b.NAME Group_Name,
c.TAX_NAME Tax_code,
c.TAX_RATE,
d.ATTRIBUTE5 Section,
d.ATTRIBUTE3 Tax_Regime,
d.ATTRIBUTE4 IRIS_TAX_CODES,
d.ATTRIBUTE6 Exemption_Code_Blank_Space,
b.DESCRIPTION Group_Description,
d.DESCRIPTION Tax_name_Description,
c.START_DATE,
f.VENDOR_SITE_CODE Site,
d.ATTRIBUTE1 DFF_SECTION,
d.ATTRIBUTE2 DFF_DESCRIPTION,
gc.SEGMENT1 Company,
gc.SEGMENT2 Location,
gc.SEGMENT4 Account
from AP_AWT_GROUP_TAXES_ALL a,
Ap_Tax_Codes_All d,
Ap_Awt_Tax_Rates_All c,
AP_AWT_GROUPS b,
ap_supplier_sites_all f,
gl_code_combinations gc
where d.NAME = a.TAX_NAME
and d.ORG_ID = a.ORG_ID
and a.TAX_NAME = c.TAX_NAME
and c.TAX_NAME = d.NAME
and c.ORG_ID = a.ORG_ID
and f.VENDOR_SITE_ID = d.AWT_VENDOR_SITE_ID
and b.GROUP_ID = a.GROUP_ID
and f.VENDOR_ID = d.AWT_VENDOR_ID
and gc.CODE_COMBINATION_ID = d.TAX_CODE_COMBINATION_ID
and c.RATE_TYPE = 'STANDARD'
and d.ENabLED_FLAG = 'Y'
and c.END_DATE is null
order by group_name
