247: end_disposition order_number,
248: null pegging_id ,
249: null transaction_id,
250: null end_demand_class
251: from msc_flp_supply_demand_v3
252: where plan_id = p_plan_id
253: and prev_pegging_id in ( select pegging_id
254: from msc_full_pegging
255: where plan_id = p_plan_id
336: pegged_qty,
337: end_disposition order_number,
338: order_type,
339: end_demand_class
340: from msc_flp_supply_demand_v3
341: where plan_id = p_plan_id
342: and transaction_id = p_transaction_id
343: order by item_org, demand_date;
344:
356: pegged_qty,
357: end_disposition order_number,
358: order_type,
359: end_demand_class
360: from msc_flp_supply_demand_v3
361: where plan_id = p_plan_id
362: and pegging_id = p_pegging_id
363: order by item_org, demand_date;
364:
506: end_disposition order_number,
507: null pegging_id ,
508: null transaction_id,
509: null end_demand_class
510: from msc_flp_supply_demand_v3
511: where plan_id = p_plan_id
512: and prev_pegging_id in ( select mfp.pegging_id
513: from msc_full_pegging mfp,
514: msc_supplies ms