APPS.MSC_ANALYSIS_PKG dependencies on MSC_PLANS

Line 51: from msc_plans

47: and detail_date < p_curr_pr_date;
48:
49: cursor c_planinfo (p_plan in number) is
50: select plan_start_date, curr_cutoff_date
51: from msc_plans
52: where plan_id = p_plan;
53:
54:
55: 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 1326: msc_plans mp

1322:
1323: CURSOR PERIOD_CURSOR (p_plan_id in number) IS
1324: SELECT count(*)
1325: FROM msc_bis_periods mbp,
1326: msc_plans mp
1327: WHERE mbp.organization_id = mp.organization_id
1328: and mbp.sr_instance_id = mp.sr_instance_id
1329: and ((mbp.start_date between nvl(mp.data_start_date, sysdate)
1330: and mp.cutoff_date

Line 1354: msc_plans mp

1350: select round(sum(nvl(((ms.new_order_quantity * msi.unit_weight) * mism.cost_per_weight_unit),0)),6)
1351: from msc_supplies ms,
1352: msc_system_items msi,
1353: msc_interorg_ship_methods mism,
1354: msc_plans mp
1355: WHERE ms.plan_id = p_plan_id
1356: and ms.organization_id <> ms.source_organization_id
1357: and ms.order_type in (l_otype1, l_otype2, l_otype3)
1358: and ms.plan_id = msi.plan_id

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

1415: ' where plan_id = :1 ';
1416: --' where plan_id in ('||arg_plan_list ||') ';
1417: --||' and category_set_id ='||l_cat_set_id;
1418:
1419: l_cursor2 := ' select plan_id from msc_plans where plan_id in (' ||arg_plan_list ||') ';
1420: OPEN c2 FOR l_cursor2;
1421: loop
1422: FETCH c2 INTO ll_plan_id;
1423: EXIT WHEN c2%NOTFOUND;

Line 1562: from msc_plans

1558: nvl(WEEKLY_RESOURCE_CONSTRAINTS,0)+
1559: nvl(PERIOD_RESOURCE_CONSTRAINTS,0),
1560: plan_type
1561: into v_constraint, v_plan_type
1562: from msc_plans
1563: where plan_id = p_plan_id;
1564:
1565: -- unconstrained plan is always 100%
1566: if v_constraint = 0 then

Line 1681: from msc_plans

1677:
1678: function get_plan_dflt_value(p_plan_id number) return number is
1679: cursor c_dflt is
1680: select nvl(demand_fulfillment_lt,0)
1681: from msc_plans
1682: where plan_id = p_plan_id;
1683:
1684: l_dflt number;
1685: begin