APPS.MSC_RELEASE_PK dependencies on MSC_PLANS

Line 182: from msc_plans

178: invalid_plan EXCEPTION;
179:
180: cursor plan_type_c(v_plan_id number) is
181: select curr_plan_type
182: from msc_plans
183: where plan_id = v_plan_id;
184:
185: l_def_pref_id number;
186: l_plan_type number;

Line 258: msc_plans mps,

254: msc_system_items msi,
255: msc_system_items rsi,
256: msc_supplies mr,
257: msc_plan_organizations_v mpo,
258: msc_plans mps,
259: msc_trading_partners mt
260: WHERE mpo.organization_id = arg_org_id
261: AND mpo.plan_id = arg_plan_id
262: AND mpo.sr_instance_id = arg_instance_id

Line 330: FROM MSC_PLANS

326: and a.plan_id=mr.plan_id
327: and b.SCHEDULE_ORIGINATION_TYPE =1
328: and a.schedule_designator_id = d.DESIGNATOR_ID
329: and d.designator not in (SELECT DISTINCT compile_designator
330: FROM MSC_PLANS
331: where sr_instance_id=a.sr_instance_id )
332:
333: ))
334: AND decode(mps.curr_plan_type,

Line 638: FROM msc_plans mp,

634: INTO var_plan_type,
635: var_start_date,
636: var_demand_class,
637: lv_plan_name
638: FROM msc_plans mp,
639: msc_designators sched
640: WHERE sched.organization_id(+)= mp.organization_id
641: AND sched.designator(+) = mp.compile_designator
642: AND sched.sr_instance_id(+) = mp.sr_instance_id

Line 1207: UPDATE msc_plans

1203: (arg_plan_id,arg_org_id,arg_instance_id,arg_org_id,
1204: arg_instance_id,var_count_po,var_released_instance,
1205: var_po_res_id,var_po_res_count,var_po_pwb_count);
1206:
1207: UPDATE msc_plans
1208: SET release_reschedules=2
1209: WHERE plan_id=arg_plan_id;
1210: commit;
1211:

Line 1376: FROM msc_plans mp

1372: SELECT mp.sr_instance_id,
1373: mp.organization_id
1374: INTO v_instance_id,
1375: v_owning_org_id
1376: FROM msc_plans mp
1377: WHERE mp.plan_id = pPlan_id;
1378: EXCEPTION
1379: WHEN NO_DATA_FOUND THEN
1380: ERRMSG := 'Not a Valid plan ID';