Oracle EBS EBTAX-EBTAX Tax Rates

Oracle EBS EBTAX-EBTAX Tax Rates

Tables:-
ZX_RATES_VL
ZX_ACCOUNTS
ZX_RATES_B
AP_ZX_RATES_B

SQL Example:-

SELECT
 ratetleo.tax_regime_code
 ,ratetleo.tax
 ,ratetleo.tax_status_code
,ratetleo.tax_rate_name
,ratetleo.tax_rate_code
,ratetleo.tax_jurisdiction_code
,(SELECT DISTINCT a.content_owner_name
  FROM APPS.ZX_MCO_EO_RATES_V a
  WHERE a.tax_rate_id=ratetleo.tax_rate_id
  ) "Configuration Owner"
  ,ratetleo.rate_type_code
  ,ratetleo.percentage_rate
  ,ratetleo.effective_FROM
  ,ratetleo.effective_to
  ,ratetleo.active_flag
  ,ratetleo.vat_transaction_type_code "Tax Transaction Type"
  ,ratetleo.description "Tax Rate Description"
  ,ratetleo.default_rec_rate_code "Default Recovery Rate Code"
  ,ratetleo.recovery_type_code 
  ,ratetleo.recovery_rule_code
  ,ratetleo.def_rec_settlement_option_code
  ,ratetleo.offset_tax_rate_code
  ,ratetleo.offset_tax
  ,ratetleo.offset_status_code
  ,ratetleo.default_rate_flag
  ,ratetleo.default_flg_effective_FROM
  ,ratetleo.default_flg_effective_to
  ,ratetleo.inclusive_tax_flag
  ,ratetleo.tax_inclusive_override_flag
  ,ratetleo.allow_exemptions_flag
  ,ratetleo.allow_exceptions_flag
  ,ratetleo.allow_adhoc_tax_rate_flag
  ,ratetleo.adj_for_adhoc_amt_code
  ,ratetleo.taxable_basis_formula_code
  ,ratetleo.attribute1  "Tax Exempt"
  ,ratetleo.attribute9  "Auto Invoice-Duplicate Rates"
  ,ratetleo.attribute11 "Item Model"
  ,ratetleo.attribute10 "Tax Denomination"
  ,ap_ext.ATTRIBUTE1 TAX_CLASS
  ,ap_ext.ATTRIBUTE2 XCHANGE_PAY_WTH
  ,ap_ext.ATTRIBUTE3 TXN_TYPE
  ,ar_ext.ATTRIBUTE1 Tax_Class
  ,ar_ext.ATTRIBUTE2 Transaction_Type
  ,ar_ext.ATTRIBUTE3 Perception_Rate
  ,ar_ext.ATTRIBUTE4 IGV_Type
  ,ar_ext.ATTRIBUTE5 ISC_Type
  ,ar_ext.ATTRIBUTE6 Other_Concepts
  ,ar_ext.ATTRIBUTE7 Value_Type
  ,ar_ext.ATTRIBUTE8 Perception_Regimen
  FROM
  APPS.ZX_RATES_VL ratetleo,
  APPS.ZX_ACCOUNTS B,
  APPS.HR_OPERATING_UNITS HOU,
   APPS.ZX_RATES_B ar_ext,
  APPS.AP_ZX_RATES_B ap_ext
  WHERE 1=1 AND b.internal_organization_id = hou.organization_id
AND b.tax_account_entity_code  = 'RATES'
AND b.tax_account_entity_id    = ratetleo.tax_rate_id
AND ratetleo.active_flag = 'Y'
AND SYSDATE BETWEEN ratetleo.effective_FROM AND NVL(ratetleo.effective_to, SYSDATE)
AND RateTLEO.tax_rate_id=ap_ext.tax_rate_id(+)
AND RateTLEO.tax_rate_id=ar_ext.tax_rate_id(+) ;