APPS.MSC_ITEM_PKG dependencies on STANDARD

Line 152: sum(nvl(f.indep_demand_qty,0) * nvl(i.standard_cost,0)) indep_demand_value,

148:
149: end) demand_qty,
150:
151: sum(nvl(f.indep_demand_qty,0)) indep_demand_qty,
152: sum(nvl(f.indep_demand_qty,0) * nvl(i.standard_cost,0)) indep_demand_value,
153:
154: ---- make sure this indep_demand_value is qty * std_cost. this is used to calculate
155: ---- cogs =item std cost x sum of Indep dem qty
156:

Line 157: --sum(nvl(INDEP_DEMAND_QTY,0) * i.standard_cost) indep_demand_value,

153:
154: ---- make sure this indep_demand_value is qty * std_cost. this is used to calculate
155: ---- cogs =item std cost x sum of Indep dem qty
156:
157: --sum(nvl(INDEP_DEMAND_QTY,0) * i.standard_cost) indep_demand_value,
158: --bnaghi -dep_demand_qty not calculated for DRP plan
159: decode(l_plan_type,5,to_number(null), sum(decode(nvl(f.order_type,0),
160: -1,decode(l_plan_type,5,0,nvl(f.demand_qty,0)), -- exclude drp planned demand from dep demand
161: -2,nvl(f.demand_qty,0),

Line 282: sum(decode(nvl(f.supply_type,0), 18, nvl(f.supply_qty,0), 0) * nvl(i.standard_cost,0)) onhand_value,

278: decode(l_plan_type,5,to_number(null),sum(nvl(f.work_order_leadtime,0))) make_order_leadtime,
279: decode(l_plan_type,5,to_number(null),sum(nvl(f.work_order_count,0))) make_order_count,
280: decode(l_plan_type,5,to_number(null),avg(i.fixed_lead_time)) item_leadtime,
281: sum(decode(nvl(f.supply_type,0), 18, nvl(f.supply_qty,0), 0)) onhand_qty,
282: sum(decode(nvl(f.supply_type,0), 18, nvl(f.supply_qty,0), 0) * nvl(i.standard_cost,0)) onhand_value,
283:
284: sum(case when l_plan_type=8
285: and nvl(f.part_condition,1)=1
286: and f.supply_type=18

Line 326: then nvl(f.supply_qty, 0) else 0 end) * nvl(i.standard_cost,0)) scheduled_rept_value,

322: sum(case when f.supply_type in (1,2,3,8,11,12,14,27,49,53,80)
323: then nvl(f.supply_qty, 0) else 0 end) scheduled_rept_qty, -- bug 6797566, 9376354
324:
325: sum((case when f.supply_type in (1,2,3,8,11,12,14,27,49,53,80)
326: then nvl(f.supply_qty, 0) else 0 end) * nvl(i.standard_cost,0)) scheduled_rept_value,
327:
328: fnd_global.user_id, sysdate,
329: sysdate, fnd_global.user_id, fnd_global.login_id,
330: fnd_global.conc_program_id, fnd_global.conc_login_id,

Line 404: nvl(i.standard_cost,0)) sup_end_pgd_to_fcst_value,

400: sum(decode(mfp2.end_origination_type, 30, mfp.allocated_quantity, 0)) sup_end_pgd_to_so,
401: sum(decode(mfp2.demand_id, -2, mfp.allocated_quantity, 0)) sup_end_pgd_to_ss,
402: sum(decode(mfp2.demand_id, -1, mfp.allocated_quantity, 0)) sup_end_pgd_to_excess,
403: sum(decode(mfp2.end_origination_type, 29, mfp.allocated_quantity,0) *
404: nvl(i.standard_cost,0)) sup_end_pgd_to_fcst_value,
405: sum(decode(mfp2.end_origination_type, 30, mfp.allocated_quantity, 0) *
406: nvl(i.standard_cost,0)) sup_end_pgd_to_so_value,
407: sum(decode(mfp2.demand_id, -2, mfp.allocated_quantity, 0) *
408: nvl(i.standard_cost,0)) sup_end_pgd_to_ss_value,

Line 406: nvl(i.standard_cost,0)) sup_end_pgd_to_so_value,

