APPS.MSC_ANALYSIS_PKG dependencies on MSC_PLANS

Line 49: from msc_plans

45: and detail_date < p_curr_pr_date;
46:
47: cursor c_planinfo (p_plan in number) is
48: select plan_start_date, curr_cutoff_date
49: from msc_plans
50: where plan_id = p_plan;
51:
52:
53: cursor c_plan_orgs (l_plan_id number) is

Line 92: from msc_plans

88:
89: function get_plan_type(p_plan_id number) return number is
90: cursor c_plan (p_plan_id number) is
91: select plan_type
92: from msc_plans
93: where plan_id = p_plan_id;
94:
95: l_plan_id number;
96: l_plan_type number;

Line 203: FROM msc_plans

199:
200: CURSOR planCur(p_plan_id in NUMBER)
201: IS
202: SELECT sr_instance_id, organization_id
203: FROM msc_plans
204: WHERE plan_id = p_plan_id;
205:
206: CURSOR totalMfgPerCur(p_plan_id in NUMBER, p_sr_instance_id in number, p_org_id in number)
207: IS

Line 211: msc_plans mp

207: IS
208: SELECT count(distinct mpsd.period_start_date)
209: FROM msc_trading_partners tp,
210: msc_period_start_dates mpsd,
211: msc_plans mp
212: WHERE mpsd.calendar_code = tp.calendar_code
213: and mpsd.sr_instance_id = tp.sr_instance_id
214: and mpsd.exception_set_id = tp.calendar_exception_set_id
215: and tp.sr_instance_id = p_sr_instance_id

Line 226: msc_plans mp

222: CURSOR totalBisPerCur(p_plan_id in NUMBER)
223: IS
224: SELECT count(distinct mbp.period_name)
225: FROM msc_bis_periods mbp,
226: msc_plans mp
227: WHERE mbp.organization_id = mp.organization_id
228: and mbp.sr_instance_id = mp.sr_instance_id
229: and ((mbp.start_date between nvl(mp.curr_start_date, sysdate)
230: and mp.cutoff_date

Line 1345: msc_plans mp

1341:
1342: CURSOR PERIOD_CURSOR (p_plan_id in number) IS
1343: SELECT count(*)
1344: FROM msc_bis_periods mbp,
1345: msc_plans mp
1346: WHERE mbp.organization_id = mp.organization_id
1347: and mbp.sr_instance_id = mp.sr_instance_id
1348: and ((mbp.start_date between nvl(mp.data_start_date, sysdate)
1349: and mp.cutoff_date

Line 1362: msc_plans mp

1358: select round(sum(nvl(((ms.new_order_quantity * msi.unit_weight) * mism.cost_per_weight_unit),0)),6)
1359: from msc_supplies ms,
1360: msc_system_items msi,
1361: msc_interorg_ship_methods mism,
1362: msc_plans mp
1363: WHERE ms.plan_id = p_plan_id
1364: and ms.organization_id <> ms.source_organization_id
1365: and ms.order_type in (l_otype1, l_otype2, l_otype3)
1366: and ms.plan_id = msi.plan_id

Line 1426: l_cursor2 := ' select plan_id from msc_plans where plan_id in (' ||arg_plan_list ||') ';

1422: ' where plan_id = :1 ';
1423: --' where plan_id in ('||arg_plan_list ||') ';
1424: --||' and category_set_id ='||l_cat_set_id;
1425:
1426: l_cursor2 := ' select plan_id from msc_plans where plan_id in (' ||arg_plan_list ||') ';
1427: OPEN c2 FOR l_cursor2;
1428: loop
1429: FETCH c2 INTO ll_plan_id;
1430: EXIT WHEN c2%NOTFOUND;

Line 1573: from msc_plans

1569: nvl(WEEKLY_RESOURCE_CONSTRAINTS,0)+
1570: nvl(PERIOD_RESOURCE_CONSTRAINTS,0),
1571: plan_type
1572: into v_constraint, v_plan_type
1573: from msc_plans
1574: where plan_id = p_plan_id;
1575:
1576: -- unconstrained plan is always 100%
1577: if v_constraint = 0 then

Line 1695: from msc_plans

1691:
1692: function get_plan_dflt_value(p_plan_id number) return number is
1693: cursor c_dflt is
1694: select nvl(demand_fulfillment_lt,0)
1695: from msc_plans
1696: where plan_id = p_plan_id;
1697:
1698: l_dflt number;
1699: begin