Oracle EBS GST-Commn Configuration

Oracle EBS GST-Commn Configuration
Configuration:Commn Configuration,
Responsibility:Oracle Financials For India,
Navigation:Tax Configuration ->Define Common Configuration

Tables:-
JAI_TAX_CONFIGURATIONS
JAI_TAX_DEFAULTING_BASIS

SQL Example:-

SELECT
'Operating Unit' as "Organization Type"
,e.name "Organization Name"
,(SELECT PARTY_SITE_NAME from hz_party_sites WHERE location_id=f.LOCATION_ID) "Location"
,b.TAX_DEFAULTING_BASIS "Defaulting Basis"
,b.MAX_DAYS
,b.EFFECTIVE_FROM
,b.EFFECTIVE_TO
,b.COPY_TAX_FROM_SOURCE
,(SELECT jr.REGIME_CODE
FROM    APPS.JAI_REGIMES jr, APPS.JAI_TAX_RATES jtr , APPS.hr_organization_units hou
WHERE jr.REGIME_ID=jtr.REGIME_ID
AND jtr.ORG_ID=hou.ORGANIZATION_ID
AND hou.ORGANIZATION_ID=e.ORGANIZATION_ID 
AND REGIME_TYPE='W'
AND COUNTRY_CODE='IN'
AND REGIME_JURISDICTION='COUNTRY')  "Tax Regim"
,(SELECT jtc.TAX_CATEGORY_NAME
FROM    APPS.JAI_REGIMES jr, APPS.JAI_TAX_RATES jtr , APPS.hr_organization_units hr,APPS.JAI_TAX_CATEGORIES jtc
WHERE jr.REGIME_ID=jtr.REGIME_ID
AND jtr.ORG_ID=hr.ORGANIZATION_ID
AND hr.ORGANIZATION_ID=e.ORGANIZATION_ID 
AND REGIME_TYPE='W'
AND COUNTRY_CODE='IN'
AND REGIME_JURISDICTION='COUNTRY'
AND jtr.ORG_ID=jtc.ORG_ID
AND (jtr.TAX_RATE_CODE LIKE ('%'||jtc.TAX_CATEGORY_NAME||'%'))) "Tax Category"
,a.APPROVED_INVOICE_FLAG
,a.APPROVED_TDS_FLAG
,a.DSPTCH_EXCEED_ORG_QTY_FLAG
,a.OSP_RETURN_DAYS
FROM APPS.JAI_TAX_CONFIGURATIONS a,
APPS.jai_tax_defaulting_basis b,
APPS.hr_organization_units e,
APPS.hr_locations_all f
WHERE 1=1
AND a.LOCATION_ID(+)=f.LOCATION_ID
AND b.ORG_ID=e.ORGANIZATION_ID
AND e.LOCATION_ID=f.LOCATION_ID
AND e.name= '&&';