[Home] [Help]
364: SELECT
365: nvl(sum(so_tax.tax_amount),0)
366: FROM
367: JAI_OM_OE_SO_TAXES so_tax
368: , jai_cmn_taxes_all tax -- Added by Jia Li for inclusive tax on 2008/01/07
369: WHERE
370: line_id = pr_new.source_line_id AND
371: header_id = pr_new.source_header_id
372: AND so_tax.tax_id = tax.tax_id -- Added by Jia Li for inclusive tax on 2008/01/07
439: )
440: IS
441: SELECT 1
442: FROM JAI_OM_OE_SO_TAXES jstl ,
443: JAI_CMN_TAXES_ALL jtc ,
444: jai_regime_tax_types_v tax_types
445: WHERE jstl.line_id = cp_line_id
446: AND jstl.header_id = cp_header_id
447: AND jtc.tax_id = jstl.tax_id
454: )
455: IS
456: SELECT 1
457: FROM JAI_OM_OE_SO_TAXES jstl ,
458: JAI_CMN_TAXES_ALL jtc
459: WHERE jstl.line_id = cp_line_id
460: AND jstl.header_id = cp_header_id
461: AND jtc.tax_id = jstl.tax_id
462: AND jtc.tax_type in ( jai_constants.tax_type_excise,
1477: A.Tax_Amount,
1478: A.Base_Tax_Amount,
1479: A.Func_Tax_Amount
1480: FROM JAI_OM_OE_SO_TAXES A,
1481: JAI_CMN_TAXES_ALL b
1482: WHERE Line_id = v_source_line_id
1483: AND A.Tax_Id = b.Tax_Id
1484: ORDER BY A.Tax_Line_No;
1485: CURSOR Pick_Tax_Line_Count_Cur(P_Tax_Id NUMBER) IS
1489: AND Tax_Id = P_Tax_Id;
1490: CURSOR Get_Tot_Tax_Amount_Cur IS
1491: SELECT SUM(A.Tax_Amount)
1492: FROM JAI_OM_WSH_LINE_TAXES A,
1493: JAI_CMN_TAXES_ALL b
1494: WHERE A.Delivery_Detail_Id = v_delivery_detail_id
1495: AND b.Tax_Id = A.Tax_Id
1496: AND b.Tax_Type <> 'TDS';
1497: CURSOR Get_Delivery_Line_Count_Cur IS
1533: SELECT
1534: nvl(sum(a.func_tax_amount),0) -- cbabu for Bug# 2736191
1535: FROM
1536: JAI_CMN_MATCH_TAXES a,
1537: JAI_CMN_TAXES_ALL b
1538: WHERE
1539: a.tax_id = b.tax_id AND
1540: b.tax_type = p_tax_type AND
1541: A.ref_line_id = v_delivery_detail_id AND
1663: AND B.organization_id = p_organization_id
1664: AND B.location_id = p_location_id );
1665: CURSOR Get_Tax_Lines_Details_Cur1 IS
1666: SELECT A.Tax_Rate, NVL(b.Rounding_Factor,0) Rounding_Factor
1667: FROM JAI_OM_OE_SO_TAXES A, JAI_CMN_TAXES_ALL b
1668: WHERE Line_id = v_source_line_id
1669: AND A.Tax_Id = b.Tax_Id
1670: AND b.tax_type = 'Modvat Recovery'
1671: ORDER BY A.Tax_Line_No;
1724:
1725: CURSOR c_cess_amount (cp_delivery_id JAI_OM_WSH_LINES_ALL.DELIVERY_ID%TYPE) IS
1726: SELECT nvl(sum(jsptl.func_tax_amount),0) tax_amount
1727: FROM JAI_OM_WSH_LINE_TAXES jsptl ,
1728: JAI_CMN_TAXES_ALL jtc
1729: WHERE jtc.tax_id = jsptl.tax_id
1730: AND delivery_detail_id in
1731: (SELECT delivery_detail_id
1732: FROM JAI_OM_WSH_LINES_ALL
1742:
1743: CURSOR c_sh_cess_amount (cp_delivery_id JAI_OM_WSH_LINES_ALL.DELIVERY_ID%TYPE) IS
1744: SELECT nvl(sum(jsptl.func_tax_amount),0) tax_amount
1745: FROM JAI_OM_WSH_LINE_TAXES jsptl ,
1746: JAI_CMN_TAXES_ALL jtc
1747: WHERE jtc.tax_id = jsptl.tax_id
1748: AND delivery_detail_id in
1749: (SELECT delivery_detail_id
1750: FROM JAI_OM_WSH_LINES_ALL
1771: CURSOR cur_chk_vat_exists (cp_del_det_id JAI_OM_WSH_LINES_ALL.DELIVERY_DETAIL_ID%TYPE)
1772: IS
1773: SELECT 1
1774: FROM JAI_OM_WSH_LINE_TAXES jsptl,
1775: JAI_CMN_TAXES_ALL jtc
1776: , jai_regime_tax_types_v tax_types
1777: WHERE jsptl.delivery_detail_id = cp_del_det_id
1778: AND jtc.tax_id = jsptl.tax_id
1779: AND jtc.tax_type = tax_types.tax_type
1804: || Added by csahoo for bug#5680459
1805: || Check if only 'VAT REVERSAL' tax type is present in JAI_OM_WSH_LINE_TAXES
1806: */
1807: CURSOR c_chk_vat_reversal (cp_del_det_id JAI_OM_WSH_LINES_ALL.delivery_detail_id%TYPE,
1808: cp_tax_type JAI_CMN_TAXES_ALL.tax_type%TYPE )
1809: IS
1810: SELECT 1
1811: FROM JAI_OM_WSH_LINE_TAXES jsptl,
1812: JAI_CMN_TAXES_ALL jtc
1808: cp_tax_type JAI_CMN_TAXES_ALL.tax_type%TYPE )
1809: IS
1810: SELECT 1
1811: FROM JAI_OM_WSH_LINE_TAXES jsptl,
1812: JAI_CMN_TAXES_ALL jtc
1813: WHERE jsptl.delivery_detail_id = cp_del_det_id
1814: AND jtc.tax_id = jsptl.tax_id
1815: AND jtc.tax_type = cp_tax_type ;
1816:
1845: IS
1846: SELECT COUNT(1)
1847: FROM JAI_REGIME_TAX_TYPES_V JRTTV
1848: , JAI_OM_WSH_LINE_TAXES JSPT
1849: , JAI_CMN_TAXES_ALL JTC
1850: WHERE JTC.TAX_ID = JSPT.TAX_ID
1851: AND JTC.TAX_TYPE = JRTTV.TAX_TYPE
1852: AND REGIME_CODE = CP_REGIME_CODE
1853: AND JSPT.DELIVERY_DETAIL_ID = CP_DELIVERY_DETAIL_ID;
2008:
2009: Fix Of Bug#3158282:-
2010: Issue:-
2011: In case of non INR type of transactions with Excise type of tax the rounding precision should be maintained at 0
2012: and in all other cases the rounding factor should be picked up from JAI_CMN_TAXES_ALL.
2013:
2014: Solution:-
2015: Modified the rounding factor to reflect the above scenario. variable v_func_tax_amount gets
2016: rounded of to zero in case of non INR type of transactions ( v_curr_conv_rate <> 1) with Excise type of tax
2013:
2014: Solution:-
2015: Modified the rounding factor to reflect the above scenario. variable v_func_tax_amount gets
2016: rounded of to zero in case of non INR type of transactions ( v_curr_conv_rate <> 1) with Excise type of tax
2017: and for all other cases rounding precession is picked up from JAI_CMN_TAXES_ALL table.
2018:
2019: Dependency Introduced Due to this Bug : -
2020: None
2021:
2844: /* Get line number of the base tax (tax_type=TCS) for calculating the surcharge basically to set a precedence */
2845: select max(tax_line_no)
2846: into ln_base_line_no
2847: from JAI_OM_WSH_LINE_TAXES jsptl
2848: , JAI_CMN_TAXES_ALL jtc
2849: where jsptl.delivery_detail_id = v_delivery_detail_id
2850: and jsptl.tax_id = jtc.tax_id
2851: and jtc.tax_type = jai_constants.tax_type_tcs;
2852:
3706:
3707: /*Added following cursor for Bug#10213327 by abezgam*/
3708: CURSOR c_inclusive_flag (CP_DDID IN NUMBER )IS
3709: SELECT count(*)
3710: FROM jai_om_wsh_line_taxes a,jai_cmn_taxes_all b
3711: where a.delivery_Detail_id=cp_ddid
3712: and a.tax_id=b.tax_id
3713: and upper(b.tax_type) like '%EXCISE%'
3714: AND B.INCLUSIVE_TAX_FLAG='Y';