APPS.MSC_ANALYSIS_BUDGET dependencies on MSC_PLANS

Line 79: from msc_plans

75: l_def_pref_id number;
76: l_plan_type number;
77: cursor plan_type_c(v_plan_id number) is
78: select curr_plan_type
79: from msc_plans
80: where plan_id = v_plan_id;
81: BEGIN
82: open plan_type_c(arg_plan_id);
83: fetch plan_type_c into l_plan_type;

Line 101: msc_plans mp, msc_bis_periods mbp

97: (SELECT DISTINCT mbid.detail_date
98: FROM msc_bis_inv_detail mbid
99: WHERE mbid.plan_id = p_Plan_id
100: AND (mbid.period_type IS NULL OR mbid.period_type = 0)) pd,
101: msc_plans mp, msc_bis_periods mbp
102: WHERE mp.plan_id = p_plan_id
103: AND mp.sr_instance_id = mbp.sr_instance_id
104: AND mp.organization_id = mbp.organization_id
105: AND mbp.period_set_name = 'Accounting'

Line 143: FROM msc_plans mp, msc_trading_partners mtp, msc_plan_buckets mpb, msc_period_start_dates mpsd

139: IS
140: CURSOR c1(p_plan_id NUMBER) IS
141: SELECT mp.plan_id, mp.compile_designator, mtp.calendar_code, mpb.bkt_start_date, mpb.bkt_end_date,
142: mpsd.period_start_date, mpb.bucket_type
143: FROM msc_plans mp, msc_trading_partners mtp, msc_plan_buckets mpb, msc_period_start_dates mpsd
144: WHERE mp.plan_id = p_plan_id
145: AND mtp.sr_tp_id = mp.organization_id
146: AND mtp.sr_instance_id = mp.sr_instance_id
147: AND mtp.partner_type = 3

Line 393: msc_trading_partners mtp, msc_plans mp

389: NULL AS week_nr, NULL AS period_start_date, NULL AS bucket_type, NVL(mbid.detail_level, DETAIL_LEVEL_PERIOD) AS detail_level,
390: SUM(nvl(mbid.inventory_value, 0)) AS achieved_budget_usd, NULL as delivered_quantity, 0 as required_quantity,
391: NULL AS target_sl, NULL AS num_target_sl, RECORD_BUDGET AS record_type
392: FROM msc_bis_inv_detail mbid, msc_system_items mis, msc_item_categories mic,
393: msc_trading_partners mtp, msc_plans mp
394: WHERE mbid.plan_id = p_plan_id
395: AND mbid.plan_id = mp.plan_id
396: AND mbid.plan_id = mis.plan_id
397: AND mbid.organization_id = mis.organization_id

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

Line 566: FROM msc_plans mp, msc_system_items msi, msc_item_categories mic, msc_trading_partners mtp,

562: mic.sr_category_id AS sr_category_id, mic.category_name AS category_name,
563: mp.compile_designator AS plan_name,
564: mtp.organization_code AS org_name,
565: msi.item_name AS item_name, msd.customer_id AS partner_id
566: FROM msc_plans mp, msc_system_items msi, msc_item_categories mic, msc_trading_partners mtp,
567: (SELECT demands.plan_id, demands.sr_instance_id, demands.organization_id, demands.using_assembly_item_id,
568: demands.customer_id, demands.demand_id
569: FROM msc_demands demands
570: WHERE demands.origination_type IN (6,7,8,9,11,12,15,22,28,29,30)) msd,

Line 642: FROM msc_plans_tree_v mpt, msc_plans mp

638: RETURN BOOLEAN
639: IS
640: CURSOR c1(p_plan_id NUMBER) IS
641: SELECT 1
642: FROM msc_plans_tree_v mpt, msc_plans mp
643: WHERE mpt.curr_plan_type = 4
644: AND mpt.plan_id = mp.plan_id
645: AND mp.plan_start_date IS NOT NULL
646: AND mp.plan_id = p_plan_id;