[Home] [Help]
442: a.qty_rate,
443: a.tax_rate, a.tax_amount, a.uom, b.end_date valid_date,
444: decode(upper(b.tax_type),'EXCISE', 1, 'ADDL. EXCISE', 1, 'OTHER EXCISE', 1, 'CVD',1, 'TDS', 2, 0) tax_type_val,
445: b.mod_cr_Percentage, b.vendor_id, b.tax_type, NVL( b.rounding_factor, 0 ) rnd
446: FROM JAI_AR_TRX_TAX_LINES a, JAI_CMN_TAXES_ALL b
447: WHERE a.link_to_cust_trx_line_id = p_line_id
448: AND a.tax_id = b.tax_id
449: ORDER BY a.tax_line_no;
450:
1153: 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,
1154: 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,
1155: 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,
1156: c.qty_rate, c.tax_rate, c.tax_amount, c.uom
1157: FROM JAI_PO_TAXES a, JAI_CMN_TAXES_ALL b, JAI_RCV_LINE_TAXES c
1158: WHERE c.tax_line_no > nvl(v_tax_line_no,0)
1159: AND a.tax_id = b.tax_id
1160: AND c.tax_id = b.tax_id
1161: AND (c.shipment_line_id,a.line_location_id) = (SELECT shipment_line_id,po_line_location_id
1456: b.adhoc_flag /* Added bug 5091874 */
1457: , b.inclusive_tax_flag --Add by Kevin Cheng for inclusive tax Dec 12, 2007
1458: FROM
1459: JAI_OM_OE_SO_TAXES a ,
1460: JAI_CMN_TAXES_ALL b
1461: WHERE
1462: a.line_id = p_line_id AND
1463: a.tax_id = b.tax_id
1464: ORDER BY
1506: b.adhoc_flag
1507: , b.inclusive_tax_flag --Add by Kevin for inclusive tax Dec 12, 2007
1508: FROM
1509: jai_cmn_document_taxes a ,
1510: jai_cmn_taxes_all b ,
1511: jai_mtl_trxs c /* jai_mtl_trxs_temp is modified as jai_mtl_trxs by Vijay for ReArch. bug#2942973 */
1512: WHERE
1513: a.source_doc_line_id = p_line_id AND
1514: a.tax_id = b.tax_id AND
1541: lv_sh_cvd_cess_code,4,
1542: 0) tax_type_val,
1543: b.mod_cr_Percentage, b.vendor_id, b.tax_type, NVL( b.rounding_factor, 0 ) rnd, b.adhoc_flag /* Added for bug 5091874*/
1544: , b.inclusive_tax_flag --Add by Kevin Cheng for inclusive tax Dec 12, 2007
1545: FROM JAI_AR_TRX_TAX_LINES a, JAI_CMN_TAXES_ALL b
1546: WHERE a.link_to_cust_trx_line_id = p_line_id
1547: AND a.tax_id = b.tax_id
1548: ORDER BY a.tax_line_no;
1549:
1672: WHERE delivery_detail_id = cp_delivery_detail_id;
1673:
1674: CURSOR c_oe_excise_cess_cnt(cp_order_line_id IN NUMBER) IS
1675: SELECT count(1)
1676: FROM JAI_OM_OE_SO_TAXES a, JAI_CMN_TAXES_ALL b
1677: WHERE a.line_id = cp_order_line_id
1678: AND a.tax_id = b.tax_id
1679: AND b.tax_type = p_Cess_type_code;/*Bug 5989740 bduvarag*/
1680:
1679: AND b.tax_type = p_Cess_type_code;/*Bug 5989740 bduvarag*/
1680:
1681: CURSOR c_ar_excise_cess_cnt(cp_customer_trx_line_id IN NUMBER) IS
1682: SELECT count(1)
1683: FROM JAI_AR_TRX_TAX_LINES a, JAI_CMN_TAXES_ALL b
1684: WHERE a.link_to_cust_trx_line_id = cp_customer_trx_line_id
1685: AND a.tax_id = b.tax_id
1686: AND b.tax_type = p_Cess_type_code ;/*Bug 5989740 bduvarag*/
1687:
1794:
1795: 4 21/07/2004 Vijay Shankar for Budget2004 Bug# 3781299, Version: 115.1
1796: Education Cess has been introduced in Budget 2004, which will be calculated on all excise taxes.
1797: Code is modified to make Education Cess Tax_rate as 0 in MAIN Cursor itself if
1798: JAI_CMN_TAXES_ALL.stform_type='EXCISE - CESS' and 'EXCISE-CESS'/'CVD-CESS' exist in Receipt
1799: Separate function is written to check(1) whether Cess tax exist in sales order/AR Manual Invoice line,
1800: if exists then check(2) for ExciseCess tax is receipts, If exists then return 1 else 0. If any of the
1801: check (1),(2) fails then function returns -1.
1802: Function excise_cess_check is added with this code change. Also Cursors oe_tax_cur and ar_tax_cur are modified