429: l_stmt_num := 61;
430:
431: --Setup bulk costing parameter table
432:
433: insert into opi_pmi_cost_param_gtmp
434: (
435: ITEM_ID,
436: WHSE_CODE,
437: ORGN_CODE,
454: and scaled.plan_qty <> 0;
455:
456: l_stmt_num := 62;
457:
458: opi_pmi_cost.get_cost;
459:
460: l_stmt_num := 63;
461:
462:
465:
466: update /*+ parallel(f) */ OPI_DBI_JOB_MTL_DETAILS_F f
467: set STANDARD_VALUE_B =
468: (select f.standard_quantity * costs.total_cost
469: from opi_pmi_cost_result_gtmp costs,
470: OPI_DBI_JOBS_F jobs,
471: ic_whse_mst whse,
472: ic_item_mst_b item,
473: mtl_System_items_b msi