APPS.MSC_UI_PEG_UTIL dependencies on MSC_SUPPLIES

Line 60: msc_supplies ms

56: ms.inventory_item_id,
57: ms.order_type,
58: null disposition
59: from msc_system_items mis,
60: msc_supplies ms
61: where mis.inventory_item_id = ms.inventory_item_id
62: and mis.sr_instance_id = ms.sr_instance_id
63: and mis.organization_id = ms.organization_id
64: and mis.plan_id = ms.plan_id

Line 225: from msc_supplies

221: -- Sometimes after button Supply Pegging is clicked pld is not sending item_id
222: cursor inventory_item_id IS
223: select inventory_item_id,
224: decode(order_type, 13, disposition_id, transaction_id)
225: from msc_supplies
226: where transaction_id = p_transaction_id
227: and plan_id = p_plan_id
228: and sr_instance_id = p_instance_id
229: and organization_id = p_organization_id;

Line 514: msc_supplies ms

510: from msc_flp_supply_demand_v3
511: where plan_id = p_plan_id
512: and prev_pegging_id in ( select mfp.pegging_id
513: from msc_full_pegging mfp,
514: msc_supplies ms
515: where ms.plan_id = p_plan_id
516: and ms.transaction_id = p_transaction_id
517: and ms.sr_instance_id = p_instance_id
518: and mfp.plan_id = ms.plan_id