APPS.JAI_CMN_RCV_MATCHING_PKG dependencies on JAI_OM_OE_SO_TAXES

Line 1531: JAI_OM_OE_SO_TAXES a ,

1527: NVL( b.rounding_factor, 0 ) rnd ,
1528: b.adhoc_flag /* Added bug 5091874 */
1529: , b.inclusive_tax_flag --Add by Kevin Cheng for inclusive tax Dec 12, 2007
1530: FROM
1531: JAI_OM_OE_SO_TAXES a ,
1532: jai_regime_tax_types_v aa, -- Add by Xiao for GST refer to bug#10043656.
1533: JAI_CMN_TAXES_ALL b
1534: WHERE a.line_id = p_line_id
1535: AND a.tax_id = b.tax_id

Line 1771: FROM JAI_OM_OE_SO_TAXES a, JAI_CMN_TAXES_ALL b

1767: WHERE delivery_detail_id = cp_delivery_detail_id;
1768:
1769: CURSOR c_oe_excise_cess_cnt(cp_order_line_id IN NUMBER) IS
1770: SELECT count(1)
1771: FROM JAI_OM_OE_SO_TAXES a, JAI_CMN_TAXES_ALL b
1772: WHERE a.line_id = cp_order_line_id
1773: AND a.tax_id = b.tax_id
1774: AND b.tax_type = p_Cess_type_code;/*Bug 5989740 bduvarag*/
1775:

Line 1877: type of tax used to be defaulted from JAI_OM_OE_SO_TAXES .

1873: quantity.
1874:
1875: Reason:-
1876: This was happening because prior to this fix the tax amounts in case of Adhoc non excise
1877: type of tax used to be defaulted from JAI_OM_OE_SO_TAXES .
1878: Now when a delivery detail is split after pick release, then the delivery detail get splits
1879: but not the line.
1880: Hence the tax amount's, which were picked up from the JAI_OM_OE_SO_TAXES did not get apportioned
1881: properly.

Line 1880: Hence the tax amount's, which were picked up from the JAI_OM_OE_SO_TAXES did not get apportioned

1876: This was happening because prior to this fix the tax amounts in case of Adhoc non excise
1877: type of tax used to be defaulted from JAI_OM_OE_SO_TAXES .
1878: Now when a delivery detail is split after pick release, then the delivery detail get splits
1879: but not the line.
1880: Hence the tax amount's, which were picked up from the JAI_OM_OE_SO_TAXES did not get apportioned
1881: properly.
1882:
1883: Fix:-
1884: In case of Adhoc non excise type of taxes, the tax amounts get apportioned based on the p_line_quantity