APPS.MSC_SUPPLY_PKG dependencies on MSC_FULL_PEGGING

Line 109: msc_phub_util.gather_table_stats(msc_phub_util.stats_pds, 'MSC_FULL_PEGGING');

105: l_refresh_mode||','||l_item_rn_qid||','||l_pegging_granularity);
106:
107: ----------------------------------------------------
108: msc_phub_util.gather_table_stats(msc_phub_util.stats_pds, 'MSC_SUPPLIES');
109: msc_phub_util.gather_table_stats(msc_phub_util.stats_pds, 'MSC_FULL_PEGGING');
110: insert into msc_supplies_f (
111: plan_id, -- plan_id
112: plan_run_id,
113: io_plan_flag, --- this flag indidate whether it is an io plan

Line 369: from msc_full_pegging mfp,

365: mfp2.organization_id end_item_org_id,
366: mfp2.inventory_item_id end_item_id,
367: nvl(decode(l_pegging_granularity, 1, md.parent_model_item_id, md.top_model_item_id), -23453) parent_model_item_id,
368: sum(mfp.allocated_quantity) supply_qty
369: from msc_full_pegging mfp,
370: msc_full_pegging mfp2,
371: msc_demands md,
372: msc_apcc_item_d msi
373: where l_pegging_granularity in (0,1)

Line 370: msc_full_pegging mfp2,

366: mfp2.inventory_item_id end_item_id,
367: nvl(decode(l_pegging_granularity, 1, md.parent_model_item_id, md.top_model_item_id), -23453) parent_model_item_id,
368: sum(mfp.allocated_quantity) supply_qty
369: from msc_full_pegging mfp,
370: msc_full_pegging mfp2,
371: msc_demands md,
372: msc_apcc_item_d msi
373: where l_pegging_granularity in (0,1)
374: and mfp.plan_id=p_plan_id