DBA Data[Home] [Help]

APPS.WIP_PERF_TO_PLAN dependencies on MTL_PARAMETERS

Line 221: -- Update the item_cost based on table cst_item_costs, mtl_parameters

217: LOOP
218: FETCH perf_cur INTO perf_rec;
219: EXIT WHEN perf_cur%NOTFOUND or perf_cur%NOTFOUND IS NULL;
220:
221: -- Update the item_cost based on table cst_item_costs, mtl_parameters
222: BEGIN
223: select distinct cic.item_cost into p_item_cost
224: from
225: cst_item_costs cic,

Line 226: mtl_parameters mp

222: BEGIN
223: select distinct cic.item_cost into p_item_cost
224: from
225: cst_item_costs cic,
226: mtl_parameters mp
227: where mp.organization_id = perf_rec.organization_id
228: and cic.organization_id = mp.organization_id
229: and cic.inventory_item_id = perf_rec.inventory_item_id
230: and cic.cost_type_id = mp.primary_cost_method;