APPS.JAI_CMN_RCV_MATCHING_PKG dependencies on JAI_OM_OE_SO_TAXES

Line 1459: JAI_OM_OE_SO_TAXES a ,

1455: NVL( b.rounding_factor, 0 ) rnd ,
1456: b.adhoc_flag /* Added bug 5091874 */
1457: , b.inclusive_tax_flag --Add by Kevin Cheng for inclusive tax Dec 12, 2007
1458: FROM
1459: JAI_OM_OE_SO_TAXES a ,
1460: JAI_CMN_TAXES_ALL b
1461: WHERE
1462: a.line_id = p_line_id AND
1463: a.tax_id = b.tax_id

Line 1676: FROM JAI_OM_OE_SO_TAXES a, JAI_CMN_TAXES_ALL b

1672: WHERE delivery_detail_id = cp_delivery_detail_id;
1673:
1674: CURSOR c_oe_excise_cess_cnt(cp_order_line_id IN NUMBER) IS
1675: SELECT count(1)
1676: FROM JAI_OM_OE_SO_TAXES a, JAI_CMN_TAXES_ALL b
1677: WHERE a.line_id = cp_order_line_id
1678: AND a.tax_id = b.tax_id
1679: AND b.tax_type = p_Cess_type_code;/*Bug 5989740 bduvarag*/
1680:

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

1778: quantity.
1779:
1780: Reason:-
1781: This was happening because prior to this fix the tax amounts in case of Adhoc non excise
1782: type of tax used to be defaulted from JAI_OM_OE_SO_TAXES .
1783: Now when a delivery detail is split after pick release, then the delivery detail get splits
1784: but not the line.
1785: Hence the tax amount's, which were picked up from the JAI_OM_OE_SO_TAXES did not get apportioned
1786: properly.

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

1781: This was happening because prior to this fix the tax amounts in case of Adhoc non excise
1782: type of tax used to be defaulted from JAI_OM_OE_SO_TAXES .
1783: Now when a delivery detail is split after pick release, then the delivery detail get splits
1784: but not the line.
1785: Hence the tax amount's, which were picked up from the JAI_OM_OE_SO_TAXES did not get apportioned
1786: properly.
1787:
1788: Fix:-
1789: In case of Adhoc non excise type of taxes, the tax amounts get apportioned based on the p_line_quantity