APPS.MSC_GET_NAME dependencies on MSC_DESIGNATORS

Line 449: from msc_designators desig,

445: and order_type in (3,7,14,15,27,28);
446:
447: cursor designator_c is
448: select desig.designator
449: from msc_designators desig,
450: msc_demands mgr
451: where desig.designator_id = mgr.schedule_designator_id
452: and mgr.demand_id = arg_disp_id
453: and mgr.sr_instance_id = arg_instance_id

Line 1691: FROM msc_designators

1687: p_plan_id IN NUMBER default NULL ) return varchar2 IS
1688:
1689: CURSOR DESIG_C(v_desig_id number) IS
1690: SELECT designator, forecast_set_id
1691: FROM msc_designators
1692: WHERE designator_id = v_desig_id;
1693:
1694: CURSOR DESIG_FC IS
1695: SELECT designator

Line 1696: FROM msc_designators

1692: WHERE designator_id = v_desig_id;
1693:
1694: CURSOR DESIG_FC IS
1695: SELECT designator
1696: FROM msc_designators
1697: WHERE forecast_set_id = p_fcst_set_id
1698: and designator_id = p_desig_id;
1699:
1700: v_fcst_set_id number;

Line 1708: from msc_designators desig,

1704: -- modification for bug 2765939
1705: -- Return null if it is a dp scenario and the plan_id is passed in function call
1706: cursor is_forecast_c is
1707: select 1
1708: from msc_designators desig,
1709: msc_plan_schedules sch
1710: where desig.designator_id = p_desig_id
1711: and desig.designator_type = 6
1712: and sch.plan_id=p_plan_id

Line 1807: FROM msc_designators

1803: AND input_schedule_id = p_desig_id;
1804:
1805: CURSOR DESIG_C IS
1806: SELECT designator
1807: FROM msc_designators
1808: WHERE designator_id = p_desig_id;
1809:
1810: CURSOR c_scenario_name IS
1811: SELECT scenario_name

Line 1891: FROM msc_designators

1887: AND input_schedule_id = p_desig_id;
1888:
1889: CURSOR forecastset_name IS
1890: SELECT designator
1891: FROM msc_designators
1892: WHERE designator_id = (SELECT NVL(forecast_set_id,p_desig_id)
1893: FROM msc_designators
1894: WHERE designator_id = p_desig_id
1895: AND designator_type = 6);

Line 1893: FROM msc_designators

1889: CURSOR forecastset_name IS
1890: SELECT designator
1891: FROM msc_designators
1892: WHERE designator_id = (SELECT NVL(forecast_set_id,p_desig_id)
1893: FROM msc_designators
1894: WHERE designator_id = p_desig_id
1895: AND designator_type = 6);
1896:
1897: CURSOR c_scenario_name IS

Line 2185: from msc_designators d

2181: p_plan varchar2) return varchar2 is
2182:
2183: cursor c_dmdclass is
2184: select d.demand_class
2185: from msc_designators d
2186: where NVL(D.DESIGNATOR_TYPE,3) IN (2, 3, 4,5,-99)
2187: AND D.SR_INSTANCE_ID = p_inst_id
2188: AND D.ORGANIZATION_ID = p_org_id
2189: AND D.DESIGNATOR = p_plan ;

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

2316: FUNCTION forward_backward_days(p_plan_id number,
2317: p_schedule_desig_id number,
2318: p_fb_type number)
2319: return number IS
2320: -- Modified to check the existance of forecast by joining msc_designators
2321: -- to msc_plan_schedules
2322: -- Also modified to remove the sub queries
2323: cursor is_forecast_c is
2324: select 1

Line 2325: from msc_designators desig,

2321: -- to msc_plan_schedules
2322: -- Also modified to remove the sub queries
2323: cursor is_forecast_c is
2324: select 1
2325: from msc_designators desig,
2326: msc_plan_schedules sch
2327: where desig.designator_id = p_schedule_desig_id
2328: and desig.designator_type = 6
2329: and sch.plan_id=p_plan_id

Line 2334: from msc_designators desig

2330: and sch.input_schedule_id = desig.forecast_set_id;
2331:
2332: cursor is_forecast_cwb_c is
2333: select 1
2334: from msc_designators desig
2335: where desig.designator_id = p_schedule_desig_id
2336: and desig.designator_type = 6;
2337:
2338: CURSOR is_dp_scenario_c is

Line 2348: FROM msc_designators

2344:
2345: CURSOR forward_backward_days_c1 IS
2346: SELECT FORWARD_UPDATE_TIME_FENCE,
2347: BACKWARD_UPDATE_TIME_FENCE
2348: FROM msc_designators
2349: WHERE designator_id = p_schedule_desig_id;
2350:
2351: CURSOR forward_backward_days_c2 IS
2352: SELECT curr_FORWARD_days,