DBA Data[Home] [Help]

APPS.MSC_PEG_UTIL dependencies on MSC_ITEMS

Line 80: from msc_items mis,

76: x_itemorg_pegnode_rec.Pegged_qty,
77: x_itemorg_pegnode_rec.Item_id,
78: x_itemorg_pegnode_rec.Order_type,
79: x_itemorg_pegnode_rec.Disposition
80: from msc_items mis,
81: msc_supplies ms
82: where mis.inventory_item_id = ms.inventory_item_id
83: and ms.transaction_id = l_disposition_id
84: and ms.plan_id = p_plan_id

Line 325: from msc_items mis,

321: x_itemorg_pegnode_rec.order_number,
322: x_itemorg_pegnode_rec.Pegging_id,
323: x_itemorg_pegnode_rec.Transaction_id,
324: x_itemorg_pegnode_rec.end_demand_class
325: from msc_items mis,
326: msc_demands dm
327: where mis.inventory_item_id = dm.inventory_item_id
328: and dm.disposition_id = p_transaction_id
329: and plan_id = p_plan_id

Line 451: from msc_items mis,

447: x_itemorg_pegnode_rec.order_number,
448: x_itemorg_pegnode_rec.Pegging_id,
449: x_itemorg_pegnode_rec.Transaction_id,
450: x_itemorg_pegnode_rec.end_demand_class
451: from msc_items mis,
452: msc_demands dm
453: where mis.inventory_item_id = dm.inventory_item_id
454: and dm.disposition_id = p_transaction_id
455: and plan_id = p_plan_id