Oracle EBS GST-Tax Type

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

Tables:-
JAI_REGIMES
JAI_TAX_TYPES
jai_tax_accounts
jai_reporting_associations

SELECT DISTINCT
jr.REGIME_CODE "Tax Regime Code"
,jr.REGIME_NAME  "Tax Regime Name"
,jtt.TAX_TYPE_CODE  "Tax Type Code"
,jtt.TAX_TYPE_NAME  "Tax Type"
,jtt.EFFECTIVE_FROM "Start Date"
,jtt.EFFECTIVE_TO "End Date"
,jtt.RECOVERABLE_FLAG "Recoverable tax"
,jtt.ALLOW_ABATEMENT "Allow abatement"
,jtt.OFFSET_FLAG  "Applicable for offset"
,jtt.SELF_ASSESSED_FLAG "Self asses./reverse charge"
,jtt.REPORTING_ONLY_FLAG  "Set tax type for reporting"
,jtt.UPDATE_VENDOR_ON_TRANSACTION "Update vendor on trans"
,jtt.WTHLD_TRX_APPLICABLE_FLAG  "WHT Tax applicable"
,jtt.TAX_POINT_BASIS  "Tax Point Basis"
,gsob.NAME  "Ledger"
,hou.name "Operating Unit"
,ood.ORGANIZATION_NAME  "Inventory Organization"
,hla.DESCRIPTION  "Location"
,gcck.CONCATENATED_SEGMENTS "Interim Recovery"
,gcck.CONCATENATED_SEGMENTS "Recovery"
,gcck1.CONCATENATED_SEGMENTS "Interim Liability"
,gcck1.CONCATENATED_SEGMENTS "Liability"
,gcck2.CONCATENATED_SEGMENTS "Expense"
,gcck3.CONCATENATED_SEGMENTS "Rounding Account"
,gcck4.CONCATENATED_SEGMENTS "Suspense Account"
,gcck5.CONCATENATED_SEGMENTS "Advanced Suspense"
,jra.REPORTING_TYPE_NAME  "Reporting Type Name"
,jra.REPORTING_CODE "Reporting Code"
,jra.REPORTING_CODE_DESCRIPTION "Reporting Code Description"
,jra.EFFECTIVE_FROM "Reporting Start Date"
,jra.EFFECTIVE_TO "Reporting End Date"
FROM
APPS.JAI_REGIMES jr,
APPS.JAI_TAX_TYPES  jtt,
APPS.jai_tax_accounts  jta,
APPS.GL_SETS_OF_BOOKS  gsob,
APPS.hr_operating_units  hou,
APPS.org_organization_definitions  ood,
APPS.hr_locations_all  hla,
APPS.GL_CODE_COMBINATIONS_KFV gcck,
APPS.GL_CODE_COMBINATIONS_KFV gcck1,
APPS.GL_CODE_COMBINATIONS_KFV gcck2,
APPS.GL_CODE_COMBINATIONS_KFV gcck3,
APPS.GL_CODE_COMBINATIONS_KFV gcck4,
APPS.GL_CODE_COMBINATIONS_KFV gcck5,
APPS.jai_reporting_associations  jra
WHERE 1=1
AND jr.regime_id=jtt.regime_id
AND jtt.TAX_TYPE_ID=jta.TAX_ACCOUNT_ENTITY_ID
AND jta.LEDGER_ID=gsob.SET_OF_BOOKS_ID
AND jta.ORG_ID=hou.ORGANIZATION_ID
AND jta.ORGANIZATION_ID=ood.ORGANIZATION_ID
AND jta.LOCATION_ID=hla.LOCATION_ID
AND jta.INTERIM_RECOVERY_CCID=gcck.CODE_COMBINATION_ID(+)
AND jta.RECOVERY_CCID=gcck.CODE_COMBINATION_ID(+)
AND jta.INTERIM_LIABILITY_CCID=gcck1.CODE_COMBINATION_ID(+)
AND jta.LIABILITY_CCID=gcck1.CODE_COMBINATION_ID(+)
AND jta.EXPENSE_CCID=gcck2.CODE_COMBINATION_ID(+)
AND jta.ROUNDING_CCID=gcck3.CODE_COMBINATION_ID(+)
AND jta.SUSPENSE_CCID=gcck4.CODE_COMBINATION_ID(+)
AND jta.ADVRCPT_SUSPENSE_CCID=gcck5.CODE_COMBINATION_ID(+)
AND jtt.TAX_TYPE_ID=jra.ENTITY_ID(+)
AND jtt.TAX_TYPE_CODE=jra.REPORTING_CODE(+)
AND hou.name= '&&';