APPS.MSC_SUPPLY_PKG dependencies on MSC_APCC_ITEM_D

Line 372: msc_apcc_item_d msi

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
376: and mfp.end_pegging_id=mfp2.end_pegging_id

Line 393: msc_apcc_item_d msi,

389: mfp2.organization_id,
390: mfp2.inventory_item_id,
391: nvl(decode(l_pegging_granularity, 1, md.parent_model_item_id, md.top_model_item_id), -23453)
392: ) pg,
393: msc_apcc_item_d msi,
394: msc_trading_partners mtp
395: where ms.plan_id = msi.plan_id
396: and decode(sign(ms.sr_instance_id), -1, l_sr_instance_id, ms.sr_instance_id) = msi.sr_instance_id
397: and decode(sign(ms.organization_id), -1, msc_hub_calendar.get_item_org(p_plan_id, ms.inventory_item_id,

Line 539: msc_apcc_item_d msi

535: then decode(ms.last_unit_completion_date, null, ms.new_order_quantity, ms.daily_rate)
536: else null end) wip_qty
537: from
538: msc_supplies ms,
539: msc_apcc_item_d msi
540: where ms.plan_id = msi.plan_id
541: and ms.sr_instance_id = msi.sr_instance_id
542: and ms.organization_id =msi.organization_id
543: and ms.inventory_item_id = msi.inventory_item_id