[Home] [Help]
20: Issue - Costing update for non-recoverable taxes is wrong when transaction UOM is
21: different from primary UOM.
22: Cause - In MMT table, the cost is to be updated in terms of rate / quantity in primary UOM. But
23: the code updates it with rate / quantity in transaction UOM.
24: Fix - When calculating the amount to update the MMT table, used rcv_transactions.primary_quantity
25: instead of jai_rcv_transactions.quantity.
26:
27: 4. 01-OCT-2009 Bug 8966461 File version 120.0.12000000.11 / 120.5.12010000.5 / 120.9
28: Issue - Costing update is wrong for CORRECT transactions with negative
21: different from primary UOM.
22: Cause - In MMT table, the cost is to be updated in terms of rate / quantity in primary UOM. But
23: the code updates it with rate / quantity in transaction UOM.
24: Fix - When calculating the amount to update the MMT table, used rcv_transactions.primary_quantity
25: instead of jai_rcv_transactions.quantity.
26:
27: 4. 01-OCT-2009 Bug 8966461 File version 120.0.12000000.11 / 120.5.12010000.5 / 120.9
28: Issue - Costing update is wrong for CORRECT transactions with negative
29: quantity.
35:
36: 5. 14-Oct-2009 Bug 8894858 File version 120.0.12000000.12 / 120.5.12010000.6 / 120.10
37: Issue - Costing update is wrong when the uom for RECEIVE transaction is
38: is different from the source document (PO) uom.
39: Fix - Used rcv_transactions.source_doc_quantity instead of rcv_transactions.quantity
40: to calculate the costing amount to be added to po_unit_price.
41: Also incorporated the changes for bug 8830292 - the program has to pick
42: the transactions based on the transaction date, not the date of receipt.
43:
71: WHERE mtl.organization_id = jcio.organization_id
72: AND mtl.process_enabled_flag = 'Y'
73: )
74: AND EXISTS ( SELECT 1
75: FROM jai_rcv_transactions jrt
76: WHERE jrt.shipment_header_id = rsl.shipment_header_id
77: AND jrt.shipment_line_id = rsl.shipment_line_id
78: AND jrt.transaction_type = lv_deliver_trx
79: AND trunc(jrt.transaction_date) between cp_start_date and cp_end_date /*bug 8830292*/
84: /*cursor modified for bug 8505362, to include the quanity in primary UOM*/
85: CURSOR cur_rcv_costing_records(cp_shipment_line_id IN NUMBER )
86: IS
87: SELECT rt.transaction_id, rt.quantity, rt.primary_quantity, jrt.currency_conversion_rate, jrt.transaction_type, rt.source_doc_quantity /*bug 8894858*/
88: FROM rcv_transactions rt, jai_rcv_transactions jrt
89: WHERE rt.transaction_id = jrt.transaction_id
90: AND jrt.shipment_line_id = cp_shipment_line_id
91: AND ( (jrt.transaction_type IN (lv_rtr_trx ,lv_deliver_trx)) /*Reverted the chnage performed by bug # 9896814 through bug #12738762*/
92: OR (jrt.transaction_type = lv_correct_trx AND
259:
260: IF ln_costing_amount IS NOT NULL THEN
261:
262: If rcv_costing_records.transaction_type = 'DELIVER' then /*Added by nprashar for bug # 12738762 */
263: UPDATE rcv_transactions
264: SET po_unit_price = po_unit_price + ln_costing_amount
265: WHERE transaction_id = rcv_costing_records.transaction_id;
266: End If;
267:
268: UPDATE mtl_material_transactions
269: SET transaction_cost = transaction_cost + ln_costing_amt_func_curr /* Modified for bug 7655123 */
270: WHERE rcv_transaction_id = rcv_costing_records.transaction_id;
271:
272: UPDATE jai_rcv_transactions
273: SET opm_costing_flag = 'Y',
274: opm_costing_amount = ln_costing_amount
275: WHERE transaction_id = rcv_costing_records.transaction_id;
276: