[Home] [Help]
113: CHANGE HISTORY:
114: S.No Date Author and Details
115: 1. 2002/03/11 Vijay
116: Trigger written to delete data from tables
117: JAI_CMN_MATCH_RECEIPTS, JAI_CMN_MATCH_TAXES.
118: After Match Receipt is done, when back order is done,
119: this trigger enables to match again.
120:
121: 2. 29/11/2005 Aparajita for bug#4036241. Version#115.1
152:
153: Delete from JAI_CMN_MATCH_RECEIPTS
154: Where ref_line_id = pr_new.delivery_detail_id;
155:
156: Delete from JAI_CMN_MATCH_TAXES
157: Where ref_line_id = pr_new.delivery_detail_id;
158: END ARU_T1 ;
159:
160: /*
1281: SELECT nvl(sum(tax_amount),0) ,
1282: nvl(sum(base_tax_amount),0),
1283: nvl(sum(func_tax_amount),0)
1284: FROM
1285: JAI_CMN_MATCH_TAXES
1286: WHERE
1287: ref_line_id = v_delivery_detail_id AND
1288: receipt_id IS NOT NULL AND
1289: tax_id = p_tax_id;
1292: -- SELECT SUM(NVL(A.func_tax_amount,0))
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
1700: ----------------------------------------------
1701: Issue:-
1702: Initial code used to check that if the organization is a Trading organization,item is tradable and excisable
1703: then used to assume that a match receipt has been done and get the sum (tax_amount), sum(base_tax_amount),
1704: sum(func_tax_amount) for a delivery_detail_id and tax_id from the JAI_CMN_MATCH_TAXES table and
1705: populate this into the tax_amount, base_tax_amount and func_tax_amount columns of the table
1706: JAI_OM_WSH_LINE_TAXES.
1707:
1708: This approach used to fail, as many a times a record never used to exists in the JAI_CMN_MATCH_TAXES table
1704: sum(func_tax_amount) for a delivery_detail_id and tax_id from the JAI_CMN_MATCH_TAXES table and
1705: populate this into the tax_amount, base_tax_amount and func_tax_amount columns of the table
1706: JAI_OM_WSH_LINE_TAXES.
1707:
1708: This approach used to fail, as many a times a record never used to exists in the JAI_CMN_MATCH_TAXES table
1709: for the delivery_detail_id and tax_id even though the organization is declared as a trading organization,
1710: Item is tradable and excisable.
1711:
1712: This happens in scenario's where an order assigned to a Bond register_type is either 'Trading domestic without excise' or
1710: Item is tradable and excisable.
1711:
1712: This happens in scenario's where an order assigned to a Bond register_type is either 'Trading domestic without excise' or
1713: 'Export Without Excise', the match receipt functionaity would not be performed by client and consequently no
1714: data gets populated in JAI_CMN_MATCH_TAXES.
1715:
1716: Solution: -
1717: Added the additional check :-
1718: v_trad_register_code IN ( '23D_DOMESTIC_EXCISE','23D_EXPORT_EXCISE') .
1718: v_trad_register_code IN ( '23D_DOMESTIC_EXCISE','23D_EXPORT_EXCISE') .
1719: is all the above cases.
1720: With this the check becomes that if a organization is trdable, item is tradable , excisable and the order
1721: associated to the bond register is Trading Domestic With Excise and Export With Excise only then
1722: it can be assumed that there would be data in table JAI_CMN_MATCH_TAXES (Match receipts has been performed).
1723: In such a case take the tax_amoutn ,base_tax_amount and func_tax_amoutn for the above table.
1724: Else take it from JAI_OM_OE_SO_LINES and JAI_OM_OE_SO_TAXES table.
1725:
1726:
1810: on the quantity causing the taxes to be calculated as less than that of the actual value
1811:
1812: Solution :- Issue has been resolved by doing the following :
1813: The apportion based on quantity shipped has been removed and instead the tax amount from
1814: the JAI_CMN_MATCH_TAXES table is used for population into JAI_OM_WSH_LINES_ALL
1815: and jain_so_picking_tax_lines table
1816:
1817: Dependency : None
1818:
2222:
2223: --2001/06/08 Anuradha Parthasarathy
2224: /*
2225: This if statement has been modified by aiyer for the bug #2988829.
2226: As the tax amount, base_tax_amount and func_tax_amount would be present in table JAI_CMN_MATCH_TAXES
2227: only when match receipt functionality has been done .
2228: Now in order to check that the match receipts functionality has been performed the following check has been added in additions
2229: to the other three checks (of organization being a trading organization, Item being tradable and excisable ):-
2230: The order attached to the bond register is one of 'Trading Domestic With Excise' or 'Export With Excise'
2576: CLOSE get_item_dtls;
2577:
2578: /*
2579: This if statement has been modified by aiyer for the bug #2988829.
2580: As the tax amount, base_tax_amount and func_tax_amount would be present in table JAI_CMN_MATCH_TAXES
2581: only when match receipt functionality has been done .
2582: Now in order to check that the match receipts functionality has been performed the following check has been added in additions
2583: to the other three checks (of organization being a trading organization, Item being tradable and excisable ):-
2584: The order attached to the bond register is one of 'Trading Domestic With Excise' or 'Export With Excise'