DBA Data[Home] [Help]

APPS.MSC_PEG_UTIL dependencies on MSC_DEMANDS

Line 13: from msc_demands

9: p_plan_id IN NUMBER) IS
10:
11: cursor origination_22 is
12: select origination_type, disposition_id
13: from msc_demands
14: where demand_id = p_demand_id
15: and plan_id = p_plan_id
16: and organization_id = p_organization_id
17: and sr_instance_id = p_sr_instance_id;

Line 326: msc_demands dm

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
330: and organization_id = p_organization_id

Line 452: msc_demands dm

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
456: and organization_id = p_organization_id