Query to get E-Biz Tax Details in Oracle Apps

 SELECT xe.name entity_name

      ,ledger.name ledger_name

      ,hou.name operating_unit

      ,zxr.tax_regime_code tax_regime_code

      ,zxr.tax tax_code

      ,zxr.inclusive_tax_flag

      ,zxr.tax_status_code tax_status_code

      ,zxr.tax_rate_code tax_rate_code

      ,zxr.tax_jurisdiction_code

      ,zxr.rate_type_code

      ,zxr.percentage_rate

      ,zxr.effective_from rate_effective_from

      ,zxr.effective_to rate_effective_to

      ,acct.tax_account_ccid

      ,gcc.concatenated_segments tax_account

  FROM zx_rates_vl zxr

      ,zx_accounts acct

      ,hr_operating_units hou

      ,gl_ledgers ledger

      ,gl_code_combinations_kfv gcc

      ,xle_entity_profiles xe

 WHERE     1 = 1

       AND acct.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 = acct.tax_account_ccid

       AND hou.organization_id = acct.internal_organization_id

       AND acct.tax_account_entity_id = zxr.tax_rate_id

       AND hou.default_legal_context_id = xe.legal_entity_id

--AND zxr.tax_regime_code = 'XX'

--AND zxr.tax_rate_code = 'XX'

--AND xe.legal_entity_identifier = 'XX12345'