[Home] [Help]
154: WHERE
155: line_id = pr_new.source_line_id AND
156: header_id = pr_new.source_header_id;
157:
158: -- The following cursor gets the sum of tax amount for the line_id from JAI_OM_OE_SO_TAXES table
159: CURSOR c_ja_in_so_tax_lines_tax_amt
160: IS
161: SELECT
162: nvl(sum(so_tax.tax_amount),0)
160: IS
161: SELECT
162: nvl(sum(so_tax.tax_amount),0)
163: FROM
164: JAI_OM_OE_SO_TAXES so_tax
165: , jai_cmn_taxes_all tax
166: WHERE
167: line_id = pr_new.source_line_id AND
168: header_id = pr_new.source_header_id
584: A.Uom,
585: A.Tax_Amount,
586: A.Base_Tax_Amount,
587: A.Func_Tax_Amount
588: FROM JAI_OM_OE_SO_TAXES A,
589: JAI_CMN_TAXES_ALL b
590: WHERE Line_id = v_source_line_id
591: AND A.Tax_Id = b.Tax_Id
592: ORDER BY A.Tax_Line_No;
750: AND location_id = p_location_id;
751:
752: CURSOR Get_Tax_Lines_Details_Cur1 IS
753: SELECT A.Tax_Rate, NVL(b.Rounding_Factor,0) Rounding_Factor
754: FROM JAI_OM_OE_SO_TAXES A, JAI_CMN_TAXES_ALL b
755: WHERE Line_id = v_source_line_id
756: AND A.Tax_Id = b.Tax_Id
757: AND b.tax_type = 'Modvat Recovery'
758: ORDER BY A.Tax_Line_No;
1117: v_tax_amt := (v_shipped_quantity * (rec.tax_amount/v_quantity)) ;
1118: v_base_tax_amt := (v_shipped_quantity * (rec.base_tax_amount/v_quantity)) ;
1119: /*
1120: As the Conversion rate can be different while the sales order was booked and when the sales order would be shipped.
1121: So during shipping the functional tax amount needs to be recalculated from the tax_amount column in JAI_OM_OE_SO_TAXES
1122: , hence setting the v_func_tax_amt = v_tax_amt * nvl((v_curr_conv_rate ,1)
1123: */
1124: v_func_tax_amt := (v_tax_amt * nvl(v_curr_conv_rate,1)) ;
1125: