DBA Data[Home] [Help]

APPS.JAI_RCV_OPM_COSTING_PKG dependencies on MTL_MATERIAL_TRANSACTIONS

Line 16: 2. 23-MAR-2009 VUMAASHA 7655123 In mtl_material_transactions the cost is always recorded in functional currency.

12: Sl.No. Date Developer BugNo Remarks
13: ------------------------------------------------------------------------------------------------------------
14: 1. 21-JUL-2008 JMEENA 7268999 Added the code to convert the ln_costing_amount to base currency before updating the tables.
15:
16: 2. 23-MAR-2009 VUMAASHA 7655123 In mtl_material_transactions the cost is always recorded in functional currency.
17: The Variable ln_costing_amt_func_curr is added for store the costing
18: amount in functional currency.
19: 3. 26-May-2009 Bug 8505362 File version 120.0.12000000.10 / 120.5.12010000.4 / 120.8
20: Issue - Costing update for non-recoverable taxes is wrong when transaction UOM is

Line 268: UPDATE mtl_material_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