[Home] [Help]
123: CHANGE HISTORY:
124: S.No Date Author and Details
125: 1. 2002/03/11 Vijay
126: Trigger written to delete data from tables
127: JAI_CMN_MATCH_RECEIPTS, JAI_CMN_MATCH_TAXES.
128: After Match Receipt is done, when back order is done,
129: this trigger enables to match again.
130:
131: 2. 29/11/2005 Aparajita for bug#4036241. Version#115.1
162:
163: Delete from JAI_CMN_MATCH_RECEIPTS
164: Where ref_line_id = pr_new.delivery_detail_id;
165:
166: Delete from JAI_CMN_MATCH_TAXES
167: Where ref_line_id = pr_new.delivery_detail_id;
168: END ARU_T1 ;
169:
170: /*
1521: SELECT nvl(sum(tax_amount),0) ,
1522: nvl(sum(base_tax_amount),0),
1523: nvl(sum(func_tax_amount),0)
1524: FROM
1525: JAI_CMN_MATCH_TAXES
1526: WHERE
1527: ref_line_id = v_delivery_detail_id AND
1528: receipt_id IS NOT NULL AND
1529: tax_id = p_tax_id;
1532: -- SELECT SUM(NVL(A.func_tax_amount,0))
1533: SELECT
1534: nvl(sum(a.func_tax_amount),0) -- cbabu for Bug# 2736191
1535: FROM
1536: JAI_CMN_MATCH_TAXES a,
1537: JAI_CMN_TAXES_ALL b
1538: WHERE
1539: a.tax_id = b.tax_id AND
1540: b.tax_type = p_tax_type AND
1940: ----------------------------------------------
1941: Issue:-
1942: Initial code used to check that if the organization is a Trading organization,item is tradable and excisable
1943: then used to assume that a match receipt has been done and get the sum (tax_amount), sum(base_tax_amount),
1944: sum(func_tax_amount) for a delivery_detail_id and tax_id from the JAI_CMN_MATCH_TAXES table and
1945: populate this into the tax_amount, base_tax_amount and func_tax_amount columns of the table
1946: JAI_OM_WSH_LINE_TAXES.
1947:
1948: This approach used to fail, as many a times a record never used to exists in the JAI_CMN_MATCH_TAXES table
1944: sum(func_tax_amount) for a delivery_detail_id and tax_id from the JAI_CMN_MATCH_TAXES table and
1945: populate this into the tax_amount, base_tax_amount and func_tax_amount columns of the table
1946: JAI_OM_WSH_LINE_TAXES.
1947:
1948: This approach used to fail, as many a times a record never used to exists in the JAI_CMN_MATCH_TAXES table
1949: for the delivery_detail_id and tax_id even though the organization is declared as a trading organization,
1950: Item is tradable and excisable.
1951:
1952: This happens in scenario's where an order assigned to a Bond register_type is either 'Trading domestic without excise' or
1950: Item is tradable and excisable.
1951:
1952: This happens in scenario's where an order assigned to a Bond register_type is either 'Trading domestic without excise' or
1953: 'Export Without Excise', the match receipt functionaity would not be performed by client and consequently no
1954: data gets populated in JAI_CMN_MATCH_TAXES.
1955:
1956: Solution: -
1957: Added the additional check :-
1958: v_trad_register_code IN ( '23D_DOMESTIC_EXCISE','23D_EXPORT_EXCISE') .
1958: v_trad_register_code IN ( '23D_DOMESTIC_EXCISE','23D_EXPORT_EXCISE') .
1959: is all the above cases.
1960: With this the check becomes that if a organization is trdable, item is tradable , excisable and the order
1961: associated to the bond register is Trading Domestic With Excise and Export With Excise only then
1962: it can be assumed that there would be data in table JAI_CMN_MATCH_TAXES (Match receipts has been performed).
1963: In such a case take the tax_amoutn ,base_tax_amount and func_tax_amoutn for the above table.
1964: Else take it from JAI_OM_OE_SO_LINES and JAI_OM_OE_SO_TAXES table.
1965:
1966:
2050: on the quantity causing the taxes to be calculated as less than that of the actual value
2051:
2052: Solution :- Issue has been resolved by doing the following :
2053: The apportion based on quantity shipped has been removed and instead the tax amount from
2054: the JAI_CMN_MATCH_TAXES table is used for population into JAI_OM_WSH_LINES_ALL
2055: and jain_so_picking_tax_lines table
2056:
2057: Dependency : None
2058:
2547:
2548: --2001/06/08 Anuradha Parthasarathy
2549: /*
2550: This if statement has been modified by aiyer for the bug #2988829.
2551: As the tax amount, base_tax_amount and func_tax_amount would be present in table JAI_CMN_MATCH_TAXES
2552: only when match receipt functionality has been done .
2553: Now in order to check that the match receipts functionality has been performed the following check has been added in additions
2554: to the other three checks (of organization being a trading organization, Item being tradable and excisable ):-
2555: The order attached to the bond register is one of 'Trading Domestic With Excise' or 'Export With Excise'
2942: CLOSE get_item_dtls;
2943:
2944: /*
2945: This if statement has been modified by aiyer for the bug #2988829.
2946: As the tax amount, base_tax_amount and func_tax_amount would be present in table JAI_CMN_MATCH_TAXES
2947: only when match receipt functionality has been done .
2948: Now in order to check that the match receipts functionality has been performed the following check has been added in additions
2949: to the other three checks (of organization being a trading organization, Item being tradable and excisable ):-
2950: The order attached to the bond register is one of 'Trading Domestic With Excise' or 'Export With Excise'