APPS.MSC_SNO_PKG dependencies on MSC_PLANS

Line 176: msc_plans mp

172: decode(med.organization_id, -1, mp.organization_id, med.organization_id) eff_organization_id,
173: decode(med.organization_id, -1, mp.sr_instance_id, med.sr_instance_id) eff_sr_instance_id -- wei: sync sr_instance_id with organization_id
174: from
175: msc_exception_details med,
176: msc_plans mp
177: where mp.plan_id = med.plan_id
178: and mp.plan_type = 6
179: and mp.plan_id = p_plan_id) t,
180: msc_system_items msi,

Line 456: msc_plans mp,

452: to_number(null) buy_order_count -- wei: temp, should use lines above
453: from
454: msc_supplies ms,
455: msc_system_items msi,
456: msc_plans mp,
457: msc_trading_partners mtp
458: where mp.plan_id = p_plan_id
459: and mp.plan_type = 6
460: and ms.plan_id = p_plan_id

Line 588: msc_plans mp,

584: nvl(md.demand_class, '-23453'),
585: trunc(nvl(md.firm_date, md.using_assembly_demand_date)),
586: md.origination_type) t1,
587: msc_system_items msi,
588: msc_plans mp,
589: msc_currency_conv_mv mcc
590: where msi.plan_id = t1.plan_id
591: and msi.sr_instance_id = decode(sign(t1.sr_instance_id), -1, mp.sr_instance_id, t1.sr_instance_id) --wei
592: and msi.organization_id = decode(sign(t1.organization_id), -1, mp.organization_id, t1.organization_id) --wei

Line 706: from msc_calendar_dtl v, msc_plans mp

702: k1.demand_class,
703: k2.end_date
704: from msc_demands_f k1,
705: (select trunc(v.month_end_date) end_date
706: from msc_calendar_dtl v, msc_plans mp
707: where mp.plan_id=p_plan_id
708: and v.month_end_date between mp.curr_start_date and mp.curr_cutoff_date
709: union all
710: select trunc(v.week_end_date) end_date

Line 711: from msc_phub_mfg_cal_weeks_mv v, msc_plans mp

707: where mp.plan_id=p_plan_id
708: and v.month_end_date between mp.curr_start_date and mp.curr_cutoff_date
709: union all
710: select trunc(v.week_end_date) end_date
711: from msc_phub_mfg_cal_weeks_mv v, msc_plans mp
712: where mp.plan_id=p_plan_id
713: and v.week_end_date between mp.curr_start_date and mp.curr_cutoff_date
714: union all
715: select trunc(v.end_date) end_date

Line 716: from msc_phub_fiscal_periods_mv v, msc_plans mp

712: where mp.plan_id=p_plan_id
713: and v.week_end_date between mp.curr_start_date and mp.curr_cutoff_date
714: union all
715: select trunc(v.end_date) end_date
716: from msc_phub_fiscal_periods_mv v, msc_plans mp
717: where mp.plan_id=p_plan_id
718: and v.end_date between mp.curr_start_date and mp.curr_cutoff_date
719: union all
720: select order_date from msc_demands_f f