APPS.MSC_RELEASE_PK dependencies on MSC_PLANS

Line 201: from msc_plans

197: lv_arg_org_id_new NUMBER ;
198: lv_arg_instance_id_new NUMBER ;
199: cursor plan_type_c(v_plan_id number) is
200: select curr_plan_type
201: from msc_plans
202: where plan_id = v_plan_id;
203:
204: lv_auto_release_method number;
205: l_def_pref_id number;

Line 281: msc_plans mps,

277: msc_system_items msi,
278: msc_system_items rsi,
279: msc_supplies mr,
280: msc_plan_organizations_v mpo,
281: msc_plans mps,
282: msc_trading_partners mt
283: WHERE -- mpo.organization_id = arg_org_id
284: mpo.plan_id = arg_plan_id
285: -- AND mpo.sr_instance_id = arg_instance_id

Line 354: FROM MSC_PLANS

350: and a.plan_id=mr.plan_id
351: and b.SCHEDULE_ORIGINATION_TYPE =1
352: and a.schedule_designator_id = d.DESIGNATOR_ID
353: and d.designator not in (SELECT DISTINCT compile_designator
354: FROM MSC_PLANS
355: where sr_instance_id=a.sr_instance_id )
356:
357: ))
358: AND decode(mps.curr_plan_type,

Line 464: msc_plans mps,

460: ms.sr_instance_id ,
461: ms.plan_id
462: from
463: msc_supplies ms,
464: msc_plans mps,
465: msc_system_items msi,
466: msc_trading_partners mtp,
467: msc_calendar_dates cal1,
468: msc_calendar_dates cal2

Line 514: msc_plans mps,

510: ms.sr_instance_id ,
511: ms.plan_id
512: from
513: msc_supplies ms,
514: msc_plans mps,
515: msc_system_items msi,
516: msc_trading_partners mtp,
517: msc_calendar_dates cal1,
518: msc_calendar_dates cal2

Line 581: msc_plans mps,

577: ms.sr_instance_id ,
578: ms.plan_id
579: from
580: msc_supplies ms,
581: msc_plans mps,
582: msc_system_items msi,
583: msc_trading_partners mtp,
584: msc_calendar_dates cal1,
585: msc_calendar_dates cal2

Line 630: from msc_plans

626: select organization_id,
627: sr_instance_id
628: into lv_arg_org_id_new,
629: lv_arg_instance_id_new
630: from msc_plans
631: where plan_id = arg_plan_id ;
632:
633: select decode(FND_PROFILE.VALUE('MSC_DRP_RELEASE_FROM_MRP'),'Y',SYS_YES,SYS_NO)
634: into lv_plan_release_profile

Line 683: FROM msc_plans

679: So obtain them from the table
680: */
681: SELECT plan_type
682: INTO var_plan_type
683: FROM msc_plans
684: WHERE plan_id = arg_plan_id;
685:
686: IF (var_plan_type >= RP_MRP_PLAN)
687: THEN

Line 787: FROM msc_plans mp,

783: var_start_date,
784: var_demand_class,
785: lv_plan_name,
786: lv_auto_release_method
787: FROM msc_plans mp,
788: msc_designators sched
789: WHERE sched.organization_id(+)= mp.organization_id
790: AND sched.designator(+) = mp.compile_designator
791: AND sched.sr_instance_id(+) = mp.sr_instance_id

Line 1512: UPDATE msc_plans

1508: var_loaded_int_repair_orders,var_int_repair_orders_id,var_loaded_ext_repair_orders,
1509: var_ext_repair_orders_id,var_loaded_eam_jobs,var_loaded_eam_req_id,
1510: var_resched_cmro_jobs,var_resched_cmro_req_id,var_loaded_cmro_jobs,var_loaded_cmro_req_id);
1511:
1512: UPDATE msc_plans
1513: SET release_reschedules=2
1514: WHERE plan_id=arg_plan_id
1515: AND var_plan_type < RP_MRP_PLAN; -- For RP Plan keep the flag unchanged
1516: commit;

Line 1732: FROM msc_plans mp

1728: SELECT mp.sr_instance_id,
1729: mp.organization_id
1730: INTO v_instance_id,
1731: v_owning_org_id
1732: FROM msc_plans mp
1733: WHERE mp.plan_id = pPlan_id;
1734: EXCEPTION
1735: WHEN NO_DATA_FOUND THEN
1736: ERRMSG := 'Not a Valid plan ID';

Line 1938: From MSC_PLANS mp

1934: NVL(Mp.include_reschedules,-1)
1935: INTO
1936: lv_auto_release_method,
1937: lv_inc_rescheds
1938: From MSC_PLANS mp
1939: Where mp.plan_id = pPlan_id ;
1940:
1941:
1942: