GST TAX Details For EBS R12

select

decode(substr(h.tax_rate_code,1,4),'SGST',nvl(h.unround_tax_amt_tax_curr,0)) SGST_AMT ,

decode(substr(h.tax_rate_code,1,4),'CGST',nvl(h.unround_tax_amt_tax_curr,0)) CGST_AMT ,

decode(substr(h.tax_rate_code,1,4),'SGST',nvl(h.tax_rate_percentage,0))      SGST_RATE,

decode(substr(h.tax_rate_code,1,4),'CGST',nvl(h.tax_rate_percentage,0))      CGST_RATE,

h.first_party_primary_reg_num GST_NUM,

h.third_party_primary_reg_num CUSOMER_GST_NUM,

h.ledger_id LEDGER_ID ,

h.trx_number INVOICE_NUM,(SELECT jra.reporting_code

FROM jai_reporting_associations jra,

jai_item_templ_hdr jit

WHERE jra.entity_id = jit.template_hdr_id

AND jra.entity_code = 'ITEM'

AND jra.entity_source_table = 'JAI_ITEM_TEMPL_HDR'

AND ROWNUM = 1) "HSN/SAC Code"

from

jai_tax_lines_all h

where h.trx_number=:trx_number

and substr(h.tax_rate_code,1,4) IN('CGST','SGST');