APPS.MSC_SCN_UTILS dependencies on MSC_PLANS

Line 237: ' FROM msc_plans plans, msc_designators desig'||

233: PARAM_VERSION)
234: VALUES(6,'PLAN_ID','VARCHAR2',NULL,1,
235: ' SELECT plans.compile_designator hidden,'||
236: ' plans.compile_designator display'||
237: ' FROM msc_plans plans, msc_designators desig'||
238: ' WHERE plans.organization_id = NVL(fnd_profile.value(''SCENARIO_PLANNING_ORG''),plans.organization_id)'||
239: ' AND plans.sr_instance_id = NVL(fnd_profile.value(''SCENARIO_PLANNING_INST''),plans.sr_instance_id)'||
240: ' AND plans.curr_plan_type = 6 '||
241: ' AND plans.organization_id = desig.organization_id'||

Line 1871: from msc_plans

1867: FUNCTION get_plan_name(p_plan_type in number,p_plan_id in number, p_plan_run_id in number) return varchar2 is
1868:
1869: cursor c_plan_name is
1870: select compile_designator as plan_name
1871: from msc_plans
1872: where plan_type = nvl(p_plan_type,plan_type) and plan_id = p_plan_id
1873: union
1874: select distinct scenario_name as plan_name
1875: from msd_dp_ascp_scenarios_v

Line 2437: from msc_plans mp,

2433: msc_Get_name.lookup_meaning(
2434: 'MSC_SCN_PLAN_STATUS',
2435: decode(upper(fcr.status_code),'C',4,'E',3)
2436: ) plan_status_display
2437: from msc_plans mp,
2438: msc_plan_runs mpr,
2439: fnd_concurrent_requests fcr
2440: where mp.plan_type is not null and
2441: mp.plan_id = mpr.plan_id and

Line 2705: from msc_plans

2701:
2702: function get_plan_run_date(p_plan_type in number,p_plan_id in number) return date is
2703: cursor c_run_date is
2704: select plan_completion_date
2705: from msc_plans
2706: where plan_type = p_plan_type and
2707: plan_id = p_plan_id;
2708:
2709: cursor c_dem_run_date is

Line 2836: from msc_plans

2832: l_temp number;
2833:
2834: cursor c_plan_type (ll_plan_id number) is
2835: select curr_plan_type
2836: from msc_plans
2837: where plan_id = ll_plan_id;
2838:
2839: cursor c_scn_plan (p_scn_id number, p_plan_id number) is
2840: select count(*)