Sunday, 7 January 2018

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');



2 comments: