Introduction
This post is about to GST TAX Details query in 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’);
Got any queries?
Do drop a note by writing us at doyen.ebiz@gmail.com or use the comment section below to ask your questions.
