DBA Data[Home] [Help]

APPS.MSC_UI_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 315: msc_demands dm

311: null pegging_id,
312: null transaction_id,
313: null end_demand_class
314: from msc_system_items mis,
315: msc_demands dm
316: where mis.inventory_item_id = dm.inventory_item_id
317: and mis.sr_instance_id = dm.sr_instance_id
318: and mis.organization_id = dm.organization_id
319: and mis.plan_id = dm.plan_id

Line 621: msc_demands dm

617: null pegging_id,
618: null transaction_id,
619: null end_demand_class
620: from msc_system_items mis,
621: msc_demands dm
622: where mis.inventory_item_id = dm.inventory_item_id
623: and mis.sr_instance_id = dm.sr_instance_id
624: and mis.organization_id = dm.organization_id
625: and mis.plan_id = dm.plan_id