APPS.MSC_REL_WF dependencies on MSC_PLANS

Line 256: from msc_plans mp,

252: ms.new_schedule_date,
253: ms.implement_date,
254: ms.new_order_quantity,
255: msi.buyer_name
256: from msc_plans mp,
257: msc_system_items msi,
258: msc_supplies ms
259: where ms.plan_id = p_plan_id
260: and ms.transaction_id = p_transaction_id

Line 425: from msc_plans mp,

421: msc_get_name.lookup_meaning('MRP_ORDER_TYPE',ms.order_type),
422: ms.new_schedule_date,
423: ms.implement_date,
424: ms.new_order_quantity
425: from msc_plans mp,
426: msc_supplies ms
427: where ms.plan_id = p_plan_id
428: and ms.transaction_id = p_transaction_id
429: and mp.plan_id = ms.plan_id

Line 786: from msc_plans a

782: v_autorelease number;
783:
784: CURSOR c_plan_type(p_plan_id number) IS
785: select plan_type
786: from msc_plans a
787: where
788: plan_id = p_plan_id;
789:
790: p_plan_type NUMBER;

Line 1157: FROM msc_plans

1153: /* for auto-release we do not want applied and status to be updated */
1154:
1155: SELECT release_reschedules
1156: INTO v_autorelease
1157: FROM msc_plans
1158: WHERE plan_id=arg_plan_id;
1159:
1160: UPDATE MSC_SUPPLIES
1161: SET implement_date = NULL,

Line 2225: msc_plans mp,

2221: s.implement_quantity,
2222: cal2.calendar_date
2223: from msc_supplies s,
2224: msc_system_items msi,
2225: msc_plans mp,
2226: msc_calendar_dates cal1,
2227: msc_calendar_dates cal2,
2228: msc_trading_partners mtp
2229: where s.plan_id = p_plan_id

Line 3166: msc_plans mp,

3162: nvl(md.prev_subst_org, md.original_org_id),
3163: md.plan_id,md.original_inst_id)
3164: orig_item_desc
3165: from msc_system_items msi,
3166: msc_plans mp,
3167: msc_demands md,
3168: msc_sales_order_interface msoi
3169: where msoi.batch_id = p_batch_id
3170: and msoi.sr_instance_id = p_instance_id