Blog / Category
Tax
5 articles in this category
Find tax intended use for an Item
SELECT NVL (attribute_value, ‘N’) FROM jai_item_templ_hdr_v jih, jai_item_templ_dtls_v jid WHERE 1 = 1 AND jih.template_hdr_id = jid.template_hdr_id AND jid.att…
India Tax Insert script
CREATE OR REPLACE PROCEDURE_iso_gst_tax_prc (p_trx_number VARCHAR2) AS CURSOR c IS SELECT prla.requisition_header_id, prla.requisition_line_id, prla.source_orga…
Journal Tax
Setup to create Tax Journals This Document explains the configuration needed for Journal level taxes.
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_t…
AR Transactions and Tax Query – India Localization
SELECT TO_CHAR (trx_date, ‘DD-MON-YYYY’) ar_posting_date, TO_CHAR (jatt.excise_invoice_date, ‘DD-MON-YYYY’) excise_invoice_date, &nbs…