Query to get E-Biz Tax Details in Oracle Apps

 SELECT xep.name entity_name

      ,ledger.name                  ledger

  ,hou.name                     operating_unit

  ,zxr.tax_regime_code          tax_regime_code

  ,zxr.tax                      tax_code

  ,zxr.inclusive_tax_flag       inclusive_tax_flag

  ,zxr.tax_status_code          tax_status_code

  ,zxr.tax_rate_code            tax_rate_code

  ,zxr.tax_jurisdiction_code    tax_jurisdiction_code

  ,zxr.rate_type_code           rate_type_code

  ,zxr.percentage_rate          percentage_rate

  ,zxr.effective_from           rate_effective_from

  ,zxr.effective_to             rate_effective_to   

  ,account.tax_account_ccid     tax_account_ccid

  ,gcc.concatenated_segments    tax_account

  FROM zx_rates_vl    zxr

      ,zx_accounts         account

  ,hr_operating_units  hou

  ,gl_ledgers          ledger

  ,gl_code_combinations_kfv  gcc

  ,xle_entity_profiles xep

 WHERE account.tax_account_entity_code = 'RATES'

   AND zxr.active_flag = 'Y'

   AND TRUNC (SYSDATE) BETWEEN TRUNC (zxr.effective_from) AND NVL (TRUNC (zxr.effective_to), TRUNC (SYSDATE) + 1)

   AND ledger.ledger_id = hou.set_of_books_id

   AND gcc.code_combination_id = account.tax_account_ccid

   AND hou.organization_id = account.internal_organization_id

   AND account.tax_account_entity_id = zxr.tax_rate_id

   and hou.default_legal_context_id = xep.legal_entity_id

   --AND zxr.tax_regime_code = 'TAX_REGIME_CODE'

   --AND zxr.tax_rate_code = 'TAX_RATE_CODE'