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 807: from msc_plans a

803: null_date date := null;
804:
805: CURSOR c_plan_type(p_plan_id number) IS
806: select plan_type
807: from msc_plans a
808: where
809: plan_id = p_plan_id;
810:
811: p_plan_type NUMBER;

Line 1306: FROM msc_plans

1302: /* for auto-release we do not want applied and status to be updated */
1303:
1304: SELECT release_reschedules
1305: INTO v_autorelease
1306: FROM msc_plans
1307: WHERE plan_id=arg_plan_id;
1308: UPDATE MSC_SUPPLIES
1309: SET implement_date = NULL,
1310: release_status = decode(sign(p_plan_type-100),1,

Line 1416: from msc_plans a

1412: and msi.inventory_item_id = l_item_id;
1413:
1414: CURSOR c_plan_type(p_plan_id number) IS
1415: select plan_type
1416: from msc_plans a
1417: where
1418: plan_id = p_plan_id;
1419: p_plan_type NUMBER;
1420: BEGIN

Line 2476: msc_plans mp,

2472: s.implement_quantity,
2473: cal2.calendar_date
2474: from msc_supplies s,
2475: msc_system_items msi,
2476: msc_plans mp,
2477: msc_calendar_dates cal1,
2478: msc_calendar_dates cal2,
2479: msc_trading_partners mtp
2480: where s.plan_id = p_plan_id

Line 2890: from msc_plans a

2886: p_new_earliest_date date;
2887:
2888: CURSOR c_plan_type(p_plan_id number) IS
2889: select plan_type
2890: from msc_plans a
2891: where
2892: plan_id = p_plan_id;
2893:
2894: p_plan_type NUMBER;

Line 3445: msc_plans mp,

3441: nvl(md.prev_subst_org, md.original_org_id),
3442: md.plan_id,md.original_inst_id)
3443: orig_item_desc
3444: from msc_system_items msi,
3445: msc_plans mp,
3446: msc_demands md,
3447: msc_sales_order_interface msoi
3448: where msoi.batch_id = p_batch_id
3449: and msoi.sr_instance_id = p_instance_id