DBA Data[Home] [Help]

APPS.MSC_SUPPLY_PKG dependencies on MSC_DEMANDS

Line 371: msc_demands md,

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
375: and mfp.plan_id=mfp2.plan_id