DBA Data[Home] [Help]

APPS.MSC_ANALYSIS_BUDGET dependencies on MSC_PLAN_ORGANIZATIONS

Line 479: FROM msc_plans mp, msc_plan_organizations mpo, msc_demands msd, msc_system_items msi,

475: nvl(msd.probability,1)) AS required_quantity,
476: sum(nvl(msd.service_level, 50)) AS target_service_level,
477: count(*) AS num_target_service_level,
478: RECORD_SERVICE_LEVEL AS record_type
479: FROM msc_plans mp, msc_plan_organizations mpo, msc_demands msd, msc_system_items msi,
480: msc_item_categories mic, msc_trading_partners mtp
481: WHERE mp.plan_id = p_plan_id
482: AND mp.plan_id = mpo.plan_id
483: AND mpo.plan_id = msd.plan_id