APPS.MSC_ANALYSIS_SAFETY_STOCK dependencies on MSC_DEMANDS

Line 489: FROM msc_demands demands

485: FROM msc_plans mp, msc_system_items msi, msc_item_categories mic, msc_trading_partners mtp, msc_trading_partners cust,
486: msc_safety_stocks mss,
487: (SELECT demands.plan_id, demands.sr_instance_id, demands.organization_id, demands.using_assembly_item_id,
488: demands.customer_id, demands.demand_id
489: FROM msc_demands demands
490: WHERE demands.origination_type IN (6,7,8,9,11,12,15,22,28,29,30)) msd
491: WHERE mp.plan_id = p_plan_id
492: AND mp.plan_id = msi.plan_id
493: AND msi.organization_id = mic.organization_id

Line 539: FROM msc_demands demands

535: cust.partner_id, cust.partner_name, cust.customer_class_code, msi.item_name AS item_name
536: FROM msc_plans mp, msc_system_items msi, msc_item_categories mic, msc_trading_partners mtp, msc_trading_partners cust,
537: (SELECT demands.plan_id, demands.sr_instance_id, demands.organization_id, demands.using_assembly_item_id,
538: demands.customer_id, demands.demand_id
539: FROM msc_demands demands
540: WHERE demands.origination_type IN (6,7,8,9,11,12,15,22,28,29,30)) msd
541: WHERE mp.plan_id = p_plan_id
542: AND mp.plan_id = msi.plan_id
543: AND msi.inventory_item_id = NVL(p_item_id, msi.inventory_item_id)

Line 650: FROM msc_demands msd, msc_system_items msi,

646: msd.customer_id AS partner_id,
647: cust.partner_name AS partner_name,
648: cust.customer_class_code AS customer_class_code,
649: RECORD_SERVICE_LEVEL AS record_type
650: FROM msc_demands msd, msc_system_items msi,
651: msc_item_categories mic, msc_plans mp, msc_plan_organizations mpo,
652: msc_trading_partners cust
653: WHERE mp.plan_id = p_plan_id
654: AND msd.plan_id = msi.plan_id