402: sum(decode(mfp2.demand_id, -1, mfp.allocated_quantity, 0)) sup_end_pgd_to_excess,
403: sum(decode(mfp2.end_origination_type, 29, mfp.allocated_quantity,0) *
404: nvl(i.standard_cost,0)) sup_end_pgd_to_fcst_value,
405: sum(decode(mfp2.end_origination_type, 30, mfp.allocated_quantity, 0) *
406: nvl(i.standard_cost,0)) sup_end_pgd_to_so_value,
407: sum(decode(mfp2.demand_id, -2, mfp.allocated_quantity, 0) *
408: nvl(i.standard_cost,0)) sup_end_pgd_to_ss_value,
409: sum(decode(mfp2.demand_id, -1, mfp.allocated_quantity, 0) *
410: nvl(i.standard_cost,0)) sup_end_pgd_to_excess_value,

Line 408: nvl(i.standard_cost,0)) sup_end_pgd_to_ss_value,

404: nvl(i.standard_cost,0)) sup_end_pgd_to_fcst_value,
405: sum(decode(mfp2.end_origination_type, 30, mfp.allocated_quantity, 0) *
406: nvl(i.standard_cost,0)) sup_end_pgd_to_so_value,
407: sum(decode(mfp2.demand_id, -2, mfp.allocated_quantity, 0) *
408: nvl(i.standard_cost,0)) sup_end_pgd_to_ss_value,
409: sum(decode(mfp2.demand_id, -1, mfp.allocated_quantity, 0) *
410: nvl(i.standard_cost,0)) sup_end_pgd_to_excess_value,
411:
412: fnd_global.user_id, sysdate,

Line 410: nvl(i.standard_cost,0)) sup_end_pgd_to_excess_value,

406: nvl(i.standard_cost,0)) sup_end_pgd_to_so_value,
407: sum(decode(mfp2.demand_id, -2, mfp.allocated_quantity, 0) *
408: nvl(i.standard_cost,0)) sup_end_pgd_to_ss_value,
409: sum(decode(mfp2.demand_id, -1, mfp.allocated_quantity, 0) *
410: nvl(i.standard_cost,0)) sup_end_pgd_to_excess_value,
411:
412: fnd_global.user_id, sysdate,
413: sysdate, fnd_global.user_id, fnd_global.login_id,
414: fnd_global.conc_program_id, fnd_global.conc_login_id,

Line 834: sum((nvl(f.supply_qty,0) - nvl(f.demand_qty,0)) * nvl(i.standard_cost,0)) pab_value,

830: nvl(i.vmi_flag,0) vmi_flag,
831: d.date2 order_date,
832:
833: sum(nvl(f.supply_qty,0) - nvl(f.demand_qty,0)) pab_qty,
834: sum((nvl(f.supply_qty,0) - nvl(f.demand_qty,0)) * nvl(i.standard_cost,0)) pab_value,
835: sum((nvl(f.supply_qty,0) - nvl(f.demand_qty,0)) * nvl(i.unit_volume,1)) pab_volume,
836:
837: fnd_global.user_id, sysdate,
838: sysdate, fnd_global.user_id, fnd_global.login_id,

Line 900: t.pab_qty * nvl(i.standard_cost, 0) pab_value,

896: nvl(i.vmi_flag,0) vmi_flag,
897: t.order_date,
898:
899: t.pab_qty,
900: t.pab_qty * nvl(i.standard_cost, 0) pab_value,
901: t.pab_qty * nvl(i.unit_volume, 1) pab_volume,
902: t.pab_qty inv_build_target,
903:
904: fnd_global.user_id, sysdate,

Line 976: t.safety_stock_quantity * nvl(i.standard_cost,0) safety_stock_value,

972: nvl(i.vmi_flag,0) vmi_flag,
973: t.order_date,
974:
975: t.safety_stock_quantity safety_stock_qty,
976: t.safety_stock_quantity * nvl(i.standard_cost,0) safety_stock_value,
977: t.safety_stock_quantity * nvl(i.unit_volume,1) safety_stock_volume,
978: (case when l_plan_type in (4, 9) then t.achieved_days_of_supply else null end) safety_stock_days,
979:
980: t.demand_var_ss_percent*t.total_unpooled_safety_stock/100 demand_var_ss_qty,