DBA Data[Home] [Help]

APPS.MSC_PEG_UTIL dependencies on MSC_FLP_SUPPLY_DEMAND_V

Line 247: from msc_flp_supply_demand_v

243: x_itemorg_pegnode_rec.order_number,
244: x_itemorg_pegnode_rec.Pegging_id,
245: x_itemorg_pegnode_rec.Transaction_id,
246: x_itemorg_pegnode_rec.end_demand_class
247: from msc_flp_supply_demand_v
248: where plan_id = p_plan_id
249: and prev_pegging_id in ( select pegging_id
250: from msc_full_pegging
251: where plan_id = p_plan_id

Line 365: from msc_flp_supply_demand_v

361: x_itemorg_pegnode_rec.Pegged_qty,
362: x_itemorg_pegnode_rec.order_number,
363: x_itemorg_pegnode_rec.order_type,
364: x_itemorg_pegnode_rec.end_demand_class
365: from msc_flp_supply_demand_v
366: where plan_id = p_plan_id
367: and sr_instance_id = p_instance_id
368: and transaction_id = p_transaction_id
369: order by item_org, demand_date;

Line 400: from msc_flp_supply_demand_v

396: x_itemorg_pegnode_rec.Pegged_qty,
397: x_itemorg_pegnode_rec.order_number,
398: x_itemorg_pegnode_rec.order_type,
399: x_itemorg_pegnode_rec.end_demand_class
400: from msc_flp_supply_demand_v
401: where plan_id = p_plan_id
402: and pegging_id = p_pegging_id
403: order by item_org, demand_date;
404: END IF;