[Home] [Help]
339: SELECT
340: nvl(sum(so_tax.tax_amount),0)
341: FROM
342: JAI_OM_OE_SO_TAXES so_tax
343: , jai_cmn_taxes_all tax -- Added by Jia Li for inclusive tax on 2008/01/07
344: WHERE
345: line_id = pr_new.source_line_id AND
346: header_id = pr_new.source_header_id
347: AND so_tax.tax_id = tax.tax_id -- Added by Jia Li for inclusive tax on 2008/01/07
413: )
414: IS
415: SELECT 1
416: FROM JAI_OM_OE_SO_TAXES jstl ,
417: JAI_CMN_TAXES_ALL jtc ,
418: jai_regime_tax_types_v tax_types
419: WHERE jstl.line_id = cp_line_id
420: AND jstl.header_id = cp_header_id
421: AND jtc.tax_id = jstl.tax_id
1245: A.Tax_Amount,
1246: A.Base_Tax_Amount,
1247: A.Func_Tax_Amount
1248: FROM JAI_OM_OE_SO_TAXES A,
1249: JAI_CMN_TAXES_ALL b
1250: WHERE Line_id = v_source_line_id
1251: AND A.Tax_Id = b.Tax_Id
1252: ORDER BY A.Tax_Line_No;
1253: CURSOR Pick_Tax_Line_Count_Cur(P_Tax_Id NUMBER) IS
1257: AND Tax_Id = P_Tax_Id;
1258: CURSOR Get_Tot_Tax_Amount_Cur IS
1259: SELECT SUM(A.Tax_Amount)
1260: FROM JAI_OM_WSH_LINE_TAXES A,
1261: JAI_CMN_TAXES_ALL b
1262: WHERE A.Delivery_Detail_Id = v_delivery_detail_id
1263: AND b.Tax_Id = A.Tax_Id
1264: AND b.Tax_Type <> 'TDS';
1265: CURSOR Get_Delivery_Line_Count_Cur IS
1293: SELECT
1294: nvl(sum(a.func_tax_amount),0) -- cbabu for Bug# 2736191
1295: FROM
1296: JAI_CMN_MATCH_TAXES a,
1297: JAI_CMN_TAXES_ALL b
1298: WHERE
1299: a.tax_id = b.tax_id AND
1300: b.tax_type = p_tax_type AND
1301: A.ref_line_id = v_delivery_detail_id AND
1423: AND B.organization_id = p_organization_id
1424: AND B.location_id = p_location_id );
1425: CURSOR Get_Tax_Lines_Details_Cur1 IS
1426: SELECT A.Tax_Rate, NVL(b.Rounding_Factor,0) Rounding_Factor
1427: FROM JAI_OM_OE_SO_TAXES A, JAI_CMN_TAXES_ALL b
1428: WHERE Line_id = v_source_line_id
1429: AND A.Tax_Id = b.Tax_Id
1430: AND b.tax_type = 'Modvat Recovery'
1431: ORDER BY A.Tax_Line_No;
1484:
1485: CURSOR c_cess_amount (cp_delivery_id JAI_OM_WSH_LINES_ALL.DELIVERY_ID%TYPE) IS
1486: SELECT nvl(sum(jsptl.func_tax_amount),0) tax_amount
1487: FROM JAI_OM_WSH_LINE_TAXES jsptl ,
1488: JAI_CMN_TAXES_ALL jtc
1489: WHERE jtc.tax_id = jsptl.tax_id
1490: AND delivery_detail_id in
1491: (SELECT delivery_detail_id
1492: FROM JAI_OM_WSH_LINES_ALL
1502:
1503: CURSOR c_sh_cess_amount (cp_delivery_id JAI_OM_WSH_LINES_ALL.DELIVERY_ID%TYPE) IS
1504: SELECT nvl(sum(jsptl.func_tax_amount),0) tax_amount
1505: FROM JAI_OM_WSH_LINE_TAXES jsptl ,
1506: JAI_CMN_TAXES_ALL jtc
1507: WHERE jtc.tax_id = jsptl.tax_id
1508: AND delivery_detail_id in
1509: (SELECT delivery_detail_id
1510: FROM JAI_OM_WSH_LINES_ALL
1531: CURSOR cur_chk_vat_exists (cp_del_det_id JAI_OM_WSH_LINES_ALL.DELIVERY_DETAIL_ID%TYPE)
1532: IS
1533: SELECT 1
1534: FROM JAI_OM_WSH_LINE_TAXES jsptl,
1535: JAI_CMN_TAXES_ALL jtc
1536: , jai_regime_tax_types_v tax_types
1537: WHERE jsptl.delivery_detail_id = cp_del_det_id
1538: AND jtc.tax_id = jsptl.tax_id
1539: AND jtc.tax_type = tax_types.tax_type
1564: || Added by csahoo for bug#5680459
1565: || Check if only 'VAT REVERSAL' tax type is present in JAI_OM_WSH_LINE_TAXES
1566: */
1567: CURSOR c_chk_vat_reversal (cp_del_det_id JAI_OM_WSH_LINES_ALL.delivery_detail_id%TYPE,
1568: cp_tax_type JAI_CMN_TAXES_ALL.tax_type%TYPE )
1569: IS
1570: SELECT 1
1571: FROM JAI_OM_WSH_LINE_TAXES jsptl,
1572: JAI_CMN_TAXES_ALL jtc
1568: cp_tax_type JAI_CMN_TAXES_ALL.tax_type%TYPE )
1569: IS
1570: SELECT 1
1571: FROM JAI_OM_WSH_LINE_TAXES jsptl,
1572: JAI_CMN_TAXES_ALL jtc
1573: WHERE jsptl.delivery_detail_id = cp_del_det_id
1574: AND jtc.tax_id = jsptl.tax_id
1575: AND jtc.tax_type = cp_tax_type ;
1576:
1605: IS
1606: SELECT COUNT(1)
1607: FROM JAI_REGIME_TAX_TYPES_V JRTTV
1608: , JAI_OM_WSH_LINE_TAXES JSPT
1609: , JAI_CMN_TAXES_ALL JTC
1610: WHERE JTC.TAX_ID = JSPT.TAX_ID
1611: AND JTC.TAX_TYPE = JRTTV.TAX_TYPE
1612: AND REGIME_CODE = CP_REGIME_CODE
1613: AND JSPT.DELIVERY_DETAIL_ID = CP_DELIVERY_DETAIL_ID;
1768:
1769: Fix Of Bug#3158282:-
1770: Issue:-
1771: In case of non INR type of transactions with Excise type of tax the rounding precision should be maintained at 0
1772: and in all other cases the rounding factor should be picked up from JAI_CMN_TAXES_ALL.
1773:
1774: Solution:-
1775: Modified the rounding factor to reflect the above scenario. variable v_func_tax_amount gets
1776: rounded of to zero in case of non INR type of transactions ( v_curr_conv_rate <> 1) with Excise type of tax
1773:
1774: Solution:-
1775: Modified the rounding factor to reflect the above scenario. variable v_func_tax_amount gets
1776: rounded of to zero in case of non INR type of transactions ( v_curr_conv_rate <> 1) with Excise type of tax
1777: and for all other cases rounding precession is picked up from JAI_CMN_TAXES_ALL table.
1778:
1779: Dependency Introduced Due to this Bug : -
1780: None
1781:
2481: /* Get line number of the base tax (tax_type=TCS) for calculating the surcharge basically to set a precedence */
2482: select max(tax_line_no)
2483: into ln_base_line_no
2484: from JAI_OM_WSH_LINE_TAXES jsptl
2485: , JAI_CMN_TAXES_ALL jtc
2486: where jsptl.delivery_detail_id = v_delivery_detail_id
2487: and jsptl.tax_id = jtc.tax_id
2488: and jtc.tax_type = jai_constants.tax_type_tcs;
2489: