DBA Data[Home] [Help]

APPS.MSC_UI_PEG_UTIL dependencies on MSC_FLP_SUPPLY_DEMAND_V3

Line 251: from msc_flp_supply_demand_v3

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

Line 340: from msc_flp_supply_demand_v3

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:

Line 360: from msc_flp_supply_demand_v3

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:

Line 510: from msc_flp_supply_demand_v3

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