eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MSC_GET_NAME dependencies on MSC_PLAN_SCHEDULES

Line 2066: msc_plan_schedules sch

2062: -- Return null if it is a dp scenario and the plan_id is passed in function call
2063: cursor is_forecast_c is
2064: select 1
2065: from msc_designators desig,
2066: msc_plan_schedules sch
2067: where desig.designator_id = p_desig_id
2068: and desig.designator_type = 6
2069: and sch.plan_id=p_plan_id
2070: and sch.input_schedule_id = desig.forecast_set_id;

Line 2169: FROM msc_plan_schedules

2165:
2166:
2167: cursor c_designator_type_g is
2168: SELECT designator_type
2169: FROM msc_plan_schedules
2170: WHERE plan_id = p_plan_id
2171: AND organization_id = -1
2172: AND sr_instance_id = p_instance_id
2173: AND input_schedule_id = p_desig_id;

Line 2177: FROM msc_plan_schedules

2173: AND input_schedule_id = p_desig_id;
2174:
2175: CURSOR c_designator_type IS
2176: SELECT designator_type
2177: FROM msc_plan_schedules
2178: WHERE plan_id = p_plan_id
2179: AND organization_id = p_organization_id
2180: AND sr_instance_id = p_instance_id
2181: AND input_schedule_id = p_desig_id;

Line 2185: FROM msc_plan_schedules

2181: AND input_schedule_id = p_desig_id;
2182:
2183: CURSOR c_coll_designator_type IS
2184: SELECT designator_type
2185: FROM msc_plan_schedules
2186: WHERE organization_id = p_organization_id
2187: AND sr_instance_id = p_instance_id
2188: AND input_schedule_id = p_desig_id;
2189:

Line 2209: FROM msc_plan_schedules

2205: l_designator_type NUMBER;
2206:
2207: cursor l_count_c is
2208: SELECT count(*)
2209: FROM msc_plan_schedules
2210: WHERE plan_id = p_plan_id
2211: AND organization_id = p_organization_id
2212: AND sr_instance_id = p_instance_id
2213: AND input_schedule_id = p_desig_id;

Line 2285: FROM msc_plan_schedules

2281: -- cnazarma
2282:
2283: CURSOR c_designator_type IS
2284: SELECT designator_type
2285: FROM msc_plan_schedules
2286: WHERE plan_id = p_plan_id
2287: AND organization_id = p_organization_id
2288: AND sr_instance_id = p_instance_id
2289: AND input_schedule_id = p_desig_id;

Line 2723: -- to msc_plan_schedules

2719: p_schedule_desig_id number,
2720: p_fb_type number)
2721: return number IS
2722: -- Modified to check the existance of forecast by joining msc_designators
2723: -- to msc_plan_schedules
2724: -- Also modified to remove the sub queries
2725: cursor is_forecast_c is
2726: select 1
2727: from msc_designators desig,

Line 2728: msc_plan_schedules sch

2724: -- Also modified to remove the sub queries
2725: cursor is_forecast_c is
2726: select 1
2727: from msc_designators desig,
2728: msc_plan_schedules sch
2729: where desig.designator_id = p_schedule_desig_id
2730: and desig.designator_type = 6
2731: and sch.plan_id=p_plan_id
2732: and sch.input_schedule_id = desig.forecast_set_id;

Line 2742: from msc_plan_schedules

2738: and desig.designator_type = 6;
2739:
2740: CURSOR is_dp_scenario_c is
2741: SELECT 1
2742: from msc_plan_schedules
2743: where plan_id = p_plan_id
2744: and input_schedule_id=p_schedule_desig_id
2745: and designator_type=7;
2746:

Line 3573: msc_plan_schedules ps

3569:
3570: select count(*)
3571: into l_count
3572: from msd_dp_scn_output_levels_v dp,
3573: msc_plan_schedules ps
3574: where ps.input_schedule_id = dp.scenario_id
3575: and ps.designator_type = 7
3576: and dp.level_id in (11, 15, 41)
3577: and ps.plan_id = p_plan_id