[Home] [Help]
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.
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
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: