APPS.MSC_GET_NAME dependencies on MSC_DESIGNATORS

Line 575: from msc_designators desig,

571: and order_type in (3,7,14,15,27,28);
572:
573: cursor designator_c is
574: select desig.designator
575: from msc_designators desig,
576: msc_demands mgr
577: where desig.designator_id = mgr.schedule_designator_id
578: and mgr.demand_id = arg_disp_id
579: and mgr.sr_instance_id = arg_instance_id

Line 2045: FROM msc_designators

2041: p_plan_id IN NUMBER default NULL ) return varchar2 IS
2042:
2043: CURSOR DESIG_C(v_desig_id number) IS
2044: SELECT designator, forecast_set_id
2045: FROM msc_designators
2046: WHERE designator_id = v_desig_id;
2047:
2048: CURSOR DESIG_FC IS
2049: SELECT designator

Line 2050: FROM msc_designators

2046: WHERE designator_id = v_desig_id;
2047:
2048: CURSOR DESIG_FC IS
2049: SELECT designator
2050: FROM msc_designators
2051: WHERE forecast_set_id = p_fcst_set_id
2052: and designator_id = p_desig_id;
2053:
2054: v_fcst_set_id number;

Line 2065: from msc_designators desig,

2061: -- modification for bug 2765939
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

Line 2192: FROM msc_designators

2188: AND input_schedule_id = p_desig_id;
2189:
2190: CURSOR DESIG_C IS
2191: SELECT designator
2192: FROM msc_designators
2193: WHERE designator_id = p_desig_id;
2194:
2195: CURSOR c_scenario_name IS
2196: SELECT scenario_name

Line 2293: FROM msc_designators

2289: AND input_schedule_id = p_desig_id;
2290:
2291: CURSOR forecastset_name IS
2292: SELECT designator
2293: FROM msc_designators
2294: WHERE designator_id = (SELECT NVL(forecast_set_id,p_desig_id)
2295: FROM msc_designators
2296: WHERE designator_id = p_desig_id
2297: AND designator_type = 6);

Line 2295: FROM msc_designators

2291: CURSOR forecastset_name IS
2292: SELECT designator
2293: FROM msc_designators
2294: WHERE designator_id = (SELECT NVL(forecast_set_id,p_desig_id)
2295: FROM msc_designators
2296: WHERE designator_id = p_desig_id
2297: AND designator_type = 6);
2298:
2299: CURSOR c_scenario_name IS

Line 2587: from msc_designators d

2583: p_plan varchar2) return varchar2 is
2584:
2585: cursor c_dmdclass is
2586: select d.demand_class
2587: from msc_designators d
2588: where NVL(D.DESIGNATOR_TYPE,3) IN (2, 3, 4,5,-99)
2589: AND D.SR_INSTANCE_ID = p_inst_id
2590: AND D.ORGANIZATION_ID = p_org_id
2591: AND D.DESIGNATOR = p_plan ;

Line 2722: -- Modified to check the existance of forecast by joining msc_designators

2718: FUNCTION forward_backward_days(p_plan_id number,
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

Line 2727: from msc_designators desig,

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,
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

Line 2736: from msc_designators desig

2732: and sch.input_schedule_id = desig.forecast_set_id;
2733:
2734: cursor is_forecast_cwb_c is
2735: select 1
2736: from msc_designators desig
2737: where desig.designator_id = p_schedule_desig_id
2738: and desig.designator_type = 6;
2739:
2740: CURSOR is_dp_scenario_c is

Line 2750: FROM msc_designators

2746:
2747: CURSOR forward_backward_days_c1 IS
2748: SELECT FORWARD_UPDATE_TIME_FENCE,
2749: BACKWARD_UPDATE_TIME_FENCE
2750: FROM msc_designators
2751: WHERE designator_id = p_schedule_desig_id;
2752:
2753: CURSOR forward_backward_days_c2 IS
2754: SELECT curr_FORWARD_days,

Line 6379: from msc_designators

6375: arg_sr_instance_id IN NUMBER default null) return varchar2
6376: is
6377: cursor c1 is
6378: select SRC_DESIGNATOR
6379: from msc_designators
6380: where DESIGNATOR_ID= arg_schedule_designator_id
6381: and designator_type in (12,13);
6382:
6383: cursor maint_source is