APPS.MSC_DRP_HORI_PLAN dependencies on MSC_SUPPLIES

Line 245: msc_supplies ms

241: sum(NVL(ms.old_order_quantity,0)*nvl(msi.unit_weight,0)) quantity2,
242: sum(NVL(ms.old_order_quantity,0)*nvl(msi.unit_volume,0)) quantity3
243: FROM msc_form_query mfq,
244: msc_system_items msi,
245: msc_supplies ms
246: WHERE ms.plan_id = msi.plan_id
247: AND ms.inventory_item_id = msi.inventory_item_id
248: AND ms.organization_id = msi.organization_id
249: AND ms.sr_instance_id = msi.sr_instance_id

Line 396: from msc_supplies mr

392: not(md.origination_type = SALES_ORDER and
393: nvl(md.demand_source_type,2) = 8)))
394: AND not exists (
395: select 'cancelled IR'
396: from msc_supplies mr
397: where md.origination_type = 30
398: and md.disposition_id = mr.transaction_id
399: and md.plan_id = mr.plan_id
400: and md.sr_instance_id = mr.sr_instance_id

Line 466: msc_supplies ms,

462: nvl(msi.unit_volume,0)) volume,
463: 0 quantity2,
464: 0 quantity3
465: FROM msc_system_items msi,
466: msc_supplies ms,
467: msc_form_query mfq
468: WHERE msi.plan_id = ms.plan_id
469: AND msi.inventory_item_id = ms.inventory_item_id
470: AND msi.organization_id = ms.source_organization_id