DBA Data[Home] [Help]

APPS.OPI_DBI_MTL_VARIANCE_PKG dependencies on OPI_PMI_COST

Line 433: insert into opi_pmi_cost_param_gtmp

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,

Line 458: opi_pmi_cost.get_cost;

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:

Line 469: from opi_pmi_cost_result_gtmp costs,

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