[Home] [Help]
501: a.qty_rate,
502: a.tax_rate, a.tax_amount, a.uom, b.end_date valid_date,
503: decode(upper(b.tax_type),'EXCISE', 1, 'ADDL. EXCISE', 1, 'OTHER EXCISE', 1, 'CVD',1, 'TDS', 2, 0) tax_type_val,
504: b.mod_cr_Percentage, b.vendor_id, b.tax_type, NVL( b.rounding_factor, 0 ) rnd
505: FROM JAI_AR_TRX_TAX_LINES a, JAI_CMN_TAXES_ALL b
506: WHERE a.link_to_cust_trx_line_id = p_line_id
507: AND a.tax_id = b.tax_id
508: ORDER BY a.tax_line_no;
509:
1212: CURSOR Get_Receipt_taxes IS SELECT a.tax_id tax_id_po, a.tax_line_no tax_line_no_po, c.tax_id , c.tax_line_no,
1213: a.precedence_1 p_1, a.precedence_2 p_2, a.precedence_3 p_3, a.precedence_4 p_4, a.precedence_5 p_5,
1214: a.precedence_6 p_6, a.precedence_7 p_7, a.precedence_8 p_8, a.precedence_9 p_9, a.precedence_10 p_10,
1215: c.qty_rate, c.tax_rate, c.tax_amount, c.uom
1216: FROM JAI_PO_TAXES a, JAI_CMN_TAXES_ALL b, JAI_RCV_LINE_TAXES c
1217: WHERE c.tax_line_no > nvl(v_tax_line_no,0)
1218: AND a.tax_id = b.tax_id
1219: AND c.tax_id = b.tax_id
1220: AND (c.shipment_line_id,a.line_location_id) = (SELECT shipment_line_id,po_line_location_id
1529: , b.inclusive_tax_flag --Add by Kevin Cheng for inclusive tax Dec 12, 2007
1530: FROM
1531: JAI_OM_OE_SO_TAXES a ,
1532: jai_regime_tax_types_v aa, -- Add by Xiao for GST refer to bug#10043656.
1533: JAI_CMN_TAXES_ALL b
1534: WHERE a.line_id = p_line_id
1535: AND a.tax_id = b.tax_id
1536: AND aa.tax_type(+) = b.tax_type -- Add by Xiao for GST refer to bug#10043656.
1537: ORDER BY
1582: , b.inclusive_tax_flag --Add by Kevin for inclusive tax Dec 12, 2007
1583: FROM
1584: jai_cmn_document_taxes a ,
1585: jai_regime_tax_types_v aa , -- Add by Xiao for GST refer to bug#10043656.
1586: jai_cmn_taxes_all b ,
1587: jai_mtl_trxs c /* jai_mtl_trxs_temp is modified as jai_mtl_trxs by Vijay for ReArch. bug#2942973 */
1588: WHERE
1589: a.source_doc_line_id = p_line_id AND
1590: a.tax_id = b.tax_id AND
1625: AND jrttv.regime_code = jai_constants.vat_regime), 5,
1626: 'VAT REVERSAL', 6, 0)) tax_type_val,
1627: b.mod_cr_Percentage, b.vendor_id, b.tax_type, NVL( b.rounding_factor, 0 ) rnd, b.adhoc_flag /* Added for bug 5091874*/
1628: , b.inclusive_tax_flag --Add by Kevin Cheng for inclusive tax Dec 12, 2007
1629: FROM JAI_AR_TRX_TAX_LINES a, JAI_CMN_TAXES_ALL b,
1630: jai_regime_tax_types_v aa -- Add by Xiao for GST refer to bug#10043656.
1631: WHERE a.link_to_cust_trx_line_id = p_line_id
1632: AND a.tax_id = b.tax_id
1633: AND aa.tax_type(+) = b.tax_type -- Add by Xiao for GST refer to bug#10043656.
1767: WHERE delivery_detail_id = cp_delivery_detail_id;
1768:
1769: CURSOR c_oe_excise_cess_cnt(cp_order_line_id IN NUMBER) IS
1770: SELECT count(1)
1771: FROM JAI_OM_OE_SO_TAXES a, JAI_CMN_TAXES_ALL b
1772: WHERE a.line_id = cp_order_line_id
1773: AND a.tax_id = b.tax_id
1774: AND b.tax_type = p_Cess_type_code;/*Bug 5989740 bduvarag*/
1775:
1774: AND b.tax_type = p_Cess_type_code;/*Bug 5989740 bduvarag*/
1775:
1776: CURSOR c_ar_excise_cess_cnt(cp_customer_trx_line_id IN NUMBER) IS
1777: SELECT count(1)
1778: FROM JAI_AR_TRX_TAX_LINES a, JAI_CMN_TAXES_ALL b
1779: WHERE a.link_to_cust_trx_line_id = cp_customer_trx_line_id
1780: AND a.tax_id = b.tax_id
1781: AND b.tax_type = p_Cess_type_code ;/*Bug 5989740 bduvarag*/
1782:
1889:
1890: 4 21/07/2004 Vijay Shankar for Budget2004 Bug# 3781299, Version: 115.1
1891: Education Cess has been introduced in Budget 2004, which will be calculated on all excise taxes.
1892: Code is modified to make Education Cess Tax_rate as 0 in MAIN Cursor itself if
1893: JAI_CMN_TAXES_ALL.stform_type='EXCISE - CESS' and 'EXCISE-CESS'/'CVD-CESS' exist in Receipt
1894: Separate function is written to check(1) whether Cess tax exist in sales order/AR Manual Invoice line,
1895: if exists then check(2) for ExciseCess tax is receipts, If exists then return 1 else 0. If any of the
1896: check (1),(2) fails then function returns -1.
1897: Function excise_cess_check is added with this code change. Also Cursors oe_tax_cur and ar_tax_cur are modified