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…
Read More