Query to get the tax type and tax accounts details.

SELECT hou.name Entity_name,

tax_type_id,

tax_type_code,

tax_type_name,

(SELECT concatenated_segments

FROMapps.gl_code_combinations_kfv

WHEREcode_combination_id=interim_recovery_ccid) interim_recovery_ccid,

(SELECT concatenated_segments

FROMapps.gl_code_combinations_kfv

WHEREcode_combination_id=recovery_ccid) recovery_ccid,

(SELECT concatenated_segments

FROMapps.gl_code_combinations_kfv

WHEREcode_combination_id=interim_liability_ccid) interim_liability_ccid,

(SELECT concatenated_segments

FROMapps.gl_code_combinations_kfv

WHEREcode_combination_id=liability_ccid) liability_ccid

FROM apps.jai_tax_types_v tv,

apps.jai_tax_accounts ta,

apps.hr_operating_units hou

WHERE tax_type_id=tax_account_entity_id

AND hou.organization_id=ta.org_id;