Tax_catagure

SELECT   txh.org_id, txh.tax_category_name, tax.tax_name, tax.tax_descr,
         tax.tax_type, GLCC.CONCATENATED_SEGMENTS TAX_ACCOUNT , tax.tax_rate, tax.adhoc_flag,
         tax.mod_cr_percentage,tax.modifiable_flag, tax.orig_tax_percentage,
         tax.rounding_factor, txl.line_no, txl.precedence_1, txl.precedence_2,
         txl.precedence_3, txl.precedence_4
    FROM jai_cmn_tax_ctgs_all txh,
         jai_cmn_tax_ctg_lines txl,
         jai_cmn_taxes_all tax,
         GL_CODE_COMBINATIONS_KFV GLCC
   WHERE txh.tax_category_id = txl.tax_category_id
          AND txl.tax_id = tax.tax_id
     AND GLCC.CODE_COMBINATION_ID = TAX.TAX_ACCOUNT_ID
ORDER BY txh.tax_category_name,
TXL.LINE_NO