DBA Data[Home] [Help]

APPS.MSC_PEG_UTIL dependencies on MSC_FLP_DEMAND_SUPPLY_V

Line 115: from msc_flp_demand_supply_v

111: x_itemorg_pegnode_rec.Pegged_qty,
112: x_itemorg_pegnode_rec.Item_id,
113: x_itemorg_pegnode_rec.Order_type,
114: x_itemorg_pegnode_rec.Disposition
115: from msc_flp_demand_supply_v
116: where plan_id = p_plan_id
117: and pegging_id = p_prev_peg_id
118: order by item_org, supply_date;
119:

Line 157: from msc_flp_demand_supply_v

153: x_itemorg_pegnode_rec.Pegged_qty,
154: x_itemorg_pegnode_rec.Item_id,
155: x_itemorg_pegnode_rec.Order_type,
156: x_itemorg_pegnode_rec.Disposition
157: from msc_flp_demand_supply_v
158: where plan_id = p_plan_id
159: and prev_pegging_id = l_prev_peg_id
160: and demand_id = p_demand_id
161: and order_type not in (15,16,28)