Oracle EBS EBTAX-Tax Rates Accounts

Oracle EBS EBTAX-Tax Rates Accounts

Tables:-
ZX_RATES_VL
ZX_ACCOUNTS
GL_LEDGERS
GL_CODE_COMBINATIONS_KFV

SQL Example:-

SELECT
hou.name  "Operationg Unit"
,zxr.tax_regime_code
,zxr.tax
,zxr.tax_status_code
,zxr.tax_rate_code
,zxr.tax_jurisdiction_code
,zxr.rate_type_code
,zxr.percentage_rate
,zxr.effective_FROM
,zxr.effective_to
,zxr.active_flag
,led.name "Ledger Name"
,gcc.concatenated_segments  "Liability Account"
FROM APPS.ZX_RATES_VL ZXR,
  APPS.ZX_ACCOUNTS B,
  APPS.HR_OPERATING_UNITS HOU,
APPS.GL_LEDGERS LED,
  APPS.GL_CODE_COMBINATIONS_KFV GCC WHERE 1=1 AND b.internal_organization_id = hou.organization_id
AND led.ledger_id                = hou.set_of_books_id
AND b.tax_account_entity_code    = 'RATES'
AND b.tax_account_entity_id      = zxr.tax_rate_id
AND gcc.code_combination_id      = b.tax_account_ccid
AND zxr.active_flag  = 'Y'
AND SYSDATE BETWEEN zxr.effective_FROM AND NVL(zxr.effective_to, SYSDATE);