[Home] [Help]
19: "if NVL(ln_tax_amount, 0) = 0 then " to "if NVL(p_tax_amount, 0) = 0 then"
20:
21: 3 10/10/2004 Vijay Shankar for Bug#3899897 (3927371), Version:115.2
22: During Average Costing, Instead of populating MTL_MATERIAL_TRANSACTIONS_TEMP table we stated populating
23: MTL_TRANSACTIONS_INTERFACE and MTL_TXN_COST_DET_INTERFACE. This new route is followed to remove the incosistancy in
24: the way the costing happens. This is porting of Bug#3841831
25: New Internal Package Procedure MTI_ENTRY is introduced with this fix. Procedure name MMTT_ENTRY is modified as AVERAGE_COSTING
26:
27: 4 08/11/2004 Vijay Shankar for Bug#3949487, Version:115.3
219: transaction_header_id
220: INTO ln_txn_interface_id ,
221: p_txn_header_id ;
222:
223: INSERT INTO mtl_txn_cost_det_interface
224: (
225: transaction_interface_id ,
226: last_update_date ,
227: last_updated_by ,
250: ||Added the condition p_overhead_exists
251: ||so that the insert gets executed only for Overhead elements
252: */
253: IF nvl(p_overhead_exists,'NO') = 'YES' THEN
254: INSERT INTO mtl_txn_cost_det_interface
255: (
256: transaction_interface_id ,
257: last_update_date ,
258: last_updated_by ,
282: || Cost elements which are present in the CLCD (cst_layer_cost_details)
283: || should be inserted into MCTCDI with a value change of 0 .
284: */
285:
286: INSERT INTO mtl_txn_cost_det_interface
287: (
288: transaction_interface_id,
289: last_update_date,
290: last_updated_by,
317: ( SELECT
318: mctcd1.cost_element_id,
319: mctcd1.level_type
320: FROM
321: mtl_txn_cost_det_interface mctcd1
322: WHERE
323: mctcd1.transaction_interface_id = ln_txn_interface_id
324: )
325: );