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 1867: from msc_plans

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

Line 2434: from msc_plans mp,

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

Line 2702: from msc_plans

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