Oracle EBS GST-Tax Category

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

Tables:-
JAI_TAX_CATEGORIES
jai_tax_category_lines
JAI_TAX_RATES
JAI_REGIMES
JAI_TAX_TYPES
jai_tax_category_lines_v

Example:-

SELECT DISTINCT
hou.name  "Opearting Unit"
,jtc.TAX_CATEGORY_NAME  "Tax Category"
,jtc.TAX_CATEGORY_DESC  "Description"
,jtc.ITEM_CLASS_CODE  "Item Class"
,jtc.ITEM_CLASS_CODE  "Item Class Code"
,jtc.EFFECTIVE_FROM "Start Date"
,jtc.EFFECTIVE_TO "End Date"
,jtcl.LINE_NUMBER "Num"
,jtr.TAX_RATE_NAME  "Tax Rate"
,jr.REGIME_CODE "Regime Code"
,jtt.TAX_TYPE_NAME  "Tax Type"
,jtcl.PRECEDENCE_1  "1"
,jtcl.PRECEDENCE_2  "2"
,jtcl.PRECEDENCE_3  "3"
,jtcl.PRECEDENCE_4  "4"
,jtcl.PRECEDENCE_5  "5"
,jtcl.PRECEDENCE_6  "6"
,jtcl.PRECEDENCE_7  "7"
,jtcl.PRECEDENCE_8  "8"
,jtcl.PRECEDENCE_9  "9"
,jtcl.PRECEDENCE_10  "10"
,jtcl.PRECEDENCE_11  "11"
,jtcl.PRECEDENCE_12  "12"
,jtcl.PRECEDENCE_13  "13"
,jtcl.PRECEDENCE_14  "14"
,jtcl.PRECEDENCE_15  "15"
,jtcl.PRECEDENCE_16  "16"
,jtcl.PRECEDENCE_17  "17"
,jtcl.PRECEDENCE_18  "18"
,jtcl.PRECEDENCE_19  "19"
,jtcl.PRECEDENCE_20  "20"
,jtclv.RECOVERABLE_FLAG "Recoverable"
,jtclv.INCLUSIVE_FLAG  "Inclusive"
,jtclv.SELF_ASSESSED_FLAG "Self Assessed"
FROM
APPS.JAI_TAX_CATEGORIES jtc,
APPS.hr_operating_units  hou,
APPS.jai_tax_category_lines  jtcl,
APPS.JAI_TAX_RATES jtr,
APPS.JAI_REGIMES jr,
APPS.JAI_TAX_TYPES  jtt,
APPS.jai_tax_category_lines_v  jtclv
WHERE 1=1
AND jtc.ORG_ID=hou.ORGANIZATION_ID
AND jtc.ORG_ID=jtr.ORG_ID
AND jtc.TAX_CATEGORY_ID=jtcl.TAX_CATEGORY_ID
AND jtcl.TAX_RATE_ID=jtr.TAX_RATE_ID
AND jtcl.REGIME_ID=jr.REGIME_ID
AND jtcl.TAX_TYPE_ID=jtt.TAX_TYPE_ID
AND jtcl.REGIME_ID=jtt.REGIME_ID
AND jtcl.TAX_CATEGORY_LINE_ID=jtclv.TAX_CATEGORY_LINE_ID
AND jtcl.TAX_CATEGORY_ID=jtclv.TAX_CATEGORY_ID
AND hou.name= '&&';