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



4 comments:

  1. Excellent blog I visit this blog it's really awesome. The important thing is that in this blog content written clearly and understandable. The content of information is very informative.
    Magnificent blog I visit this blog it's extremely wonderful. Interestingly, in this blog content composed plainly and reasonable. The substance of data is useful.
    Oracle Fusion HCM Online Training
    Oracle Fusion SCM Online Training
    Oracle Fusion Financials Online Training
    Big Data and Hadoop Training In Hyderabad
    oracle fusion financials classroom training
    Oracle Fusion HCM Classroom Training
    oracle cpq online training / Oracle CPQ Class Room Training
    Oracle Taleo Online Training

    ReplyDelete
  2. Thanks for posting, it's helps to enhance the people knowledge. Contact Vakilsearch expert to GST Registration

    ReplyDelete