APPS.JAI_CMN_RCV_MATCHING_PKG dependencies on JAI_CMN_DOCUMENT_TAXES

Line 69: UPDATE Jai_cmn_document_Taxes

65: Issue:
66: In Interorg transfer for a trading org ,matching the transaction quantity against the multiple receipts
67: is showing the wrong excise amount.
68: Reason::
69: UPDATE Jai_cmn_document_Taxes
70: SET Tax_Amt = tax_amt_tab(i),
71: Func_Tax_Amt = tax_amt_tab(i) * NVL( p_curr_conv_factor, 1 )
72: WHERE source_doc_line_id = p_ref_line_id
73: AND source_doc_type = 'INTERORG_XFER'

Line 80: UPDATE Jai_cmn_document_Taxes

76:
77: Due to this the amount is not getting correctly.
78: Fix:
79: Modified the update stmt as
80: UPDATE Jai_cmn_document_Taxes
81: SET Tax_Amt = nvl(tax_amt,0)+tax_amt_tab(i), --added nvl(tax_amt,0)
82: for bug#8445390
83: Func_Tax_Amt = nvl(Func_Tax_Amt,0)+tax_amt_tab(i) * NVL(
84: p_curr_conv_factor, 1 ) --added nvl(Func_Tax_Amt,0) for bug#8445390

Line 1584: jai_cmn_document_taxes a ,

1580: NVL( b.rounding_factor, 0 ) rnd ,
1581: b.adhoc_flag
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

Line 4529: UPDATE Jai_cmn_document_Taxes

4525: END IF;
4526:
4527: ELSIF p_order_invoice = 'X' THEN -- Interorg bug 6030615
4528:
4529: UPDATE Jai_cmn_document_Taxes
4530: SET Tax_Amt = nvl(tax_amt,0)+tax_amt_tab(i), --added nvl(tax_amt,0) for bug#8445390
4531: Func_Tax_Amt = nvl(Func_Tax_Amt,0)+tax_amt_tab(i) * NVL( p_curr_conv_factor, 1 ) --added nvl(Func_Tax_Amt,0) for bug#8445390
4532: WHERE source_doc_line_id = p_ref_line_id
4533: AND source_doc_type = 'INTERORG_XFER'